Price Change Worksheet Answer - Break-Even Analysis [Virtual Learning Arcade]

Break Even Analysis

The Input Parameters

Price (£) 8.50
Office Staff Salary (£ annual) 21000.00
Operative Staff Salary (£ annual)) 24000.00
Ship Maintenance (£ annual) 67000.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) 77806.64
Margin of Safety (miles) 2193.36
Profit (£) 15200.00
Profit per Mile (£) 0.19
Contribution (£) 6.93
Total Costs (£) 664800.00
Total Fixed Costs (£) 539200.00
Total Variable Costs (£) 125600.00
Total Revenue (£) 680000.00