Description

GETTING STARTED 

• Open the file NP_EX19_8b_FirstLastName_1.xlsx, available for download from the SAM website.

• Save the file as NP_EX19_8b_FirstLastName_2.xlsx by changing the “1” to a “2”.

o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

• With the file NP_EX19_8b_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

This project requires you to use the Solver add-in. If this add-in is not available on the Data tab in the Analyze group (or if the Analyze group is not available), install Solver as follows:

In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add-Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver.

PROJECT STEPS 1. 

Bruce and Doug Ferguson started Ferguson Fitness, providing comprehensive private and corporate fitness programs in Philadelphia, PA. Bruce made a workbook detailing the services they offers. He asks you to help analyze the data to determine how they can increase profits. 

Switch to the Personal Training worksheet. Create a one-variable data table to calculate the sales, expenses, and profit based on the hours of personal training provided, as follows

a. In cell E5, enter a formula without using a function that references cell C4, which is the number of hours of personal training provided. 

b. In cell F5, enter a formula without using a function that references cell C19, which is the total sales from personal training. 

c. In cell G5, enter a formula without using a function that references cell C20, which is the total expenses related to personal training. 

d. In cell H5, enter a formula without using a function that references cell C21, which is the expected gross profit for personal training. 

e. Select the range E5:H10 and then complete the one-variable data table, using cell C4 as the Column input cell.