Chapter 15: EIQ Analysis Practice Case
The raw data and analysis sheets for "Example EX0" discussed in this course are provided in Microsoft Excel format. Please check numerical changes and chart linking while comparing them with the explanations in each chapter.
Includes specific calculation logic and graph creation procedures.
Download File (.xls)📁 Main Data Sheets Included
- EX0-DATA: Underlying order history data
- EIQ Table: Basic table sorted by Order Quantity (EQ) and Shipment Quantity (IQ)
- ABC Analysis Sheet: Cumulative ratios and graphs by EQ/IQ
- Frequency Distribution: Histogram data for order size and item overlap (IK)
- PCB Analysis Sheet: Aggregated tables by packaging type (Pallet, Case, Bulk)
- Radar Chart: Calculation data for DC Size and DC Scale