Use solver Excel, Please show the cells and more put into the solver function in excel

Wald Open recovered workbooks? Your rece No Assignment Tasks Planning Production Practice Use Solver to determine the optimal number of units produced to maximize overall profit given the constraints. Make sure that you account for all problem constraints including those in the problem narrative. [55 points] Office Update To keep up-to-date with fx es 9 A1 A B D E K 1 2 The "Freeze-It Now Inc. makes top-notch refrigerators for different home sizes. Currently, the company is planning its production schedule for its three models: the "NYC (1-2 person 4 household), the Milwaukee (3-5 person household) and the Provo (6-9 person household). The company has two different production steps fits suppliers provide pre- 5 manufactured modules from south-east Asia) to assemble a refrigerator: parts inspection and final assembly. The necessary times in minutes per unit) for each model are given in the 6 7 8 following table. The table also provides information with respect to the retail price and the unit costs in USD. In the inspection department, the company has a capacity of 160 hours/month and in the assembly department 300 hours/month. The operations manager requires that the schedule be determined for full units per month only. Parameters NYC Provo Inspection Assembly Retail Price Unit Costs 12 22 $299 $190 Milwaukee 15 24 $330 $210 13 28 $410 $280 Decisions 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Production Objective Profit/Unit and Total Profit $109 $120 $130 $ 359 Constraints Inspection Assembly 1 1.83333333 1.25 1.08333333 2 2.33333333 Left Hand Side (LHS) 3.333333333 6.166666667 Right Hand Side (RHS) 160 hours/month 300 hours/month