Building a Model using a case description and worksheets

Anonymous
timer Asked: Nov 28th, 2017
account_balance_wallet $35

Question Description

Build the Model that I have attached below then answer these questions:

1. What is the unit revenue for the WHOLE product line after your adjustments? Enter your result rounded to 1/10 of a penny (3 decimal places).

2.What is the unit cost of DIRECT MATERIALS for the WHOLE product line after your adjustments? Enter your result rounded to 1/10 of a penny (3 decimal places).

3. What is the unit cost of DIRECT LABOR for the WHOLE product line after your adjustments? Enter your result rounded to 1/10 of a penny (3 decimal places).

4. What is the unit cost of VARIABLE MANUFACTURING OVERHEAD for the WHOLE product line? Enter your result rounded to 1/10 of a penny (3 decimal places).

5. What is the unit cost of VARIABLE SELLING & ADMINISTRATIVE for the WHOLE product line? Enter your result rounded to 1/10 of a penny (3 decimal places)

6.What is the unit CONTRIBUTION MARGIN for the WHOLE product line after your adjustments? Enter your result rounded to 1/10 of a penny (3 decimal places).

7.In the Answer Report, how many constraints are listed as binding? [Ignore the non-negativity constraints.]

8.Is the solution unique?

9.Is the model degenerate?

10.Based on the results of your SOLVER run, what is the Return on Sales (Ratio of Total Net Profit to Total Revenues)?

11.In the optimal production mix, what is the quantity of CRUNCH produced? enter your answer rounded to the nearest whole unit (integer) and do not include commas or other symbols

12.In the optimal production mix, what is the quantity of ROAST produced?

13. In the optimal production mix, what is the quantity of CLUSTER produced?

14.After optimization, assume that the company had an opportunity to further reduce the production of any product, despite production quantity constraints. Which product would be the best candidate? Cluster, Roasted, Whole or Crunch

15.What is the total revenues in the optimized model? Round your answers to the nearest penny.

16.What is the total NET Profits in the optimized model? Round your answers to the nearest penny.

17.The Human Resource manager asked the director of production how many additinal workers he needed for the following planning period. Each worker contributes 2,200 hours per year (a planning period).

18.A business unit manager from another unit is helping his procurement department find additional resources. He approaches you, as the product manager, to request nuts and he will pay at the internal transfer price. If you have a deadline to meet, how many pounds should be transferred without impacting you?

19.The product manager of the Cluster product line is concerned about the production numbers. Based on the Sensitivity Report, determine the minimum increase or decrease in the unit sales price of the product that should alleviate his concerns. Round your answers to the nearest penny. Use + for increase and - for decrease.

20.The manufacturing manager wants to buy another roasting machine. Based on the Sensitivity Report, determine the net gain or loss if the machine costs $5,000, the full cost is absorbed in this planning cycle, and the optimal production mix does not change. Round your answers to the nearest dollar. Use + for a net gain and - for a net loss

21.The purchasing manager wants to buy more chocolate. Based on the Sensitivity Report, determine the net gain or loss if it takes her purchasing agent two days to accomplish this task at a cost of $700. Round your answers to the nearest dollar. Use + for a net gain and - for a net loss

22.The purchasing manager wants to buy more nuts. Based on the Sensitivity Report and other reports, determine how many pounds of nuts should be purchased.

23.After optimizing the model, what is the improvement in the Return on Sales? Express your result as a difference between the final and original ROS in decimal form rounded to 2 decimal places.

Tutor Answer

TeacherSethGreg
School: Boston College

The ans...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors