Works out a mowing price per visit and a monthly total from lawn area, visit frequency, and two optional add-on services.
Which cell does what, and which worksheets the model reads. These are the assignments you recreate when you import the file.
| Cell | Role | Note |
|---|---|---|
| B1 | Input | Turf area actually mown, in square feet. Not the whole plot — exclude the house, drive and beds. |
| B2 | Input | Mowing visits per month. |
| B3 | Input | 1 when hedge and shrub trimming is included, 0 when it is not. |
| B4 | Input | 1 when the fertilizer and weed programme is included, 0 when it is not. |
| B6 | Lookup | Floor of the size bracket the lawn falls in, from the Rates sheet. |
| B7 | Lookup | Cumulative price at that floor — the total of every bracket beneath it. |
| B8 | Lookup | Rate per 1,000 sq ft charged on the area above the floor. |
| B9 | Result | Mowing price for one visit: the base plus the marginal area at the bracket rate. |
| B10 | Result | Per visit after the minimum call-out charge is applied. |
| B11 | Result | Frequency uplift: 1 weekly, 1.15 fortnightly, 1.4 monthly, because longer grass takes longer to cut. |
| B12 | Result | Final price per mowing visit. |
| B13 | Result | Mowing charge per month. |
| B14 | Result | Fertilizer and weed control, on the same turf area, with a $35 minimum. |
| B15 | Result | All add-ons per month. |
| B16 | Result | Monthly total. |
Change the numbers to yours, then paste it into your own page. It runs in the visitor’s browser and the answers are theirs, not a screenshot of yours.
Start from this model rather than a blank sheet. The inputs, the results and any lookup worksheets come with it.
The prices here are examples. Change them in the Formula view and the calculator follows — no rewiring.
Publishing gives you an iframe snippet. Drop it into your own page and enquiries land in your workspace.
Travel, unloading, trimming, and blowing take the same time on a small lawn as a large one. The rate per 1,000 square feet starts at $11 for lawns under 5,000 sq ft and drops to $4 above one acre, and every job is floored at a $48 minimum stop charge.
Grass left for four weeks is taller and wetter, so it takes longer to cut, needs a second pass, and produces clippings that have to be cleared. The calculator adds 15 percent per visit for every-other-week service and 40 percent for monthly service.
Only if that toggle is on. When it is, the calculator adds $4.50 per 1,000 square feet per month with a $35 minimum, which is the monthly equivalent of a seven-application seasonal programme.
It is the in-season monthly figure. Most regions mow for seven to nine months of the year, so annual spend is the monthly total multiplied by the length of your season, not by twelve.
Yes. The band rates live on the Rates reference sheet, and the minimum stop charge, frequency factors, hedge trimming price, and fertilizer rate are all plain numbers inside the formulas. Change them and the calculator reprices without any other edits.