v

You are to determine a distribution plan for a retailer that is adding direct-to-home service to their customers. A simplified dataset is provided on the attached spreadsheet. Each customer represents a neighborhood with one or more houses to deliver "bags" of product. The unit of demand is the "bag" and considered undifferentiated. Delivery cost is based on distance from the local fulfillment center and the number of stops in the neighborhood. A. Please build a model to determine the optimal shipping pattern. What is the overall plan cost? B. Suppose that you can transship available stock from one fulfillment center to another prior to shipment. What would you propose? What is the overall cost of your proposal? You are to determine a distribution plan for a retailer that is adding direct-to-home service to their customers. A simplified dataset is provided on the attached spreadsheet. Each customer represents a neighborhood with one or more houses to deliver "bags" of product. The unit of demand is the "bag" and considered undifferentiated. Delivery cost is based on distance from the local fulfillment center and the number of stops in the neighborhood. A. Please build a model to determine the optimal shipping pattern. What is the overall plan cost? B. Suppose that you can transship available stock from one fulfillment center to another prior to shipment. What would you propose? What is the overall cost of your proposal