Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want correct answer with explanation... I'll upvote you... A company makes two types of computer desks from laminated particle board. The Presidential computer desk

I want correct answer with explanation...

I'll upvote you...

A company makes two types of computer desks from laminated particle board. The Presidential computer desk model requires 30 square feet of particle board, one keyboard sliding mechanism, 5 hours of labor to fabricate, and sells for $149. The Senator computer desk model requires 24 square feet of particle board, one keyboard sliding mechanism, requires 3 hours of labor to fabricate, and sells for $135. In the coming week, the company can buy up to 15,000 square feet of particle board at $1.35 per square foot and up to 600 keyboard sliding mechanisms at a cost of $4.75 each. The company views manufacturing labor as a fixed cost and has 3,000 labor hours available in the coming week for the fabrication of these desks. Determine the number of Presidential and Senator computer desk models that should be made to maximize profit.

Let X1 = number of Presidential computer desks manufactured next week

X2 = number of Senator computer desks manufactured next week

Max Z=103.75X1+97.85X2

Subject to:

30X1+24X2 15,000

X1+ X2 600

5X1+ 3X2 3,000

a) Perform the calculations to show that the profits for the Presidential computer desks are $103.75 and the Senator computer desks are $97.85.

b) Use the solver in Excel to find the optimal solution. Indicate the value of X1, X2, and Z using the context of the problem. In other words, give your answers as sentences.

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

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

Fundamentals Of Quality Control And Improvement

Authors: Amitava Mitra

5th Edition

1119692334, 978-1119692331

More Books

Students also viewed these General Management questions

Question

Identify the major phases of the training and HRD process

Answered: 1 week ago