Contribution margin and breakeven analysis

Assignment Help Corporate Finance
Reference no: EM1345336

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

Reference no: EM1345336

Questions Cloud

Calculate eoq and total cost : Speedy Manufacturers wishes to estimate the economic order quantity for a critical and expensive inventory item that is used in large values at a relatively constant rate throughout year.
Treaty of versailles : Reparations payments by Germany required under Treaty of Versailles posed the problem. How were tax payments by German citizens to their government in German marks to be converted to dollar payments to United States lenders?
What is a car acceleration : How fast should a car move toward you for the car's horn to sound 2.88% higher in frequency than as the car is stationary? The speed of sound is 343 m/s.
Decision to present one marketing message : Why doesn't Evo need to tailor its marketing to different countries and do you agree with their decision to present one marketing message
Contribution margin and breakeven analysis : Develop the Contribution Margin and Breakeven Analysis on a spreadsheet for the below company
Limit risk exposure through using forward contract : Describe how a firm's management can limit risk exposure through using  the forward contract. What sorts of forward contracts are available?
Find cash paid for interest : On October 31, 2011, Bondable, Inc. issued $20,000 of 10-year, 6% bonds at 100. Bonds pay interest yearly on October 31. On its statement of cash flows for the year ended December
Illustrate out term convertible currency : Illustrate out the term convertible currency and identify them.
List five red flags : One step in assessing the quality of earnings is to look for red flags. An example of a red flag is a change in auditors. A parting of ways with auditors may be because of disagreements over accounting matters.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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