Hello,

Need help understanding this advanced question for my Junior Logistics class. The blue chart x's above show which numbers are used for each channel.

Question 1: Identify the cost of each activity and the total delivered cost PER UNIT for A, B, and C items for each proposed channel.

Let me know if you need any more info. Please provide detailed formula of how to solve.

Traditional BOPUS BODFS BODDC A Items X X C Items 40.00% 31.00% X X X 8x X X X X X X X X X X X X x X X X B Items 40.00% 40.00% 31.00% 31.00% 2.1x 2.75x 15 17 $95.00 $50.00 $121.00 $32.00 $0.35 $0.21 $0.50 $0.36 $0.12 $0.11 $0.90 $0.42 $0.64 $0.31 $1.14 $0.53 $0.12 $0.20 19.00% 12.00% 10.00% 5.00% 5.00% 4.00% $1.18 $0.95 18.20% 30.00% 6.00% 4.20% 4.70% 3.00% 6.00% 15.30% $0.07 $0.20 $0.32 $0.97 $0.30 $0.65 $0.17 $0.17 X X Annual ICC Store Annual ICC DC (BODDC only) Annual Turnover Average shipment weight (lbs) Average Unit Cost Average Unit Price Customer Service Online Customer Service Retail Store Operations DC Operations DC to Ship Direct to Customers process Operations Retail Store Packaging for LTL/Small Packaging shipments Packaging for TL shipments Return Rate for Items Fulfilled from DC Return Rate for Items Fulfilled from Retail Store Return Rate for Items Sold or Picked Up at Retail Store Returns Cost to process Sales Increase projected Additional Customer purchase when picking up an order Sales increase projected due to newe BODDC channel Sales increase projected due to new BODFS cahnnel Sales increase projected due to new BOPUS channel Shippig DC to Sotre TL [per pound] Shipping LTL/small package to DC to customer (maximum 225 miles) (per pound] Shipping LTL/small package to Retail to customer (maximum 25 miles) (per pound] System support/management for online ordering X 2 $10.00 $10.00 $0.13 $0.27 $0.08 $0.30 $0.10 $0.32 $0.06 6.70% 2.00% 1.00% $0.76 65.70% 0.50% 0.50% 25.00% $0.27 $3.71 $2.70 $0.17 X X X X IX IX IX X X x X X X X X Class A inventory turnover per year) 2.1 #SKUS Avg Cost Avg Price pre unit at store Inventory in all stores 1800 $ 95.00 $ 121.00 $ 3600 $ 50.00 $ 32.00 $ 12600 $ 10.00 $ 10.00 $ B 601,200.00 1,827,900.00 4,049,640.00 2.75 C 8 Traditional BOPUS BODFS BODDC A Items X X C Items 40.00% 31.00% X X X 8x X X X X X X X X X X X X x X X X B Items 40.00% 40.00% 31.00% 31.00% 2.1x 2.75x 15 17 $95.00 $50.00 $121.00 $32.00 $0.35 $0.21 $0.50 $0.36 $0.12 $0.11 $0.90 $0.42 $0.64 $0.31 $1.14 $0.53 $0.12 $0.20 19.00% 12.00% 10.00% 5.00% 5.00% 4.00% $1.18 $0.95 18.20% 30.00% 6.00% 4.20% 4.70% 3.00% 6.00% 15.30% $0.07 $0.20 $0.32 $0.97 $0.30 $0.65 $0.17 $0.17 X X Annual ICC Store Annual ICC DC (BODDC only) Annual Turnover Average shipment weight (lbs) Average Unit Cost Average Unit Price Customer Service Online Customer Service Retail Store Operations DC Operations DC to Ship Direct to Customers process Operations Retail Store Packaging for LTL/Small Packaging shipments Packaging for TL shipments Return Rate for Items Fulfilled from DC Return Rate for Items Fulfilled from Retail Store Return Rate for Items Sold or Picked Up at Retail Store Returns Cost to process Sales Increase projected Additional Customer purchase when picking up an order Sales increase projected due to newe BODDC channel Sales increase projected due to new BODFS cahnnel Sales increase projected due to new BOPUS channel Shippig DC to Sotre TL [per pound] Shipping LTL/small package to DC to customer (maximum 225 miles) (per pound] Shipping LTL/small package to Retail to customer (maximum 25 miles) (per pound] System support/management for online ordering X 2 $10.00 $10.00 $0.13 $0.27 $0.08 $0.30 $0.10 $0.32 $0.06 6.70% 2.00% 1.00% $0.76 65.70% 0.50% 0.50% 25.00% $0.27 $3.71 $2.70 $0.17 X X X X IX IX IX X X x X X X X X Class A inventory turnover per year) 2.1 #SKUS Avg Cost Avg Price pre unit at store Inventory in all stores 1800 $ 95.00 $ 121.00 $ 3600 $ 50.00 $ 32.00 $ 12600 $ 10.00 $ 10.00 $ B 601,200.00 1,827,900.00 4,049,640.00 2.75 C 8