1. Bruce and Doug Ferguson started Ferguson Fitness, providing comprehensive private and corporate fitness programs in...

Transcribed Image Text:

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. b. C. In cell E5, enter a formula without using a function that references cell C4, which is the number of hours of personal training provided. e. In cell F5, enter a formula without using a function that references cell C19, which is the total sales from personal training. 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. Select the range E5:H10 and then complete the one-variable data table, using cell C4 as the Column input cell. 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. b. C. In cell E5, enter a formula without using a function that references cell C4, which is the number of hours of personal training provided. e. In cell F5, enter a formula without using a function that references cell C19, which is the total sales from personal training. 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. Select the range E5:H10 and then complete the one-variable data table, using cell C4 as the Column input cell.

Answer rating: 100% (QA)

To create the onevariable data table for sales expenses and profit based on the hours of personal tr... View the full answer