Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Options Trading For Beginners

Authors: Mike Hartley

1st Edition

979-8864514832

More Books

Students also viewed these Finance questions