An Excel spreadsheet for doing S&OP at a skateboard company. Work with this spreadsheet to develop the lowest overall cost plan for meeting the demand forecast. Develop your plan based on the following information:

• The forecast has been validated and entered into the spreadsheet.
• Starting inventory is zero.
• One employee has been injured on the job so regular weekly production is reduced to 280 units
• Rather than hiring short-term, overtime will be allowed. The maximum overtime unit production is 40 units per week

 

Skateboard Problem (Problem Set Solution) S&OP Plan Period Forecast Output Regular Overtime Subcontract Output-Forecast Inventory Beginning Ending Average Backlog Cost Table Regular Overtime Subcontract Inventory (per) Backorders Cost Model Period Output Regular Overtime Subcontract Inventory Backorders Total $ $ $ $ 1 200 -200 1 0 0 0 200 . $2 $3 $6 $1 $5 $ $ $ $ 2 200 -200 2 0 0 0 400 $ $ $ $ 3 300 -300 3 0 0 0 700 . $ $ $ $ 4 400 -400 0 0 0 1100 4 $ $ $ $ 5 500 -500 0 0 0 1600 5 $1,000 $2,000 $3,500 $5,500 $8,000 $1,000 $2,000 $3,500 $ 5,500 $ 8,000 $ $ $ $ 6 200 -200 6 0 0 0 1800 $ $ $ $ $9,000 $ $9,000 $ Total 1800 0 0 0 -1800 0 5800 Total 29,000 29,000