Funeral Home Economics: Calls & Service Mix, Itemised Prices vs Packages, Cost per Call, Third-Party Disbursements, On-Call Rotas, Chapel & Vehicle Capacity, Merchandise and Pre-Arranged Plans
Run the numbers of a small funeral home with care and transparency. You will track calls and service mix, compare itemised prices with packages, cost each service type, keep third-party disbursements separate, plan an on-call rota, schedule chapel and vehicles, manage memorial merchandise and treat pre-paid plans correctly before finding break-even, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course runs the numbers of a small, fictional funeral home with care and transparency, one checked cell at a time. You total calls by service type and weight the average revenue by the mix, price one family's choices itemised and as two packages with SUMPRODUCT, and cost each service type from staff hours, kilometres and supplies. You pass third-party fees through at cost, age open balances with SUMIFS and IFS, pay night call-outs with a minimum-hours rule and size the on-call rota with CEILING. Finally you flag chapel and hearse clashes with COUNTIFS, decide stock or catalogue for coffins and urns, hold pre-arranged plans as a liability and find the break-even number of calls.
Lessons
- Calls and Service Mix: Calls by Type, Shares, Revenue per Call and a Mix Chart Pro
- Itemised Prices vs Packages: Price One Family's Choices Both Ways and Show the Lower Total Pro
- Cost per Call: Staff Hours, Vehicle Kilometres, Supplies and Contribution by Service Type Pro
- Third-Party Disbursements: Pass-Through at Cost, Deposits, Open Balances and Ageing Pro
- On-Call Rota: 24/7 Cover, Call-Outs per Night, Allowances, Overtime and Staff Needed Pro
- Chapel and Vehicle Capacity: Booking Clashes with COUNTIFS, Utilisation and When a Second Hearse Pays Off Pro
- Memorial Merchandise: Coffins, Urns and Plaques – Margin, Stock Turns and Stock vs Catalogue Pro
- Capstone – Pre-Arranged Plans and Break-Even: Trust Liability, Fixed Costs, Break-Even Calls and a Plan Chart Pro