Question: Re create the assignment problem spreadsheet for Flynn Boot Company described
Re-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. Speciﬁcally, the user should be able to change the weekly capacity (Ci), weekly demand (Dj), or shipping cost (Cij) values and generate a new solution using Excel’s Solver function. Test your spreadsheet by seeing whether you get a new solution when Atlanta’s ware house capacity changes from 20,000 to 15,000. Make sure your answers match those in Example 8.7.
Answer to relevant QuestionsConsider the following information:Cost to shop from plant to store (per unit of demand)a. Write out the assignment problem by hand, using Equations (8.4) through (8.7) and Example 8.7 as a guide.b. Develop an Excel ...Develop a three-period moving average forecast for periods 13–15.PERIOD DEMAND10............ 24811............ 37012............ 42413............ 28614............ 444Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights of 0.4, 0.35, and 0.3, with the most recent observation weighted the highest. Calculate the MFE, MAD, and MAPE values for periods ...Suppose you are given the following demand and forecast data for the past four quarters:Develop a seasonal index for each of the quarters. Does the fall quarter really need a seasonal adjustment index? Explain.How does S&OP differ from strategic capacity planning? From detailed planning and control? What role does S&OP play in the overall planning activities of an organization?
Post your question