Please see attached excel spreadsheet for Q. Please show all calculations. A company is considering three different product quality strategies. Using the following data table, analyze the situation to answer the three questions Product Quality Forecasted Sales Units/yr Price/Unit Variable Cost/Unit Fixed Cost/yr Production Capacity Units/yr* 1. HIGH 100,000 $60.00 $40.00 $1,500,000 50,000 2. MEDIUM 200,000 $40.00 $35.00 $1,000,000 333,000 3. LOW 450,000 $25.00 $24.00 $400,000 500,000 *= the maximum annual volume possible from the operation 1. What are the breakeven points and the annual profits of each alternative? 2. Which is the best Product Quality alternative and why? 3. Using the EVA model, explain how OPSCM could impact this decision.,excellent. i was trying to figure out how to send it to you directly vs posting to the general pool of tutors. I am glad that you picked it up.,Hi. This looks great. I have one Q, In column "I" (annual profit) you have 50,000, 333,000 and 500,000 in the equation (respectively from high to low) How did you come up with those numbers? Please explain. Thanks.
Paper#5881 | Written in 18-Jul-2015Price : $25