📦 Inventory & Inbound Estimation Tab

Calculation Screen for Estimating Stock & Inbound Volumes from Outbound Data - Detailed Manual

📋 Tab Overview

🎯 What is "Inventory & Inbound Estimation Tab"?
This tab (在庫入荷量の推定Tp) estimates required **inventory levels and daily inbound replenishment volumes** derived directly from historical outbound shipping data (T200 master table).

It provides critical baseline metrics for **distribution center design**, determining required **storage footprint and receiving dock capacity**.

Full-case and piece-picking operations are evaluated independently, calculating inventory/inbound requirements across **I-ranks & E-ranks (A1, A2, B, C, D)**.

By configuring **Maximum Stock Days, Safety Stock Days, and Operational Stock Days** alongside shipping days and throughput volume, the system automatically computes rank-based inventory and inbound targets.

🎯 Purpose and Role

Primary Objectives

  • Storage Footprint Calculation: Derives required pallet positions, rack modules, and warehouse floor area from estimated stock.
  • Inbound Facility Sizing: Estimates necessary truck unloading docks and inspection bays from daily receiving throughput.
  • Rank-based Stock Policies: Establishes customized inventory turnover policies across A1 through D tiers.
  • Case vs. Piece Separation: Segregates case-rack storage areas from piece-picking rack locations.
  • Receiving Frequency Projection: Estimates inbound delivery frequency, truck trips, and receiving dock schedules.

System Architecture Position

Item Details
Parent Form 2在庫入荷量の推定.vb
Parent TabControl 在庫入庫推定Tc
Tab Name 在庫入荷量の推定
TabPage Name 在庫入荷量の推定Tp
Data Sources T200 (Filtered Shipping Master)
T050 (Daily Working Days)
TS30 (Case/Piece Equipment Allocation)
Execution Trigger Auto-summarizes on form load; calculation runs when clicking "ケース出荷分開始Bt" or "バラ出荷分開始Bt"

💡 Inventory Modeling Principles

Three Concepts of Stock Days

📅 Definition of Stock Days Parameters
Parameter Definition Input Method
Maximum Stock Days Peak inventory level immediately after receiving replenishment (e.g., 30 days of stock received at once). User Manual Entry
Safety Stock Days Minimum buffer inventory kept to prevent stockouts before the next shipment arrives (e.g., 5 days buffer). User Manual Entry
Operational Stock Days Average working inventory during stable operations. Automated Formula:
(Max - Safety) ÷ 2 + Safety
🎓 Sawtooth Inventory Model
Working inventory follows a standard **sawtooth replenishment pattern**:
Peak Stock (30 Days) → Depletes via Daily Outbound → Buffer Floor (5 Days Safety) → Inbound Replenishment → Peak Stock (30 Days).

🧮 Inventory & Inbound Formulas

📊 Key Formula Equations
1. Daily Average Shipping Volume
Daily Avg Volume = Total Outbound Volume ÷ Operating Days

2. Operational Stock Quantity
Operational Stock = Daily Avg Volume × Operational Stock Days

3. Replenishment Cycle Days
Inbound Cycle Days = Maximum Stock Days - Safety Stock Days

4. Daily Inbound Receiving SKU Count
Inbound SKUs / Day = Total Stock SKUs ÷ Inbound Cycle Days

📖 Standard User Operating Guide

1. Case Shipping Operations

  1. Input **Maximum Stock Days** and **Safety Stock Days** for Case Ranks A1 through D.
  2. Click button **ケース出荷分開始Bt** to execute case inventory/inbound calculation.
  3. Review detailed calculation outputs in grid `ケース単位出荷物量計算Dgv`.
  4. Toggle RadioButtons `ケース在庫量Rb` or `ケース入荷量Rb` to inspect target results.

2. Piece (Bara) Shipping Operations

  1. Input **Maximum Stock Days** and **Safety Stock Days** for Piece Ranks A1 through D.
  2. Click button **バラ出荷分開始Bt** to execute piece inventory/inbound calculation.
  3. Review detailed calculation outputs in grid `バラ単位出荷物量計算Dgv`.
  4. Toggle RadioButtons `バラ在庫量Rb`, `バラ入荷量Rb`, or `バラ出荷Rb` to view stock, inbound, or outbound profiles.