Question: Please solve using excel and show all formulas Problem 8: Refer to the data in Problem 6, If backorders are allowed, determine the total cost

Please solve using excel and show all formulas
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
