Problem 3(35%):Chapter 3-Question 11, part a.Do not complete parts b,c c, d, or e. Formulate the problem in a textbox alongside the spreadsheet model. Using Excel Solver, solve for the optimal solution and optimal value. Be sure to appropriately color the different parts of the spreadsheet model.

Also, generate anAnswer Report.

11. TVGuru Inc. manufactures LCD TV and Plasma TV sets in its Kentucky plant. The company makes a profit of $400 on each Plasma TV and $300 on each LCD TV set. The production process has a capacity of 30,000 machine-hours. It takes 3 machine-hours to produce a unit of Plasma TV and 1 machine-hour to produce a unit of LCD TV. After a market research survey by a well-known research firm, it is concluded that no more than 8,000 Plasma and 12,000 LCD TVs could be sold. a. Formulate the LP model