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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these General Management questions