|
|
| | | Sales price per unit | $75.00 | * |
| | | Variable Cost per unit | $67.00 | * |
| | | Fixed Cost | $100,000.00 | * |
| | | Targeted Net Income | $0.00 | * | (assume 0 if you want to calculate breakeven) |
| | | Calculated Volume | 12,500 | calculated |
| | | * inputted by user |
| Breakeven | | | Making X the subject of the formula |
| At break even : Total cost= Total revenue | | | 67X + 100,000=75X |
| Total cost(TC) = Variable cost(VC) + Fixed Cost(FC) | | | 100,000=X(75-67) |
| variable Cost = Variable cost per unit * No. of units | | | 100,000 = 8X |
| Total Sales = Sales price * Number of units | | | 12500 |
| TC = VC + FC |
| Number of units | X | | X | 12500 |
| VC | 67X |
| FC | $100,000.00 |
| TC | 67X + 100,000 |
| Sales |
| TR | 75X |
monque11
Brown-Costvolumeanalysis.xls
