Marina & Boatyard Economics: Berth Mix by Length, Annual, Seasonal & Visitor Nights, Waiting Lists and Berth Fit, Fuel Dock, Haul-Outs & Winter Storage, Pontoon & Dredging Reserves and Break-Even
Run a fictional marina and its boatyard by the metre. You will price berths by length, mix annual, seasonal and visitor nights, match a waiting list to berth sizes, read fuel-dock margins, plan haul-outs and winter storage, quote yard work, fund pontoon and dredging reserves and find break-even occupancy, 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 a small fictional marina and its boatyard in a spreadsheet. You price berths by length band with SUMPRODUCT and compare occupancy in berths and in metres, price visitor nights by season with XLOOKUP and count berth-nights with EOMONTH. You match a waiting list to free berths with MINIFS and COUNTIFS and price the revenue lost to oversized berths, read fuel margins after card fees and the chandlery attach rate, plan haul-outs, hard-standing space and the last lift day with WORKDAY, and quote yard work with ROUNDUP. Then you fund pontoon and dredging reserves with PMT and finish with a P&L, break-even occupancy, a rate-increase scenario and a chart.
Lessons
- Berth Inventory: Length Bands, Rates per Metre and Potential Revenue Pro
- Annual, Seasonal and Visitor Nights: Season Rates, Occupancy and Revenue per Berth-Metre Pro
- The Waiting List: Berth Fit, the Smallest Fitting Berth and Revenue Lost to Oversizing Pro
- Fuel Dock and Chandlery: Margin per Litre, Price Changes and the Shop Attach Rate Pro
- Haul-Outs and Winter Storage: Lift Bookings, Hard-Standing Space and the Haul-Out Schedule Pro
- Yard Work Quotes: Labour Hours, Antifouling Area from the Label and Materials Markup Pro
- Pontoon and Dredging Reserves: Replacement Schedules, Dredging Cycles and Contributions with PMT Pro
- Capstone: Marina P&L, Break-Even Occupancy and a Rate-Increase Scenario Pro