I Have Plan A down , I need help for Plan B only. Please make it on excel and explain please

- 13.9 The S&OP team at Kansas Furniture, has received the following estimates of demand requirements: July Aug. Sept. Oct. Dec. 1,200 1,400 1,800 1,800 1,800 Nov. 1,000 Stephanie Klein-Davis/The Roanoke Times/ AP Images a) Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 per unit per month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum require- ments) of 1,000 units per month and subcontract additional units at a $60 per unit premium cost. Plan B: Vary the workforce, to produce the prior month's demand. The firm produced 1,300 units in June. The cost of hiring additional workers is $3,000 per 100 units produced. The cost of layoffs is $6,000 per 100 units cut back. 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 1,000 in Au- gust requires a layoff (and related costs) of 300 units in August, just as going from production of 1,000 in August to 1,200 in September requires hiring (and related costs) of 200 units in September). Px