Question
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
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