is this correct and how did they get holding cost and order cost?

data used from here

Location Q Ddlt SS Ord Cost Tot Cost avg Inv Inv Cost 78 15 93 61 12 73 Atlanta 39.0 Boston 30.5 Chicago 39,5 Dallas 34.5 Los Angeles 37.5 78 13 91 111.6 74366035717436603683 87.6 74366035717436603659 91 2607428571 2607428662 110 2085942857 2085942967 111.25 2085942857 2085942968 21652521940 69 19 88 75 14 89 total cost of the distribution system Week 58 Wees 47 Week 37 Table 1: Historical Demand for 12 weeks Wella Weeks Web Weeks Week Weeb? Atlanta 33 45 37 38 55 30 18 Boston 26 35 49 40 46 48 55 44 34 Chic 22 55 72 62 Das 27 42 35 40 51 64 70 LA 43 40 74 Week 12 55 45 62 44 We11 23 30 35 38 18 28 27 45 95 43 55 47 65 35 38 56 Transportation, Ordering, and Holding Costs Currently with inbound transportation there is fixed ordering cost per order plus a variable transportation cost associated with it. For outbound transportation (regional warehouse to retailer) orders, which are typically much smaller in quantity, there is only variable transportation cost Table 2 provides inbound and outbound transportation cost associated with current distribution system. Table 3 provides information about (outbound) transportation costs per unit product from each existing regional warehouse to all other market areas, assuming this regional warehouse becomes the central warehouse as described in figure 1b. In case if KLF decides to add central warehouse to serve Atlanta, Boston, Chicago and Dallas regional warehouses, 3PL provider has agreed to provide similar cost model, Le floved ordering cost per order and variable transportation cost per unit ordered. Transportation cost quoted by 3PL from manufacturing facility to new warehouse for Los Angles) is $10 and from new warehouse to other four regional warehouse is $6. Table 4 provides ordering cost per order associated with current, single centralized warehouse and mix model distribution system. Corresponding holding cost is also given Table 2: Inbound and Outbound Transportation Costs per Unit with Current System Warehouse Inbound Outbound Atlanta $12.00 $13.00 Boston $11.50 $13.00 Chicago $11.00 $13.00 Dallas $9.00 $13.00 Los Angles 57.00 $13.00 Table 3: Outbound Transportation Costs per Unit in Single Centralized System Warehouse Atlanta Boston Chicago Dallas Los Angles Atlanta $13 Boston $16 $13 Chicago $16 $10 $13 Dallas $17 $17 517 $13 Los Angles $19 $19 $18 $10 $13 Table 4: Ordering Cost and Holding Cost (per unit per week) Cost at Ordering Cost Current System (figure la) Regional Warehouse $5550 Central Warehouse (Figure 1b) Central Warehouse $5550 Mix Model (Figure 1) Central Warehouse $3000 Regional Warehouse $3000 Holding Cost $1.25 $1.25 $1.00 $1.25 Location Q Ddlt SS Ord Cost Tot Cost avg Inv Inv Cost 78 15 93 61 12 73 Atlanta 39.0 Boston 30.5 Chicago 39,5 Dallas 34.5 Los Angeles 37.5 78 13 91 111.6 74366035717436603683 87.6 74366035717436603659 91 2607428571 2607428662 110 2085942857 2085942967 111.25 2085942857 2085942968 21652521940 69 19 88 75 14 89 total cost of the distribution system Week 58 Wees 47 Week 37 Table 1: Historical Demand for 12 weeks Wella Weeks Web Weeks Week Weeb? Atlanta 33 45 37 38 55 30 18 Boston 26 35 49 40 46 48 55 44 34 Chic 22 55 72 62 Das 27 42 35 40 51 64 70 LA 43 40 74 Week 12 55 45 62 44 We11 23 30 35 38 18 28 27 45 95 43 55 47 65 35 38 56 Transportation, Ordering, and Holding Costs Currently with inbound transportation there is fixed ordering cost per order plus a variable transportation cost associated with it. For outbound transportation (regional warehouse to retailer) orders, which are typically much smaller in quantity, there is only variable transportation cost Table 2 provides inbound and outbound transportation cost associated with current distribution system. Table 3 provides information about (outbound) transportation costs per unit product from each existing regional warehouse to all other market areas, assuming this regional warehouse becomes the central warehouse as described in figure 1b. In case if KLF decides to add central warehouse to serve Atlanta, Boston, Chicago and Dallas regional warehouses, 3PL provider has agreed to provide similar cost model, Le floved ordering cost per order and variable transportation cost per unit ordered. Transportation cost quoted by 3PL from manufacturing facility to new warehouse for Los Angles) is $10 and from new warehouse to other four regional warehouse is $6. Table 4 provides ordering cost per order associated with current, single centralized warehouse and mix model distribution system. Corresponding holding cost is also given Table 2: Inbound and Outbound Transportation Costs per Unit with Current System Warehouse Inbound Outbound Atlanta $12.00 $13.00 Boston $11.50 $13.00 Chicago $11.00 $13.00 Dallas $9.00 $13.00 Los Angles 57.00 $13.00 Table 3: Outbound Transportation Costs per Unit in Single Centralized System Warehouse Atlanta Boston Chicago Dallas Los Angles Atlanta $13 Boston $16 $13 Chicago $16 $10 $13 Dallas $17 $17 517 $13 Los Angles $19 $19 $18 $10 $13 Table 4: Ordering Cost and Holding Cost (per unit per week) Cost at Ordering Cost Current System (figure la) Regional Warehouse $5550 Central Warehouse (Figure 1b) Central Warehouse $5550 Mix Model (Figure 1) Central Warehouse $3000 Regional Warehouse $3000 Holding Cost $1.25 $1.25 $1.00 $1.25