Community Health Chapter 2 Discussion
March 29, 2021
Please respond to at least three of the five DQs this week: What are the effects of innovation and technology on…
March 29, 2021

create a break even analysis

A breakeven analysis is an analysis to determine the point at which revenue received equals the costs associated with receiving the revenue. Breakeven analysis calculates what is known as a margin of safety, the amount that revenues exceed the breakeven point.

What to use: Excel File

  • Open Excel file: BreakEven-formula.xlsxPreview the document
  • According to your business product, update both data tables. You can focus on the red italicized costs in the tables shown below. You must change all numbers.
  • In the results tables, the column ‘Units Sold’ can be replaced from 1, 2, 3, to 10, 20, 30 or 1000, 2000, 3000 or any other increasing scheme according to your unit price and possible break-even point
  • All the numbers MUST be different from the sample sheet.

What to write: Word Document

  • Create and name your own business (fictional business with made-up data sets)
  • Describe your business’ mission statement: provide a one sentence “formal summary of the aims and values of a company, organization, or individual.”
  • Business operation description for break-even analysis
    1. Describe your product
    2. Discuss Fixed Costs (land, factory/plant, equipment, etc.)
    3. Discuss Variable Costs (labor, materials/parts, power supply, water, etc.)
    4. The sample excel file has all formulas embedded. Briefly discuss how formulas are used in the file.
  • Your decision-making guidelines
    1. Which data table is suitable for your business?
    2. Where is the break-even point – the number of units sold?
    3. When do you need to make the break-even point; 3 months, 6 months, 1 year? Explain why.
  • Data Tables – copy and paste both tables: data table 1 and data table 2
  • Screenshots (alt + PrtScn, then paste it to your Word doc) of Excel Sheet with Charts

What to submit

  • Submit your (a) Word doc and (b) Excel file in Canvas:
    1. ep4-steve-brown.docx
    2. ep4-steve-brown.xlsx
Data Table 1: Fixed Variable Costs, Changing Sell Prices
Unit Sold Fixed Costs Variable Costs Sell Price Profit Contribution
1 $2,500.00 $300.00 $445.00 $145.00
1 $2,500.00 $300.00 $485.00 $185.00
1 $2,500.00 $300.00 $525.00 $225.00
1 $2,500.00 $300.00 $565.00 $265.00
1 $2,500.00 $300.00 $605.00 $305.00
Data Table 2: Changing Variable Costs, Fixed Sell Prices
Units Sold Fixed Costs Variable Costs Sell Price Profit Contribution
1 $2,500.00 $300.00 $445.00 $145.00
1 $2,500.00 $280.00 $445.00 $165.00
1 $2,500.00 $260.00 $445.00 $185.00
1 $2,500.00 $240.00 $445.00 $205.00
1 $2,500.00 $220.00 $445.00 $225.00

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post create a break even analysis appeared first on The Nursing TermPaper.

 

"Is this question part of your assignment? We Can Help!"

Essay Writing Service