b. Would the total cost be less with full regular production each period with no overtime, but using a subcontractor to handle the excess above regular capacity at a cost of $45 per hundred bolts? Backlogs are not allowed. The inventory carrying cost is $4 per hundred bolts. (Round your Average inventory values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 6 7 Total Forecast Output Regular Subcontracting Beginning Ending Average Regular Subcontracting Inventory Cost Inventory Total 300 250 250 320 280 275 250 1,925 Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a regular output capacity of 270(00) bolts per month, except for the seventh month, when capacity will be 245(00) bolts. Regular output has a cost of $25 per hundred bolts. Workers can be assigned to other jobs if production is less than regular. The beginning inventory is zero bolts. Month 1 2 3 4 5 6 7 Total Forecast 300 250 250 320 280 275 250 1,925 a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Overtime is $55 per hundred bolts. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 6 7 Total Forecast Output Regular Overtime Output - Forecast Cost Regular Overtime Total 300 275 25 0 $11,000 1,500 $ 12,500 250 250 0 0 10,000 0 10,000 250 250 0 0 10,000 0 10,000 320 280 275 250 1,925 b. Would the total cost be less with full regular production each period with no overtime, but using a subcontractor to handle the excess above regular capacity at a cost of $45 per hundred bolts? Backlogs are not allowed. The inventory carrying cost is $4 per hundred bolts. (Round your Average inventory values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 6 7 Total Forecast Output Regular Subcontracting Beginning Ending Average Regular Subcontracting Inventory Cost Inventory Total 300 250 250 320 280 275 250 1,925 Manager Chris Channing of Fabric Mills, Inc., has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a regular output capacity of 270(00) bolts per month, except for the seventh month, when capacity will be 245(00) bolts. Regular output has a cost of $25 per hundred bolts. Workers can be assigned to other jobs if production is less than regular. The beginning inventory is zero bolts. Month 1 2 3 4 5 6 7 Total Forecast 300 250 250 320 280 275 250 1,925 a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Overtime is $55 per hundred bolts. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 6 7 Total Forecast Output Regular Overtime Output - Forecast Cost Regular Overtime Total 300 275 25 0 $11,000 1,500 $ 12,500 250 250 0 0 10,000 0 10,000 250 250 0 0 10,000 0 10,000 320 280 275 250 1,925