⚙️ Equipment Allocation Tab

Function Tab mapping Storage and Picking Equipment by EIQ Rank - Detailed Guide

📋 Tab Overview

🎯 What is the "Equipment Allocation Tab"?
This tab (機器設備割付Tp) maps specific **storage and picking equipment systems to items categorized by 5×5 EIQ ranks**.

It assigns material handling solutions—such as **Pallet ASRS, Mobile Racks, Fixed Racks, Automated Case Sorters, Case ASRS, and Flow Racks**—across all 25 EIQ matrix intersections to aggregate volume requirements by equipment type.

This functionality provides the baseline operational data required for **engineering facility equipment layouts and capital investment plans**.

🎯 Purpose and Role

Primary Objectives

  • Equipment Assignment: Map storage and picking systems across 25 EIQ rank cells.
  • Volume Aggregation: Summarize workload (pallets, cases, weight, lines) by allocated equipment.
  • Facility Master Planning: Derive required equipment counts and system throughput capacities.
  • Apply Preset Rules: Batch-apply Teramoto's standard recommended allocation profiles.
  • Custom Facility Mapping: Customize equipment profiles for specialized warehouse designs.

System Position

Item Details
Parent Form 3機器設備割付.vb (Equipment Allocation Form)
Parent TabControl 機器割付Tc
Tab Name 機器設備割付
TabPage Name 機器設備割付Tp
Output Excel Files TS50_ケース出荷機器別集計.xlsx
TS50_バラ出荷機器別集計.xlsx

⚙️ Selectable Equipment Systems

🏭 Equipment Catalog
System Name Key ID Engineering Application
Pallet ASRS PL_Ass Automated pallet storage; high-volume/high-turnover case shipments.
Mobile Rack 1 電動棚1 High-density case storage; medium-volume/turnover SKUs.
Mobile Rack 2 電動棚2 High-density piece storage; medium-volume/turnover SKUs.
Pallet Fixed Rack PL固定棚 Standard selective pallet racking for medium-low volume SKUs.
Sorter Machine 仕分機 Automated case sorter for high-frequency multi-route shipping.
Case ASRS ケースAss Automated mini-load tote/case storage & buffer.
Flow Rack フロー棚 Gravity flow picking modules for high-frequency piece picking.
Medium Rack 中量棚 Manual shelving for low-frequency piece picking.

📊 5×5 Matrix Mapping

In this tab, storage and picking equipment are assigned to all **25 EIQ matrix intersections (5 I-Ranks × 5 E-Ranks)** separately for Case and Piece workflows.

🧮 Operating Steps

  1. Select target peak shipping date from the date drop-down.
  2. Choose physical summary metric unit (Pallets, Cases, Pieces, Lines, Volume, Weight).
  3. Batch-apply **Tera Preset** or manually assign equipment per matrix cell.
  4. Click **S割付計算開始Bt** (Execute Allocation Calculation).
  5. Review equipment workload summaries in the data grids.
  6. Click **Excel保存** (Save Excel) to export `TS50` summary files.
⚠️ Mandatory Step
You **MUST click "Excel保存"** to generate `TS50` files before closing. Failing to save will cause errors in Module 4 (Equipment Capacity Requirement).