Purchase Solution

Contribution Margin and Breakeven Analysis

Not what you're looking for?

Ask Custom Question

Instructions:
- Prepared the Contribution Margin and Breakeven Analysis on a spreadsheet for the below company

Case background
A relatively new company is struggling to understand its cost structure and the implications for profitability. Its president has hired you to help him figure out when the company's solutions will finally reach profitability with its current product mix and cost structure.

Here's the information given to you:

Projected sales for the next 12 months: $995,000.

Two main products:
Product 1 (sold to retailers or channel partners)
Product 2 (sold through an ERP provider)

The percentage of sales each product comprises:
Product 1 65%
Product 2 35%

The product is fully developed and the labor to develop the program was expensed in the period it was incurred. The only current cost to sell the program is the commission that must be paid and any other variable expenses listed below.

Commissions owed for product sales:
Product 1 20%
Product 2 30%

Other expenses:
Bad dept expenses 2% of total sales (includes charged sales)
Credit card fees 3% of sales charged on a card
Percentage of sales charged 30%

The following expenses are incurred whether or not any product is sold:
Software development staff salaries $446,650
Customer support salaries $124,560
Administrative salaries $102,500
Office expenses $ 76,190
Advertising & marketing expenses $ 31,750
Hosting expenses (network costs) $ 13,000

Purchase this Solution

Solution Summary

Contribution margin and break-even analysis is examined. Cost structures and implications for profitability is determined.

Solution Preview

Contribution margin ratio
Total sales = $995,000
Variable expenses = Commission for Product 1 + Product 2 + Bad debt + Credit card fees
= (0.20 x 0.65 x ...

Purchase this Solution


Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.