{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MHDC10_B_Design_Criteria_Data

MHDC10_B_Design_Criteria_Data - 1-A 1 Exhibit 1-A Summary...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1-A 1 file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls 02/17/2010 07:05:50 KEOGH Consulting Exhibit 1-A Summary of Total Shipments to Customer Stores from Regional DCs, by DC Type and Site Base Year and projected Design Year All DC types and facilities Base Year Service Volumes Design Year Service Volumes Annual Shipments to Stores Annual Shipments to Stores Avg. DC to Store Shipment (2.a) ID Name City State Cost $ CuFt Total Stores Serviced Total Shipments DC Shipment Value @ Cost $ Total Shipment Units (3) Total Shipment CuFt Avg. Store Shipment from DC, $ Total Stores Serviced Total Shipments DC Shipment Value @ Cost $ Total Shipment Units Total Shipment CuFt Equiv. Pallets / Shipment I. Phoenix Regional DC Total Service Volume 349 20,644 $361,483,762 126,881,735 15,043,392 $17,716 404 23,941 $419,709,114 147,403,440 17,467,724 $17,716 738 10 Avg. $/Unit -->$2.85 Avg $ / CuFt/--> $24.03 Notes: 1 Data provided by VP of Distribution. 2 Proposed DC design criteria as represented on this exhibit computed based on the following assumptions: a. New Stores defined using average shipments and shipped volume b. Total Store receipt volume for Design Year estimated from Base Year volume and projected shipment volume for new stores c. Frequency of store deliveries remains unchanged through the Design Year 3 Units = Retail selling units
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2-A 2 file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls 02/17/2010 07:05:50 KEOGH Consulting Exhibit 2-A Summary - Peak Week SKU Analysis Base Year, week ending 8/28/09 and projected Design Year average week Shipment CuFt (1) Typical Full Combo DCs and FDCs Total Peak Week CuFt, All DCs Base Year Peak Week CuFt Design Year Peak Week CuFt Description % of Total CuFt / Store Weekly Total CuFt Avg. CuFt / Store Avg. Weekly CuFt Avg. CuFt / Store Weekly CuFt (2) Avg. CuFt / Store Shipment No. of Flow SKUs Design Year Avg. Inventory (CuFt) Design Year Storage Pallet Positions Req'd % Total Storage CuFt. Phoenix DC SKU Analysis (1) A. Extremely Fast Moving Full Case Pick SKUs Top 60 Full Case Pick SKUs Sub Totals 327,848 29.1% 623 109,283 623 117,283 578 289 60 607,771 14,519 12% B. Other Full Case SKUs Next 2,768 Full Case Pick SKUs Sub Totals 525,148 46.7% 998 175,049 998 189,124 932 466 - 2,461,250 64,559 50% C. Repack SKUs 5,655 Non Flow Through Repack SKUs Sub Totals 272,282 24.2% 518 90,761 518 98,471 485 243 - 1,872,884 55,672 38% Total Peak Storage Required: 4,941,905 134,750 Notes: 1 Data summarized from Exhibit 2-B of this report
Background image of page 2
2-B 3 file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls 02/17/2010 07:05:50 KEOGH Consulting Exhibit 2-B Peak Week SKU Analysis Base Year, week ending 8/28/09 and projected Design Year average week Shipment CuFt (1) Phoenix DC Department SKU Base Year Peak Week CuFt Design Year Peak Week CuFt Item Number Description CuFt / Store Dept. Number Avg. Weekly CuFt Avg. CuFt / Store Weekly CuFt (2) Avg. CuFt / Store Shipment (3) Fast SKU? (1 = Yes, 0 = No) (4) Design Year Peak. Inventory (CuFt) Design Year Storage Pallet Positions Req'd Avg. CuFt / Pallet I. Extremely Fast Moving Full Case Pick SKUs 1 3122 1 No Description Provided 6,491 37 6,780 33 16.70 1 6,372 147 43.44 2 3114 2 No Description Provided 6,428 37 6,794 33 16.73 1 2,719 56 48.64 3 3310 3 No Description Provided 5,707 33 6,128 30 15.09 1 10,895 251 43.44 4 3105 4 No Description Provided 4,523 26 4,909 24 12.09 1 8,398 185 45.33 5 3105 5 No Description Provided 4,182 24 4,531 22 11.16 1 4,742 107 44.15 6 3114 6 No Description Provided 3,804 22 4,057 20 9.99 1 20,840 460 45.33 7 3114 7
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}