Tutorvo

Cost per Call: Staff Hours, Vehicle Kilometres, Supplies and Contribution by Service Type

Lesson 3 of 816 minLab

This lesson is part of the course

In this lesson

You cost each service type from staff hours, kilometres and supplies, find its contribution margin, add up the contribution of the year with SUMPRODUCT and let a formula name the type that earns most per staff hour.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Calls and Service Mix: Calls by Type, Shares, Revenue per Call and a Mix ChartLab15 min Locked
  2. Itemised Prices vs Packages: Price One Family's Choices Both Ways and Show the Lower TotalLab16 min Locked
  3. Cost per Call: Staff Hours, Vehicle Kilometres, Supplies and Contribution by Service TypeLab16 min Locked
  4. Third-Party Disbursements: Pass-Through at Cost, Deposits, Open Balances and AgeingLab16 min Locked
  5. On-Call Rota: 24/7 Cover, Call-Outs per Night, Allowances, Overtime and Staff NeededLab16 min Locked
  6. Chapel and Vehicle Capacity: Booking Clashes with COUNTIFS, Utilisation and When a Second Hearse Pays OffLab16 min Locked
  7. Memorial Merchandise: Coffins, Urns and Plaques – Margin, Stock Turns and Stock vs CatalogueLab15 min Locked
  8. Capstone – Pre-Arranged Plans and Break-Even: Trust Liability, Fixed Costs, Break-Even Calls and a Plan ChartLab18 min Locked