Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help creating the two tables based on the 2 scenario tables shown in the first picture. I need help starting it b. Credle

image text in transcribedimage text in transcribedI need help creating the two tables based on the 2 scenario tables shown in the first picture. I need help starting it

b. Credle Lwo Sceridrios S TOUWS 10 CUTIpare lhe COSLS OI muriy Tress listructorS WILT those for hiring certified personal trainers while increasing the number of hours provided: a. In the Scenario Manager, add two scenarios using the data shown in bold in Table 1 below. b. The changing cells for both scenarios are the nonadjacent cells C4, C11, and C14. C. Close the Scenario Manager without showing any of the scenarios. Table 1: Fitness Consulting Scenario Values Values Scenario Name | Hours_Sold_Consulting (C4) Variable_Cost_per_Hour_Consulting (C11) Total_Fixed_Cost_Consulting (C14) Scenario 1 Instructors 1500 53 34,500 Scenario 2 Trainers 1800 55 35,500 Ferguson Fitness - Consulting Sales Hours Sold Price Per Hour Total Sales 1,200 80.00 96,000.00 $ Hours 1,200 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700 Expenses Variable Expenses Hours Contracted Variable Cost Per Hour Total Variable Costs Fixed Expenses Total Fixed Cost Expenses - Total Total Expense Per Hour Consulting - Break-Even Analysis Total Sales Total Expenses 96,000 93,700 120,000 109,000 112,000 103,900 104,000 98,800 96,000 93,700 88,000 88,600 80,000 83,500 72,000 78,400 64,000 73,300 56,000 68,200 Gross Profit 2,300 11,000 8,100 5,200 2,300 (600) (3,500) (6,400) (9,300) (12,200) 4 1,200 51.00 61,200.00 $ 4 $ 32,500.00 93,700.00 78.08 $130,000 4 $110,000 $90,000 Profit Total Sales Total Expenses Gross Profit 96,000.00 93,700.00 2,300.00 $70,000 Sales and Expenses $50,000 $30,000 Break-Even Analysis Price Per Hour Cost Per Hour Hours Contracted Gross Profit $ $ $10,000 80.00 78.08 1,200 2,300.00 $ $10,000700 800 900 1,000 1,100 Hours 1,200 1,300 1,400 1,5 - Total Sales - Total Expenses b. Credle Lwo Sceridrios S TOUWS 10 CUTIpare lhe COSLS OI muriy Tress listructorS WILT those for hiring certified personal trainers while increasing the number of hours provided: a. In the Scenario Manager, add two scenarios using the data shown in bold in Table 1 below. b. The changing cells for both scenarios are the nonadjacent cells C4, C11, and C14. C. Close the Scenario Manager without showing any of the scenarios. Table 1: Fitness Consulting Scenario Values Values Scenario Name | Hours_Sold_Consulting (C4) Variable_Cost_per_Hour_Consulting (C11) Total_Fixed_Cost_Consulting (C14) Scenario 1 Instructors 1500 53 34,500 Scenario 2 Trainers 1800 55 35,500 Ferguson Fitness - Consulting Sales Hours Sold Price Per Hour Total Sales 1,200 80.00 96,000.00 $ Hours 1,200 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700 Expenses Variable Expenses Hours Contracted Variable Cost Per Hour Total Variable Costs Fixed Expenses Total Fixed Cost Expenses - Total Total Expense Per Hour Consulting - Break-Even Analysis Total Sales Total Expenses 96,000 93,700 120,000 109,000 112,000 103,900 104,000 98,800 96,000 93,700 88,000 88,600 80,000 83,500 72,000 78,400 64,000 73,300 56,000 68,200 Gross Profit 2,300 11,000 8,100 5,200 2,300 (600) (3,500) (6,400) (9,300) (12,200) 4 1,200 51.00 61,200.00 $ 4 $ 32,500.00 93,700.00 78.08 $130,000 4 $110,000 $90,000 Profit Total Sales Total Expenses Gross Profit 96,000.00 93,700.00 2,300.00 $70,000 Sales and Expenses $50,000 $30,000 Break-Even Analysis Price Per Hour Cost Per Hour Hours Contracted Gross Profit $ $ $10,000 80.00 78.08 1,200 2,300.00 $ $10,000700 800 900 1,000 1,100 Hours 1,200 1,300 1,400 1,5 - Total Sales - Total Expenses

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Produktivitat Von Dienstleistungen

Authors: Klaus Moller, Wolfgang Schultze

3rd Edition

3658040858, 9783658040857

More Books

Students also viewed these Accounting questions

Question

What do you call your problem (or illness or distress)?

Answered: 1 week ago

Question

What is the history of this situation?

Answered: 1 week ago