AI for Dentists: Consumables Stock Ordering and Price Checks

A dental practice can use AI to manage consumables by setting a par level for each item, building a weekly reorder sheet from counts and usage, and converting every supplier's price to a cost per unit. No patient data is involved, so a free AI plan is enough. A person still approves and places every order.

The money is in the details. Gloves, pouches, bibs, needle tips, cartridges and bonding agents are bought in boxes, cases and packs that rarely match between suppliers. A cheaper-looking box can be dearer per glove. AI is good at the dull arithmetic of converting those into comparable numbers, and at turning a stock count into a short list of what to order.

Follow me on Instagram@sagnikteaches

What counts as a consumable, and why guessing costs money

Consumables are items used up in treatment or infection control: gloves, masks, patient bibs, disposable suction tips, saliva ejectors, sterilisation pouches, disposable prophy angles, polishing paste, local anaesthetic cartridges, etching and bonding agents, composite, impression material, matrix bands and the like. Equipment, instruments and software sit elsewhere.

Connect on LinkedInSagnik Bhattacharya

Two errors are expensive. Running out stops treatment or sends a team member on an urgent run to a supplier. Over-ordering ties up cash and creates expired stock, which is wasted outright. Items with expiry dates, such as cartridges and bonding materials, need first-in, first-out handling. A par-level system prevents both errors without a lot of effort, and it makes ordering something any trained team member can do.

Subscribe on YouTube@sagnikteaches

If you want a wider picture of where AI can help a practice with no IT staff, six tools to try in the first month shows the range. Stock is a good first job because it carries no patient information and the savings are easy to see.

Par levels: the number that makes ordering mechanical

A par level is the quantity you want on the shelf after an order arrives. A reorder point is the quantity at which you place the next order. Both come from three facts about each item: how fast you use it, how long the supplier takes to deliver, and how much cushion you want.

Reorder point = (average daily use × lead time in days) + safety stock. Par level = reorder point + the quantity you want to order each time.

Worked example: one item, with numbers (illustrative)

Take nitrile gloves, size medium, bought in boxes of 100. The practice uses about 14 boxes a month across three chairs over 21 working days, so about 0.67 boxes a day. The supplier delivers in two working days. You want a safety stock of three days' use. Reorder point: 0.67 × 2 + 0.67 × 3 = 3.35, round up to 4 boxes. If you order in cases of 10 boxes, par level is 4 + 10 = 14 boxes. When the shelf count drops to 4 boxes, order a case. That is the rule, and nobody needs to remember anything.

Now repeat that for every item. Doing it by hand for 80 lines is tedious; asking AI to do it from a table is quick, as long as you check the first few lines by hand.

A reorder sheet that fits in a spreadsheet

You need one table with one row per item. Keep columns lean and agree on them once.

• Item and size or variant (for example "Nitrile gloves, medium")
• Unit (box, case, pack, cartridge)
• Units per pack (for example 100 gloves)
• Average use per month, from the last three months of orders or usage
• Lead time (days)
• Safety days
• Reorder point and par level (calculated)
• On hand (from the count)
• To order (calculated: par minus on hand if on hand is at or below reorder point)
• Preferred supplier, expiry-sensitive? (yes or no)

In Excel or Google Sheets, the reorder point formula is a single line, for instance =ROUNDUP(([@Monthly]/21)*([@Lead]+[@Safety]),0) if usage is monthly and there are 21 working days in a month. The order flag is =IF([@OnHand]<=[@ReorderPoint],[@Par]-[@OnHand],0). AI helps you write and debug these, and a person checks the first few rows against a calculator. Excel's COPILOT worksheet function stopped working on 14 September 2026, and Microsoft now points users to the Copilot pane, so use the pane or a chatbot to help build formulas rather than a function inside cells. Google Sheets has an AI() function on eligible Workspace and Google AI plans, but formulas for stock maths should be ordinary formulas that give the same answer each time. If you need help tidying a messy export first, cleaning messy data shows how.

Prompt to build the sheet

I run a three-chair dental practice. Here is a table of consumables with monthly use, pack size, supplier lead time and safety days. For each row, calculate: reorder point = (monthly use / 21) x (lead time + safety days), rounded up to a whole pack; par level = reorder point + usual order quantity. Show the working for the first five rows. Flag any item with an expiry date and a par level above 6 weeks of use, because overstocking risks waste. Output as a table I can paste into a spreadsheet.

Table: [paste]

Check the first five working lines yourself. If they are right, the rest almost always are. If the tool says gloves have a reorder point of 40 boxes when you use 14 a month, it has misread the units. Fix the column headings and rerun.

The weekly count and order routine

A system lives or dies on the routine. Keep it small enough that it happens on a Friday afternoon.

1. Count (15 minutes). One person walks the stock room and each surgery with the sheet and records "on hand". Use a phone to type straight into the sheet. If counting is slow, a phone barcode scanner that types straight into the sheet speeds it up.
2. Calculate (a minute). The sheet shows what to order.
3. Review (5 minutes). A practice manager or head nurse checks the list for oddities: a sudden jump in use, a service starting or stopping, a holiday week.
4. Order. Place the order through the supplier's site or phone. AI can draft the email or order summary, and you approve it.
5. Receive (as it arrives). Check the delivery against the order, rotate stock so the oldest sits at the front, and update on-hand.

That is about 25 minutes a week. Before, a typical practice either has a "whoever notices" system or an hour of ad hoc ordering, plus the occasional emergency. For turning the list into supplier emails, automating purchase orders and supplier emails covers the drafting part.

Supplier price comparison: cost per unit, not price per box

The most common mistake in comparing dental suppliers is comparing the headline price of a pack. Pack sizes differ, shipping thresholds differ, and some suppliers give rebates on volume or a free item with a case. Convert everything to cost per usable unit, then adjust for delivery.

A worked comparison (illustrative figures, not real quotes)

Supplier C looks cheapest by box ($8.60) but is dearest per glove, because its box holds 90, not 100. Supplier B is cheapest per glove at $0.084, but delivery adds $12 on orders below $200. If gloves are the only thing on a Supplier B order, $84.00 plus $12 is $96.00 for 1,000, or $0.096 each, which is more than Supplier A at $0.092 with free delivery on a large combined order. The right answer depends on the whole basket: if B's case price is paired with other items taking the order over $200, B wins. That is why a comparison needs a table and a basket view, not a glance at one item.

Prompt for the comparison

Here are quotes from three dental suppliers for the same consumables. For each item, calculate cost per usable unit (price / units per pack). Then, for my usual monthly basket (quantities below), calculate the total cost per supplier including delivery fees and free-delivery thresholds. Show the working. Flag any item where pack sizes differ so the comparison is not like for like, and any item where the products are not equivalent (for example a different glove thickness or brand grade). Do not recommend a supplier; list the totals and the caveats.

Quotes: [paste table]
Monthly basket: [paste quantities]

Notice "do not recommend a supplier". The tool compares arithmetic. You weigh service, reliability, returns policy, account manager, minimum orders and whether you trust the product. A saving of 3 per cent is not worth a supplier who takes a week to deliver.

What a price check cannot tell you

• Equivalence. Two composites or two bonding agents may not perform the same way, and that is a clinical decision for the dentists. AI can line up the prices, not judge the materials.
• Expiry on arrival. A case with only four months of shelf life is a poor bargain for a slow-moving item. Ask suppliers for expiry guarantees on cartridges and materials.
• Price changes. Prices and rebate schemes change. Record the quote date and re-check anything above a set value every quarter.

Where possible, get prices from the supplier's own catalogue or quote, not from a chatbot's memory. A chatbot may state a price that has not been current for a year. Paste in the figures you were quoted. If you want a wider view of how AI handles quote comparison and purchase matching, matching supplier invoices to purchase orders covers the payment end.

Main worked example: a three-chair practice over one quarter

Say a three-chair practice sees about 90 patients a week. The practice manager spends roughly two hours a week on ordering and chasing, and the practice buys about $5,200 of consumables a month. She builds the sheet for 62 items in an afternoon.

1. Week 1: pulls the last three months of supplier invoices into a spreadsheet, asks AI to turn them into monthly usage per item (with a human check on ten lines), and sets the first par levels.
2. Weeks 2 to 4: runs the Friday routine of 25 minutes, and notes every time she overrides a suggested order and why.
3. Month 2: compares prices for the 15 highest-spend items. Gloves, pouches and bibs together account for about $1,600 of the monthly bill, nearly a third of the bill in three lines.
4. Month 3: switches the three highest-spend lines to the best basket price, keeping the other items with the current supplier for service reasons.

Illustrative results: ordering time falls from two hours to about 25 minutes a week, a saving of roughly 6.5 hours a month. The price check finds savings of about 6 per cent on the $1,600 of high-spend lines, around $96 a month. Emergency orders fall from three in the previous quarter to one. Those are modest numbers for a business that spends $5,200 a month, and that is the honest scale of the win. The larger payoff is the quiet one: nobody finds themselves without a size of glove on a Monday morning. Your results will depend on how loose your starting process is. Practices already ordering with discipline will see less.

Five more situations the sheet should handle

• A holiday closure. Ask AI to adjust par levels for a two-week shutdown by scaling usage down and checking that nothing expires while the practice is closed. Check against the delivery calendar, since suppliers close too.
• A new service. If you add clear aligners or whitening, create new rows with an estimated first-month usage and review them after four weeks with real numbers. Do not extrapolate from a guess for a quarter.
• A supplier stockout. Keep an "approved alternative" column for critical items. When the preferred product is out, the team knows which substitute the dentists have already accepted.
• Expiry-sensitive items. Add a monthly expiry sweep for cartridges and materials: list items expiring within 90 days and plan to use them first. A cartridge thrown away at $0.90 is small, but a whole box of impression material is not.
• Price creep. Once a quarter, paste the latest invoice prices next to the previous quarter's and ask for every item whose unit price rose by more than 5 per cent. Challenge those at the next account review. It takes ten minutes and often finds an error or an unannounced increase.

Equipment that uses consumables, such as autoclaves, needs its own service-date log, and it follows the same pattern. If you do use pouch stock for sterilisation, link the par level to the sterilisation log so the two records agree on how much you really use.

Setting up the item list so the sheet stays clean

Most stock sheets decay because the item list is vague. "Gloves" becomes three rows, then six, then nobody knows which is current. Spend an hour at the start on naming, because every later step depends on it.

• One row per orderable item. A row is whatever you would type into a supplier's order form, including the size. "Nitrile gloves, medium, box of 100" is one row; "Gloves" is not.
• A supplier code column copied from the catalogue, so two people ordering the same product always pick the same item.
• A location column such as "Surgery 2 drawer", "Main store, shelf C", "Fridge". A stock count is faster when the sheet follows the walking route.
• An owner column with the nurse or manager who is responsible for each area, so a stockout has a name beside it rather than a shrug.

If you already have invoices but no list, give AI a de-identified batch of line items (descriptions and prices only) and ask it to propose a clean item list with units, pack sizes and likely duplicates. Illustrative output: "Rows 7 and 31 appear to be the same item, medium nitrile gloves, described differently. Row 14 is 90 per box, not 100, so it is not like for like with rows 7 and 31." Review the proposal line by line, because tools can merge two products that look alike but are not interchangeable.

Clearing out what you do not use

Every practice has a shelf of things bought for a technique someone tried once. Before setting par levels, run the oldest-stock check: list every item that has not been used in six months, and ask the dentists whether each one stays. Items that stay get a low par level, often one pack, and an expiry check. Items that go are used up, returned if the supplier accepts returns, or written off. It will not feel like savings, but a smaller range means fewer lines to count and order, and the sheet gets easier to run.

A delivery check that keeps the numbers honest

Stock sheets only work if what arrives matches what was ordered. Add a short receiving routine, posted on the stock room door:

1. Tick each delivered line against the order list, counting boxes, not trusting the delivery note.
2. Check expiry dates on anything with a shelf life, and note any under six months.
3. Rotate: new stock behind, old stock in front.
4. Photograph the delivery note if there is a shortfall and email the supplier the same day; credits are easier before the invoice is paid.
5. Update on-hand in the sheet before you leave the room.

If a delivery repeatedly arrives short or late, the lead-time column should reflect reality, not the promise. Change it to the true average, and the reorder points adjust themselves. That is a quiet benefit of the system: it shows which suppliers deliver as promised.

Free versus paid AI for this job

Because the data holds no patient information, the free plans of ChatGPT and Claude ($0) cover this comfortably. ChatGPT Plus is $20 a month and Claude Pro is $20 a month or $17 on annual billing; they raise message and upload limits (free plans allow only limited uploads), which helps if you upload a long supplier price list as a PDF or spreadsheet. If the practice already has a Microsoft 365 or Google Workspace subscription with AI built in, use that for in-sheet help. Check vendor pages before buying anything: plans and features change often, and a paid plan is not needed to try this.

Unit mix-ups, stale usage and other sheet failures

• Wrong units. Boxes versus cases confused, so the sheet orders 14 cases instead of 14 boxes. Spot it by checking the "to order" total against last quarter's spend each week.
• Stale usage. Par levels never updated after a chair was added. Spot it by a rise in emergency orders.
• Invented prices. A chatbot supplies a catalogue price from memory. Avoid it by pasting quotes yourself and stating "use only the prices I give you".
• Over-trust. The team stops looking at the shelves. Keep the weekly count a physical walk, not an assumption from the spreadsheet.

Starting with the 20 highest-spend lines

Start with the 20 highest-spend items, not all 62. Build the table, set pars, run the Friday routine for a month and compare prices on those lines only. If it saves time, add the rest. If you would like help setting up the sheet or deciding which parts of your practice admin deserve the same treatment, my AI implementation consultation covers that, through the contact page. The wider four-week AI plan for a dental clinic shows how stock ordering fits beside the other jobs.

Questions practice managers ask about AI and dental stock

Does AI need patient data for stock ordering?

No. Stock counts, pack sizes and prices contain no patient information, so a free AI plan is fine for this job. Keep clinical records, appointment lists with names and anything identifiable out of the sheet you share with the tool.

Can AI place orders with my supplier?

It can draft the order list and email, but a person should place and approve the order. Some supplier portals have their own reorder tools; use those for sending and let AI do the thinking beforehand.

What if my practice software tracks stock already?

Use its report as the data source. Export usage or inventory to a spreadsheet, then let AI work on the export. If your software has built-in reorder alerts, compare them with your par levels before turning any of them on.

How often should par levels be reviewed?

Every quarter, and whenever your schedule changes, for example when you add a chair, a hygienist day or a new service. Seasonal swings, such as a holiday shutdown, are worth a one-off adjustment.

Further reads

• How to Use AI to Set Reorder Points and Prevent Stockouts — The reorder-point maths in more depth, for any small stockroom.
• How to Find Dead Stock and Slow Movers With AI — Spot slow movers and cut waste in a stockroom.
• Does AI Stock Ordering Pay Off for an Independent Pharmacy? — How another health business weighs stock-ordering tools.
• How Small Shops Can Use AI to Forecast Stock and Reorder — Forecasting and reordering in a small retail setting.
• Dental Morning Huddle: A One-Page Daily Brief AI Builds From the Schedule — Bring low-stock flags to the daily huddle.
• How to Run a Stocktake Faster With AI and a Phone Scanner — Count stock faster with a phone scanner feeding the sheet.
• Dental Equipment Maintenance Log: Service Dates and AI Reminders — Keep autoclave and equipment service dates on the same routine.
• Associate Dentist Contract Checklist for Practice Owners: AI First Pass — A clause-by-clause checklist for practice owners: pay basis, lab fees, notice and covenants, with an AI first-pass prompt before the solicitor.
• Dental Fee Schedule: Set Fees and Explain Them to Patients With AI — Work out a dental fee schedule from chair-minute cost, price a membership plan, and draft patient wording that explains each fee.
• Can Dentists Use ChatGPT? Seven Admin Jobs With No Patient Data — Seven dental practice admin jobs ChatGPT can do without any patient information, with prompts, filled-in examples and the data rules to follow.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Support page on the COPILOT function, Google Docs Editors Help page on the AI function, ChatGPT and Claude pricing pages (all checked 4 November 2026).