Salon Commission or Booth Rent? Model Both on Your Numbers With AI

Neither wins everywhere. Commission earns the salon more from a busy chair; booth rent pays a fixed sum and hands the empty-chair risk to the stylist. Have ChatGPT build a sheet from your booking data that models each chair at 40%, 60% and 80% occupancy and finds the rent matching commission profit, then check employment status with an adviser.

The result depends on three things AI can't see: how busy each stylist really is, what a chair truly costs you, and whether "rent" is a fair description of the arrangement. Fill the first two from your own books. Treat the third as a question for an employment adviser or accountant, because the label on the contract does not decide it.

Follow me on Instagram@sagnikteaches

Who carries which cost and which risk

Before any numbers, be clear what each model hands to whom. The table is a general picture; your own agreements may split things differently, and that is exactly what the spreadsheet will test.

Connect on LinkedInSagnik Bhattacharya

That last pair of rows is the whole decision in miniature. Rent is a bet that the chair will be busier than the rent implies, placed by the stylist and accepted by the salon. Commission is a shared bet. The sheet turns "busier than the rent implies" into a number you can check.

Subscribe on YouTube@sagnikteaches

The inputs, and where each one comes from

You need nine figures. The example values below describe one chair in an imaginary salon, and every one is illustrative: swap in yours. Where a figure is a percentage, the "slip" column shows how it usually goes wrong.

The chair overhead deserves its own breakdown, because it is easy to underestimate. In the example it is premises share $120, utilities $25, insurance $15, booking software and card terminal $12, laundry and cleaning $18 and a front-desk share of $20: $210 in all. The front-desk share is the item that gets left out most easily. It is also the one that makes rent look better than it is, because a renter who books their own clients uses less of it, which is a fair point to negotiate on.

For card fees, the 2.5% is a blended rate, and your own statements decide it. As one data point, Square's pricing page currently lists 2.6% + 15 cents per in-person payment on its free plan and 2.5% and 2.4% on higher plans (October 2026); other processors differ, and the fixed 15 cents matters more on a $30 cut than on a $200 colour. For on-costs, ask whoever runs your payroll what they add on top of gross pay, since the figure depends on where you trade.

Get each stylist's real occupancy from a booking export

Occupancy is the input people guess, and guessing is how a rent gets set for the wrong stylist. Your booking system can export appointments with the date, stylist, start and end times, service and price. Take 13 weeks, delete client names, phone numbers and emails before anything is uploaded, and give the assistant a prompt that spells out the chair hours and what to ignore. If the export is untidy, the clean messy data tutorial covers the tidy-up first.

The attached CSV lists appointments for the last 13 weeks: date,
stylist, start_time, end_time, status, service_price. Ignore rows whose
status is cancelled or no-show, and say how many you ignored.
Each stylist's chair is available 40 hours a week.
For each stylist give: average booked hours per week, occupancy (booked
hours divided by 40), service revenue per booked hour, and the lowest
and highest weekly occupancy. Count overlapping appointments once.
List any week above 1.5 times that stylist's average so I can check it.

An illustrative reply gives three lines such as: stylist A, 24.3 hours, 61% occupancy, $63.40 an hour, weekly range 45% to 78%; stylist B, 14.1 hours, 35%, $58.90, range 20% to 52%; stylist C, 33.6 hours, 84%, $39.20, range 75% to 95%. The range matters as much as the average. Stylist B's best week barely reaches the 50% where a $450 rent starts to make sense, and stylist A's range straddles it, which is the signal to test the offer at both ends before putting it on paper.

Two things to fix in the first answer you get. The AI may count a colour client who is processing and a cut booked in the same hour as two booked hours, which can push occupancy above 100%; the line "count overlapping appointments once" in the prompt prevents it, and if the result still looks too good, check the stylist's longest day by hand. And reconcile: ask the AI to total the exported revenue by month and compare it with the service takings in your till or bank records, leaving retail out. A gap of more than a few percent usually means the export is missing a service category or is counting something it shouldn't, such as a deposit that was later refunded, and every revenue-per-hour figure is then off.

One chair at 40%, 60% and 80% occupancy

This is the main worked example. Occupancy here means booked hours as a share of the 40 chair hours. The salon pays the stylist 50% of service revenue on commission, and on rent the stylist pays $450 and buys their own product.

Read it from the salon's side first. A flat $450 rent beats commission at 40% occupancy ($240 against $132), loses to it at 60% ($240 against $303) and loses heavily at 80% ($240 against $474). Now the stylist's side: renting at $450 leaves them worse off at 40% (about $98 a week less than commission) and much better off at 60% and 80% (about $98 and $294 more). At no one of the three levels does a $450 rent suit both people.

The "rent that matches commission" row is the useful one. It is the lowest rent at which the salon doesn't mind switching, and it comes out as 34.5% of service revenue. The "highest rent the stylist would accept" row is the other end of the negotiation. Between the two sits the range where both sides gain: $342 to $352 at 40%, $513 to $548 at 60% and $684 to $744 at 80%.

Why a flat rent suits both sides only in a narrow band

The range between the two rent rows is narrow because it is made of one thing: the employer on-costs the salon stops paying (5% of service revenue here), less the renter's own costs of $40. Revenue grows with occupancy, so the on-cost saving grows, while the renter's costs stay put. That's why the zone is $10 wide at 40% and $59 wide at 80%. Both take-home rows are also before personal tax. A self-employed renter's tax and social contributions can differ from an employee's, depending on where you trade, and the difference can be enough to close a band this narrow, so the stylist should run their side past their own accountant before agreeing a figure.

The same arithmetic gives the occupancy at which a given rent switches sides. Divide the rent by the break-even share of revenue and the hours: $450 ÷ (0.345 × 40 hours × $62) is 52.6%. Below that, the salon does better on rent; above it, on commission. For the stylist the switch comes at 50.0%. So a $450 rent works for both people only between 50% and 53% occupancy, a band under three points wide. Outside it, one side is quietly subsidising the other, and a stylist who is stuck on the wrong side may well leave.

Two more break-evens are worth printing. On commission, this chair stops losing money for the salon at about 24.5% occupancy (9.8 booked hours), because $210 of overhead divided by 34.5% is $609 of revenue. At the empty-chair end, at 20% occupancy (8 booked hours) the salon's commission profit is minus $38.88 while the rent still pays it $240. A renter in the same week takes home minus $46.08 and is unlikely to stay. The salon's real protection from rent is the guarantee, and the renter's real cost is that the guarantee is theirs to fund.

What moves the answer: five tests worth running

One more result deserves a mention before building anything: the chair overhead cancels out of the break-even rent. Both models carry it, so it affects whether the chair earns anything but not the rent that matches commission. The inputs that do move the rent are below, shown at 60% occupancy, where the base answer is $513.36; the last row is the overhead test, there to prove the point.

The pattern is that the commission split dominates. A five-point change in the split moves the break-even rent by more than a four-point change in product cost, which is why it pays to look at the split before haggling over towels. Revenue per hour deserves a close look at each rerun, because it moves whenever you change prices or the mix of services.

Build the model in ChatGPT and test it against a known answer

The spreadsheet is small enough to describe in one prompt. OpenAI's help article on creating files in ChatGPT Work says the feature is still rolling out and that availability depends on your plan, workspace settings, file type and where you use it. So name the sheets, rows, formulas and chart you want, review every formula before you save or share the file, and keep a fallback: if your plan won't produce a file, ask for the sheet as a list of cell addresses and formulas that you paste into Excel or Google Sheets. The ChatGPT Excel guide covers both routes.

Build an Excel workbook with two sheets, "Inputs" and "Model".
Inputs, label in column A and value in column B:
chair hours per week 40; service revenue per booked hour 62;
salon share on commission 50%; product cost 8% of service revenue;
card fees 2.5% of service revenue; employer on-costs 10% of stylist pay;
chair overhead per week 210; proposed weekly booth rent 450;
renter's own weekly costs 40.
Model: columns B, C, D for occupancy 40%, 60%, 80%. Rows: booked hours;
service revenue; stylist pay on commission; employer on-costs; products
and card fees; salon profit on commission; salon profit on booth rent
(rent minus chair overhead); rent that matches commission for the salon;
stylist take-home on commission; stylist take-home renting; highest rent
the stylist would accept; whether the proposed rent suits both.
Rules: every formula refers to the Inputs sheet or to cells in the same
column; no numbers typed inside formulas; percentages stored as
percentages. Add a line chart of salon profit against occupancy from 0%
to 100% in steps of 10 for both models. List each row's formula at the end.

The reply is a workbook, or a formula list in which salon profit on commission reads something like =B4-B5-B6-B7-Inputs!$B$8: revenue, minus pay, on-costs, products and card fees, minus the overhead. Whichever you get, test it with a known answer before believing anything. With the inputs above, the salon's commission profit at 60% occupancy must read $303.36 and the highest rent the stylist would accept must read $547.76. If either differs, stop and find out why. Then change one input and check that the sheet responds: set the salon share to 55% and the 60% break-even rent must become $595.20.

Three slips turn up often enough to look for. A formula with the split typed into it (=B4*0.5) matches the example but ignores your edits, and the 55% test catches it. A percentage typed as 8 rather than 8% produces absurd results the moment you look at them. And rent profit shown as the full $450 rather than $450 minus overhead flatters rent by $210 a week; the check is that salon profit on rent equals $240, not $450. A fourth is conceptual: occupancy defined as a share of opening hours instead of chair hours, which makes every stylist look busier than they are.

Finally, ask the AI to argue with its own sheet: "List the five assumptions in this model that would change the answer most, and what each would do to the break-even rent." The table above is that exercise done by hand. If you want the weekly cash-flow view of the same salon, the hair salon business plan tutorial carries the numbers further.

Two more chairs: a barber with a full book and a new stylist

Start with a barber who has a loyal book. Haircuts are quicker and cheaper, so say $38 per booked hour, but the chair is 85% full: 34 hours and $1,292 a week. On commission the salon's profit is 34.5% of $1,292 less $210, or $235.74. A $300 rent would give the salon $90. For the barber, commission pays $646, while renting at $300 leaves $1,292 less $300 less $135.66 in product and card fees less $40, or $816.34. The barber is about $170 a week better off renting and the salon about $146 worse off, which is the high-occupancy pattern again: rent suits the person who knows they will be busy, and the salon should price accordingly. Here the sheet puts the zone at about $446 to $470, or the salon can stay with commission.

Now a new stylist whose book is only 25% full, 10 hours and $620 a week. On commission the salon makes $3.90 after overhead, close to break-even, and the stylist earns $310. At the same $450 rent the stylist would take home $620 less $450 less $65.10 less $40, which is $64.90 against $310 on commission. A rent like that would be a bet on a book that doesn't yet exist. Commission, a lower stepped rent for the first months, or a short trial are the likelier arrangements, and the sheet lets you price a stepped rent by changing one input each quarter.

What the spreadsheet can't see

The model counts money that moves through the chair. It misses the rest, and some of it is worth more than the numbers above.

• New clients. On commission, walk-ins and new enquiries are usually passed to stylists; a renter is expected to bring their own. If the salon's marketing fills diaries, a renter is using it, and the rent should reflect that.
• Retail and add-ons. Who sells shampoo, and who keeps the margin? A renter may sell their own range inside your premises, which changes your own retail income.
• Pay floors. If the stylist is an employee paid on commission alone, minimum-pay rules where you trade may require a top-up in a quiet week. At 20% occupancy the commission pay in the model is $248 for 40 chair hours, about $6.20 an hour, so the salon's low-occupancy profit may be overstated.
• Control and standards. Commission lets you set prices, products and service standards. Rent hands those to the stylist, and the salon's name still sits on the door.
• Admin and awkward weeks. Payroll is one task and chasing late rent is another. Sickness, holidays and a stylist leaving mid-term fall on different people under each model.
• Who owns the clients. Decide in writing whose client list it is if the stylist leaves, since the two models tend to assume different answers.

Employment status: the label on the contract doesn't decide it

Calling a stylist a renter does not make them self-employed. Whether someone counts as an employee or a self-employed renter is decided by how the arrangement works in practice, under employment rules where you trade, which differ and change. I can't tell you which side of the line your stylist sits on, and ChatGPT cannot either.

What I can give you is a set of questions that point towards the risk. Does the salon set prices, hours or methods? Does the salon book and keep the clients? Can the stylist send a substitute, refuse a client or work elsewhere? Who supplies tools and products? Who loses money in a quiet week? The more the honest answers are "the salon", the more the arrangement looks like employment, whatever the contract says. The reverse is also true: a renter who sets their own prices and hours, takes their own bookings and carries their own losses is much easier to defend.

Look back at the model with that in mind. The only reason a rent exists that suits both sides is the on-costs the salon stops paying. If the relationship were later treated as employment, those on-costs, and possibly back-dated amounts, could come back, and the model's gain would disappear. Ask an employment adviser or accountant before you move anyone from commission to rent, and again before using these numbers to justify it. The barber chair rental agreement tutorial and the tattoo artist booth rent or employee terms tutorial cover the paperwork and where AI is useful in drafting it.

From the numbers to an offer

Run the sheet for each stylist separately, since the occupancy and revenue per hour differ. For the stylist at 60% in our example, a rent between $513 and $548 sits in the zone; start inside it and expect to negotiate. For a stylist at 45%, commission is the cleaner fit. For one at 85% who wants rent, price it with the sheet instead of by feel, because the commission you'd give up is far larger than at 60%. Whichever you choose, agree a three-month trial, put the terms in a written agreement a lawyer has read, and rerun the sheet each quarter. The pricing side of a chair, minute by minute, is in the salon pricing calculator tutorial.

Questions salon owners ask before changing how a chair is paid

Which is better for a new stylist with few clients?

Usually commission, because a quiet chair then costs the stylist nothing beyond lost earnings, and the salon shares the risk while the book builds. A fixed rent is hardest to carry in the first months. Some salons offer a stepped rent that starts low and rises, but model it in the sheet before you offer it.

Can I model rent plus a percentage of takings?

Yes. Add an input for the percentage and a column for rent plus that share, then compare it with the other two. Be careful with the employment question, though: a charge that rises with the stylist's takings looks more like commission than rent, which can matter when someone assesses the arrangement. Ask your adviser before you offer a hybrid.

Should tips count towards revenue per hour?

Leave them out. Rules about who keeps tips differ by place, so check yours, but they should not inflate the income figure the whole model rests on. If card fees apply to tipped amounts, treat that as a separate cost line so it does not distort the service revenue per booked hour.

Should retail sales be part of the comparison?

Model them separately. Under commission the salon usually keeps the retail margin and may pay the stylist a share, while a renter may sell their own range. Add a retail line with its own margin and a note on who keeps it, then see whether it changes the break-even rent for that chair.

How often should I rerun the comparison?

Every quarter, and whenever rent, product prices or a stylist's hours change. It takes minutes once the sheet exists, because you only update the inputs. A rent agreed at 60% occupancy can quietly become a bad deal for one side if bookings drift to 45% or 80%.

Further reads

• Break-Even Analysis With AI: A Worked Example for a New Product — Break-even logic explained from a different starting point.
• How to Write a Salon Service Menu and Price List With AI — Price lists that feed the revenue-per-hour number.
• Fresha Pricing: Subscription, Marketplace Fees and Add-Ons Explained — Fresha looks cheap until you add marketplace fees, card processing and add-ons. Four worked monthly bills for a solo stylist, a small salon and a barber.
• Vagaro Pricing for a Small Salon: Calendars, Add-Ons and AI Features — A four-stylist salon costed line by line on Vagaro: the base plan, extra calendars, add-ons, Vera and card fees, with year-one and steady-state totals.
• How Much to Charge for Hair Extensions: Fitting, Hair and Aftercare — A worked price table for tape-in, beaded and keratin extensions: hair cost, fitting time, maintenance visits and aftercare, modelled with AI.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Square's pricing page (card rates, checked October 2026); OpenAI's help article on creating and editing spreadsheets with ChatGPT Work. All salon figures are illustrative.