Purchase Solution

CVP formula to compute break-even

Not what you're looking for?

Ask Custom Question

The following are the monthly fixed expenses for Peyton Travel:

Office rent: $3,000.00
Depreciation of office furniture 200.00
Utilities 110.00
Telephone 520.00
Reservation Service Fees 380.00
Travel Agent Salaries 1,400.00
Variable expenses include the following:
Travel Agent Commission 5.0% of sales
Advertising 6.0% of sales
Supplies and Postage 1.0% of sales
Telephone and Reservation Service usage fees 3.0% of sales

Use the contribution margin ratio CVP formula to compute Peyton Travel's break-even sales in dollars. If the average sales price of a ticket is $660.00; how many tickets must be sold to reach break-even?

Use the income statement equation [revenue - (variable expense + fixed expense) = operating income] to compute the dollar sales needed to earn a target monthly operating income of $6,290.00. How many tickets is this if the average sales price of a ticket is $660.00?

Assume the average sales price decreases to $440.00 per ticket. Use the contribution margin approach to compute Peyton Travel's new break-even point in tickets sold. How does this compare to your answer in part a)?

Purchase this Solution
Solution Preview

Please see the attached Excel spreadsheet.

Fixed Costs
Rent 3,000
Depreciation 200
Utilities 110
Phone 520
Service Fees 380
Salaries 1,400
Total Fixed Costs 5,610

Variable Costs @ $660 @440
Commission 5% 33 22
Advertising 6% 39.60 26.4
Supplies 1% 6.60 4.4
Service Fees 3% 19.80 13.2
Total Variable Costs 99.00 66.00

Average ...

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

View More Free Quizzes
Related BrainMass Solutions

  • Personal Investors are opening an Office.

    Use the contribution margin ratio CVP formula to compute the investment firm's break-even revenue in dollars. If the average trade leads to $400 in revenue for Personal Investors, how many trades must be made to break even? 2.

  • CVP Analysis

    78724 Prepare a CVP graph and compute break-even point and margin of safety Please show how to make this graph as well. Thanks Embleton Company estimates that variable costs will be 40% of sales, and fixed costs will total $900,000.

  • CVP graph

    Compute the margin of safety in (1) dollars and (2) as a ratio, assuming actual sales are $2 million. Hint: Prepare a CVP graph and compute break‐even point and margin of safety. ( Study Objective 6 Study Objective 7). Response is attached.

  • CVP Analysis and Break-Even Analysis

    424245 CVP Analysis and Break-Even Analysis: Formula and Application to Strategic Business Planning. Does CVP Analysis help you decide whether to make or buy, sell at a special price to a customer not in your customer base, etc.?

  • Introduction to Management Accounting

    EXCEL Application Exercise EXCEL Application Exercise 2-65 CVP and Break-Even Goal: Create an Excel spreadsheet to perform CVP analysis and show the relationship between price, costs, and break-even points in terms of units and dollars.

  • CVP Income statement and Cost Behavior Analysis

    Instructions (a) Prepare a CVP income statement for 2008 based on management's estimates. (b) Compute the break-even point in (1) units and (2) dollars. (c) Compute the contribution margin ratio and the margin of safety ratio.

  • Computing breakeven sales and sales needed

    Use the contribution margin ratio CVP formula to compute Big Time's breakeven revenue in dollars. If the average trade leads to $800 in revenue for Big Time, how many trades must be made to break even? 2.)

  • Basic Cost-Volume-Profit Analysis

    It also presents a graph of the CVP relationship, illustrates how to compute the net profit or loss at any sales level, and illustrates how to compute the new break-even points if one or more factors change. It is very comprehensive.

  • CVP analysis

    Hint: Compute break-even point and margin of safety ratio, and prepare a CVP income statement before and after changes in business environment.

View More Related Solutions