By: Natalie Johnson
Ask an executive on the plant floor which product lines make the most money, and you will usually get a quick answer. Taking a closer look at standard cost calculations and manufacturing rate variances, however, may reveal a different story. Shaun M. Farley, an experienced manufacturing chief financial officer (CFO), spends much of his time showing leadership teams that their margin numbers rest on unverified math. Uncovering true profitability requires rethinking cost variances, automating operational data, and building detailed analyses that can be verifiably tied back to the general ledger.
Validating The Baseline Numbers
In manufacturing, pricing models and sales quotes largely depend on standard cost calculations. Across dozens of balance sheets and plant reviews, Farley finds that leadership rarely checks whether those baseline numbers match current factory conditions. “The data can reveal that profitability isn’t coming from where you think it is,” Farley says. “Profitability analysis begins and ends with accurate standard cost gross margins, and that accuracy has to be validated regularly.”
When companies operate without auditing those baselines, small cost deviations quietly turn into substantial losses. “The biggest issue I see with clients and in my CFO career has been a question that rarely gets asked: are the standard costs even accurate?” Farley explains. “Too many management teams work on the assumption that they are correct without anyone asking for validation.” Sales teams then quote prices using historical estimates, unaware that supplier price increases or scrap rates have erased the spread. Fixing this blind spot does not require an annual audit that disrupts daily operations. Instead, Farley advises treating standard cost reviews as a steady operational discipline. “Standard cost variance analysis should be done monthly to give your sales team the confidence that the gross margins used for pricing are reliable and to give executives the confidence to make good decisions,” he notes. “When they are not, it’s appropriate to adjust.”
Replacing Manual Guesswork With Automated Analytics
Catching discrepancies every 30 days helps, but sales teams still face daily pricing discussions that cannot wait for month-end reports. If a commercial director has to wait two weeks for finance to run a custom spreadsheet, the contract is already signed. Farley points out that pulling granular transaction numbers should never turn into an internal fire drill. Operational leaders need accurate numbers placed directly into their daily workflow before commitments take effect.
“Automate the analytics,” Farley says of streamlining this workflow. “You shouldn’t have to do some emergency analysis when the detail can be automated and spoon-fed to a user before the decision has to be made.” By feeding verified data directly to decision-makers, companies remove the delays that stall commercial negotiations. Routine transactions move forward with pricing that reflects shop floor costs in practice. Speed matters most when it replaces internal debate with clear facts. “Remove guesswork and theories so that departments are making fully informed decisions in real time,” Farley advises. With immediate access to reliable metrics, teams spend far less time arguing over spreadsheets during critical meetings. Managers can adjust terms, catch sudden cost spikes, and protect contract margins before finalizing deals.
Laying The Groundwork For Scalable Data
Constructing this level of reporting requires a sensible approach to corporate data systems. Modern manufacturers often run a mix of older enterprise software, plant tracking tools, and newer cloud applications. “We are in the age of data ecosystems being the relevant buzzword,” Farley observes. Trying to run business intelligence by connecting reports to dozens of isolated databases creates an administrative headache. Instead of starting painful system migrations, Farley advocates for a practical replication model. “The primary way in which you handle and monitor large ecosystems with dozens or hundreds of data sources is by cloud replication of as many data sources as possible,” he points out. “This can allow analysts and developers to go to one or two data lakes for access to all required data, instead of connecting to a multitude of sources, which makes managing business intelligence analyses far more difficult and inefficient.” Centralizing data copies gives developers a clean workspace without disrupting day-to-day plant operations.
Cloud data infrastructure no longer requires the bloated budgets of the past. “Microsoft Fabric Lakehouse is a great solution for this and possibly the best solution out there, but there are many more,” Farley says. “Nonetheless, starting with a cloud computing solution to copy, not migrate, existing data sources is the first place to start. The best part is the affordability is still there for even the tightest budgets.” Taking this first step keeps initial spending low, while opening the door to real-time financial and operational tracking. Once the storage foundation is running, leadership can turn their attention to practical execution. “The next step is to get business intelligence developers on staff or contracted to create the real-time analyses your decision-makers need,” Farley concludes. When companies pair clean cloud replication with experienced analysts, profitability stops being a mystery solved months after the fact. With reliable data in hand, the management team can finally be confident they can see which products carry the business.
Shaun M. Farley shares his perspective on manufacturing finance, cost variance analysis, mergers and acquisitions in the manufacturing sector, and building scalable business intelligence systems on his LinkedIn profile.
