Prologue: When Profits Erode Unnoticed
Imagine you are the owner of a steel processing factory in Karawang. Last month, you successfully won a large tender from an infrastructure contractor worth IDR 4.7 billion. That figure feels promising. The production team is moving, the machines are running, and deliveries are going smoothly. But when the end-of-month financial report arrives on your desk, the profit margin that was supposed to be 18% is only left at 6%—even after deducting operational costs, the figure is nearly break-even.
What is wrong?
It turns out that the price of steel billets increased by 14% during the production process. There was no system to alert us. The purchasing team bought based on the old price. The cost estimation at the beginning of the project was never updated. And when everything was finished, the losses had already occurred.
This is the reality faced by thousands of metal industry entrepreneurs in Indonesia every day.
Case Study: CV Karya Baja Nusantara
The company name and details have been anonymized to protect client confidentiality, but this scenario represents the general conditions of the industry.
CV Karya Baja Nusantara is a metal component manufacturing company established in 2008 in Bandung. They produce steel frames, aluminum panels, and precision components for the construction and automotive sectors. With 85 employees and a production capacity of 200 tons per month, this company is classified as a medium-sized business that is currently growing.
In 2022–2023, the company began to experience a series of seemingly unrelated problems, which turned out to stem from a single root cause: the lack of an integrated information system.
Pain Points: Real Problems That Undermine Businesses
1. Material Prices Changed, Costing Data Did Not Change
The metal industry is very sensitive to fluctuations in global commodity prices. The prices of steel, aluminum, copper, and nickel can move 10–20% in just a matter of weeks, depending on geopolitical conditions, the dollar exchange rate, and global market demand.
At Karya Baja Nusantara, the production cost estimate (Bill of Materials / BOM) is created at the beginning of each month using an Excel spreadsheet. The problem is that the material prices in the spreadsheet are rarely updated in real-time. When purchasing buys materials at new, higher prices, those figures do not automatically reflect in the calculation of COGS (Cost of Goods Sold). As a result, price quotes to clients are often under-priced, and profit margins are eroded without detection.
2. Uncontrolled Stock: Surplus in One Warehouse, Shortage in Another Warehouse
This company has two warehouses: one at the main factory location and another in the distribution area. Stock recording is done manually by each warehouse officer using physical books and separate Excel files. The result? The production team at the main factory often orders new materials because they think the stock is depleted, while the distribution warehouse still has a surplus of the same materials. Money is tied up in unproductive inventory, while cash flow continues to be strained.
3. Late and Inaccurate Financial Reports
At the end of each month, the accounting staff must gather data from various sources: physical purchase receipts, manual production reports, sales invoices from emails, and stock summaries from two warehouse locations. This recap process takes 7–10 working days. This means that the owner can only see the financial condition of the previous month by the middle of the following month—too late to make timely strategic decisions.
4. Weak Production Traceability (No Traceability)
When there is a complaint from a client about defects in the received components, the team must manually trace: which production batch is problematic, which supplier's material was used, and who the operator was running the machine at that time. This process can take days and often damages client trust.
5. Non-Standardized Purchasing Process
Purchase Order (PO) is created through WhatsApp or email without a structured approval process. There is no price comparison among suppliers, no historical price records, and no automatic mechanism to detect purchases outside the established budget.
Turning Point: The Decision to Go Digital
After experiencing net losses for two consecutive quarters, the management of CV Karya Baja Nusantara decided to conduct a comprehensive evaluation. They realized that the problem did not lie in the quality of the products or the capabilities of the human resources—but rather in the system's inability to provide accurate and real-time information to decision-makers.
The decision was made: the implementation of an ERP system. And their choice fell on Odoo—a modular, flexible, and proven effective open-source ERP platform for medium-sized manufacturing industries.
Odoo Solution: One Platform, All Under Control
Dynamic Manufacturing & Bill of Materials (BOM)
With Odoo Manufacturing, companies can define BOM digitally for each product. Its main advantage: the material prices in the BOM can be directly linked to the latest purchase prices. Every time the purchasing team enters a PO with new prices, the system automatically updates the estimated COGS. Owners and production managers can immediately see if the margin is still on target before production begins.
In addition, the Work Center and Routing features allow for precise recording of machine time and resources, enabling overhead costs to be calculated much more accurately.
Inventory Management: Real-Time Stock Visibility
Odoo Inventory integrates stock data from all warehouse locations into a single dashboard. The production team can view material availability in real-time before planning the production schedule. The system is also equipped with reorder rules that automatically provide notifications (or even create draft POs) when stock approaches the minimum threshold that has been set.
The lot/serial number tracking feature enables full traceability from incoming materials to finished products—crucial for handling warranty claims and quality audits.
Purchase Management: Data-Based Purchase Control
Odoo Purchase allows the entire purchasing process to be digitized: from purchase requests, price comparison among suppliers (Request for Quotation), to multi-level approvals based on transaction value. The system stores historical prices per supplier, enabling the purchasing team to easily compare and negotiate based on real data, not intuition.
Integrated Accounting & Costing
This is the heart of the solution. In Odoo, every transaction—material purchases, consumption in production, sales of finished products—is automatically posted to the accounting journal. No more time-consuming manual input processes that could potentially be erroneous.
The Standard Cost and Average Cost (AVCO) features allow companies to choose the inventory valuation method that best suits their business characteristics. For the metal industry with high price fluctuations, the AVCO method provides a more realistic picture of the Cost of Goods Sold (COGS).
Real-time income statements, balance sheets, and cash flow statements are available whenever needed—no longer having to wait 10 days after the end of the month.
Dashboard & Reporting for Decision Making
Odoo provides a customizable dashboard according to needs. Owners can monitor key KPIs on one screen: margin per product, production efficiency per work center, accounts receivable aging, and cash position. With always up-to-date data, business decisions can be made based on facts—not estimates.
Results Achieved After Implementation
After six months of implementing Odoo with the support of experienced ERP consultants, CV Karya Baja Nusantara has recorded significant results:
- Costing accuracy increased by 94% — the deviation between estimates and actual COGS decreased from an average of 11% to below 1%
- The monthly book closing time has decreased from 10 days to 2 days
- Excess inventory value decreased by 28% thanks to centralized stock control
- No more duplicate purchases between warehouses in the first three months
- Client claim response time decreased by 80% thanks to the lot traceability feature
Conclusion: Digitalization is Not a Cost, But an Investment
The metal industry is a business that operates on thin margins. Every percentage difference between estimates and reality can mean the difference between profit and loss. In such an environment, managing a business with spreadsheets and manual records is not just inefficient—it is a real business risk.
Odoo is not presented as a burden of new technology, but rather as a solid data foundation for businesses that want to grow healthily and measurably. With the right implementation and guidance from experienced partners, digital transformation is not a luxury—it is a basic necessity for survival and growth in an increasingly competitive era.
PT Fujicon Priangan Perdana is an experienced Odoo ERP implementation partner for the manufacturing, construction, and distribution sectors in Indonesia. Contact us for a free consultation and analysis of your business needs.
www.fujicon-japan.com | Bandung, Jawa Barat, Indonesia