Comprehensive model formulation exercise Q1: New product development Problem A Leisure Food Company plans to develop some new products. The following table shows relevant data for six potential foods which are under considera tion. The company wants to know which projects should be selected so asto maximize total pr ofits. There are some constrains for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be select ed simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fo urth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be select ed among project 3, 4, and 5. Please help this company to determine the optimal combinations of new products. Table 1 Data table Capital require Researchers r Project Profit ment equirement 1 50 11 65 2 65 16 90 3 45 9. 80 4 55 7 90 40 60 90 110 24 5

Comprehensive model formulation exercise Q1: New product development Problem A Leisure Food Company plans to develop some new products. The following table shows relevant data for six potential foods which are under considera tion. The company wants to know which projects should be selected so asto maximize total pr ofits. There are some constrains for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be select ed simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fo urth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be select ed among project 3, 4, and 5. Please help this company to determine the optimal combinations of new products. Table 1 Data table Capital require Researchers r Project Profit ment equirement 1 50 11 65 2 65 16 90 3 45 9. 80 4 55 7 90 40 60 90 110 24 5

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Make a plan on a specific sport event you want to have in your community following the steps in organising a sport event. Don't forget to consider availability of resources and facilities available in your community as well as the interests of the people living in it. This is the format: Name of the Community: 1. Planning Sport Event: Objectives of the Sport Event: Theme for the Event: Venue/available facilities in the community to be used in the event: Initial Budget/Source of Budget: 2. Organizing Program and Schedule: Policies: 3. Staffing Designate people/staff needed in the event and their duties Designation Duties
Write at least 2 event objectives for each of these situations. 1. A real estate company will host a party and present its newest condominium project to the alumni of the Asian Institute of Management. 2. The Parent-Teacher Association will hold a dinner dance as a fund-raising project. 3. The national sales office of a pharmaceutical company will hold its annual sales managers' meeting to kick off this year's sales campaigns. 4. The head of the Vergara clan of Batangas calls all clan members to a reunion in their hometown. 5. The Catholic Women's League plans a rummage sale at the parish activity area.
The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects. Following are five projects under consideration. Criteria Strong sponsor Supports business strategy Urgency 10% of sales from new products Competition Fill market gap Weight 2 4 2 5 1 2 Project 1 6 8 9 5 4 0 Project 2 9 8 4 2 7 10 Project 3 3 2 3 9 4 8 Project 4 9 6 6 1 4 0 Project 5 6 0 7 4 1 0 Using the scoring matrix above, what score would you give to each project?
A client and his wife come to the financial planner for education planning for their 5 year old son. The client is specific about which school he would like to send his son to (his alma mater) and tells the planner he would like to plan for 6 year of college instead of the more normal 4 the planner asks how she feels about the plan, she says one component that is important to her questions about the children, higher education in general and the specific education plan the recently diagnosed with autism. This information is invaluable in helping the planner develop a.Active listening b.Education planning c.Problem framing d.Meddling.
14. Stephanie, the supply chain analyst of Nestle is asked to present an expansion plan for thecompany. The plan is either to construct a plant, open a distribution center, or do nothing. Fromthe plant construction, the company will gain 80,000Php if the market turns favorable, loss of10,000 if average, and loss of 50,000 if unfavorable. From opening a distribution center, thecompany will gain 40,000Php if favorable, gain 20,000Php if average, and loss of 30,000Php ifunfavorable. And if the decision is do nothing, the company will gain nothing regardless of themarket turnout. Then, he was able to determine further the probability of occurrence of eachtype of market. The probability of occurrence is 60%, 25%, and 40%, respectively. He also foundout that he can buy the information on what will really happen to the market for 2,000Php.a. What should be the analyst’s decision?b. How much gain or loss will he expect for the company?c. Should he buy the perfect information? Why or why not?d.…
Herron Company is screening three new product ideas: A, B, and C. Resource constraints allow only one of them to be commercialized. The performance criteria and ratings, on a scale of 1 (worst) to 10 (best), are shown in the following table. The Herron managers give equal weights to the performance criteria. Which is the best alternative, as indicated by the preference matrix method? Rating Performance Criterion Product A Product B Product C 1. Demand uncertainty and project risk 3 9 2 2. Similarity to present products 7 8 6 3. Expected return on investment (ROI) 10 4 8 4. Compatibility with current manufacturing process 4 7 6 5. Competitive advantage 4 6 5
what is the problem statement?
The following payoff matrix shows the various profit outcomes for 3 projects, A, B, and C, under 2 possible states of nature: the product price is $15 or the product price is $25. Profit Project A P= $15 60 B -28 C 40 Using the maximax rule, the decision maker would choose... Multiple Choice A. B. P = $25 80 160 100 impossible to say from the information given
Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the objective function coefficient for Product_1 were increased to a value of 8, which of the following would be TRUE? The optimal solution would change. The optimal objective function value would stay the same. Product_1 would enter the solution (the final value of the variable Product_1 would be greater than zero).
Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the right-hand side of Resource_C increases to 750, which of the following would be true The objective function value will increase by $1.75 The objective function value will decrease by $1.75 The objective function value will increase by $87.50 The objective function value will decrease by $87.50 None of the answer choices is correct
b) Table Q4b. shows data obtained using the scoring method in a project selection exercise. (1) Describe clearly how the scoring method works, using table Q4b. as an example upon which to base your description. (ii) The project manager must select one project only. State which project, the project manager should select (Project A, Project B or Project C) and provide a justification based on the data provided in Table Q4b. Weighted Score (= Score x Weighting) Criterion Weight Project A Project B Project C Criterion 1 Mandatory Yes Yes No Criterion 2 10 9 x 10 = 90 8x 10 = 80 9 x 10 = 90 Criterion 3 8 9 x 8 = 72 8x 8 = 64 9 x 8 = 72 Criterion 4 6 6 x 6 = 36 7x 6 = 42 9 x 6 = 54 Criterion 5 4 7x 4 = 28 8x 4 = 32 9 x 4 = 36 Total Score 226 218 252 Table Q4b
Address the market structure classification of the Apple iPhone 6 plus. Guidelines for this assignment are listed below: Discuss which market structure best aligns with the Apple iPhone 6 plus. Align characteristics of the market structure to that of the Apple iPhone 6 plus. Discuss how price and quantity are determined for the Apple iPhone 6 plus. Identify other competitors in the market. Discuss whether or not any other competitors have influence over the market. State whether or not any competitors engage in price discrimination. Identify if the market for cellular phone aligns with game theory to include, a Prisoner's Dilemma. Include the following: 1 to 2-pages of content At least two sources