User Account

All Pages

Create table that highlights the tradeoffs

Assignment Help Accounting Basics
Reference no: EM131557850

 

Assignment - RapidBus is a commuter bus company. On regional route A, RapidBus currently charges $10 per passenger (fare). Monthly revenue for this route is $108,000. Currently variable cost is $5 per passenger and fixed cost is $45,000 per month. (complete the calculations for a month) 

Required:

1. Enter this information into the "Data Table" in your Excel2Template (Hint you will need to calculate the number of passengers).

2. Set up formulas to calculate, Revenue, Cost, & Income

3. Use formulas to complete the contribution margin income statement.

4. Use scenario manager to save this original data that you added to the Data Table. [name this scenario: Original] Hint: only save the four variables in the data table. If you put a formula in any of these cells, allow scenario manager to change these values to constants.

5. Use Goal Seek to find out how many passengers are necessary to breakeven. (Hint: you will need to set income to 0)

6. Use scenario manager to save this breakeven information [name this scenario: BE Original] *note if passengers are not whole round up in all scenarios

7. Evaluate the following changes and report their affects on income. (Each scenario is independent, so return to the original scenario before making changes)

a. Fare decreases to $9, but passengers increase by 10% (use scenario manager to save this as: Scenario One)

b. Fixed cost decrease by $15,000 and the variable rate per passenger increases to $5.50 (use scenario manager to save this as: Scenario Two)

c. Fixed cost increases by $15,000 and the variable rate per passenger decreases to $3.50 (use scenario manager to save this as: Scenario Three)

8. Use goal seek to find out how many passengers are necessary to breakeven under scenario two (use scenario manager to save this as: BE Scenario Two )

9. Use goal seek to find out how many passengers are necessary to breakeven under scenario three (use scenario manager to save this as: BE Scenario Three)

10. Evaluate passenger rates on scenario two

a. Using scenario two change passengers to 20,000 (use scenario manager to save this as: 20,000 Scenario Two)

b. Using scenario two change passengers to 10,000 (use scenario manager to save this as: 10,000 Scenario Two)

11. Evaluate passenger rates on scenario three

a. Using scenario three change passengers to 20,000 (use scenario manager to save this as: 20,000 Scenario Three)

b. Using scenario Three change passengers to 10,000 (use scenario manager to save this as: 10,000 Scenario Three)

12. Create scenario summary, include revenue, cost, and income in the results (set result cells as the cells that contain this information)

13. Set up the scenario summary table to print on one page. 

14. Create table (using the data in the scenario summary table) that highlights the tradeoffs between fixed and variable cost (cost structure). Hint: you will need to use the passenger combinations of scenario two and three. Note you do not need to pivot table or a data table, just a simple table that illustrates the tradeoffs.

Reference no: EM131557850

Questions Cloud

Saving account to her basic checking account : Suppose Karen transfers $500 from her saving account to her basic checking account. How will this transaction affect M1 and M2?
Write a communications plan : Write a communications plan not to exceed 1,050 words to support the strategy of American Plastics.
Unemployment in hometown assignment : This is a follow-up discussion to the Unemployment in Your Hometown Assignment. Share your unemployment findings with the discussion group.
How many ways can five tv commentators be seated : CIRCULAR PERMUTATIONS Suppose n distinct objects are arranged in a circle. Show that the number of (different) circular arrangements of the n objects is (n 1)!.
Create table that highlights the tradeoffs : Create table (using the data in the scenario summary table) that highlights the tradeoffs between fixed and variable cost (cost structure)
Understanding of batna and the negotiating process : As you begin to think about your career how will your understanding of BATNA and the negotiating process impact your salary negotiations.
Show the number of circular arrangements of the n objects : CIRCULAR PERMUTATIONS Suppose n distinct objects are arranged in a circle. Show that the number of (different) circular arrangements of the n objects is (n 1)!.
Define humanism : Write a paper that explains how The Prince represents a humanist approach to the art of governing, in contrast to the idea of government.
A world superpower in the context of entering vietnam : What do you think the United States' responsibilities were as a world superpower in the context of entering Vietnam?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Owners of a property one invested in the down payment and

2 owners of a property. one invested in the down payment and the other owner has done renovations etc. he has issued

  Current liabilities section of the balance sheet

Prepare the current liabilities section of the balance sheet for Rock On Magazine Inc. on March 31, 2009.

  Art and craft items

The following information is available for the first month of operations of Korv Inc., a manufacturer of art and craft items:

  Variable costs as a percentage of sales

Variable costs as a percentage of sales for Leamon Inc. are 75%, current sales are $600,000, and fixed costs are $110,000. How much will operating income change if sales increase by $40,000?

  Randiddle co. is a merchandising business

Randiddle Co. is a merchandising business.

  Dependable guideline for computing genuine rates

What is the lapse from utilizing this dependable guideline for computing genuine rates of return in the accompanying cases?

  What are the major disadvantages in using bonds

As a source of long-term financing, what are the major advantages of bonds over common stock?

  Assuming that total dividends declared in 2012 were 35000

toggles fishing fleet had 20000 shares of 5 20 par value preferred stock and 15000 shares of 25 par value common stock

  A major drug company anticipates that in future years it

a major drug company anticipates that in future years it could be involved in litigation regarding perceived side

  Tally amp co incurred a pretax operating loss of 100000 in

tally amp co. incurred a pretax operating loss of 100000 in its first year of operations for both financial reporting

  The contribution-margin ratio]

The difference between the selling price and the variable cost per unit.

  What amount should be deducted as lease expense

What amount should be deducted as lease expense on Schedule C in 2013?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd