How to perform supply and demand with orchards to distribution center

Discussion created by ALEEBCIT on Apr 4, 2013
Latest reply on Apr 5, 2013 by jsandhu-esristaff
Hi everyone,

I have been stuck on a problem. I searched through the ESRI forums, but couldn't find anything that helped me. If anyone could lend some guidance or point me in the right direction, it would be greatly appreciated.

Here is the problem, it gets a bit complex, but having certain components working would also be appreciated:

I have 100 different fruit orchard points which are supply
I have 5 different distribution centers which are demand
I  know the number of trucks and their capacity

What I want to get from this is:
- The route visualized
- The route (ie. The truck goes from this point to this point)
- I also want the number of times the truck can travel in a time frame, but its not necessary as I'm trying to do this one step at a time.
* The route would be the shortest distance

For a simple example, if I am given:
- Orchard A has 50 apples supply
- Orchard B has 50 apples supply
- Distribution Center has a demand of 100
- A truck that has a capacity of 10

I basically want the thing to spit out for the truck to go back and forth between Orchard A until it is depleted, and then go to orchard B until it is depleted. I assume it will tell me the time travelled in which I can figure out how many trips in a day it can make.

I have tried to be as detailed as possible, if anyone would like some clarification, it would be fantastic:D