You are the chief financial officer for Viking Heating and Air. You were given the task of increasing gross income from $91,000 to $120,000 per year. Vikings income is earned through service calls. Customers are charged trip and hourly charges as pictured in the table below. Your goal is to create a spreadsheet to enable you to evaluate the most economically feasible option for increasing gross income while adhering to the following constraints. The maximum amount of hours billed without hiring additional technicians is 2,500. The trip charge may not exceed $50.00, and the service hourly rate/trip charge must all be whole numbers. The calls/hourly rate/trip charge must all be whole numbers. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible

**Hi could you please upload a set by step picture for this problem and how to do each function in excel** THANK YOU

1.Open the downloaded file exploring_e06_grader_h3_Viking Heating and Air.xlsx. 0.000

2 Create range names based on the values in the range A2:B5. 10.000

3 Use the formula Service_calls * Trip_charge + Hourly_rate* Hours_billed to determine gross income. 8.000

4 Load the Solver add-in. Set the objective cell B6 to 120000 and set B2:B5 as Changing Variable Cells. 12.000

5 Set constraints to ensure service calls, hourly rate, and trip charge are integers. 15.000

6 Set a constraint to ensure hours billed cannot exceed (less than or equal to) 2500. 10.000

7 Set a constraint to ensure the trip charge does not exceed (less than or equal) 50. 10.000

8 Set a constraint to ensure hourly rate does not drop below (greater than or equal to) 30. 10.000

9 Solve and create an Answer Report to outline your findings. 15.000

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.000

11 Save and close the file. Based on your instructors directions, submit exploring_e06_grader_h3_Viking Heating and Air.xlsx. 0.000

Question

You are the chief financial officer for Viking Heating and Air. You were given the task of increasing gross income from $91,000 to $120,000 per year. Vikings income is earned through service calls. Customers are charged trip and hourly charges as pictured in the table below. Your goal is to create a spreadsheet to enable you to evaluate the most economically feasible option for increasing gross income while adhering to the following constraints. The maximum amount of hours billed without hiring additional technicians is 2,500. The trip charge may not exceed $50.00, and the service hourly rate/trip charge must all be whole numbers. The calls/hourly rate/trip charge must all be whole numbers. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible

**Hi could you please upload a set by step picture for this problem and how to do each function in excel** THANK YOU

1.Open the downloaded file exploring_e06_grader_h3_Viking Heating and Air.xlsx. 0.000

2 Create range names based on the values in the range A2:B5. 10.000

3 Use the formula Service_calls * Trip_charge + Hourly_rate* Hours_billed to determine gross income. 8.000

4 Load the Solver add-in. Set the objective cell B6 to 120000 and set B2:B5 as Changing Variable Cells. 12.000

5 Set constraints to ensure service calls, hourly rate, and trip charge are integers. 15.000

6 Set a constraint to ensure hours billed cannot exceed (less than or equal to) 2500. 10.000

7 Set a constraint to ensure the trip charge does not exceed (less than or equal) 50. 10.000

8 Set a constraint to ensure hourly rate does not drop below (greater than or equal to) 30. 10.000

9 Solve and create an Answer Report to outline your findings. 15.000

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.000

11 Save and close the file. Based on your instructors directions, submit exploring_e06_grader_h3_Viking Heating and Air.xlsx. 0.000