# Building a Model using a case description and worksheets

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.