Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I get the following calculated on excel with explanations. 1. Total Sales, Variable Costs, Contribution Margin, & Operating Income 2. Contribution margin per unit

Can I get the following calculated on excel with explanations.

1. Total Sales, Variable Costs, Contribution Margin, & Operating Income

2. Contribution margin per unit

3. Breakeven point in units

4. Breakeven point in dollars

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)

7. Calculate operating leverage

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 coolers produced & sold 230000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISO 27001 Controls A Guide To Implementing And Auditing

Authors: IT Governance

1st Edition

1787781445, 978-1787781443

More Books

Students also viewed these Accounting questions