Contribution Margin and Breakeven Analysis
Not what you're looking for?
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.