Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Corporation X, which manufactures laptops, would like to understand how many laptops it needs to produce within the next month. This company produces three types
Corporation X, which manufactures laptops, would like to understand how many laptops
it needs to produce within the next month. This company produces three types of laptops: Y-1, Y-
2, and Y-3. Y-1 needs 150 days of labor and $5,000 raw materials, while Y-2 needs 400 days of
labor and $12,000 raw materials, and Y-3 needs 350 days of labor and $8,000 raw materials. The
plant has a capacity of 300,000 working days per month, and it has a $10 million material budget
per month. While the profit contribution of Y-1 is $5,000, Y-2 is $15,000, and Y-3 is $10,000. The
company needs to produce at least 200 units of Y1, at least 100 units of Y2, and at most 300 units
of Y3 each month. The main issue is to maximize the company's profits by identifying how many
units of each laptop type should be produced each month. Present this information on a worksheet
titled "Ouestion 1"
showing your findings. Include your interpretation of the results to senior
management in the report document.
Use Solver and answer the following questions:
1. How many Y-1, Y-2, and X-3 should the company produce to maximize the profit?
2. Interpret the results you get from the Solver in a short paragraph. (e.g., you can mention which
Laptop type is (not) profitable and why).
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