Break-even analysis of a fictional business
Programming
A break–even analysis is an analysis to determine the point at which revenue received equals the costs associated with receiving the revenue. Break–even analysis calculates what is known as a margin of safety, the amount that revenues exceed the break–even point.
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
- Describe your product
- Discuss Fixed Costs (land, factory/plant, equipment, etc.)
- Discuss Variable Costs (labor, materials/parts, power supply, water, etc.)
- Use the formula provided in the excel sheet below. How are the data tables designed using the formula?
- How are the results of the tables designed using the formula?
- Your decision-making guidelines
- Which data table is suitable for your business?
- Where is the break-even point – the number of units sold?
- 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 use: Excel File
- Open Excel file attached.
- 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.
- All the numbers MUST be different from the sample sheet.
| 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 |
| 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 |
Let me know if you have any questions,
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational
