Hola como estas, esto es una prueba
Enviado por caycla • 9 de Septiembre de 2014 • Informe • 739 Palabras (3 Páginas) • 223 Visitas
Hola como estas, esto es una prueba
9
VII.
APPENDIX
Table 1: Calculating Transportation Costs for 8 Warehouses Option Griffin Erlenmeyer Comments
Total Demand 65,04 19,56 Calculated by 20% increaseFill Rate 0,01 0,01 If there is no policy change about it.Bulk Shipment Rate 0,4 0,4
Inter-Warehouse Transportations (If stockout occurs)
Total Biweekly Costs 0,0325 0,0196Fill Rate x Total Demand x CostRate x WeightTotal Biweekly Cost for 8 w/h 0,2601 0,156Total Annually Costs (1) 6,7641 4,068
From Waltham to Warehouses
Total Amount to Carry 455,28 136,92 To seven other warehousesTotal Biweekly Cost 22,764 13,692Total Amount to Carry * Weight *Bulk RateTotal Annually Costs (2) 591,864 355,992
From Warehouses to Customers (Average 19,5 pounds shipments by Winged Fleet)
Total Amount to Carry 520,32 156,48Total Biweekly Cost 92,123 55,41Fixed Cost + Total Demand x CostRate x WeightTotal Annually Costs (3) 2395,20 1440,66Total Annual Costs (1+2+3) 2993,83 1800,72Relative Weight in Sales 75,49% 24,51%Related Sales Revenue / TotalSales Revenue from both
Average Annual Cost 2701,4
Table 2: Calculating Transportation Costs for 1 Centralized Warehouse OptionGriffin Erlenmeyer Comments
Total Demand (Biweekly) 520,08 156,36Demand for one w/h region 65,01 19,545 Calculated by dividing total demand by 8Demand for Central Region 130,02 39,09 To Toronto and ChicagoDemand for West Region 195,03 58,63 To Seattle, Denver and PhoenixDemand for East Region 130,02 39,09 To Atlanta and MassachusettsTotal Costs for Within Region 154,99 46,60 For East RegionTotal Costs for Across 1 Region 160,825 48,35 For Central RegionTotal Costs for Across 2 Region 246,234 74,03 For West RegionTotal Biweekly Cost 562,05 168,979Total Annual Cost 14613,38 4393,46Relative Weight in Sales 75,50% 24,50%Related Sales Revenue / Total SalesRevenue from both
Average Annual Cost 12109,16
10
Table 3: Calculating Transportation Costs for 2 Centralized Warehouses Option
Griffin Erlenmeyer Comments
Total Demand (Biweekly) 520,08 156,36 Calculated by considering 20% increaseDemand for one w/h region 65,01 19,545 Calculated by dividing total demand by 8Demand for Central Region 130,02 39,09 To Toronto and ChicagoDemand for West Region 195,03 58,635 To Seattle, Denver and PhoenixDemand for East Region 130,02 39,09 To Atlanta and MassachusettsPhoenix's Delivery Costs (1) 48,957 29,438[ (Demand of West * Weight) ]* (5 x 1/ 19,5 +1.16 ) + [Demand of Central * 0,5 * Weight]*(12 x 1/ 19,5 + 1.16)Waltham's Delivery Costs (2) 37,447 22,516[ (Demand of East * Weight) ]* (5 x 1/ 19,5 +1.16 ) + [Demand of Central * 0,5 * Weight]*(12 x 1/ 19,5 + 1.16)From Waltham to PhoenixTotal Amount to Carry 260,04 78,18 West's Demand + Half of Central's
...