_{The answer "less than $123,000,000" was incorrect, so please help me find the correct one. Thank you!}

Incorrect Question 21 0/4 pts We 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 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 cost production plan. Month Demand Forecast Month Demand Forecast January 133,067 July 251,630 February 155,026 August 249,630 March 168,200 September 200,312 April 173,890 October 160,830 May 202,759 November 145,266 June 260,842 December 128,900 Regular production cost $48 per unit Holding cost $13 per unit per month based on ending inventory Backorder cost $17.00 per unit per month based on ending inventory Beginning Inventory 430,000 units Beginning workforce 18 employees Regular production rate 9,600 units per employee per month Hiring cost $14,000 per worker Firing cost $ 16,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 possible. What are the total costs incurred following the level production strategy? Less than $123,000,000 Greater than $123,200,001 Between $123,000,001 and $123,100,000 Between $123,100,001 and $123,200,000 Incorrect Question 21 0/4 pts We 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 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 cost production plan. Month Demand Forecast Month Demand Forecast January 133,067 July 251,630 February 155,026 August 249,630 March 168,200 September 200,312 April 173,890 October 160,830 May 202,759 November 145,266 June 260,842 December 128,900 Regular production cost $48 per unit Holding cost $13 per unit per month based on ending inventory Backorder cost $17.00 per unit per month based on ending inventory Beginning Inventory 430,000 units Beginning workforce 18 employees Regular production rate 9,600 units per employee per month Hiring cost $14,000 per worker Firing cost $ 16,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 possible. What are the total costs incurred following the level production strategy? Less than $123,000,000 Greater than $123,200,001 Between $123,000,001 and $123,100,000 Between $123,100,001 and $123,200,000