Calculate the breakeven point in sales dollars

Assignment Help Accounting Basics
Reference no: EM13970338

Total sales for the current year for Peter's Pet Toys were $980,000.

Looking ahead to next year, projections are for $1 million in sales. Fixed Expenses are estimated at $568,000.

There are three main products sold by Peter's Pet Toys: Cat Castles, Dog Dens, and Pet Palaces. Based on past experience, the sales mix contribution margin ratio for each has been:

Product

% of Sales ($1 million estimate)

CM Ratio

Cat Castle

45%

60%

Dog Den

35%

72%

Pet Palace

20%

67%

 

 

 

Required:

a. Prepare a contribution margin/variable income statement in good form to show the sales mix stated and the contribution margins for each product as well as the contribution margin for the company. The time frame is next year.

b. Calculate the breakeven point in sales dollars.

c. Peter is considering adding a yearly donation of $20,000 to animal charities, which would be considered a fixed cost. If Peter factors in this addition to fixed expenses for next year, what would his breakeven point be?

d. If Peter wishes to earn a minimum of $65,000 per year (before taxes) can he afford the donation?
The before taxes stipulation coincides with the contribution margin income statement providing net operating income as the final result, not net income. You do not need to try to calculate for taxes.

e. If Peter wished to review his advertising budget, which product should receive more promotion and why?

f. Using the figures from the TOTALS column, assuming the $20,000 donation is added to fixed costs and becomes part of the annual fixed costs, answer the following questions in a color other than black. Each item is an independent scenario. The "what if" questions are not cumulative.

(1) If sales do not increase as anticipated and remain $980K from the previous year, what would NOI be?

(2) If Peter sets a target profit of only $50,000 NOI, what level of sales (in dollars) would generate $50,000?

(3) If sales volume increased 6% beyond original projections of $1,000,000, what would NOI be?

(4) Peter is concerned that a competitor's cheaper products may result in a decrease of his original anticipated sales volume by 5%. He also believes both variable costs and fixed costs (exclusive of the $20,000 donation which will remain unchanged year after year) could increase by 3%. In this scenario, what is Peter' Pet Toys NOI (or NOL), Contribution Margin Ratio, and Breakeven point in dollars?

Reference no: EM13970338

Questions Cloud

Controls and displays of oscilloscope and function generator : Prepare a report on the controls and displays of the oscilloscope and function generator. hen practiced taking measurements with the oscilloscope and properly stating the known boundaries.
Find a lower bound for the probabilities : Find a lower bound for the probabilities, under the assumption that the Xn's are mutually independent.
Find a lower bound for the probability p : Find a lower bound for the probability P (|A20 - 50| ≤ 10), where A20 is the average of the distances from Hangtown at the time of breakdown.
What kind of writing have you done in school : write an essay that reflects of yourself as a writer. The assignment includes several questions that will help you understand the kinds of information to include.
Calculate the breakeven point in sales dollars : Prepare a contribution margin/variable income statement in good form to show the sales mix stated and the contribution margins for each product as well as the contribution margin for the company. The time frame is next year.
How does the author measure their own success : Write in a formal, academic manner, you are the expert. Go to Canvas Files, open the folder, Helpful Resources and review the "No-No List," "Useful Verbs," the "Grading Rubric" and other documents.
Prepare an income statement in the variable costing format : Prepare an income statement in the variable costing format, indicating the projected annual income from operations if Proposal 3 is accepted. The expenditure of $43,200 for the rental of additional warehouse space can be added to the fixed operati..
Determine the node voltages va and vb for the given circuit : Determine the node voltages, Va and Vb, for this circuit. Use the node voltage analysis to determine the voltage V in the circuit. Assume that R1 = 2 , R2 = 1 , R3 = 4 , R4 = 3 , I1 = 2 A, and I2 = 3 A. I1
Important pieces of information for your managers : What are 3 key things that you would want a mid- or upper-level manager to know about you if you had a chance to make a presentation to him or her?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Yengling companys payroll for the year is 593150 of this

yengling companys payroll for the year is 593150. of this amount 211630 is for wages paid in excess of 7000 to each

  It is a long walk to the cafeteria the lines are long once

getting to school for your 8 a.m. class doesnt leave much time for breakfast and you are quite hungry by the time class

  How many backpacks should be ordered at one time

Using the Economic Order Quantity formula (EOQ), how many backpacks should be ordered at one time

  Basis in the machine

What is the amount of Mr. Dennis' basis in the machine?

  Elm corporation''s only class of stock

1. Anna transferred land with an adjusted basis to her of $20,000 and a fair market value of $56,000 to Elm Corporation in exchange for 100% of Elm Corporation's only class of stock.

  For each of parts 1 to 5 a prepare the necessary journal

the following selected items and amounts were taken from the balance sheet of quale company as of december 31 2012cash

  Calculate the depreciation expense

Calculate the depreciation expense (to the nearest dollar) by each of the following methods, showing the figures used on a separate Excel spreadsheet as directed on the Problem Set 2 instructions.

  In each of the following situations what is the amount of

in each of the following situations what is the amount of profit or loss? in each situation what account will be

  Deskins clothiers is a small company that manufactures

deskins clothiers is a small company that manufactures tall-menssuits. the company has used a standard cost system. in

  Problem regarding quarterly sales forecast

Adams Sporting Goods sells bicycles throughout the southeastern United States. The following data were taken from the most recent quarterly sales forecast:

  Prepare a complete depreciation table

Prepare a complete depreciation table under the straight line method. Assume that a full year depreciation was taken for 2015.

  Sally wilson is planning her retirement she is presently

sally wilson is planning her retirement. she is presently investing in a 401k but needs an additional 500000 to reach

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!

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