Re create the S OP spread sheet used in Table 10 10 and
Re-create the S&OP spread sheet used in Table 10.10 and Example 10.11. (You do not have to build in the optimization model using the Solver function.) While your formatting may differ, your answers should be the same. Your spreadsheet should generate new results any time any of the planning, sales forecast, or hiring/layoff values are changed. To test your spreadsheet, change the planning values to match the following:

If your spreadsheet works correctly, the new total cost for a level production plan should be $5,769,100, and for a chase production plan, it should be $5,755,600.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help