Please use excel to solve and show all formulas

Given the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per Problem 8: Refer to the data in Problem 6, If backorders are allowed, determine the total cost of a plan if overtime is limited to 40 units per month and subcontracting is limited to 20 units per month. Backordering costs are \\( \\$ 30 \\) per unit. G Costs Regular Time Overtime Subcontracting Holding Back Order J \\begin{tabular}{|l|l|} \\hline 40.00 & per unit \\\\ \\hline 60.00 & per unit \\\\ \\hline 80.00 & per unit \\\\ \\hline \\end{tabular} K L M \\( \\mathbf{N} \\) O Production 10.00 per unit per month Regular per unit Overtime \\begin{tabular}{|ll|l} \\hline\\( \\$ \\) & 10.00 & per unit per month \\\\ \\hline\\( \\$ \\) & 30.00 & per unit \\\\ \\hline \\end{tabular} Subcontracting \\begin{tabular}{l|l} Backorder Inventory \\\\ \\hline \\end{tabular} Production Cost Units Cost Costs