BREAK-EVEN ANALYSIS
Fixed Costs Costs required to produce the first unit of a product. Definition Cost 500.00
Variable Unit Costs that vary directly with the produc Definiton
5.00 Unit Selling Price: The amount of money charged to the customer for each unit of a product or service. 310 Expected Unit Sales: Number of units of the product projected to be sold over a specific period of time. Break-Even Units: 200.00
SIS
Variable Unit Costs directly with the production of one additional unit. Cost 2.50
ce.
BREAK-EVEN ANALYSIS
Total Fixed Costs: Total Variable Unit Costs: Expected Unit Sales: Price per Unit: Break Even Units: 500.00 2.50 310 5.00 200.00
18000 16000 14000 12000 10000 8000 6000 4000 2000 0
You will be making profit after 200.00 units.
Units 100 200 300 310
Fixed Cost 500.00 500.00 500.00 500.00
Variable Cost 250.00 500.00 750.00 775.00
Total Cost 750.00 1,000.00 1,250.00 1,275.00
Revenue 500.00 1,000.00 1,500.00 1,550.00
SIS
Fixed Cost Variable Cost Total Cost Revenue
Revenue 500.00 1,000.00 1,500.00 1,550.00
Profit -250.00 0.00 250.00 275.00
Follow the steps to enable your online Break-Even Analyzer.
>> 1) Your Break-Even Analyzer is ready to use. Following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your online Break-Even Analyzer. 2) Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. 3) >> >> Click "Add Web Application" to upload this file. Your online Break-Even Analyzer will be created automatically. You can simply use the Break-Even Analyzer from that link or place it on your website. Your online Break-Even Analyzer will look like: https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=53555cb2-d802-496b-8fd2-61526d285124 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
6b-8fd2-61526d285124
1 31 301 3001 30001 300001 3000001 30000001 300000001
1 10 100 1000 10000 100000 1000000 10000000 100000000
100
100 200 300 400 500 600 700 800 900 1,000 1,100 1,200 1,300 1,400 1,500 1,600 1,700 1,800 1,900 2,000 2,100 2,200 2,300 2,400 2,500 2,600 2,700 2,800 2,900 3,000 3,100
100 200 300 400 500 600 700 800 900 1,000 1,100 1,200 1,300 1,400 1,500 1,600 1,700 1,800 1,900 2,000 2,100 2,200 2,300 2,400 2,500 2,600 2,700 2,800 2,900 3,000 3,100
Fixed Cost 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500
Variable Cost Total Cost Revenue 250 750 500 500 1000 1000 750 1250 1500 1000 1500 2000 1250 1750 2500 1500 2000 3000 1750 2250 3500 2000 2500 4000 2250 2750 4500 2500 3000 5000 2750 3250 5500 3000 3500 6000 3250 3750 6500 3500 4000 7000 3750 4250 7500 4000 4500 8000 4250 4750 8500 4500 5000 9000 4750 5250 9500 5000 5500 10000 5250 5750 10500 5500 6000 11000 5750 6250 11500 6000 6500 12000 6250 6750 12500 6500 7000 13000 6750 7250 13500 7000 7500 14000 7250 7750 14500 7500 8000 15000 7750 8250 15500
FALSE You will be making profit after 200.00 units
ng profit after 200.00 units.