I need help solving these problems

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 normal capacity of 275(00) bolts per month, except for the seventh month, when capacity w 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 normal. The beginning inventory is zero bolts. Click here for the Excel Data File a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Overtime is $60 per hundred boits. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter " 0 " wherever required.) Prepare a master production schedule for industrial pumps in the-manner of the following table. Use the MPS rule to "schedule production when the projected on-hand inventory would be less than 10 without production." Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used. (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 allewed. The inventory carrying cost is $2 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.) \begin{tabular}{|c|} \hline Output - Forecast \\ \hline Inventory \\ \hline Beginning \\ \hline Ending \\ \hline Average \\ \hline Backlog \\ \hline Costs: \\ \hline Output \\ \hline Regular \\ \hline Overtime \\ \hline Subcontract \\ \hline Inventory \\ \hline Backorder \\ \hline Total \\ \hline \end{tabular}