I strongly suggest using Excel to setup the aggregate plan associated with these questions A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest "Squeaky Clean" IV stand, which eliminates all oils and germs left behind by users. Though IVP sells these stands all year long, they sell the most during the summer months, when end-of-fiscal year purchases are at a peak. The demand over the next 12 months is shown in the table below. Use the demand forecasts and determine the lowest coast production plan Month Demand Forecast Month Demand Forecast January 133 057 July 251,630 February 155,026 August 249,630 March 16200 September 200,312 April 173,890 October 160,830 May 202.759 November 145,266 June 260.842 December 128,900 Regular production cost SO per unit Holding cost $23 per unit per month based on ending inventory Backorder cost $35.00 per unit per month based on ending inventory Beginning Inventory 650,000 units Beginning workforce 21 employees Regular production rate 5,600 units per employee per month Hiring cost $9,000 per worker Firing cast $12,000 per worker Produce at a level rate using regular time production only. Backlogs are allowed in any month except December. Ending inventory is allowed in any month. Ending inventory for December should be as low as posible What is the hiring or firing cost in the first month following the level production strategy? o Between 0 and $15.000 o Between $15,001 and 525,000 o Between $25,001 and S35,000 o Between $35,001 and 545.000 I strongly suggest using Excel to setup the aggregate plan associated with these questions A key hospital supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest "Squeaky Clean" IV stand, which eliminates all oils and germs left behind by users. Though IVP sells these stands all year long, they sell the most during the summer months, when end-of-fiscal year purchases are at a peak. The demand over the next 12 months is shown in the table below. Use the demand forecasts and determine the lowest coast production plan Month Demand Forecast Month Demand Forecast January 133 057 July 251,630 February 155,026 August 249,630 March 16200 September 200,312 April 173,890 October 160,830 May 202.759 November 145,266 June 260.842 December 128,900 Regular production cost SO per unit Holding cost $23 per unit per month based on ending inventory Backorder cost $35.00 per unit per month based on ending inventory Beginning Inventory 650,000 units Beginning workforce 21 employees Regular production rate 5,600 units per employee per month Hiring cost $9,000 per worker Firing cast $12,000 per worker Produce at a level rate using regular time production only. Backlogs are allowed in any month except December. Ending inventory is allowed in any month. Ending inventory for December should be as low as posible What is the hiring or firing cost in the first month following the level production strategy? o Between 0 and $15.000 o Between $15,001 and 525,000 o Between $25,001 and S35,000 o Between $35,001 and 545.000