Category : Lotus and other Spreadsheets
Archive   : BPD22.ZIP
Filename : BPDBREAK.WK1

 
Output of file : BPDBREAK.WK1 contained in archive : BPD22.ZIP

4–44
4*2/ÿÿ q H#  d GFIXED COSTSGPRICE

GPROFITGQUANTITYGVARIABLE COSTSG\P+-G\Q02ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$ÿ%ò&ò'((
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqqÿ^Biz Plan Developer v2.2ÿ^*ÿ^Lotus 1-2-3 versionÿ^*ÿ^*ÿ^BREAKEVEN ANALYSISÿ^*%ÿ^Copyright 1993, David A. Worksÿ^*ÿ^* ÿ^Please Read User's Guide!ÿ^*ÿ^*^This is SHAREWARE.ÿ^*$ÿ ^Registration brings benefits!ÿ ^*ÿ
\* ÿ
'***** ÿ
'PRICE

dÿ'QUANTITY
]tÑ[email protected]ÿ'FIXED COSTSÿ' Rent
9 "ÿ' Utilities
– "ÿ' Insurance
d "ÿ' Salaries
ˆ "ÿ' Machinery
Ü " ÿ"Total "—½@ ÿ¿û¿ÿ¿ÿ¿Pÿ'VARIABLE COSTSÿ' Labor[email protected]€ó¿Ð?  ÿ' Materialmail protected]€òŸš™™™™™¹?  ÿ' Commissions[email protected]€ñŸš™™™™™¹?   ÿ"Total €[email protected] ÿ¿ý¿ÿ¿ÿ¿P  
ÿ'PROFIT 
ÿ)\-ÿ)\-ÿ)^| ÿ*'\Pÿ*^|ÿ*'{Solve for Price}ÿ+'{GOTO}Price~ÿ+^|9ÿ,^+(Fixed Costs+(Quantity*Variable Costs))/Quantity~ÿ,^| ÿ-'/rv~~ÿ-^|*ÿ-'{Value Price to avoid CIRC and ERR}ÿ.^| ÿ/'\Qÿ/^|ÿ/'{Solve for Quantity}ÿ0'{GOTO}Quantity~ÿ0^|-ÿ1^+(Fixed Costs/(Price-Variable Costs))~ÿ1^| ÿ2'/rv~~ÿ2^|-ÿ2'{Value Quantity to avoid CIRC and ERR}ÿ3^|ÿ4\-ÿ4\-ÿ4^|