ROI Case File No.497 'A Company That Can't See Inventory Until Month-End'
A Company That Can't See Inventory Until Month-End
Chapter One: Until Month-End Closing, Inventory Is Unknown
"How much inventory remains—we can't accurately grasp it until month-end."
Yasuharu Kataoka, IT lead at Globex Corporation, explained the current management flow. Sales, procurement, and inventory management run on Excel, with no integration with the accounting features of the Bugyo series. "The field that moves daily and the management side that can only aggregate monthly are misaligned."
"How is the relationship with group companies?" Claude confirmed.
"Security strengthening requests are coming from the parent company," Kataoka answered. "Excel-based management of personal information and transaction information doesn't conform to the group's security policy. We've been given a deadline and are required to systematize."
"What's the field's IT literacy?" Gemini asked.
"It varies by department," Kataoka answered. "Sales is comfortable with Excel but has aversion to system input. Warehouse staff are paper-based. Accounting is somewhat comfortable with systems. Uniform operational training will leave some departments unable to take root."
"How many locations?" I confirmed.
"Headquarters and three warehouse locations, plus two sales offices," Kataoka answered. "Workflow differs subtly by location. Data integration hasn't been achieved."
"Group companies, internal culture, locations, costs—these 'distances' are entangled together," I said. "CAGE suits that organization."
Chapter Two: CAGE Asks About Four Distances
"This case requires CAGE."
Claude wrote four letters on the whiteboard: C, A, G, E.
"CAGE is a framework for evaluating gaps between organizations and markets through four distances: Cultural, Administrative, Geographic, and Economic," I explained. "Originally a framework for international management strategy, it can be applied to internal system implementation. Institutional distance with group companies, cultural distance between departments, geographic distance between locations, economic distance between cost and return—lining these up reveals what to prioritize in system selection."
"Let's first measure current costs," Gemini said, opening ROI Polygraph. She entered the work records from Kataoka.
"Monthly management costs are out," Gemini read. "Excel-based sales, procurement, and inventory management workload averages 240 hours per month. At 3,000 yen per hour, that's 720,000 yen monthly. Monthly closing work: 80 hours, equaling 240,000 yen. Order errors and stockout losses from inventory inaccuracy averaging 350,000 yen. Management decision delay opportunity loss from monthly-only visibility: 400,000 yen monthly. Audit response workload from group security policy non-compliance: 30 hours, equaling 90,000 yen. Total: 1.8 million yen monthly. Annualized: approximately 21.6 million yen."
Kataoka studied the figures. "Inventory inaccuracy and decision delays are large as hidden costs."
"Now let's design with CAGE," I continued.
[C—Cultural: Bridging IT Literacy Gaps Between Departments]
"First, we address cultural distance," Claude said. "With sales, warehouse, and accounting having different IT literacy, a uniform system implementation won't take root in weak departments. The countermeasure is designing 'view-only screens,' 'input screens,' and 'aggregation screens' separately by department. For warehouse staff, minimize input screens; for sales, center on result confirmation screens."
"The same system, with department-specific presentation," Kataoka confirmed.
"Yes," I agreed. "Cultural distance is absorbed through screen design. This lowers training burden and raises adoption rate."
[A—Administrative: Match the Group's Security System]
"Next, administrative distance," Gemini continued. "The parent group's security policy is a mandatory requirement. Multi-factor authentication, audit log retention and submission, domestic data storage, hierarchical access permission management—these become preconditions for selecting products."
"How specifically do we narrow it down?" Kataoka asked.
"Send RFIs (Request for Information) to candidate products, having them respond on whether they comply with the group's security checklist," Claude answered. "If even one item is non-compliant, drop them from candidates. Administrative distance is the axis to slice off first."
[G—Geographic: Cross-Location Data Integration]
"Geographic distance is about data integration across multiple locations," I continued. "Headquarters, three warehouses, two sales offices—six locations each currently hold individual Excel files. Integrate to a cloud-based sales management system, sharing in real time. Make a state where inventory is visible across locations."
"How do you absorb operational differences between locations?" Kataoka confirmed.
"Divide workflow into three layers," Gemini responded. "All-location common core operations, customizable parts by location, local operational rules. Common parts go into the system, local parts handled by operational rules. Trying to systematize all operations causes complexity to explode."
[E—Economic: Aligning Investment Scale with Returns]
"Economic distance is the balance between investment scale and recovery," Claude continued. "Major packages are feature-rich but become excessive at your scale. Prioritize mid-tier packages that meet group security requirements. Keep investment within an amount that matches your annual revenue scale."
[Calculating Investment Recovery]
"Let's run the numbers with ROI Proposal Generator," Gemini suggested.
- Initial cost: Sales management system implementation, data migration, location-specific screen design, group security compliance, department-specific training. Total: 6.8 million yen
- Monthly cost: System usage fee 240,000 yen
- Monthly reduction: Excel management workload reduction = 500,000 yen (assuming 70% reduction), monthly closing work reduction = 160,000 yen, order optimization from inventory accuracy improvement = 250,000 yen, decision delay improvement = 280,000 yen, audit response workload reduction = 70,000 yen. Total: 1.26 million yen monthly
- Net monthly reduction: 1,260,000 − 240,000 = 1,020,000 yen
- Payback period: 6,800,000 ÷ 1,020,000 = approximately 6.7 months
"Payback in just over six months," Gemini summarized. "Inventory becoming visible in real time advances order optimization. This works as a surprisingly large effect."
Kataoka confirmed the figures and said, "I was viewing this as investment for security compliance. Organizing with CAGE, other effects can be captured at the same time."
"Four distances aren't separate effects—they resolve simultaneously through one system selection," I responded.
Chapter Three: A Selection Process That Visualizes Distance
"Let me organize the approach," I said, standing at the whiteboard.
"Week 1—Organize requirements through four distances (CAGE). Weeks 2–3—Send RFIs to five candidate products, confirm group security compliance. Week 4—Narrow to three, send RFPs. Weeks 5–6—Receive proposals, run demos, evaluate department-specific operability. Week 7—Select, contract. Weeks 8–11—Data migration, location-specific screen design, department training. Week 12—Begin parallel operation. Week 16—Cutover complete."
"What's the load of location-specific screen design?" Kataoka confirmed.
"Adjustments from standard templates suffice," Claude answered. "It looks like all locations are customizing, but core operations are common. Differences are handled through location-specific configuration changes. Design workload fits within one-third of initial estimates."
Kataoka took notes and said, "Selecting only by security requirements would result in a system unusable in the field. Through four distances, the way of choosing changes."
Chapter Four: The Day Inventory Becomes Visible in Real Time
Nine months later, a report arrived from Kataoka.
After implementing the sales management system, inventory became real-time shared across all locations. Inventory levels that were unknown until month-end transformed into a state where the figures from five minutes ago are constantly visible. "Order timing and quantity can be decided based on data," Kataoka wrote.
The biggest change was the simultaneous reduction of stockouts and overstock. Real-time visibility allowed early detection of stockout warning signs, reducing stockout incidents from a monthly average of 8 to 2. Simultaneously, the need to hold safety stock decreased, also reducing overstock. "When inventory is visible, you can hold only what's needed," the report noted.
The effect of department-specific screen design was also significant. Warehouse staff input screens narrowed to three items, with familiarization within a week of transitioning from paper. Sales centered on result confirmation screens, transitioning smoothly from past Excel habits. "Different visible screens by department allowed training content to be optimized by department," Kataoka wrote.
For group security compliance, audit response workload dramatically decreased during parent company audits. Because audit logs and access permission hierarchy are equipped as standard features, output for audit requests became immediate. "Previously we had to re-aggregate from Excel for each audit. Now it comes out at the press of a button," the report noted.
Management decision speed also changed. Inventory and sales status materials previously presented at monthly meetings were replaced with real-time dashboards, allowing reference to data during meetings. "The premise of discussion changed from monthly data to current numbers," Kataoka wrote.
As a secondary effect, inquiries from other group subsidiaries increased. "We want to reference your case as an example of implementing a system with the same security requirements that's also usable in the field," contact came from other subsidiary IT departments. The selection process organized through CAGE began being shared as group-wide knowledge.
The end of the report read: "Targeting only security compliance results in a system unusable in the field. Organizing distance through CAGE allows pursuing multiple effects simultaneously. Visualizing distance changed the precision of selection."
It was the day inventory unknowable until month-end became visible at any moment.
"System selection can't be decided on one axis. What CAGE asks is the four distances of culture, administration, geography, and economy. Selecting while looking at only one distance, you don't notice the other distances widening. Distance from the group, between departments, between locations, between investment and recovery—lining up four naturally determines selection priority. The state where inventory unknowable until month-end becomes constantly visible wasn't solved by system features—it was solved by organization of distance."
Related Files
Tools Used
- ROI Polygraph — Visualizing Excel management, inventory inaccuracy, and audit response cost
- ROI Proposal Generator — Investment recovery simulation for sales management system implementation
