please solve using excel formulas and solver.

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 household), the "Milwaukee" (3-5 person household) and the "Provo" (6-9 person household). The company has two different production steps its suppliers provide pre- 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 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. Task Description Calculate the profit/unit for the NYC model. Profit/unit is calculated as Retail Price - Unit Costs for the NYC model. Reuse your formula to calculate the profit/unit the other models. Calculate total profit for all units in cell G22. Total profit is calculated as the sum of the products of the profit/unit and units produced for each model. Calculate the inspection time in hours for the NYC model in cell D25. The inspection time in hours is the number of minutes required to inspect the parts for the NYC model divided by 60 (because there are 60 minutes in an hour). Reuse your formula to calculate the hourly inpsection times for all models. Calculate the LHS constraint for Inspection time. The LHS constant for Inspection time is the total amount of Inspection time used for all of the models produced. This the sum of the products of the number of units produced and the inspection time required for each model. Calculate the assembly time in hours for the NYC model in cell D26. The assembly time in hours is the number of minutes required to assemble the NYC model divided by 60 (because there are 60 minutes in an hour). Reuse your formula to calculate the hourly assembly times for all models. Calculate the LHS constraint for Assembly time. The LHS constaint for Assembly time is the total amount of Assembly time used for all of the models produced. This is the sum of the products of the number of units produced and the Assembly time required for each model. Set the RHS constraint value for inspection time. There are 160 total hours a month available for inspections. Set the RHS constraint value for Assembly time. There are 300 total hours a month available for Assembly. 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. Parameters NYC Inspection Assembly Retail Price Unit Costs Milwaukee Provo 12 15 13 22 24 281 $299 $330 $410 $190 $210 $280 Decisions Production 1 1 Objective Total Profit Profit/Unit Left Hand Side (LHS) Right Hand Side Constraints Inspection Assembly