Classroom Supply Inventory Spreadsheet That Tells You What to Reorder

You’re twelve minutes into a project. Twenty-four kids need glue sticks. You have nine. Everyone knows how the rest of that period goes.

The frustrating part is that this is a solved problem. You didn’t run out of glue sticks because glue sticks are unpredictable — you ran out because nothing was watching the count, and there’s no version of the teaching day that leaves room for you to be the one watching it.

The Real Cost of Not Knowing What You Have

Teachers spent an average of $895 out of pocket on school supplies during the 2024–2025 school year, according to the AdoptAClassroom.org 2025 Teacher Survey — up from roughly $600 in 2015, a 49% increase in a decade. Meanwhile the median school-provided supply budget in that same survey was $200.

Some of that spending is genuinely unavoidable. But a meaningful slice of it isn’t. It’s the second pack of colored pencils bought in November because nobody remembered the eight sets already in the back cabinet. It’s the emergency Dollar Tree run at full retail because the cheap bulk order needed to go in two weeks earlier. It’s the duplicate purchase, the panic purchase, and the wrong-size purchase — three categories of waste that all trace back to the same root cause: you don’t have a current picture of what’s in the room.

An inventory sheet doesn’t reduce what your students need. It reduces what you buy twice.

What a Reorder Alert Actually Is

The mechanic is simple enough that it fits in one sentence: for each item, record the quantity you have and the quantity at which you’d want to reorder, and let the sheet compare them.

Two formulas do all the work. One calculates the shortfall — the quantity on hand subtracted from the reorder point, floored at zero so items you’re well-stocked on don’t show a negative. The other returns a status flag: REORDER when the count is at or below the threshold, OK when it isn’t.

Add an estimated cost per unit and a preferred supplier column and something more useful appears: the sheet can total what it would cost to bring every flagged item back to its threshold. That’s not a vague sense that you need supplies. That’s “$34.20 at Amazon and Costco” — a number you can compare against your remaining budget, submit as a reimbursement request, or hand to a parent asking what the class needs.

Setting Thresholds That Aren’t Guesses

The reorder point is the only judgment call in the system, and teachers routinely set it too low.

Two factors should drive it: consumption rate and lead time. A class that burns through a glue stick per student per project needs a threshold well above a single class set. Anything you order online rather than buy locally needs a higher threshold to cover shipping time. Anything that would derail a lesson if you ran out — dry erase markers, tissues, hand sanitizer — deserves a deliberately generous buffer.

A reasonable starting rule: set the reorder point at roughly one month of typical usage, then adjust after a semester of real data. If an item hits REORDER and you’re already out before the replacement arrives, the threshold was too low. Raise it and move on. You’re calibrating once, not managing a warehouse.

The categories worth tracking separately are the ones that behave differently: office supplies, art supplies, books and reading, snacks and hygiene, technology, furniture and storage, decorations, classroom management, and STEM materials. Consumables and durables don’t belong in the same bucket — one needs a reorder point, the other needs a replacement date.

The Teacher Classroom Budget & Supply Organizer from ReadySheetGo builds this in on its Supply Inventory tab, with the quantity-needed and REORDER status columns pre-formulated for up to ~96 items and a count of low-stock items surfaced on the Year-End Summary.

Where Inventory Meets Budget

An inventory sheet on its own is useful. An inventory sheet connected to a spending log is a different tool entirely.

When both live in the same file, three questions become answerable that otherwise aren’t:

“Do I already own this?” — the question that prevents the duplicate purchase, asked in the store aisle from your phone.

“What does restocking everything cost right now?” — the flagged items multiplied by estimated cost each, which is exactly the figure a reimbursement request or a classroom wish list needs.

“Which categories are actually draining my budget?” — month-by-month spending by category tells you whether art supplies or snacks and hygiene is the line item quietly eating your year, and inventory tells you whether that’s genuine consumption or repeat-buying.

That last pairing is where teachers usually find the surprise. Nobody predicts their own answer correctly.

The Once-a-Year Setup

The whole thing takes about forty-five minutes in August, and it’s the highest-leverage forty-five minutes of your setup week.

1. Walk the room with a laptop or tablet. List every consumable and durable you can see, including the back-cabinet inventory you forgot you had. Twenty to forty items is typical.
2. Enter quantity on hand. Approximate counts are fine — “about 200 sheets” beats no number at all.
3. Set a reorder point for each. One month of usage as a starting estimate.
4. Add estimated cost and preferred supplier. This is what makes the sheet do budget math later.
5. Update when something changes. Restocked? Adjust the count. Noticed something running low? Adjust the count. That’s the entire ongoing commitment.

After that, the sheet tells you what to buy. You stop discovering shortages during a lesson, you stop buying things you already own, and the back-to-school shopping list writes itself from the flagged items instead of from memory at 9pm the night before the bulk order deadline.

It won’t fix teacher pay or district supply budgets. But of the money you’re already spending out of your own pocket, it’s the part you can actually control.

Featured on ReadySheetGo

Teacher Classroom Budget & Supply Organizer — 10 tabs built for the way teachers actually spend. Supply Inventory with automatic REORDER alerts and quantity-needed calculations, Expense Log with reimbursable and receipt-saved flags, Back-to-School shopping list with estimated vs. actual cost, Grants & Donations tracker, Reimbursement tracker, Classroom Library inventory, month-by-month spending by category, a priority-scored Wish List, and a Year-End Summary covering net out-of-pocket cost and your educator deduction. Works in Excel and Google Sheets, no macros. Instant digital download — $12.99.

Sources: AdoptAClassroom.org 2025 Teacher Survey