Cost of Operations Worksheet

 

  Annual Monthly Per km
(or per hr)
FIXED COSTS $ $ $
Overheads
Interest paid (vehicle & mortgage)
Accounting fees
Audit fees
Bank fees & charges
Bad debts & debt collection costs
Rent
Building repairs/maintenance
Cleaning
Electricity
Printing & stationery
Postage
Telephone/fax/modem
Data processing
Insurance - general
Insurance - public liability
Insurance - sickness and accident
Employee benefits and amenities
Uniforms
Wages
Superannuation
Donations
Other expenses
Total overhead cost
Finance costs
Loan repayments
Total finance costs
Depreciation
Cost of item
$
Estimated sale price
- $
Equals total depreciation
= $
   
Divide by number of years
÷ yrs
   
Equals annual depreciation
Fixed vehicle costs
Insurance
Vehicle registration
Licences and permits
Security
Total fixed vehicle costs
 
TOTAL FIXED COSTS (= overheads + finance costs + depreciation + fixed vehicle costs)
VARIABLE COSTS
Fuel (less rebate)
Oil
Tyres
Repairs
Service
Loading equipment
Hire/equipment
Truck wash
Loading/unloading charges
Administration fees
Accommodation and meals
Other variable costs
 
TOTAL VARIABLE COSTS
TOTAL COSTS (total fixed costs + total variable costs)
TOTAL KILOMETRES / HOURS RUN  

Rate per kilometre
Less total costs per kilometre
Equals how much you’ll clear per kilometre
Multiplied by total kilometres run per year
Gives annual personal income

Rate per hour
Less total costs per hour
Equals how much you’ll clear per hour
Multiplied by total hours run per year
Gives annual personal income

  Annual Monthly Per km
(or per hr)
Personal Income
Total Cost (from spreadsheet)
Equals total cost of operations (or gross income required)