Add up the chair's monthly costs and divide by the minutes you realistically book to get a cost per chair minute. Price each service as chair time plus stylist time plus weighed product cost, divided by the share of the price left after card fees and your margin target. AI builds the sheet; the costs must be yours.
AI can't see your bank statements, so it will happily fill gaps with plausible numbers: a colour costing $12, a chair costing $30 an hour. Those figures look professional and are wrong for your salon. Every input below has a place to find the real value, and the checksums near the end show you whether the sheet is calculating properly.
What the calculator needs, and what building it costs
The calculator has five blocks of real numbers. Most of the work is gathering them once; after that the sheet does the sums.
| Block | What goes in | Where it comes from |
|---|---|---|
| Chair cost | Monthly fixed costs per chair, available minutes, realistic occupancy | Bank statements, booking system |
| Stylist cost | Hourly pay, on-costs, share of paid time that is hands-on | Payroll, diary |
| Product cost | Grams used per service times cost per gram, plus waste | Supplier invoices, a scale |
| Card fees | Percentage of each payment | Payment statements |
| Margin target | Share of each price kept as profit | Your profit and loss account |
As for what it costs to build and keep, this is the honest list. The time estimates are rough, and the plan price is a list price.
| Item | One-off or recurring | Cost |
|---|---|---|
| Gathering costs from statements and invoices | One-off | About two hours of your time |
| Weighing product on a scale that reads to 1 gram | Two weeks, then yearly | A few minutes a day; the scale is a small purchase |
| Building and checking the sheet with AI | One-off | About an hour |
| AI assistant | Monthly if you pay | Free to try; a paid plan is about $20 a month at list price, and you can cancel after the build |
| Spreadsheet | Recurring | Google Sheets is free; Excel comes with some plans you may already hold |
| Quarterly review | Recurring | About thirty minutes |
Cost per chair minute, from your own statements
The chair cost is the salon's fixed costs shared across the chairs and then across the minutes those chairs are really booked. Here is an imaginary two-chair salon, with the fixed monthly costs taken from twelve months of statements and averaged.
| Monthly fixed cost | Amount |
|---|---|
| Rent | $2,400 |
| Utilities | $260 |
| Insurance | $110 |
| Booking software and card terminal rental | $85 |
| Laundry and cleaning | $140 |
| Marketing | $120 |
| Tools and equipment replacement | $90 |
| Accountancy and admin | $150 |
| Total | $3,355 |
Shared between two chairs that is $1,677.50 a month each. Each chair is open 40 hours a week, which is 40 × 52 ÷ 12 × 60 = 10,400 minutes a month, and the booking system shows that 70% of those minutes were booked over the last three months: 7,280. The cost per booked chair minute is $1,677.50 ÷ 7,280, or $0.2304. A 60-minute appointment therefore carries $13.83 of chair cost before a single product or stylist minute is counted.
Two choices in that sum matter. The first is the occupancy figure: it must be what happened, not what you hope for, because costs don't shrink when the diary is quiet. The second is the number of weeks. A month is 4.33 weeks, not 4, and an assistant may use 4, which inflates the chair cost per minute by about 8%. If you see 9,600 available minutes for a 40-hour chair, that is the slip.
List every cost that exists because the chair exists, including the dull ones, since a missing line makes every price too low. If you need to turn a messy year of statements into monthly averages, an assistant can sum a categorised CSV for you; remove account numbers and anything personal first, give it the file, ask for the monthly average per category, and check the total against the last statement.
Stylist cost per hands-on minute
A stylist is paid for the whole shift, but only part of it is hands-on with a client. The rest is gaps, cleaning, phone calls and breaks. So the cost of a hands-on minute is the loaded hourly cost divided by 60 and then by the hands-on share of paid time. A stylist paid $21 an hour with 10% employer on-costs costs $23.10 an hour, and if the diary shows 80% of paid time is hands-on, a hands-on minute costs $23.10 ÷ 60 ÷ 0.80, or $0.4813.
If you are the stylist, include yourself. Put your own hours in at the hourly value you would pay someone else to do your chair; otherwise the price comes out too low and the shortfall is unpaid work. For commission, the formula changes: labour becomes a percentage of price, and the price equals chair cost plus product cost, divided by what is left after commission, the employer on-costs on that commission, card fees and margin. For a 60-minute cut and blow-dry with 45% commission and 10% on-costs (4.5% of the price), that is ($13.83 + $2.10) ÷ (1 − 0.45 − 0.045 − 0.025 − 0.15), or $48.27, leaving the stylist $21.72 for 50 hands-on minutes. With 80% of paid time hands-on, that is about $20.85 for every hour at work, close to the $21 hourly rate, so on these figures the two methods price the cut within about 20 cents of each other. The difference is who carries the empty time: on hourly pay the salon does, on commission the stylist does, and a quiet month cuts their pay, which is why you should check that the stylist still earns a fair rate at your prices.
The commission or booth rent tutorial uses the same cost lines to compare how a chair is paid for, and is worth reading before you assume either arrangement is cheaper.
Product cost per colour: weigh the bowl, don't guess
Product cost is the easiest line to guess and the hardest to see leaking. Weigh the bowl before and after each colour service for two weeks, on a scale that reads to 1 gram, and write down the grams of colour and developer used. Average them by service type. Then turn supplier prices into cost per gram: a 60 g tube at $9.60 is $0.16 a gram, and a 1,000 g bottle of developer at $12 is $0.012 a gram. An assistant can do the conversion from pasted invoice lines, but check one result by hand, because it can misread pack sizes.
Convert these supplier lines to a cost per gram. Show the arithmetic.
1. Permanent colour, 60 g tube, case of 12, $115.20
2. Developer, 1 litre bottle, $12.00 (treat 1 ml as 1 g)
3. Lightener, 500 g tub, $28.00
An illustrative reply gives $115.20 ÷ (12 × 60 g) = $0.16 a gram, $12.00 ÷ 1,000 g = $0.012 a gram and $28.00 ÷ 500 g = $0.056 a gram. Check line 1 first: dividing the case price by one tube instead of twelve gives $1.92 a gram, twelve times too high, and the answer looks plausible enough to slip through. The 1 ml = 1 g shortcut for developer is also worth confirming by weighing a measured volume of your own.
This is the colour card for a full head of permanent colour with a finish, with illustrative numbers.
| Line | Amount | Unit cost | Cost |
|---|---|---|---|
| Permanent colour | 100 g | $0.16 a gram | $16.00 |
| Developer | 150 g | $0.012 a gram | $1.80 |
| Waste allowance | 10% of the two lines above | $1.78 | |
| Shampoo, conditioner and finishing product | Per client | $1.70 | |
| Gloves, cape cover and foils | Per client | $0.90 | |
| Product cost for the service | $22.18 |
The waste allowance covers the product left in the bowl, the tube end and the mix that gets thrown away. Your two weeks of weighing will tell you the real figure; 10% is a placeholder. A card like this for each colour service, plus a lighter one for cuts at $2.10, is all the product data the calculator needs. Keeping the cost per gram current is easier if you also track stock; the salon colour stock tutorial covers colour stock and reorder points.
Margin target: why adding 15% on top is not a 15% margin
Markup and margin are different, and the difference costs real money. Consider the cut and blow-dry, whose total cost is $39.99. Adding 15% on top gives $45.99. The card fee is 2.5% of that, $1.15, leaving $4.85 of profit, which is 10.5% of the price, not 15%. To keep 15% of the price after card fees, divide the cost by what remains of each dollar: $39.99 ÷ (1 − 0.025 − 0.15) = $48.47. At that price the card fee is $1.21 and the profit $7.27, which is 15.0%.
Where does the target come from? From your own accounts, not from an industry rule. Work out last year's profit as a share of takings after paying every cost, including a wage for yourself. If it was 6% and you want 12%, a 15% service-level target can make sense, because some visits never reach full price: discounts, free corrections and the quiet hours. Test it, then adjust.
Five services priced from cost
With the three rates fixed, each service needs only its chair minutes (the appointment length), its hands-on minutes and its product cost. Here is the cost build-up for five services in the example salon.
| Service | Chair min | Hands-on min | Chair | Stylist | Product | Total cost |
|---|---|---|---|---|---|---|
| Cut and blow-dry | 60 | 50 | $13.83 | $24.06 | $2.10 | $39.99 |
| Root colour and blow-dry | 90 | 50 | $20.74 | $24.06 | $12.10 | $56.90 |
| Full head colour and finish | 150 | 80 | $34.56 | $38.50 | $22.18 | $95.24 |
| Half-head highlights and finish | 150 | 100 | $34.56 | $48.13 | $14.13 | $96.82 |
| Children's cut | 30 | 25 | $6.91 | $12.03 | $0.60 | $19.54 |
Notice the colour services: the chair minutes are far more than the hands-on minutes, because the client sits while the colour processes. The stylist may be working on someone else then, but the chair is occupied, which is exactly why chair minutes and hands-on minutes are separate columns. Now divide each total cost by 0.825 (1 less the 2.5% card fee and the 15% margin) and compare with the price list.
| Service | Calculated price | Current price | Gap | Margin at current price |
|---|---|---|---|---|
| Cut and blow-dry | $48.47 | $48 | +$0.47 | 14.2% |
| Root colour and blow-dry | $68.97 | $62 | +$6.97 | 5.7% |
| Full head colour and finish | $115.45 | $95 | +$20.45 | -2.8% |
| Half-head highlights and finish | $117.36 | $120 | -$2.64 | 16.8% |
| Children's cut | $23.69 | $28 | -$4.31 | 27.7% |
The finding is the point of the exercise. Full head colour, at $95, loses money once the chair and the stylist's time are counted, because it ties up a chair for 150 minutes and the price doesn't quite cover the $95.24 cost, let alone the card fee. The children's cut is quietly carrying the day. This doesn't mean raise the colour price by $20 on Monday. It means colour is where a rise earns its keep and where the next conversation with your team should start; the salon price increase letter tutorial covers how to announce a rise once you've decided it, and checks how many visits you can lose before it stops paying.
Build the sheet in ChatGPT, then test it against known answers
The sheet needs four tabs: Costs, Rates, Products and Services. One prompt covers it. Whether your plan lets ChatGPT hand you a finished workbook depends on the plan and app, so be ready to ask for a list of cells and formulas instead; the ChatGPT Excel guide covers both routes.
Build a spreadsheet for pricing hair salon services. Four tabs.
Costs: a list of monthly fixed costs with amounts, a total, number of
chairs, cost per chair.
Rates: chair hours a week (40), weeks per month (52 divided by 12),
occupancy (70%), chair cost per booked minute, stylist hourly pay (21),
on-costs (10%), hands-on share of paid time (80%), stylist cost per
hands-on minute, card fee (2.5%), margin target (15%).
Products: each product line with amount used, cost per unit and cost;
a waste allowance percentage; a total per service.
Services: one row per service with chair minutes, hands-on minutes,
product cost (linked), total cost, calculated price
(total cost divided by 1 minus card fee minus margin), current price,
gap, and margin at the current price.
Rules: formulas only, no typed numbers inside formulas, inputs in
clearly labelled cells, percentages stored as percentages.
Do not round the per-minute rates.
Check it against the figures in this tutorial before you enter your own. With the example inputs, chair cost per booked minute must show $0.2304 and stylist cost per hands-on minute $0.4813. The cut and blow-dry must come out at $48.47 and the full head colour at $115.45. The checksums match to the cent only if the per-minute rates aren't rounded, which is why the prompt says so. Then change the occupancy to 75% and check that the cut falls to about $47.35 and the 60-minute chair cost to $12.90.
Four mistakes recur. Using 4 weeks a month instead of 4.33 makes the chair rate too high. Dividing stylist cost by chair minutes instead of hands-on minutes understates colour services. Multiplying cost by 1.15 instead of dividing by 0.825 is the markup trap and produces $45.99 for the cut. And formatting a percentage as 70 rather than 70% turns a $13.83 chair cost into a nonsense figure. OpenAI's help article on creating and editing spreadsheets in ChatGPT Work says the feature is still rolling out and depends on your plan, workspace settings and file type, so run these checks whichever route produced the sheet, and review every formula before you save or share it.
A last reality check uses last month's actual diary. Count how many of each service you did, multiply by the total costs above and add them. The answer should sit within a few percent of what the month's statements and payroll say you spent on chairs, stylists and colour. If it is far off, one input is wrong, and the gap tells you roughly which.
Cheap, mid and high: one haircut on three cost bases
The same 60-minute cut with the same stylist and product costs prices very differently depending on what the chair costs. These are three imaginary set-ups.
| Set-up | Chair cost a month | Open hours a week | Occupancy | Cost per chair minute | Calculated cut price |
|---|---|---|---|---|---|
| Solo stylist renting a chair | $620 | 36 | 65% | $0.1019 | $39.12 |
| Two-chair salon (the example) | $1,677.50 | 40 | 70% | $0.2304 | $48.47 |
| Central premises with reception | $3,100 | 45 | 70% | $0.3785 | $59.24 |
The spread is about $20 for the same haircut, and none of the three is wrong. It is why copying a competitor's price list tells you what they charge and nothing about whether you should. Card fees also depend on where you take payment. As one data point, Square's pricing page currently lists 2.6% plus 15 cents per in-person payment on its free plan, 2.5% on Plus and 2.4% on Premium (October 2026); the fixed 15 cents is a bigger share of a $24 children's cut than of a $115 colour, so use your own statements to set the blended rate.
Costs the calculator can miss
A calculator is only as honest as its inputs. These are the costs that most often go missing, and where each belongs.
| Hidden cost | Where it goes |
|---|---|
| Late cancellations and no-shows | Lower the occupancy figure |
| Free corrections and consultations | Add the minutes to hands-on time for that service |
| Product waste | The waste allowance on each colour card |
| Training time and holidays | Stylist on-costs and the hands-on share |
| Discounts to new clients or staff | Test the margin at the discounted price |
| Tools wearing out | The equipment replacement line in chair costs |
| Software subscription rises | Chair costs, reviewed each quarter |
The discount test is worth doing before you run an offer. A 20% new-client discount on the $48.47 cut gives $38.78, which is below the $39.99 cost, so every discounted cut loses a little. That is a pricing decision you can make knowingly, perhaps as a way of filling quiet hours, but it should never be a surprise.
Closing the full head colour gap: price is only one lever
The calculator also shows which levers move a price. The colour that loses money is the place to start. At $95 its margin is minus 2.8%, and a rise to the calculated $115 would be a big step for clients. Look at what else could change first.
| Lever | Effect on cost | Cost after | Margin at $95 |
|---|---|---|---|
| Today | None | $95.24 | -2.8% |
| Halve colour waste, 10% to 5% | $0.89 less product | $94.35 | -1.8% |
| Lift occupancy from 70% to 75% | $2.30 less chair cost | $92.94 | -0.3% |
| Move 35 processing minutes off the styling chair | $8.06 less chair cost | $87.18 | 5.7% |
| All three together | $10.72 less in total | $84.52 | 8.5% (14.6% at $102) |
The savings don't simply add up, because the occupancy and processing levers overlap: the processing minutes are costed at the lower rate once occupancy has risen. The processing lever has a condition attached. It only saves money if another client is really using the styling chair during those 35 minutes, for instance because the colour client waits at a colour bar; otherwise the saving exists on paper only. Halving waste needs weighing, and lifting occupancy needs fewer no-shows and quicker rebooking of gaps, which the no-show reminders tutorial covers from the diary side.
With all three in place, a $7 rise to $102 brings the margin back to 14.6%, close to the 15% target, instead of the $20 jump the raw calculation suggested. That is a smaller conversation to have with clients, and the service menu and price list tutorial shows how to present the final list once the numbers have settled.
Questions salon owners ask when pricing from costs
Is the calculated price the price I should charge?
No, it is the floor. It tells you what the service costs and what it must earn to hit your margin. The market, your reputation and your clients' budgets set the ceiling. If the floor is above what the market will pay, change the service time, the product or the chair cost instead.
What if my stylists are paid at different rates?
Give each pay level its own stylist-cost row and choose the row that matches who does the work. A junior and a senior stylist have different costs per hands-on minute, and a single blended rate hides it. If clients can choose either, price the service for each level instead of averaging, or you subsidise the senior's time.
How do I price services where hair length changes the time?
Use bands rather than one service. Short, medium and long hair can each have their own chair minutes, hands-on minutes and product weights from your weighing sheets, and each gets its own calculated price. That is more honest than one price for everyone and avoids a flat rate that loses money on the longest heads.
Should retail products go in the same calculator?
Keep retail out of the service calculator. Shampoo and styling products have a purchase cost, a shelf price and a margin of their own, and mixing them in hides what each earns. Price services from chair, stylist and product-used costs here, and track retail margin on its own sheet.
How often should I update the calculator?
Quarterly, and whenever rent, product prices or stylist pay change. Re-weigh product for a week once a year, since formulas and habits drift. A thirty-minute review beats a big rebuild, because the structure stays the same and only the inputs move.
Further reads
- Hair Salon Business Plan: Chairs, Prices and Cash Flow With AI — Chairs, prices and cash flow in one plan.
- How to Check Your Margins Product by Product With AI — Checking margins product by product from your own sales.
- How Much to Charge for Hair Extensions: Fitting, Hair and Aftercare — Pricing one service with hair, fitting and aftercare costs.
- Bakery Pricing Calculator: Build One With ChatGPT and a Spreadsheet — The same cost-based method built for a food business.
- How Much Should a Personal Trainer Charge? Model Session Packs With AI — A cost-based rate for solo trainers: the hourly maths, what a pack discount really costs, no-show losses, and a spreadsheet built with ChatGPT.
- Makeup Artist Price List Template: Build Bridal Rates With AI — A bridal rate card built from your hourly target: per-face prices, on-site fee, travel and early-start add-ons, with AI doing the sums and the layout.
- Salon Retail Sales: Write Aftercare Product Recommendations With AI — Product cards, a service-to-product map, a safe prompt and a claims check, so aftercare texts sell honestly without health claims.
- 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 (in-person card rates, checked October 2026); OpenAI's help article on creating and editing files with ChatGPT Work; the paid ChatGPT figure is an approximate list price. All salon costs are illustrative.