Create a modeland use Excel Solver to answer the following: A computercompany manufactures two types of computers. Each type of computerwill require assembly time, inspection time, and storage space. Theamounts of each of these resources that can be devoted to theproduction of the computers is limited. The manager wants todetermine the quantity of each computer to produce to maximize theprofit generated by sales of these computers.
In order to develop asuitable model of the problem, the manager has met with design andmanufacturing personnel. As a result of those meetings, the managerhas obtained the following information:
| Type1 | Type2 |
Profit per unit | $60 | $75 |
Assembly time perunit | 4 hours | 10 hours |
Inspection time perunit | 30 minutes | 20 minutes |
Storage space perunit | 3 cubic feet | 3 cubic feet |
The manager has alsoacquired information on the availability of resources. These dailyamounts are:
Resource | Amount Available |
Assembly time | 100 hours |
Inspection time | 22 hours |
Storage space | 39 cubic feet |
The manager also metwith the firm's marketing manager and learned that demand for themicrocomputers was such that whatever combination of these twotypes of computers is produced, all the output can be sold.
a. What is the mix ofcomputers that the company should produce if they want to maximizeprofits?
b. What is the optimalvalue for profit using the mix from part a.?
c. If type 2 computerbecame twice as profitable (i.e. profit rose from $75 each to $150each), would the solution change? If so, what is the new solution(please state the mix and the new profit amount)?
