Customer to Distribution Center Mapping
I need to map specific customers to local DCs in a region. Rather than a 1-to-1 relationship, each customer could be serviced by multiple DCs.
A) I've created a Customer Forecast module that contains customer demand data by customer, product, week.
I need a mapping module that allows the end-user to make local DC selections (using a Boolean) by customer.
C) I've created a Local DC Forecast module that should bucket demand by specific customers into their assigned local DCs dimensioned by local DC, product, week.
NOTE: if a customer is serviced by two local DCs, I'd like the demand from that customer to be a simple proportion of 50/50% into each local DC. My issues is getting from point A to C. The current mapping module I've created (by local DC, customer) doesn't do the trick. I am unable to SUM or LOOKUP using it.
Thoughts on how to accomplish this?