Project1_Team5_Analysis

Project1_Team5_Analysis - Warehouse Capacity of 25000...

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

View Full Document Right Arrow Icon
Warehouse Capacity of 25000 square ft based on 50% utilization 4400000 units Forecasted Sales (All are displayed in Millions.) DS Increase Year DSi 12/31/2004 1.36 2009 1.20 12/31/2005 3.27 1.404 2010 3.50 12/31/2006 5.55 0.697 2011 5.94 12/31/2007 10 0.802 2012 10.70 12/31/2008 11.75 0.175 2013 12.58 12/31/2009 12.58 0.071 2014 13.46 Demand in 6 cities is about 80% of Dsi's overall US sales (All are displayed in Millions except for Distances.) Distances Cities Population Demand (%) Chicago Denver Los Angeles Miami Chicago 9.79 14.87 0 917 1744 1190 Denver 2.46 3.74 917 0 832 1725 Los Angeles 12.88 19.56 1744 832 0 2335 Miami 5.41 8.22 1190 1725 2335 0 New York City 18.82 28.59 714 1630 2451 1097 San Pedro - - 1754 845 21 2335 Seattle 3.31 5.03 1733 1017 960 2730 Total 52.67 14.87% 3.74% 19.56% 8.22% 28.59% 5.03% Demand Chicago Denver Los Angeles Miami New York City Seattle Year 1 0.178 0.045 0.235 0.099 0.343 0.060 Year 2 0.520 0.131 0.685 0.288 1.000 0.176 Year 3 0.883 0.222 1.162 0.488 1.698 0.299 Year 4 1.592 0.400 2.094 0.880 3.060 0.538 Year 5 1.870 0.470 2.460 1.033 3.595 0.632 Year 6 2.002 0.503 2.634 1.106 3.849 0.677 Cost of Dsi = $179
Background image of page 1

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

View Full DocumentRight Arrow Icon
Supply 1.50 4.00 6.15 11.00 13.00 13.80 New York City Seattle 714 1733 1630 1017 2451 960 1097 2730 0 2404 2460 981 2404 0
Background image of page 2
Distances Cities Chicago Denver Los Angeles Miami New York City Seattle Chicago 0 917 1744 1190 714 1733 Denver 917 0 832 1725 1630 1017 Los Angeles 1744 832 0 2335 2451 960 Miami 1190 1725 2335 0 1097 2730 New York City 714 1630 2451 1097 0 2404 San Pedro 1754 845 21 2335 2460 981 Seattle 1733 1017 960 2730 2404 0 TRUCK RAIL Year Price per ton-mile Price per unit-mile Price per ton-mile 1990 $24.40 $2.66 1991 $24.80 $2.59 1992 $23.10 $2.58 1993 $25.00 $2.52 1994 $25.00 $2.49 1995 $25.10 $2.40 1996 $26.00 $2.35 1997 $26.10 $2.40 1998 $26.20 $2.34 1999 $26.20 $2.28 2000 $27.00 $2.26 2001 $26.60 $2.24 2002 $2.26 2003 $2.28 2004 $2.35 2005 $2.62 2006 $2.84 2007 2008 2009 $29.04 $0.0174 $3.22 2010 $29.31 $0.0176 $3.37 2011 $29.58 $0.0177 $3.52 2012 $29.85 $0.0179 $3.67 2013 $30.12 $0.0181 $3.82 2014 $30.38 $0.0182 $3.97 Assuming 1 DSi package weighs 0.6 kg TRUCK COST TABLE Cost to transport 1 unit from City A to city B in year 2009 Cities Chicago Denver Los Angeles Miami New York City Seattle Chicago $0.00 $15.98 $30.39 $20.74 $12.44 $30.20 Denver $15.98 $0.00 $14.50 $30.06 $28.40 $17.72 Los Angeles $30.39 $14.50 $0.00 $40.69 $42.71 $16.73 Miami $20.74 $30.06 $40.69 $0.00 $19.12 $47.57
Background image of page 3

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

View Full DocumentRight Arrow Icon
New York City $12.44 $28.40 $42.71 $19.12 $0.00 $41.89 San Pedro $30.57 $14.73 $0.37 $40.69 $42.87 $17.10 Seattle $30.20 $17.72 $16.73 $47.57 $41.89 $0.00 Cost to transport 1 unit from City A to city B in year 2010 Cities Chicago Denver Los Angeles Miami New York City Seattle Chicago $0.00 $16.13 $30.67 $20.93 $12.56 $30.48 Denver $16.13 $0.00 $14.63 $30.34 $28.67 $17.89 Los Angeles $30.67 $14.63 $0.00 $41.07 $43.11 $16.88 Miami $20.93 $30.34 $41.07 $0.00 $19.29 $48.01 New York City $12.56 $28.67 $43.11 $19.29 $0.00 $42.28 San Pedro
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/30/2009 for the course PHYS 1234 taught by Professor Judge during the Fall '09 term at USC.

Page1 / 38

Project1_Team5_Analysis - Warehouse Capacity of 25000...

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

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