Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help with my OIM homework? Can you provide detailed and organized answers? Please make sure these answers are right. Thank you! LMNO
Can you please help with my OIM homework? Can you provide detailed and organized answers? Please make sure these answers are right. Thank you!
LMNO Gaskets has seeks an optimal production plan for a product to meet demand over the upcoming three quarters. Demand in each of the three quarters and production, overtime, and subcontracting capacities are reported in the table below. The relevant costs are:
- Regular time production cost is $20/unit.
- Overtime production cost is $30/unit.
- Subcontracting cost is $34/unit.
- Inventory is held at a cost of $5/unit/quarter.
- Units may be backordered at a cost of $8/unit/quarter
What is the cost of the optimal production plan (Use EXCEL Solver)?
\begin{tabular}{||c|c|c|c|c||} \hline \multicolumn{1}{||c|}{\begin{tabular}{c} Production \\ Resource \end{tabular}} & \multicolumn{2}{c|}{ Demand in Quarter } & \multirow{2}{*}{ Capacity } \\ \cline { 2 - 5 } & Q1 & Q2 & Q3 & \\ \hline \hline Regular Time Q1 & & & & 600 \\ \hline \hline Overtime Q1 & & & & 300 \\ \hline \hline Subcontract Q1 & & & & 650 \\ \hline \hline Regular Time Q2 & & & & 600 \\ \hline Overtime Q2 & & & & 300 \\ \hline \hline Subcontract Q2 & & & & 650 \\ \hline \hline Regular Time Q3 & & & & 600 \\ \hline \hline Overtime Q3 & & & & 300 \\ \hline \hline Subcontract Q3 & & & & 650 \\ \hline \hline Demand in Quarter & 1100 & 1900 & 720 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started