Coolpak Company sells coolers.

Question # 00487984 Posted By: rey_writer Updated on: 02/21/2017 04:05 AM Due on: 02/21/2017
Subject Accounting Topic Accounting Tutorials:
Question
Dot Image

Coolpak Company sells coolers. Their controller requests that you prepare a contribution margin income statement and do an analysis to determine the following items:

1. Total Sales, Variable Costs, Contribution Margin, & Operating Income (round to the nearest whole dollar)

2. Contribution margin per unit (round to two decimal places)

3. Breakeven point in units (round up to the nearest whole unit)

4. Breakeven point in dollars (round to the nearest whole dollar)

5. Calculate the contribution margin ratio (format the answer as a percent and round your percentage one decimal place)

6. Calculate variable cost as a percentage of selling price.(format the answer as a percent and round your percentage one decimal place)

7. Calculate operating leverage. (round to two decimal places)Coolpak's projected data for the upcoming year, 2017, is presented below.


Sales Price $65.00 Variable Manufacturing expense per unit $18.00 Variable Marketing expense per unit $8.00 Variable Administrative Expenses per unit $3.00 Fixed manufacturing Overhead $2,375,000.00 Fixed operating expenses $275,000.00 Number of flags produced & sold 230000

Prepare an excel model to answer all requirements.
Be sure to keep your input section of data separate from the section of your
model that includes the formulas/calculations
Dot Image
Tutorials for this Question
  1. Tutorial # 00484411 Posted By: rey_writer Posted on: 02/21/2017 04:06 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Coolpak Company sells coolers....
    Attachments
    Doc11.docx (1265.13 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    Jen...ipo Rating Instant customer chat support 03/26/2017

Great! We have found the solution of this question!

Whatsapp Lisa