Using the shipping data below that shows both outbound shipments of cans as well as inbound movements of empty cans.

1. Identify ONE example of a consolidation opportunity for multi-drop off of finished goods. Also identify the order(s) in the data that you would use for this multi-drop off opportunity.

OUTBOUND FULL CANS FROM THE NEW STAGING FACILITY Case Count Ship Date INBOUND EMPTY CANS BACK TO THE NEW STAGING FACILITY Case Available count PickUpDate 12 4/14 Dest. City Deliver by date Origin City Downtown Hardin Valley 15 4/13 4/15 Karns 13 4/12 Bearden 25 4/14 4/16 Hardin Valley 19 4/13 East Knox 10 4/12 4/14 The Strip 25 4/13 Farragut 30 4/14 4/16 Farragut 10 4/12 Bearden 50 4/12 4/14 Powell 8 4/14 Gay St 10 4/13 4/15 Gay St 20 4/12 Karns 80 4/13 4/15 Bearden 40 4/14 Bearden 80 4/12 4/14 East Knox 15 4/13 Powell 16 4/14 416 Bearden 6 4/14 The Strip 20 4/13 4/15 10. Let's also think about operations in the new Staging Facility. Describe some characteristics of how we would operate this facility, including: a) Who should own and operate the facility (98 or a 3rd party) b) Should the facility be a large storage facility, or more like a cross dock? Explain your answer. c) Briefly describe some thoughts about how you would store product in the facility and pick it to fill customer orders. OUTBOUND FULL CANS FROM THE NEW STAGING FACILITY Case Count Ship Date INBOUND EMPTY CANS BACK TO THE NEW STAGING FACILITY Case Available count PickUpDate 12 4/14 Dest. City Deliver by date Origin City Downtown Hardin Valley 15 4/13 4/15 Karns 13 4/12 Bearden 25 4/14 4/16 Hardin Valley 19 4/13 East Knox 10 4/12 4/14 The Strip 25 4/13 Farragut 30 4/14 4/16 Farragut 10 4/12 Bearden 50 4/12 4/14 Powell 8 4/14 Gay St 10 4/13 4/15 Gay St 20 4/12 Karns 80 4/13 4/15 Bearden 40 4/14 Bearden 80 4/12 4/14 East Knox 15 4/13 Powell 16 4/14 416 Bearden 6 4/14 The Strip 20 4/13 4/15 10. Let's also think about operations in the new Staging Facility. Describe some characteristics of how we would operate this facility, including: a) Who should own and operate the facility (98 or a 3rd party) b) Should the facility be a large storage facility, or more like a cross dock? Explain your answer. c) Briefly describe some thoughts about how you would store product in the facility and pick it to fill customer orders