Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. bruce and doug ferguson started ferguson fitness,

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

90.2K

Verified Solution

Question

Accounting

  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:
    1. In cell E5, enter a formula without using a function that references cell C4, which is the number of hours of personal training provided.
    2. In cell F5, enter a formula without using a function that references cell C19, which is the total sales from personal training.
    3. In cell G5, enter a formula without using a function that references cell C20, which is the total expenses related to personal training.
    4. In cell H5, enter a formula without using a function that references cell C21, which is the expected gross profit for personal training.
    5. Select the range E5:H10 and then complete the one-variable data table, using cell C4 as the Column input cell.

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

Richard Miyashiro purchased a condominium and obtained a 30-year loan of $199,000 at an annual interest...

Biology
1.2K views

On your own words describe how proprioceptions as a sense works, including all centers and neurotransmitters?

Physics
1.2K views

A square plate of mass 10 kg and side 20 m is moving along the...

Statistics
1.2K views

1 point The exam scores out of 100 points for all students taking an introductory...

Calculus
1.2K views

D 3 x 2 ay Transform D to cylindrical and spherical coordinates

Calculus
1.2K views

Use the algorithm for Euler's method to determine approximations to the solution to the initial...

Algebra
1.2K views

Micah is twice as old as Richard Richard is four times as old as Ken...

Accounting
1.2K views

On January 1, 2018, Speedway Delivery Service purchased a truck at a cost of...

Accounting
1.2K views

Effect of Omitting Adjusting Entry The adjusting entry for accrued wages was omitted at July...

Accounting
1.2K views

Twenty metrics of liquidity, Solvency, and Profitability The comparative financial statements of Automotive Solutions Inc....

Accounting
1.2K views

In a pie chart, the data series is a slice of the pie. True or...

Finance
1.2K views

question 4 d) ADVENTs different stakeholders are likely to have different views on the listing...