Tutorvo

Chapel and Vehicle Capacity: Booking Clashes with COUNTIFS, Utilisation and When a Second Hearse Pays Off

Lesson 6 of 816 minLab

This lesson is part of the course

In this lesson

You flag overlapping chapel and hearse bookings with COUNTIFS, measure chapel utilisation, and find how many clash days a year make owning a second hearse cheaper than hiring one.

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