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

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Total twelve months of calls by service type, work out the share of direct cremations, the revenue of the year and the true average revenue per call, and draw the monthly mix as a stacked column chart.
• Price one family's selection from the itemised list, then as a Simple and a Complete package plus extras with SUMPRODUCT, and let a formula name the lowest total, so the family sees every option honestly.
• 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.
• Catch draft invoice lines that add a mark-up to fees paid for families, total the disbursements per case with SUMIFS, work out open balances after deposits and sort them into ageing bands with IFS.
• Pay a fortnight of night call-outs with a minimum-hours rule, total the overtime with SUMPRODUCT, find how many people the rota needs with CEILING and project the monthly on-call cost.
• 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.
• Work out the gross margin and gross profit of coffins, urns and plaques, measure stock turns, decide per item whether to keep it in stock or order it from the catalogue, and cost the capital tied up in stock.
• Show the money held for pre-arranged plans as a liability, find the break-even number of calls from the fixed costs and the contribution per call, work out next year's profit and chart how the plan book grows.