Fixed Cost Worksheet Answer - Break-Even Analysis [Virtual Learning Arcade]
| Break Even Analysis |
| The Input Parameters |
| Price (£) | 9.00 |
| Office Staff Salary (£ annual) | 21000.00 |
| Operative Staff Salary (£ annual)) | 24000.00 |
| Ship Maintenance (£ annual) | 79000.00 |
| Fuel (£) | 2.00 |
| Office Equipment (£ annual) | 15000.00 |
| Office Rates & Rents (£ per month) | 1600.00 |
| Insurance per Operative (£ per year) | 9000.00 |
| Number of Office Staff | 2.00 |
| Number of Operatives | 12.00 |
| Number of contracted miles (per year) | 80000.00 |
| Sensitivity to Fuel Price (%) | 65.00 |
| Operatives Bonus (£ per mile) | 0.25 |
| Office running costs (£ per mile) (£) | 0.02 |
| Outputs |
| Break-Even Point (miles) | 74185.73 |
| Margin of Safety (miles) | 5814.27 |
| Profit (£) | 43200.00 |
| Profit per Mile (£) | 0.54 |
| Contribution (£) | 7.43 |
| Total Costs (£) | 676800.00 |
| Total Fixed Costs (£) | 551200.00 |
| Total Variable Costs (£) | 125600.00 |
| Total Revenue (£) | 720000.00 |
Submitted by bized on Wed, 14/03/2001 - 13:00
