Breakeven Point Prediction Using Excel Spreadsheet
Description
Unformatted Attachment Preview
Chapter 10
Purpose: Break-Even Analysis: Sales needed to achieve break even (Net profit =0). (book p.280)
Step 0: understand the data
Step 1: calculate variable cost, total cost, Sales revenue, and net income in spreadsheet
Step 2: use what-if solver to get the break even point in sales.
To be submitted:
Please submit your assignment in WORD file. Put your screen shot in a WORD file, clearly label your
screenshot such as uestion 1, Step 1 screenshot Put the homework title, your name, and your
section in the Title of the file. Use your name and section number as the header in the Word file, such as
A333-Sec1_JamesBond. Insert page numbers. Also, use your name as the file name such as A333-Sec1JamesBond. Points will be deducted if not following the instructions and you will receive a 0 if not
submitted in a WORD file.
1. Screenshot after you finish each step listed above except for step 0.
*when you screenshot a large dataset, just screen shot the first 10 or more rows.
Jan
Price
Unit of sales
Unit cost
Fixed cost
Variable cost
Total cost
Sales revenue
Net income
7,00
300,00
4,50
1000,00
Feb
7,00
300,00
3,80
1000,00
March
April
May
June
July
7,00
7,00
7,00
7,00
7,00
300,00
300,00
300,00
300,00
300,00
3,80
3,80
3,50
3,50
3,00
1000,00 1000,00 1000,00 1000,00 1000,00
Aug
7,00
300,00
3,00
1000,00
Sep
7,00
300,00
3,00
1000,00
Oct
7,00
300,00
4,00
1000,00
Nov
7,00
300,00
4,50
1000,00
Dec
7,00
300,00
4,50
1000,00
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."