Question: Hello please assist and show me the steps towards getting the what if analysis. You are the operations manager over a production line that manufactures,

Hello please assist and show me the steps towards getting the what if analysis.

You are the operations manager over a production line that manufactures, assembles, and packages three types of products: A, Band C. The spedfications are illustrated in the following table: Volume produced and sold [items] 3'500 4500 1500 Unit sales priceiSfitem] 3 7.5 16.5 TotaIVariable Expenses (51 11250 mm The total fixed costs are $5,000. Product C has doubled costs than that ofA or B. Obtain the following information using Excel. Then, perform an analysis to the results obtained. a. The Break-even point of production and sales of each product b. The profit for each product type. c. Plot the profit graphs for all of the products using *Whatif' sensitivity analysis algorithm in Excel cl. Determine and interpret the gross margin rate e. Determine and intermet the critical turnover ( in 5]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
