Go to the New Fees worksheet. DeShawn is considering whether to change the fees for the small-group
Fantastic news! We've Found the answer you've been seeking!
Question:
- Go to the New Fees worksheet. DeShawn is considering whether to change the fees for the small-group training sessions. He has created three scenarios on the New Fees worksheet showing the profit with a $10 or $15 fee increase or a $5 fee decrease.
Compare the average profit per program based on the scenarios as follows:- Create a Scenario Summary report using the average profit per program (range B10:F10) as the result cells to show how the average profit changes depending on the fee changes.
b. Use New Fees Scenario Report as the name of the worksheet containing the report
I need help with question number 9
Transcribed Image Text:
H1 Home 15 16 17 18 19 20 Paste 21 22 23 24 25 26 27 28 1 2 3 Trainer cost per day 4 Materials cost 4 5 Total cost 6 7 Maximum trainees per day Insert Page Layout Century Sch..... B I U Wrap Text Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x ✓ fx A 8 Enrolled trainees per day 9 Training fee per person 10 Average profit per program 11 Average profit per trainee 12 13 14 Maxwell Training Ready Documentation 2T 11 $ $ Formulas Data Review A- A- $ $ $ B Orientation Tech Skills Soft Skills Product Mandatory 480 $ 480 $ 35 $ 55 8 $ 535 $ с 360 $ 65 $ 425 $ Blended Training 515 View Developer D 24 8 15 6 75 S 125 $ 700 $ 235 $ 46.67 $ 39.17 $ 77.71 Tutorial Fees 32 24 100 $ E New Fees 375 S 120 $ $ 495 24 16 80 $ 1,865 $ 785 $ $49.06 8 F Webinars 400 100 500 32 12 95 640 53.33 + Last saved by user General 5-%9 G H Cell Conditional Format Formatting as Table Styles I J K H1 Home 15 16 17 18 19 20 Paste 21 22 23 24 25 26 27 28 1 2 3 Trainer cost per day 4 Materials cost 4 5 Total cost 6 7 Maximum trainees per day Insert Page Layout Century Sch..... B I U Wrap Text Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x ✓ fx A 8 Enrolled trainees per day 9 Training fee per person 10 Average profit per program 11 Average profit per trainee 12 13 14 Maxwell Training Ready Documentation 2T 11 $ $ Formulas Data Review A- A- $ $ $ B Orientation Tech Skills Soft Skills Product Mandatory 480 $ 480 $ 35 $ 55 8 $ 535 $ с 360 $ 65 $ 425 $ Blended Training 515 View Developer D 24 8 15 6 75 S 125 $ 700 $ 235 $ 46.67 $ 39.17 $ 77.71 Tutorial Fees 32 24 100 $ E New Fees 375 S 120 $ $ 495 24 16 80 $ 1,865 $ 785 $ $49.06 8 F Webinars 400 100 500 32 12 95 640 53.33 + Last saved by user General 5-%9 G H Cell Conditional Format Formatting as Table Styles I J K
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Go to The New York Times website at www.nytimes.com/ and review the front page. Would you consider the data on the page to be structured or unstructured? Explain.
-
Go to the New York Times website (www.nytimes. com/) or to USA Today (www. usatoday. com/) and search for the term outsource. Find an article about a company making a decision to outsource a part of...
-
Go to the New York Stock Exchange's website at w.w.w.nyse.com. Scroll to the bottom of the page and under U.S. Equities click "Listings.". In the U.S. Equities page, highlight "Listings" and in the...
-
Happy Colors manufactures crayons in a three-step process: mixing, molding, and packaging. The Mixing Department combines the direct materials of paraffin wax and pigments. The heated mixture is...
-
What is an anchoring bias and how does it affect the process of setting new standards at the end of an accounting period?
-
The temperature of the earths atmosphere drops about 5C for every 1000 m of elevation above the earths surface. If the air temperature at ground level is 15C and the pressure is 760 mmHg, at what...
-
For the same system as in Problem 15.D1, the high concentration \(\mathrm{C}_{\mathrm{A}, 0}=1.2 \mathrm{~kg} / \mathrm{m}^{3}\) and \(\mathrm{C}_{\mathrm{A}, \mathrm{L}}=0.9701 \mathrm{~kg} /...
-
Holly Nikolas launched a new business, Hollys Maintenance Co., that began operations on June 1. The following transactions were completed by the company during that first month. June 1 H. Nikolas...
-
SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2015 and 2016 2015 2016 2015 2016 Assets Liabilities and Owners' Equity Current assets Cash Current liabilities Accounts receivable Inventory $...
-
Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek as of May 1, 2018 (unless otherwise indicated), are as follows: During...
-
Case Analysis ( Organizational Politics at Google ) Google only wants civil behavior at work. Talk about work at work, talk about politics elsewhere. The multinational technology company announced to...
-
1. Advocate Aurora Sheboygan Memorial Hospital health care product or service to be marketed in your community. 2. Conduct appropriate market research in your community to determine the demographics...
-
A stock price is currently trading at $100. Over the next two 6 month periods it will be with up 10% or down 10%. The risk-free interest rate is 8% per annum with continous compunding. What is the...
-
A figure skater begins spinning counterclockwise at an angular speed of 3.1 rad/s. During a 4.2 s interval, she slowly pulls her arms inward and finally spins at 7.2 rad/s. What is her average...
-
Social and emotional development is probably the most discussed and widely used area of development when considering work with young children. But to fully apply the principles of social and...
-
Calculate in Excel: You are responsible for a portfolio of just two bonds: Bond A is an asset with a face value of $40 million, a price of 102.4, a coupon rate of 4.25%, and exactly 5 years until...
-
From our best practices discussion on Selection-Evaluation-Compensation, what is true about zero basing a position? Selected answer will be automatically saved. For keyboard navigation, press up/down...
-
A fuel pump sends gasoline from a car's fuel tank to the engine at a rate of 5.88 10-2 kg/s. The density of the gasoline is 735 kg/m3, and the radius of the fuel line is 3.18 10-3 m. What is the...
-
(a) What would you look for in a simplex tableau in order to conclude that a problem is unbounded? (b) What would you look for in a simplex tableau in order to detect a degeneracy? (c) What...
-
You may have thought of trying the method of Lagrange multipliers to find optimal solutions, since, after the introduction of slack variables into the standard maximum problem, the problem has the...
-
Consider the problem: (a) Sketch the feasible region, find the coordinates of the corner points, and find the optimal value. (b) Repeat (a) if the right-hand side constants are changed to \(6+h_{1}\)...
Study smarter with the SolutionInn App