Directions for excel lab:

Original numbers provided are below:

Service Calls- 640

Hourly Rate- $30.00

Trip Charge- $25.00

Hours Billed- 2500

Gross Income-

Need help on these 4 questions below.

Questions:

1) How many service calls are required to reach the goal of $120,000 and do you feel it is feasible?

2) What is proposed new trip charge and do you feel customers will except the increase/decrease?

3) What is proposed new hourly rate? Do you feel customers will except the increase/decrease?

4) Do you feel the overall changes are economically possible?

2 Viking Heating and Air MyITLab Grader ANALYSIS You are the chief financial officer for Viking Heating and Air. You were given the task of increas- CASE ing gross income from $91,000 to $120,000 per year. Viking's 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. a. Open e06m2Viking AC and save it as e06m2 VikingAC_LastFirst. b. Create range names based on the values in the range A2:B5. c. Use the formula Service_calls * Trip_charge + Hourly_rate* Hours_billed to determine gross income. Mid-Level Exercises Excel 2016 Pearson Collections IS 2080C Digital Technologies for Business Hickman University Cincinnati Clermont, First Edition by Mary 393 Anne Poatsy and Terry Felke-Morris. Published by Pearson. Copyright 2018 by Pearson Education, Inc. d. Load the Solver add-in. e. Set the objective cell to $120,000. f. Set constraints to ensure service calls, hourly rate, and trip charge are integers. g. Set a constraint to ensure hours billed cannot exceed 2,500. h. Set a constraint to ensure the trip charge does not exceed $50.00. i. Set a constraint to ensure hourly rate does not drop below $30.00. j. Create an Answer Report to outline your findings. k. After solving, answer the questions in the Q&A section. 1. 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. m. Save and close the file. Based on your instructor's directions, submit e06m2 VikingAC_LastFirst. DISCOVER H