Open the downloaded file exploring_e06_grader_h3_Viking Heating and Air.xlsx.	0
2	Create range names based on the values in the range A2:B5.	10
3	Use the formula Service_calls * Trip_charge + Hourly_rate* Hours_billed to determine gross income.	5.5
4	Load the Solver add-in. Set the objective cell B6 to 120000 and set B2:B5 as Changing Variable Cells.	12
5	Set three separate constraints to ensure service calls, hourly rate, and trip charge are integers.	15
6	Set a constraint to ensure hours billed cannot exceed (less than or equal to) 2500.	10
7	Set a constraint to ensure the trip charge does not exceed (less than or equal) 50.	10
8	Set a constraint to ensure hourly rate does not drop below (greater than or equal to) 30.	10
9	In the Solver Options dialog box, ensure that Use Automatic Scaling is selected (on the All Methods tab), and that Require Bounds on Variables is selected on the next two tabs. Click OK. Solve and create an Answer Report to outline your findings.	17.5
10	On the Viking AC worksheet, create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.	10
11	Save and close the file. Based on your instructors directions, submit exploring_e06_grader_h3_Viking Heating and Air.xlsx.	0