Excel HW#3-Lab4 (10 points)
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.
Excel HW#3-Lab4 (10 points)
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 “Step1”. Put the homework title, your section, and your name in the Title of the file
and name the file the same way “HWTitle_01-JamesBond”. Use your name and section number as the
header in the Word file, such as “01_JamesBond”. Insert page numbers. 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.
– Include your name inside your screenshot, meaning your name needs to be shown in the
spreadsheet you screenshot on. Points will be deducted if no name is shown anywhere in the
spreadsheet.
*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
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
