As of 13 August 2026, AI can calculate the price increase you need.

What to actually do

1. Hand it to a person

   The route this page recommends

   A person who owns the outcome does this end to end, worth it when the failure is dear.

2. Use a tool built for this

   Second choice

3. Do it yourself

   The distant third

   A chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.

   How to actually do it

   1. Open your current price list and a spreadsheet containing recent sales, costs, volumes and customer or product segments.
   2. Separate prices including VAT from prices excluding VAT, then gather the same basis for unit costs, revenue and margin figures.
   3. Paste the figures and your target outcome into the prompt, adding the period covered by every volume, cost and revenue number.
   4. Paste the completed prompt into ChatGPT, Claude or Gemini and ask it to calculate the current position, target prices and volume scenarios.
   5. Copy the returned formulas and results into Rows or your existing spreadsheet, then compare each calculation with a manual check using the supplied inputs.
   6. Test the proposed prices against known customer contracts, published prices, competitor evidence and any internal approval limits before sending or publishing a price change.

   Prompt

   Calculate the price increase needed for this business using only the information below. Do not invent missing figures. If the data is insufficient, list exactly what is missing and show which parts can still be calculated.
   
   Business context: [what we sell, to whom, and in which UK market]
   Current price or prices: [include whether each figure is including or excluding VAT]
   Unit cost or delivery cost: [give the cost basis and currency]
   Current sales volume: [units, subscriptions or customers over a stated period]
   Current fixed costs: [amount and period, if relevant]
   Current revenue or gross margin: [figures and period, if known]
   Target outcome: [for example, cover a cost increase, maintain a target margin, or reach a stated revenue or profit figure]
   Expected volume change after the increase: [a justified assumption, a range, or unknown]
   Customer or product segments: [list different prices, costs and volumes if applicable]
   Proposed increase or constraints: [if any]
   
   Return:
   1. A table showing the current position and each required price under the stated target.
   2. The percentage and cash increase for every price, calculated from the figures supplied.
   3. Separate results for at least three clearly labelled volume scenarios if volume change is known or can be stated as a range. If it is unknown, explain why a single required increase cannot be calculated and show a break-even or sensitivity method instead.
   4. Every formula in plain English, with the figures substituted into the formula.
   5. A list of assumptions, missing data and checks I must complete before changing prices.
   6. Keep VAT treatment explicit and do not give legal, tax or accounting advice. State clearly that this is a planning calculation, not professional advice.

   Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.