Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step	Instructions	Points Possible
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
	Total Points	100.000

Service calls

640

Hourly rate

$30.00

Trip charge

$25.00

Hours billed

2500

Gross income