Salon Pricing Calculator: Build One With AI From Your Real Costs

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Salon Pricing Calculator: Build One With AI From Your Real Costs.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Salon Pricing Calculator: Build One With AI From Your Real Costs.

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.

Follow me on Instagram@sagnikteaches

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.

Connect on LinkedInSagnik Bhattacharya
BlockWhat goes inWhere it comes from
Chair costMonthly fixed costs per chair, available minutes, realistic occupancyBank statements, booking system
Stylist costHourly pay, on-costs, share of paid time that is hands-onPayroll, diary
Product costGrams used per service times cost per gram, plus wasteSupplier invoices, a scale
Card feesPercentage of each paymentPayment statements
Margin targetShare of each price kept as profitYour 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.

Subscribe on YouTube@sagnikteaches
ItemOne-off or recurringCost
Gathering costs from statements and invoicesOne-offAbout two hours of your time
Weighing product on a scale that reads to 1 gramTwo weeks, then yearlyA few minutes a day; the scale is a small purchase
Building and checking the sheet with AIOne-offAbout an hour
AI assistantMonthly if you payFree to try; a paid plan is about $20 a month at list price, and you can cancel after the build
SpreadsheetRecurringGoogle Sheets is free; Excel comes with some plans you may already hold
Quarterly reviewRecurringAbout 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 costAmount
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.

LineAmountUnit costCost
Permanent colour100 g$0.16 a gram$16.00
Developer150 g$0.012 a gram$1.80
Waste allowance10% of the two lines above$1.78
Shampoo, conditioner and finishing productPer client$1.70
Gloves, cape cover and foilsPer 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.

ServiceChair minHands-on minChairStylistProductTotal cost
Cut and blow-dry6050$13.83$24.06$2.10$39.99
Root colour and blow-dry9050$20.74$24.06$12.10$56.90
Full head colour and finish15080$34.56$38.50$22.18$95.24
Half-head highlights and finish150100$34.56$48.13$14.13$96.82
Children's cut3025$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.

ServiceCalculated priceCurrent priceGapMargin at current price
Cut and blow-dry$48.47$48+$0.4714.2%
Root colour and blow-dry$68.97$62+$6.975.7%
Full head colour and finish$115.45$95+$20.45-2.8%
Half-head highlights and finish$117.36$120-$2.6416.8%
Children's cut$23.69$28-$4.3127.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-upChair cost a monthOpen hours a weekOccupancyCost per chair minuteCalculated cut price
Solo stylist renting a chair$6203665%$0.1019$39.12
Two-chair salon (the example)$1,677.504070%$0.2304$48.47
Central premises with reception$3,1004570%$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 costWhere it goes
Late cancellations and no-showsLower the occupancy figure
Free corrections and consultationsAdd the minutes to hands-on time for that service
Product wasteThe waste allowance on each colour card
Training time and holidaysStylist on-costs and the hands-on share
Discounts to new clients or staffTest the margin at the discounted price
Tools wearing outThe equipment replacement line in chair costs
Software subscription risesChair 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.

LeverEffect on costCost afterMargin at $95
TodayNone$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.185.7%
All three together$10.72 less in total$84.528.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

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.

Want the calculator built around your own books?

On a 1:1 call we'll gather your cost figures, build and test the sheet, and decide which prices to fix first, so you leave with something your team can run every quarter.

Book a 1:1 call with me