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)?