# Building a Model using a case description and worksheets

*label*Business Finance

*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.

### Unformatted Attachment Preview

## Tutor Answer

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