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