Chapter 2 Tera Calculation 0 Shipping Data Processing

Section 0 Flow of Tera Calculation 0

Based on reference materials, this section explains the role and processing workflow of "Tera Calculation 0", the primary stage of shipping data analysis.

Tera Calculation 0 Flowchart Diagram

Role of Tera Calculation 0

Tera Calculation 0 is software designed to organize and process raw shipping data into an easily manageable format prior to distribution center scale calculations (Tera Calculation 1 and 2). At this stage, frequently calculated common data is created in advance and maintained as the "T200" table in Microsoft Access.

4 Steps of Data Processing

Specifically, shipping data is processed according to the following procedure:

  1. Separation of Shipping Formats: Divides shipping data into "Case Shipping" and "Piece Shipping".
  2. Unit Conversion: Batch-converts raw piece-quantity data into essential logistics design units: "Case Count", "Pallet (PL) Count", "Volume", and "Weight".
  3. Rank Assignment: Summarizes data per destination and per item (sku), assigning "Destination Rank" and "Item Rank" according to their respective fluidities.
  4. Generation of "T200" Table: Consolidates all the above information to complete the core master data table required for analysis.

Importance of Grouping by Fluidity

To design an efficient distribution center, it is crucial to accurately group high-fluidity items and low-fluidity items, assigning appropriate facility equipment and operational workflows to each category.