Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
runout - plant production scheduling tank inventory
a plant produces any 2 of 3 products (make1, make2, make3). Plant knows
how much to produce over a period of time of each product. normally product 1 is set to zero. product 2 can be stored in any of three tanks (tank1, tank2, tank3). product 3 can only be stored in tank4. Tanks have minimum volumes known as heels and maximum volumes. Liftings of products (2 & 3) need to be scheduled to maintain steady production without "runout" of room. Liftings have maximum volume/lifting. Lifting frequency should be minimized to save cost. If production is known say for three weeks ahead, how best to estimate when and how much to lift during this 21 day period? how to rotate filling of tanks1,2, & 3 with product 2? solver is one approach. counting number of lifts 0 with =COUNTIF(J9:J29,"0") , and using solver to minimize this cell still produces 21 daily lifts. How would you get solver to produce lifts every 3-4 days or so as tanks working capacity offer 4+ days of production before "runout" of room. Is there a better way to do this than solver? cheers, deano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Production/Inventory | New Users to Excel | |||
Clean Fish Tank | Excel Worksheet Functions | |||
runout - plant production scheduling tank inventory | Excel Programming | |||
Think Tank; I Need Your Help! | Excel Programming | |||
Fuel Tank Formula's For Dip sticks | Charts and Charting in Excel |