Consider the following weekly resource allocation problem faced by the productionmanager of XYZ Company. XYZ sells three types of computers; the PC (type X), thenotebook computer (type Y), and the workstation (type Z). The net profit from each isType X: $350;Type Y: $470; andType Z: $610where net profit equals the sales price of each computer minus the direct costs ofpurchasing components, producing computer cases, and assembling and testing thecomputer. Assume that all production during any given week can and will be soldimmediately.For a particular week, 120 hours are available on the Type-A test equipment, where Xand Y's are tested, and 48 hours are available on the Type-B test equipment, where Z'sare tested. The testing of each computer takes one hour, regardless of type. Production isconstrained by the availability of 2000 labor hours for product assembly. Each Type Xtakes 10 labor hours, type Y takes 15 labor hours and type Z takes 20 labor hours. Otheractivities have virtually unlimited resources.(i) Construct, by hand, an LP model of this problem.(ii) Use the SOLVER in Excel to solve this problem.Interpret youroutput.

Solve this problem using Solver in Excel and provide answers tothe following questions:

a.How many PCs, Notebook computers, and workstations should be produced?

b. What is the total profit?

c.Is this an optimal solution?

d.Please submit your supporting Excel spreadsheet.

e.If you were given additional funding,wherewould you invest that money to increase your profit andwhy?(Hint: testing equipment?If so, which ones A, B, or both?production labor? Both testing equipment and production labor?make sure to articulate the reason(s) for your investment decision.