Film Reorder Alerts: Never Run Out, Real COGS

Running out of film mid-install is a special kind of pain. The car is torn down — panels off, badges in a cup, mirrors in a bag — the customer is in your waiting room scrolling their phone, and the roll you were sure had plenty on it is done at the B-pillar. Not almost done. Done. And there is no version of the next hour that goes well.

So you make the call. Whatever your distributor can get you today, at whatever today's price is, because you don't have a choice. Maybe you drive across town to borrow a roll off another shop and owe them one. Meanwhile the bay is stalled, a tech is standing around on the clock, and the customer is watching you sweat through what was supposed to be a clean, confident install. That is the moment the whole job flips from a win to a scramble.

Here's the part owners miss: that empty core did not cost you one roll of film. It cost you the panic markup on the emergency order, the dead bay time you can't bill, and a little slice of the customer's confidence in you — the thing that was supposed to earn the referral. None of that shows up on the quote. It just quietly comes out of the number you thought you made this month. One bad Tuesday can erase the margin on the three good jobs around it.

Reorder alerts exist so you never live that Tuesday again. And the same plumbing that keeps a core from running dry — knowing exactly what's on every roll and what it cost — hands you the other thing owners almost never get: real numbers on what your work actually costs. Never run out, and always know your cost. Those two are more connected than they look, and together they're the difference between a shop that feels profitable and a shop that is.

The fix for the empty core isn't a better memory or a Sunday-night stock count. It's a threshold that does the watching for you. You set a reorder point per product, in feet, and Service VIN watches the remaining stock across every roll of that product. The moment it drops to your line, the product lands on the reorder list at the top of your inventory — and the individual rolls flag themselves low as they run down, so the rack on screen tells the same story as the rack on the wall.

That flips the whole rhythm of restocking. Instead of reordering on a panic — the morning a core dies with a car on the lift — you reorder on a signal, days ahead, while there's still time for film to ship at a normal price you negotiated. You choose the moment. You choose the supplier. Nobody's got you over a barrel because the job's already torn down. That's the difference between buying film and getting shaken down for it.

And this isn't a gut-feel threshold you're guessing at forever. Watch your usage for a few weeks and the right reorder point becomes obvious: set it above however much film a typical lead-time's worth of jobs eats, and you've built yourself a buffer that refills before it empties. The busy products carry a higher line, the slow ones a lower one, and the list only ever bugs you about the roll that actually needs attention. Everything else stays quiet. That's the whole idea — the software does the nagging so you can go back to the bay.

COGS — cost of goods sold — sounds like something your accountant worries about in April. On a film job it's simpler and a lot more useful than that. It's the true material cost of the film a job consumed, measured from what you actually paid for that roll. Not the list price on the invoice you never quite reconcile. Not a month-end estimate you back into from a stack of receipts. What that specific film really cost you, tied to the specific car it went on.

Most shops don't have this, and they don't know they don't. They have a fuzzy sense of "film's about a third of the job" and a bank balance that keeps disagreeing with how busy they feel. The reason is that film cost is the most expensive, most variable thing they move, and they're tracking it by vibe. A roll that ran clean and a roll you fought and wasted half of get counted the same in your head. They are not the same on your margin.

"Real" is the operative word. When every roll carries its own acquisition cost and draws down foot by foot as you work, your COGS stops being an average smeared across the month and becomes an actual measurement of each job. That's the version you can manage. You can't do anything with "film is roughly a third." You can do plenty with "this job's film cost was X, and here's why it ran high." One is a shrug. The other is a lever.

Tracking the roll is half of it. The half that moves your margin is attribution — every foot you pull gets tied to the job it went on. So when a car leaves your bay, its job page already carries the true material cost of the film that went on it, from what you really paid per roll. Not an average. Not a number you'll reconstruct later. The real cost of the real feet off the real roll.

This is where owners find money they didn't know they were losing, because per-job cost tells you which work is actually profitable — and it's not always the work you'd guess. The full-body job that keeps a bay tied up for two days and eats film on every complex panel can carry a thinner margin than the tidy partial front you knock out before lunch. The busy jobs feel like the winners because they fill the calendar and the invoices are big. Sometimes they're the losers. You only find out when the true cost is sitting on the job instead of living in your gut.

That's the uncomfortable, useful truth real COGS hands you. Run the same read across a month of jobs and patterns show up: a certain vehicle that always overruns your film estimate, a service you priced years ago that no longer clears its own cost, a package that looks premium but barely beats the basic one once you count the film. None of that is visible when material cost is a monthly lump. All of it is visible when each install carries its own. You stop pricing on feel and start pricing on what the work actually costs you.

So where does a job's money actually go? Below is an illustrative breakdown of a single sample job — film and material, labor, the waste you trim off and can't reuse, and the overhead the job has to carry. I want to be dead clear about what this is: it's a made-up example to show the shape of the thing, not a measured average and not a benchmark to grade your shop against. Your real split will look different, and that's exactly the point — you should be reading yours, not mine.

What the picture is meant to show is that on a film job, material and labor are the two big blocks, and the waste slice is bigger and quieter than most owners think. That waste is film you bought, cut, and dropped in the bin — the curved offcuts, the strip too narrow for the next panel. It never lands on a quote, so it never gets managed, and it adds up one trimmed edge at a time. When your software knows how much film you pulled and how much made it onto the car, that slice stops being a shrug and becomes a number you can shrink.

Reorder discipline and real COGS aren't two separate features that happen to live in the same menu. They're the same habit paying you back twice. Both start from one thing: every roll is a known quantity with a real cost and a real length, not a fuzzy pile of plastic on a rack. Get that right and your cash flow gets healthier from two directions at once.

First, you stop bleeding cash on panic. No more emergency reorders at whatever price you can get on the day — you're buying film on your schedule, at your negotiated cost, because the reorder list gave you a head start. Second, you stop tying up cash in dead stock. When you can see on-hand valuation — what the film on your rack is really worth right now, at what you actually paid — you quit over-buying the products that gather dust and you free up money that was sitting on a shelf doing nothing. Panic on one end, over-stock on the other; discipline squeezes both.

Then the reporting closes the loop. Roll your real draw-downs up and you get 30-day COGS built from what film genuinely cost you to do the work you did, plus a waste share that finally puts a figure on the scrap. That's a little P&L for the most expensive material in your building, and it's the same view that lands in your reports, where COGS, waste and margin roll up so you can act on them. Not a benchmark to feel good against — a mirror. And a mirror is worth a lot more, because you can do something about what you see in it.

Here's the payoff that ties it all together. Real cost coming in is what makes accurate margin going out even possible. When your quotes are costed from the real film in inventory, the margin you see before you hit send is the margin you'll actually keep — because the cost feeding it is the cost that'll leave your shelf, not a number you typed in once and forgot. Accurate cost in, accurate margin out. Guess at the cost and every margin above it is a guess in a nice font.

Follow the whole loop and it's genuinely tight: you quote against the real roll, the reorder point makes sure that roll is on the rack when the customer says yes, you install off it, the draw-down puts the true cost on the job, and that cost rolls straight into your reporting and your next quote. One version of the truth from roll to quote to job to P&L. No second set of books, no month-end archaeology, no surprise in the bank balance.

If you want the method behind the software — the daily habits that keep your reorder points and COGS honest instead of drifting stale — that guide walks it. And none of this is a premium add-on you have to climb a plan ladder to reach: film-roll inventory with reorder alerts is included from Essentials up, the entry plan. This is table stakes for running a shop, and it's priced like it.

We're all installers before we're business owners. The craft is why you started, and the craft is real — but the roll doesn't care how clean your squeegee work is if you never knew what it cost or when it was going to run out. Set your reorder points, let each job carry its own true cost, and go be the shop that's still here in five years.