Start Excel. Download and open the file named Exp$22\_$Excel$\_$Ch$06\_$ML$2\_$Wages.xlsx$.$ Grader has automatically added your last name to the beginning of the filename.

$0$

$2$ Create range names based on the values in the range I$10$:I$11.15$

$3$ Edit the range name Gross$\_$Earnings so it displays as Gross. $10$

$4$ Apply the Gross and Total$\_$Wages$\_$Paid range names to the formula in cell I$12$ using the Apply Range name method. $8$

$5$ Load the Solver add$-$in if it is not available. Set the objective cell to Min Total Wages Paid $($cell F$13).8$

$6$ Assign Hours Worked $($range E$5$:E$12)$ as the Changing Variables Cells. $6$

$7$ Set a constraint to ensure hours scheduled per employee are whole numbers. $6$

$8$ Set constraints $($two required$)$ to ensure full time employees work between $30$ and $50$ hours per week. $12$

$9$ Set constraints $($two required$)$ to ensure part time employees work between $0$ and $20$ hours. $12$

$10$ Set a constraint to ensure exactly $200$ hours are scheduled for the week. $6$

$11$ Solve the model and create an Answer Report to outline your findings. $9$

$12$ Create a new worksheet named RangeNames and paste a list of the range names created for the analysis starting in cell A$1.8$

$13$ Save and close Exp$22\_$Excel$\_$Ch$06\_$ML$2\_$Wages.xlsx$.$ Exit Excel. Submit the file as directed.Start Excel. Download and open the file named Exp$22\_$Excel$\_$Ch$06\_$ML$2\_$Wages.xlsx$.$ Grader has automatically added your last name to the beginning of the filename.