Show on excel with formulas and using solver with formulas

The Gourmet Grill Company manufactures and sells two different types of grills: propane and electric. Each propane grill sells for $$320$ and costs $$220($$$100$ Profit$)$ to manufacture. Each electric grill sells for $$260$ and costs $$180($$$80$ Profit$)$ to manufacture. Each grill goes through four operations in the manufacturing process. The hours required by each type of grill in each of these manufacturing processes is

summarized as follows:

Hours required per unit

Propane Electronic

Machine Press $2,1$

Fabrication $4,5$

Assembly $2,3$

Testing $1,1$

In the next production cycle there are $2,400$ hours of machine press time

available, $6,000$ hours of fabrication, $3,300$ hours of assembly, and $1,500$ hours

of testing capacity. Assume Gourmet Grill can sell everything they make and

would like to determine the production plan that would maximize profit.

$$ Formulate an LP model for this problem in a textbox.

$$ Create a spreadsheet model for this problem and solve it using

Solver.

$$ What is the optimal solution? In a textbox, write the optimal

solution and decision variables.