Question: Open e 0 6 m 2 Wages and save it as c 0 6 m 2 Wages _ LastFirst. b . Create range names based
Open emWages and save it as cmWagesLastFirst. b Create range names based on the values in the range : c Edit the range name Gross Ear nings so it displays as Gross. d Apply the Gross and TotalWagesPaid range names to the worksheet. Load the Solver addin if it is not available. Set the objective cell to Min Total Wages Paid cell F f g Assign Hours Worked range E:E as the Changing Variables Cells. h Set a constraint to ensure hours scheduled per employee are whole numbers. Set constraints two required to ensure fulltime employees work between and hours per week. j Set constraints two required to ensure parttime employees work between and hours per week. k Set a constraint to ensure exactly hours are scheduled for the week. I. Solve the model and create an Answer Report to outline your findings. m Create a new worksheet named RangeNames and paste a list of the range names created for the analysis starting in cell A n Save and close the file. Exit Excel. Based on your instructor's directions, submit: emWagesLastFirst
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
