I need help with this problem.

OM Safari File Edit View History Bookmarks Window Help Problem - Page Layout Formulas Data Review View Share Comments One 21A Y Text One x 1 W D Bernie Number One Coro 53.00 The food 700 when and ction of probe one of bourbo www.thered the w stew Snotkun 1650 to wa I therefore when www Vot Chat BCS SC A 4 De Shot NA Challenge Tag Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF v Problem 8-9 me Insert Draw Page Layout Formulas Data Review View Calibri (Body) v 11 w AA % aste BI U v Number B E Problem 8-9 Product 1 7 4 Product 2 8 6 $875.67 Total Profit Number of Overtime Hours Cost of Overtime Hours Number of Units Labor Hours per Unit 5 2 3 9 10 $76.00 14 15 20 onal Formatting 4 Tas Table v Cells Editing Ideas Sensitivity tyles K L M H N The profit function for two products is Profit=-3x2 +42X; - 3x2 +48x2 + 700 where x, represents units of production of product 1 and x, represents units of production of product 2. Producing one unit of product 1 requires 4 labor-hours and producing unit of product 2 requires 6 labor hours. Currently, 24 labor-hours are available. The cost of labor hours is already factored into the profit function. However, it is possible to schedule overtime at a premium of $5 per hour. a. Enter the formula for the objective function in cell F3. Hint: Assume you will need to use overtime hours. b. Enter the formula for the Number of Overtime Hours in cell F4 c. Solve the optimization model. How much should be produced and how many overtime hours should be scheduled? 100 ChallengeProt 7 chapter 10.1 ols Window Problem 8-9 View Share Clear Im Solver Parameters he Set Objective: SG$161 To: Max Min Value Of L By Changing Variable Cells: $B$4:$C$4 TS Subject to the Constraints: $854-5654 integer Add dx, represent 1 requires 41 rently, 24 laba o the profit fur er hour Change Hint: Assume Delete Tin cell 4 produced and he Reset All Load/Save Make Unconstrained variables Non-Negative Select a Solving Method GRG Nonlinear Options Solving Method Select the CRG Nonlinear engine for Solver Problems that are smooth nonlinear Select the LP Simplex engine for linear Solver Problems. and select the Evolutionary engine for Solver problems that are non- smooth Close Solve