Why is there a need for aggregate planning?

discuss.. what are the key inputs to aggregate planning?

Define what you mean by "what-if analysis." How might a spreadsheet be used in capacity planning?

The S&OP team at Kansas Furniture, led by David Angelow, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $125 per unit, Kinventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan B: Vary the workforce to produce the prior month's demand. Demand was 1,300 units in June. The cost of hiring additional workers is $30 per unit produced. The cost of layoffs is $65 per unit cut back. (Enter all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of 1,300 in July to 1200 in August requires a layoff (and related costs) of 100 units in August). Stockouts (Units) Month 1 July Demand 1200 Hire Production (Units) Layoff Ending (Units) Inventory 2 August 1300 3 September 1200 4 October 1700 5 November 1650 6 December 1650