Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

General Managers In Action Policies And Strategies

Authors: Francis Joseph Aguilar

2nd Edition

0195073673, 978-0195073676

More Books

Students also viewed these General Management questions

Question

Why are so many people afraid of communication?

Answered: 1 week ago