MHDC10_B_Design_Criteria_Data

MHDC10_B_Design_Criteria_Data - 1-A

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1-A 1file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls02/17/2010 07:05:50KEOGH ConsultingExhibit 1-ASummary of Total Shipments to Customer Stores from Regional DCs, by DC Type and SiteBase Year and projected Design Year All DC types and facilitiesBase Year Service Volumes Design Year Service Volumes Annual Shipments to Stores Annual Shipments to StoresAvg. DC to Store Shipment (2.a) IDNameCityStateCost $ CuFt Total Stores Serviced Total ShipmentsDC Shipment Value @ Cost $ Total Shipment Units (3) Total Shipment CuFt Avg. Store Shipment from DC, $ Total Stores Serviced Total ShipmentsDC Shipment Value @ Cost $ Total Shipment Units Total Shipment CuFt Equiv. Pallets / Shipment I.Phoenix Regional DCTotal Service Volume349 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 volumeb.Total Store receipt volume for Design Year estimated from Base Year volume and projected shipment volume for new storesc.Frequency of store deliveries remains unchanged through the Design Year3 Units = Retail selling units2-A 2file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls02/17/2010 07:05:50KEOGH ConsultingExhibit 2-ASummary - Peak Week SKU AnalysisBase Year, week ending 8/28/09 and projected Design Year average weekShipment CuFt (1)Typical Full Combo DCs and FDCsTotal Peak Week CuFt, All DCs Base Year Peak Week CuFt Design Year Peak Week CuFt Description% of TotalCuFt / Store Weekly Total CuFt Avg. CuFt / Store Avg. Weekly CuFt Avg. CuFt / Store Weekly CuFt (2) Avg. CuFt / Store ShipmentNo. 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 SKUsTop 60 Full Case Pick SKUs Sub Totals327,848 29.1%623 109,283 623 117,283 578 289 60 607,771 14,519 12%B. Other Full Case SKUsNext 2,768 Full Case Pick SKUs Sub Totals525,148 46.7%998 175,049 998 189,124 932 466 - 2,461,250 64,559 50%C. Repack SKUs5,655 Non Flow Through Repack SKUs Sub Totals272,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 report2-B 3file:////home/vdimitrov/10934/247073568bd60c05c286329f53b23c5861b69bf3.xls02/17/2010 07:05:50KEOGH ConsultingExhibit 2-BPeak Week SKU AnalysisBase Year, week ending 8/28/09 and projected Design Year average weekShipment CuFt (1)Phoenix DC DepartmentSKUBase Year Peak Week CuFt Design Year Peak Week CuFt Item NumberDescriptionCuFt / Store Dept....
View Full Document

This note was uploaded on 02/16/2010 for the course ISE 3214 at Virginia Tech.

Page1 / 15

MHDC10_B_Design_Criteria_Data - 1-A

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online