Using the information in the case (attached HBR Case Study) along with the information in the included exhibits, answer the following questions

Using the information in the case (attached HBR Case Study) along with the information in the included exhibits, answer the following questions:

Submit your answers in a clearly labeled Excel workbook using the filename Tina Thomas_Metabical_2022.xls (do the assignment in the excel sheet attached)

Questions to be answered –
1. Essay question. (Include answers in your Excel workbook.) Explain at least three uses for an accurate demand forecast.
2. Calculate annual unit sales for each of the three sales Forecast Approaches for a five year period
3. Calculate total annual total Gross Margin for a five year period using the three unit sales Forecasts for each of the three target prices.
4. Determine which forecast approach and target price combinations will achieve a minimum ROI of 5%. Which forecast would you recommend and why? What impact does pricing have on profitability?
5. What are two ways that you can suggest to improve the accuracy of these forecasts. (Include answers in your Excel workbook.)

Notes:
1. Refer to Exhibits 1, 2 and 3 to answer these questions
2. For question 4 use the given fixed costs in Exhibit 4
3. Clearly state any assumptions you make in your worksheets.
4. Use good Excel techniques covered in class.
a. Presentation quality with everything labeled.
b. Clearly define and label all variables (don’t hide them in cell formulas)

Last Completed Projects