# The Moving Company Owner: companion files

Julian R. Sterling

## What is here

- MCO_1_Estimates_and_Pricing.xlsx (Chapters 3 and 4; Estimates and Pricing workbook of Appendix A): sheets Inputs, Terms, Booking rate, Overruns, then Checks. The local rates and estimates by size, the booking rate (50.0 percent then 55.0 percent), the overrun on Cosima Fenwhistle's move ($662) and one row per move for your own overruns.
- MCO_2_Crews_and_Labor.xlsx (Chapters 5 and 6; Crews and Labor workbook): sheets Inputs, Crew bill, Seasonal, then Checks. The crew bill of both years ($604,375 then $669,882), own movers against agency movers, and the seasonal saving ($18,512).
- MCO_3_Long_Distance.xlsx (Chapters 9 and 10; Long Distance workbook): sheets Inputs, Own truck, Network, then Checks. The same 1,400-mile move in own truck ($2,891) and through the network ($1,507, or $4,783 in the peak).
- MCO_4_Claims_and_Service.xlsx (Chapters 11 and 12; Claims and Service workbook): sheets Inputs, Claims, Lodging, then Checks. The claim rate on moves in own trucks (3.7 percent then 2.5 percent), one arbitration, and the lodging rule for a late delivery.
- MCO_5_Unit_Economics.xlsx (Chapter 13; Unit Economics workbook): sheets Inputs, Income statement, Contribution, Break-even, then Checks. Both income statements, contribution per move ($749.29 then $816.87) and the break-even (692 then 757 moves).
- MCO_6_Cash_and_Valuation.xlsx (Chapter 16; Cash and Valuation workbook): sheets Inputs, EBITDA, Indication, then Checks. EBITDA ($106,876 then $146,551), the fictional buyer's indication and the truck loan repaid at closing.
- MCO_Moving_Company_Checklists.docx: the 9 checklists of Appendix B, editable (The survey and the estimate; The estimate packet for interstate moves; Local moves under the price cap; Move day and the bill of lading; Delivery and payment; A claim; A long move: own truck or network; The monthly review page; Who pays what).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 12 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In MCO_3_Long_Distance.xlsx, on Inputs, type a shorter distance for the move: every line of the Own truck sheet moves at once, and the Network sheet says which path is better in the peak and in a slow month.
2. In MCO_2_Crews_and_Labor.xlsx, on Inputs, type the agency's rate of your own peak weeks: the Seasonal sheet shows what hiring seasonal movers would save, training included.

To use a workbook on your own company, fill the yellow column from your price list, your estimates and final bills, payroll records, the agency's invoices, truck costs, claim files and the income statement, in the order Appendix A gives, and keep a copy with the case column for comparison. The workbooks are separate files with no link between them.

## A word of caution

Quillmarsh Moving Co., LLC, the town of Quillmarsh, its customers, crews, the staffing agency, the network carrier, the insurer and the regional company that gave an indication are fictional. Rates, prices, wages, hours, costs per mile, counts, shares and multiples are teaching assumptions, not market norms or recommendations. Federal rules for interstate moves, state rules for local moves, employment and insurance rules change: read them in their current text, with your outside CPA, your insurance broker and your counsel. No van line, platform, software or insurer is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
