Excel still works.
Reports are still sent every week.
The finance team still consolidates figures at month-end. The warehouse team still updates inventory records. Production still has a schedule.
From the outside, everything seems fine.
Until the CFO asks a simple question:
“How much profit did we actually make on this order?”
And answering it requires three Excel files, two calls to the production team, and a full day to verify the numbers.
This is no longer just an Excel problem.
It is a business control problem.
In plastics and packaging manufacturing, raw material prices fluctuate, scrap occurs, production schedules change, and actual costs do not always match estimates. When data is scattered across multiple spreadsheets and systems, understanding what is really happening becomes increasingly difficult.
Excel is not bad software. It is an excellent tool for analysis, calculations, and reporting.
But when Excel becomes the primary tool for connecting finance, inventory, production, and order management, your business may be relying on a system that was never designed to control an entire manufacturing operation.
So, when should a manufacturer consider ERP?
Here are six warning signs that CFOs and business leaders should watch for.
1. Your CFO Spends Too Much Time Verifying Numbers
Let’s start with a familiar situation.
The CFO needs a report showing the actual production cost of a customer order.
Finance has the material cost figures. The warehouse has records of material issues. Production has output and scrap reports. Purchasing has the latest raw material prices.
Every department has data.
But not all the data is updated at the same time, calculated using the same methods, or linked to the same transactions.
The result?
The finance team must consolidate, reconcile, and adjust the figures before it can produce a reliable report.
The problem is not a lack of reports
The problem is that the data is not connected.
When information is maintained in separate spreadsheets, manufacturers are more likely to encounter situations such as:
- Inventory balances that do not match between finance and the warehouse.
- Production costs that have not been fully updated.
- Revenue and cost reports based on data from different periods.
- Employees entering the same information into multiple systems.
- CFOs who cannot immediately determine which figures reflect the actual business situation.
A well-formatted report does not guarantee accurate underlying data.
And if every reporting cycle requires another round of manual verification, management will struggle to respond quickly enough to changing business conditions.
How can ERP help?
A suitable ERP system connects financial, purchasing, inventory, and production processes through a common data platform.
When transactions are recorded through properly configured workflows, departments can work with consistent information instead of maintaining separate versions of the same data.
This helps CFOs reduce reconciliation effort, improve reporting reliability, and establish a stronger basis for evaluating business performance.
The question every CFO should ask:
If you needed to verify the financial and production status of a customer order today, how long would it take to produce a number you could trust?
If the answer is several days, the problem may go beyond reporting speed.
2. Actual Production Costs Are Significantly Higher Than Expected
In plastics and packaging manufacturing, product costs depend on much more than raw material purchase prices.
They are also affected by scrap rates, material losses, regrind, machine runtime, changeover time, labour costs, productivity, and other operational factors.
An order may look attractive when it is quoted.
But after production is complete, the actual profit margin turns out to be significantly lower.
So, where did the money go?
If your business relies on Excel to consolidate production costs, identifying the cause can take considerable time. Costs incurred on the shop floor are not always recorded promptly or fully linked to the relevant production order.
Three gaps that make production costs difficult to control
First: Actual material consumption exceeds standard requirements.
Actual material usage may exceed the expected quantity because of scrap, material losses, process changes, or operational issues.
If consumption data is not recorded promptly, the variance may not become visible until the end-of-period reconciliation.
Second: Production costs are not fully captured.
Machine runtime, tooling and mould changeovers, labour costs, and other operational factors can cause actual costs to differ from the original estimate.
If production data is not connected to financial data, identifying the reasons for these variances becomes more complicated.
Third: Cost reports arrive too late.
By the time the CFO receives the report, the order may already be complete and the customer may have received the goods.
The business knows that profitability was lower than expected, but there may be little opportunity to change decisions affecting that particular order.
How can ERP improve production cost control?
A manufacturing ERP system can connect bills of materials, production orders, inventory transactions, material consumption, and cost information, depending on its configuration and the processes implemented.
This gives manufacturers a stronger basis for comparing standard and actual costs, identifying variances, and investigating their causes.
However, ERP cannot automatically produce accurate costing if bills of materials, input data, or transaction-recording processes are unreliable.
Technology can connect the numbers. It cannot compensate for consistently poor data.
The question every CFO should ask:
Can your business identify why actual production costs exceeded estimates before the same problem affects the next order?
If not, you do not just have a costing problem. You have a problem with proactively protecting profitability.
3. Inventory Reports Do Not Reflect What Is Actually in the Warehouse
Inventory is one of the key factors affecting working capital in a manufacturing business.
For plastics and packaging manufacturers, inventory management becomes even more complex when they need to track multiple types of raw materials, additives, packaging materials, work in progress, finished goods, and recyclable scrap.
Even a small discrepancy in inventory data can trigger a chain of problems.
- Purchasing orders additional raw materials even though sufficient stock is already available.
- Production runs short of materials despite the system showing adequate inventory.
- Finished goods accumulate while materials required for new orders are unavailable.
- Working capital becomes tied up in slow-moving inventory.
- Production schedules change because material availability information is inaccurate.
Excel can track inventory. But who controls the transactions?
An Excel spreadsheet can show inventory quantities at a particular point in time.
However, if receipts and issues are updated late, transactions are missed, or different employees use different versions of a file, the reported balance may no longer reflect reality.
The problem becomes more serious when a manufacturer operates multiple warehouses or production sites, or needs to manage materials by lot.
At that point, manual verification does more than consume time. It increases the risk of making purchasing and production decisions based on inaccurate information.
What can ERP bring to inventory management?
ERP can connect purchasing, goods receipts, inventory issues, production, and sales through a more consistent management process.
Depending on the system configuration and implementation scope, manufacturers can:
- Track inventory quantities by item and location.
- Control inventory transactions through defined workflows.
- Link material requirements to production plans.
- Track raw material and finished goods lots.
- Improve inventory reconciliation and stocktaking.
For CFOs, the benefit is not simply knowing how much inventory is sitting in the warehouse.
The bigger question is how much working capital is tied up in inventory, why inventory levels are increasing, and whether the business can meet production requirements without maintaining excessive safety stock.
The question every CFO should ask:
If your business needed to confirm whether it could fulfil a new customer order right now, would your current inventory data be reliable enough to support that decision?
4. Production Changes Constantly, but Finance Always Finds Out Last
An urgent order comes in.
A customer requests a change to the delivery schedule.
A production machine breaks down.
Raw materials fail to arrive as planned.
The production team must reprioritise work to meet new requirements.
This is the reality of plastics and packaging manufacturing. Production plans do not always unfold as expected.
The problem arises when every change triggers a series of manual updates.
Employees revise the planning spreadsheet. The warehouse adjusts material lists. Purchasing checks existing purchase orders. Finance waits for updated data before revising cost figures.
Meanwhile, the CFO is still reviewing a report based on the original production plan.
One production change can affect multiple financial indicators
When production schedules change, the business may incur:
- Overtime costs.
- Additional machine or mould changeover costs.
- Expedited transportation costs.
- Additional raw material purchases at different prices.
- Unexpected scrap or material losses.
- Late delivery risks that may affect revenue.
If these changes are not recorded promptly and linked to financial data, the CFO may struggle to assess their impact on profitability.
By month-end, the variances appear in the reports. Tracing them back to their causes can then require considerable effort.
How can ERP connect production plans with actual performance?
A suitable manufacturing ERP system can connect customer orders, material requirements, production schedules, resource capacity, and execution data.
This helps departments better understand the implications of production changes instead of addressing each issue through disconnected spreadsheets.
For CFOs, this creates an opportunity to assess cost, delivery, and resource-utilisation risks earlier.
However, real-time visibility depends on how promptly transactions are recorded and how well the ERP system integrates with other systems used on the shop floor.
The question every CFO should ask:
When production plans change, how long does it take your business to understand the impact on costs and profitability?
5. Your Business Is Growing, but Management Still Depends on a Few Key Employees
Some manufacturers operate quite successfully with Excel during their early stages.
One accountant understands every formula used to calculate production costs.
One warehouse manager knows which spreadsheet contains the latest inventory figures.
One production planner understands exactly how to adjust the manufacturing schedule.
One department head can explain exceptional cases that nobody else fully understands.
Thanks to their experience and coordination, operations continue to run.
Until someone takes leave, changes roles, or leaves the company.
Suddenly, reporting takes longer. Nobody wants to modify certain formulas. Critical business rules exist only in someone’s memory.
Your business does not lack capable employees.
It relies too heavily on knowledge that has never been standardised.
Why should CFOs be concerned?
When management processes depend on individual employees, operational complexity and the cost of maintaining control can increase as the business grows.
Each new factory, warehouse, or product line may introduce additional spreadsheets, workflows, and reporting methods.
Management then struggles to ensure that every department follows the same processes and works with consistent information.
This affects:
- The consistency of management reporting.
- Transaction controls and approval processes.
- Knowledge transfer and employee handovers.
- The ability to scale operations.
- Traceability of changes and discrepancies.
ERP helps standardise processes, not just digitise spreadsheets
ERP can help manufacturers standardise business processes, assign user permissions, manage transactions, and maintain change histories through appropriately configured functionality.
Instead of relying on someone remembering what needs to happen, the business can establish clearer workflows, responsibilities, and controls.
This is an important step towards reducing dependence on individual knowledge and building a management foundation that can support growth.
The question every CFO should ask:
If the employee responsible for a critical process left tomorrow, could the business continue operating and producing reliable reports?
If the answer is no, the risk extends well beyond losing a few Excel files.
6. Management Only Sees Problems After They Have Affected Profitability
This is perhaps the most important warning sign.
The business still has revenue reports.
It still has inventory reports.
It still has production reports.
But most of these reports explain what has already happened.
The CFO knows that costs increased last month. The COO knows that scrap rates exceeded normal levels. Purchasing knows that raw material inventory is too high.
The problem is that this information often becomes available only after the underlying events have occurred.
The business starts investigating when the financial impact is already visible.
Moving from historical reporting to earlier decision-making
A manufacturer needs more than figures consolidated at the end of each month.
The CFO needs to understand what is driving cost changes, which factors are putting pressure on margins, and what risks could affect business performance.
The COO needs to know which production orders are at risk of delay, which processes are experiencing problems, and which resources could become bottlenecks.
The CEO needs a reliable basis for deciding which orders to prioritise, where to invest, and how to allocate resources.
When data is fragmented, connecting these different perspectives to support decisions becomes difficult.
ERP provides a foundation for data-driven management
A suitable ERP system connects transactional and operational data, creating a foundation for management reporting and business performance analysis.
When data is sufficiently accurate and updated through appropriate processes, manufacturers can improve their ability to identify variances, monitor operational indicators, and detect issues requiring attention.
This also provides a foundation for more advanced analytics and AI applications.
However, it is important to distinguish between the capabilities involved.
ERP helps establish the data foundation and operational controls. Predictive capabilities depend on data quality, analytical models, and the technologies implemented.
Integrating AI into software does not magically transform inaccurate data into reliable forecasts.
The question every CFO should ask:
Can your business identify the factors threatening its profit margins early enough to take action, or does it only discover the results after the reporting period ends?
If most decisions still rely on outdated information, your business lacks the visibility needed to respond proactively.
Excel vs. ERP: What Should CFOs Consider?
Not every business using Excel needs to implement ERP immediately.
For smaller businesses with simple processes and relatively low transaction volumes, Excel may still meet many management requirements.
The objective is not to eliminate Excel at all costs.
It is to determine whether the current systems can still support the complexity of your business operations.
| Criteria | Excel and Disconnected Systems | Manufacturing ERP |
| Data management | Data may be scattered across multiple files. | Connects business data through a common platform. |
| Financial reporting | May require manual consolidation and reconciliation. | Can consolidate information from transactions recorded in the system. |
| Production cost control | Depends on input data and manually maintained formulas. | Can connect standard costs, production, materials, and cost information according to system configuration. |
| Inventory management | Relies on spreadsheets being updated and synchronised. | Connects inventory transactions with purchasing and production. |
| Production tracking | May require manual communication and updates between departments. | Connects production plans, production orders, and execution data. |
| Process control | Depends on how files and internal procedures are organised. | Supports user permissions, approvals, and transaction controls. |
| Scalability | Management effort may increase as data and processes become more complex. | Can scale with business requirements and implementation scope. |
| Data analysis | Depends on available data and analytical tools. | Provides a foundation for reporting, analytics, and advanced applications. |
Important: ERP does not automatically solve every problem. Its effectiveness depends on how well the system fits your manufacturing processes, the quality of your data, the implementation approach, and how effectively your employees use it.
What Should CFOs Evaluate Before Investing in ERP?
Before selecting a solution, assess three key areas.
Do not look only at software costs.
Consider the time employees spend reconciling data, the financial impact of inventory discrepancies, production cost variances, delivery risks, and decisions delayed by a lack of reliable information.
Not all these costs can be converted into precise financial figures immediately. However, identifying them is essential for understanding the true cost of your current operating model.
Your priorities might include inventory accuracy, production cost control, production planning, or consistency in financial reporting.
Do not implement ERP simply because your competitors are using it.
Identify the operational problems with the greatest impact on your business performance, then evaluate how technology can address them.
Manufacturers should evaluate how well a solution supports raw material management, bills of materials, production scrap, reusable materials, lot traceability, quality management, and other industry-specific processes.
A system with more features is not necessarily a better fit.
What matters is whether it supports your actual operating processes without creating excessive manual work or forcing employees to rely on workarounds outside the ERP system.
ERP and AI: The Next Step After Establishing Data Control
When production and financial data are better connected, manufacturers can explore capabilities beyond traditional reporting.
This is where AI and data analytics become relevant.
For example, businesses can investigate applications such as:
- Analysing raw material consumption trends.
- Identifying unusual variations in operational data.
- Supporting demand forecasting and production planning.
- Analysing factors affecting costs and profit margins.
- Helping managers identify issues that require prioritised action.
The practical value of these applications depends on the available data, the technologies implemented, and the specific business problems being addressed.
The important point is not to start by asking:
“What can we do with AI?”
Start with a more useful question:
“What information are we missing that would help us make better decisions?”
Then determine how ERP, analytics tools, and AI can support those requirements.
This is a more practical approach than investing in technology simply because AI is the latest trend.
Data V Tech: Connecting ERP with the Realities of Manufacturing
At Data V Tech Solutions, we work with manufacturing and distribution businesses to modernise their operations through ERP consulting and implementation.
With Epicor Kinetic ERP, businesses can establish an integrated management foundation connecting processes such as:
- Financial management and accounting.
- Purchasing and inventory management.
- Production planning and manufacturing management.
- Quality management and traceability.
- Production cost tracking and costing.
- Data analysis to support reporting and decision-making.
The actual scope and benefits depend on each business’s requirements, processes, and implementation approach.
We do not believe every manufacturer needs to replace its entire existing system immediately.
What matters is identifying the right operational bottlenecks, assessing their business impact, and developing an appropriate improvement roadmap.
Because the ultimate objective is not to add another software application.
It is to help your business gain better control over costs, operations, and business performance.
Webinar: Transforming Plastics and Packaging Manufacturing with AI-Enabled ERP
If your business struggles with fragmented data, inaccurate costing, difficult inventory control, or reports that reveal problems only after they have occurred, this webinar offers an opportunity to explore the challenges in greater depth.
Data V Tech is organising a webinar for plastics and packaging manufacturers, focusing on operational challenges and how technology can help businesses improve control over their manufacturing operations.
Webinar details
- Topic: Transforming Plastics and Packaging Manufacturing with AI-Enabled ERP
- Date: Wednesday, 11 November 2026
- Time: 3:30 PM (Vietnam time, UTC+7)
- Duration: 90 minutes
- Format: Online via Microsoft Teams
- Language: Vietnamese
- Speakers: Ms. Annie (Epicor) and Ms. Phuong (Data V Tech)
Key topics
- The operational challenges that lead to financial losses in manufacturing businesses.
- Which business problems can technology help solve?
- Transforming manufacturing operations with AI.
The webinar is designed for CEOs, CFOs, COOs, IT Directors, and other business leaders seeking better cost control, greater operational transparency, and improved decision-making.
[Register for the AI-enabled ERP webinar for plastics and packaging manufacturers.]
Excel Is Not the Problem. Business Control Is.
Excel still has a place in business management.
However, as financial, inventory, and production data become more complex, relying on disconnected spreadsheets can make it harder to verify figures, control costs, and respond quickly to operational changes.
The six most important warning signs are:
- Your CFO spends too much time verifying numbers.
- Actual production costs differ significantly from estimates.
- Inventory reports do not reflect physical stock accurately.
- Production changes are not reflected promptly in financial data.
- Management processes depend on a few key employees.
- Leadership discovers problems only after they have affected profitability.
If several of these warning signs apply to your business, it is time to evaluate your current management systems and determine whether ERP could address the underlying problems.
Because ultimately, your CFO does not need another Excel spreadsheet.
Your CFO needs reliable data to understand where the business makes money, where it loses money, and what action to take before a problem becomes more expensive.
