Question: The following gure shows an Excel spreadsheet that calculates weighted
The following ﬁgure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values for up to ﬁve demand points. Re-create this spreadsheet in Excel. While your formatting does not have to be exactly the same, your answers should be. Your spreadsheet should recalculate results whenever any changes are made to the shaded cells. To test your logic, change the weight on demand point D to 250. Your new weighted X and Y coordinates should be 3.04 and 2.96, respectively.
Answer to relevant QuestionsRe-create the assignment problem spreadsheet for Flynn Boot Company, described in Example 8.7 and Figures 8.9 through 8.11. While your for matting does not have to be exactly the same, your spread-sheet should work the same. ...If forecasting is so important, why do firms look to approaches such as CPFR as a way to reduce the need for forecasting?Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why?PERIOD DEMAND1............ 2212............ 2473............ ...While searching through your class notes, you stumble across the following forecasting model: Demand = (35,000 + 4.8 * period) seasonal indexSEASONAL INDICESSummer ...Some people have argued that the process of developing a sales and operations plan is as important as the ﬁnal numbers. How could this be?
Post your question