|
|
| Everything HP200LX: Knowledge, Products, Service |
|
Formulas for Break-Even Analysis SpreadsheetB1: [W8] ' BREAK-EVEN ANALYSISA2: [W5] \- B2: [W8] \- C2: \- D2: \- E2: \- A3: [W5] ' SELLING PRICE PER UNIT : $ D3: (C2) U 29.95 A5: [W5] ' TOTAL FIXED COSTS : $ D5: (,0) U +<<COSTS.WK1>>FIXCOSTS A7: [W5] ' VARIABLE COST PER UNIT : $ D7: (C2) U +<<COSTS.WK1>>VARCOSTS A8: [W5] \- B8: [W8] \- C8: \- D8: \- E8: \- A10: [W5] ' BREAK EVEN QUANTITY: D10: (,0) @IF(D3=0,0,+D5/(D3-D7)) B13: [W8] ^ X C13: ^ A D13: ^ B B14: [W8] ^ BE C14: "SALES D14: " COST B15: (F1) [W8] 0 C15: (F1) +B15*$D$3 D15: (F1) +$D$5+(B15*$D$7) B16: (F1) [W8] 0.1*(2*$D$10) C16: (F1) +B16*$D$3 D16: (F1) +$D$5+(B16*$D$7) B17: (F1) [W8] 0.2*(2*$D$10) C17: (F1) +B17*$D$3 D17: (F1) +$D$5+(B17*$D$7) B18: (F1) [W8] 0.3*(2*$D$10) C18: (F1) +B18*$D$3 D18: (F1) +$D$5+(B18*$D$7) B19: (F1) [W8] 0.4*(2*$D$10) C19: (F1) +B19*$D$3 D19: (F1) +$D$5+(B19*$D$7) B20: (F1) [W8] 0.5*(2*$D$10) C20: (F1) +B20*$D$3 D20: (F1) +$D$5+(B20*$D$7) B21: (F1) [W8] 0.6*(2*$D$10) C21: (F1) +B21*$D$3 D21: (F1) +$D$5+(B21*$D$7) B22: (F1) [W8] 0.7*(2*$D$10) C22: (F1) +B22*$D$3 D22: (F1) +$D$5+(B22*$D$7) B23: (F1) [W8] 0.8*(2*$D$10) C23: (F1) +B23*$D$3 D23: (F1) +$D$5+(B23*$D$7) B24: (F1) [W8] 0.9*(2*$D$10) C24: (F1) +B24*$D$3 D24: (F1) +$D$5+(B24*$D$7) B25: (F1) [W8] 2*$D$10 C25: (F1) +B25*$D$3 D25: (F1) +$D$5+(B25*$D$7) |
|
Copyright © 2005 Thaddeus Computing Inc
<