Multi-location Inventory Allocation System

– Multi-location Inventory Management Support integrated with 3PL Services –

At the Sakata Group, we provide multi-location inventory management support for client companies through our in-house developed “Multi-location Inventory Allocation System” integrated with 3PL services.

Service Menu

1. About the Multi-location Inventory Allocation Support System

The following are features of our “Multi-location Inventory Allocation Support System,” provided jointly by our Information Center and Systems Department.

(1) Inventory allocation based on shipping records, sales, production, and inventory plans

  • We support replenishment to each location and the creation of inter-location movement plans. This is done by setting minimum inventory months based on past shipping results, sales plans, production plans, and current inventory records.

(2) Data creation based on pallet-unit load calculations for chartered trucks

  • By converting movement data into pallet counts, we can estimate truck requirements and confirm the necessary number of chartered trucks.

(3) Web-based data sharing and management across multiple departments

  • The web interface allows production, sales, and logistics departments to input necessary data and share inventory information using on-screen tables and CSV import functions.

(4) Pre-planning for monthly movements with daily volume adjustments

  • We create daily movement plans for the following month based on truck load settings. These plans can be adjusted or corrected for subsequent days based on actual daily performance data.
▲ Return to Service Menu

2. Multi-location Inventory Allocation System Overview

System Overview Diagram
▲ Return to Service Menu

3. Multi-location Inventory Allocation System Function List

No. Function Description Type Cycle Timing
01 Data Import (Product Master CSV) Imports product master data files. Batch Daily Nightly
02 Data Import (Shipping Results CSV) Imports shipping results data files. Batch Daily Nightly
03 Data Import (Inventory CSV) Imports inventory data files. Batch Daily Nightly
04 Data Import (Sales Plan CSV) Imports sales plan data files. Batch Daily Nightly
05 Data Import (Production Plan CSV) Imports production plan data files. Batch Daily Nightly
06 Sales Special Factors Entry Registers special factors like campaigns to exclude them from shipping forecasts. Screen Monthly As needed
07 Shipping Ratio Creation Aggregates shipping results by location and calculates ratios per product. Batch Monthly Nightly
08 Sales Plan Creation by Location Distributes sales plans to specific locations based on shipping ratios. Batch Monthly Nightly
09 Sales Plan Adjustment Screen Modifies sales plan data for specific locations. Screen Monthly As needed
10 Inter-location Movement Planning Forecasts end-of-month stock and creates daily truck-unit movement plans for the next month. Batch Monthly Nightly
11 Current Inventory Data Creation Creates current inventory records, inventory months, and arrival schedules. Batch Daily Nightly
12 Sales Achievement Data Creation Calculates the achievement rate of sales plans by product and location. Batch Daily Nightly
13 Monitoring and Adjustment Screen Batch monitoring of inventory and achievement rates, and adjustment of movement plans. Screen Daily As needed
14 Movement Request Confirmation Confirms and modifies movement request data for specific cutoff times. Screen Daily As needed
15 Movement Request Data Creation Automatically creates request data at specified cutoff times. Batch Daily Fixed Time
16 Product Master Maintenance Maintains product attributes such as rankings and classifications. Screen Daily As needed
▲ Return to Service Menu
TOP