Office2000 produces expensive, quality 2-drawer and 4-drawer filing cabinets from solid oak for major corporations. A...

50.1K

Verified Solution

Question

General Management

Office2000 produces expensive, quality 2-drawer and 4-drawerfiling cabinets from solid oak for major corporations. A 2-drawermodel utilizes 2 labor hours to produce and package for a netprofit of $75. The 4-drawer model utilizes 3 labor hours to produceand package and nets a profit of $125. Each month Office2000 has360 labor hours available and can obtain up to 200 2-drawer frames,200 4-drawer frames, and 400 drawers from its oak supplier. Alinear programming model is formulated to maximize monthly profitfrom the manufacture of filing cabinets at Office2000. MAX 75X1 +125X2 ST 2X1 + 3X2 ? 360 2X1 + 4X2 ? 400 X1 ? 200 X2 ? 200 Set upthe model in Excel and solve for the optimal solution using Solver.In the boxes below, enter the optimal values of X1 (first box) andX2 (second box).

Answer & Explanation Solved by verified expert
4.4 Ratings (635 Votes)
Here X1 is the quantity of 2drawer andX2 is trhe    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students