630

profilepradeep.gali4
630.xlsx
Home>Business & Finance homework help>Operations Management homework help>630

Sheet1

Decentralized Distribution System
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
Atlanta 33 45 37 38 55 30 18 58 47 37 23 55 39.6666666667 12.7588353225 36.0874359065 115.4207692398 593.498104462 332.8 370.9363152888 416.0456101718 991.6666666667 1778.65
Boston 26 35 41 40 46 48 55 18 62 44 30 45
Chicago 44 34 22 55 48 72 62 28 27 95 35 45
Dallas 27 42 35 40 51 64 70 65 55 43 38 47
LA 32 43 54 40 46 74 40 35 45 38 48 56
Total
Centralized Distribution System (Cental Warehouse is in Atlanta)
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
Atlanta 162 199 189 213
Centralized Distribution System (Central Warehouse is in Boston)
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
Boston
Centralized Distribution System (Central Warehouse is in Chicago)
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
Chicago
Centralized Distribution System (Central Warehouse is in Dallas)
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
Dallas
Centralized Distribution System (Central Warehouse is in LA)
AVG STD SS RL OQ Avg Level OC HC TC Total Cost
LA