Question: I need help with that please. Step Instructions Points Possible Open the downloaded file exploring_e06_grader_h3_Viking Heating and Air.xIsx. 0 2 Create range names based on

I need help with that please.

I need help with that please. Step InstructionsI need help with that please. Step Instructions
Step Instructions Points Possible Open the downloaded file exploring_e06_grader_h3_Viking Heating and Air.xIsx. 0 2 Create range names based on the values in the range A2:B5.| 10 3 Use the formula Service calls * Trin charge + Hourly rate* Hours billed to determine 5.5 gross income. 4 Load the Solver add-in. Set the objective cell B6 to 120000 and set B2:B5 as Changing 12 Variable Cells. 5 Set three separate constraints to ensure service calls, hourly rate, and trip charge are 15 integers. 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 17.5 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. 10 On the Viking AC worksheet, create a footer with your name on the left side, the sheet name 10 code in the center, and the file name code on the right side. 11 Save and close the file. Based on your instructor's directions, submit 0 exploring_e06_grader_h3_Viking Heating and Air.xIsx. Total Points 100Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments L&! Connections Clear Properties Reapply ? Refresh Sort Filte Text to Flash Remove Data Consolidate What-If Group Ungroup Subtotal Analysis Data Solver From From New Database HTML All Edit Links Stocks Geogra Text Query Advanced Columns Fill Duplicates Validation Analysis Tools Analysis A1 X fx Viking Heating and Air B C D E F G H M N P Q R S U V Viking Heating and Ai 2 Service calls 640 Hourly rate $30.00 4 Trip charge $ 25.0 5 Hours billed 2500 6 Gross income $ 91,000.00 10 Viking AC + 100% Ready

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!