Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HAL produces two types of computers: PCs and VAXes. The computers are produced in two locations: New York and Los Angeles. New York can produce

HAL produces two types of computers: PCs and VAXes. The computers are produced in two locations: New York and Los Angeles. New York can produce up to 800 computers and Los Angeles up to 1000 computers. HAL can sell up to 900 PCs and 900 VAXes. The profit associated with each production site and computer sale is as follows: New York-PC $600; VAX, $800; Los Angeles PC, $1000; VAX, $1300. The skilled labor required to build each computer at each location is as follows: New York-PC, 2 hours; VAX, 2 hours; Los Angeles-PC, 3 hours; VAX, 4 hours. A total of 4000 hours of labor are available. Labor is purchased at a cost of $20 per hour. a. Formulate a linear programming model to determine how many PCs and VAXes should HAL produce in each location to maximize its profit? Use Solver to find the optimal solution b. If 3000 hours of skilled labor were available, what would be HALs profit? c. Suppose an outside contractor offers to increase the capacity of New York to 850 computers, at a cost of $5000. Should HAL hire the contractor? d. By how much would the profit for a VAX produced in Los Angeles have to increase before HAL would want to produce VAXes in Los Angeles? e. What is the most HAL should be willing to pay for an extra hour of labor? PLEASE ANSER IN EXCEL FORMAT AND IF PROBLEM REQUIRES A SOLVER PLEASE SCREENSHOT AND POST

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

Energy And Finance Sustainability In The Energy Industry

Authors: André Dorsman, Özgür Arslan-Ayaydin, Mehmet Baha Karan

1st Edition

3319322664, 978-3319322667

More Books

Students also viewed these Finance questions

Question

Are men or women better leaders? Why?

Answered: 1 week ago

Question

Additional Factors Affecting Group Communication?

Answered: 1 week ago