Break even analysis - Excel

Document Sample
Break even analysis - Excel Powered By Docstoc
					variable cost/unit Fixed cost selling price/unit quantity increment

v F p
q_incr

9.75 3000 16 50

quantity q 0 50 100 150 200 250 300 350 400 450 500 550 600 650 700 750 800 850 900 950 1000

Cost C 3000 3487.5 3975 4462.5 4950 5437.5 5925 6412.5 6900 7387.5 7875 8362.5 8850 9337.5 9825 10312.5 10800 11287.5 11775 12262.5 12750

Revenue R 0 800 1600 2400 3200 4000 4800 5600 6400 7200 8000 8800 9600 10400 11200 12000 12800 13600 14400 15200 16000

Profit P -3000 -2687.5 -2375 -2062.5 -1750 -1437.5 -1125 -812.5 -500 -187.5 125 437.5 750 1062.5 1375 1687.5 2000 2312.5 2625 2937.5 3250

Modify the intital quantity and also Modify the size of the quantity increment to locate the break-even quantity

variable cost/unit Fixed cost selling price/unit quantity increment

v F p
q_incr

9.75 3000 16 10

quantity q 400 410 420 430 440 450 460 470 480 490 500 510 520 530 540 550 560 570 580 590 600

Cost C 6900 6997.5 7095 7192.5 7290 7387.5 7485 7582.5 7680 7777.5 7875 7972.5 8070 8167.5 8265 8362.5 8460 8557.5 8655 8752.5 8850

Revenue R 6400 6560 6720 6880 7040 7200 7360 7520 7680 7840 8000 8160 8320 8480 8640 8800 8960 9120 9280 9440 9600

Profit P -500 -437.5 -375 -312.5 -250 -187.5 -125 -62.5 0 62.5 125 187.5 250 312.5 375 437.5 500 562.5 625 687.5 750


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:481
posted:2/6/2008
language:English
pages:2
user002 user002
About