Labor cost per ton
One number per line, decomposed into headcount, labor rate and OEE effects, so you know which lever to pull before you change staffing.
Production BI for food and beverage manufacturers
I build the reporting layer between your ERP, your line data and the people running the floor, so decisions about staffing, run sizes and customer orders get made on dollars per hour instead of gut feel.
If any of these take more than a minute to answer, the data exists and nobody has wired it together. That is the job.
One number per line, decomposed into headcount, labor rate and OEE effects, so you know which lever to pull before you change staffing.
Changeover cost by SKU and run length, so minimum order quantities are a math decision instead of an argument with sales.
Case-weighted fill rate by customer, deferred versus lost sales, and a scheduling rule that protects the accounts that pay the bills.
Seven years as the sole BI resource for an organic food manufacturer in California, multi-line, with a parent company in Europe. Built the data function from zero. These are the results.
Analysis showed single-pallet runs were unprofitable. A half-day minimum run size cut runs under two hours by 94 percent and doubled cases per run. The plant now makes 25 percent more cases on half as many runs.
Jar line OEE went from 38 to 72 percent. Bottling from 57 to 78.
Fill rate to key accounts was below 70 percent and nobody was tracking it. Built case-weighted fill rate and deferred-versus-lost reporting, then drove a fill-top-customers-first scheduling rule. Accounts that were about to leave stayed.
Roughly $200K a month in shorted orders is now recaptured.
Every line lead was hand-calculating OEE daily. The weekly KPI package was a half-day manual pull. Spec sheets took an hour each across 500 items. All of it now refreshes on its own, and 50 digital forms replaced paper-then-retype capture with 40,000+ submissions feeding reports directly.
Eight data sources (ERP, line data, syndicated retail, broker files, flat files) into one Power BI layer used weekly by the CEO and every department head. Trained 25+ people to use it and coached six to build their own reports, so it keeps working without me in the room.
I build on what you already own. No new platform, no data lake project, no six-month roadmap before the first number shows up.
Get in touch
Put "reporting audit" in the subject and one sentence about your plant. I reply within a business day.
I'm Vincent Munoz. Twelve years in business intelligence, the last seven running the entire data function for a CPG manufacturer as its only BI person. Before that, analytics at a major wine producer and a financial firm. Degree in Decision Science from San Francisco State.
I came up through the kaizen school: small, measurable improvements, every week, that compound. The same way I coach jiu-jitsu. You don't need a data team. You need one person who has done this on a real floor and can show your line leads what the numbers mean.
Based in Texas. Work remote with manufacturers across the US.