Answered step by step
Verified Expert Solution
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
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 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 ExpensesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started