Manager Chris Channing of Fabric Mils, Inc, has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a normal capacity of 275(00) bolts per month, except for the seventh month, when capacity will be 250(00) bolts. Normal output has a cost of $40 per hundred bolts. Workers can be assigned to other jobs if production is less than hormal. The beginning inventory is zero bolts Click here for the Excel Data File b. Develop a chase plan that matches the forecast and compute the total cost of your plan . Overtime is $60 per hundred bolts (Negative omounts should be indlcated by a minus sign. Leave no cells blank-be certain to enter " 0 " wherever required.) b. Would the total cost be less with regular production with no overtime, but using a subcontractor to handle the excess above normal capacity at a cost of $50 per hundred bolts? Backlogs are not allowed. The inventory carrying cost is $2 per hundred boits. (Round your Average Inventory volues to 1 decimol place. Negative amounts should be Indicoted by a minus sign. Leave no cells blank be certain to enter " O " wherever required.) Manager Chris Channing of Fabric Mils, Inc, has developed the forecast shown in the table for bolts of cloth. The figures are in hundreds of bolts. The department has a normal capacity of 275(00) bolts per month, except for the seventh month, when capacity will be 250(00) bolts. Normal output has a cost of $40 per hundred bolts. Workers can be assigned to other jobs if production is less than hormal. The beginning inventory is zero bolts Click here for the Excel Data File b. Develop a chase plan that matches the forecast and compute the total cost of your plan . Overtime is $60 per hundred bolts (Negative omounts should be indlcated by a minus sign. Leave no cells blank-be certain to enter " 0 " wherever required.)