Spreadsheet for waste pickup

Hi,

I can't seem to come up with a solution to this and I've been working on it for a while.

I work for a waste removal company and we are looking at changing out some of our old equipment and I am trying to design a spreadsheet that will allow me to enter the following variables:

-size of current container
-# of current containers
-new container size
-current pickups/week
-new pickups/week
-safety

So what I am trying to accomplish here is to have something where I can enter in the current container sizes/numbers/pickup frequency, then enter in various different new container sizes that we are looking at as well as different pickup rates a week, then determine how many containers will be needed of the new size (ex. currently we have 3 8 cubic yard containers at a site that we empty twice a week, so if we switch those out to 6 cubic yard containers how many will we need to empty them only once a week?)

I also seem to have problems getting the rounding correct, because if 20 cubic yards are generated in a week and i have a 25 cubic yard container obviously the container will only be 80% full at pickup yet I still need one container, not 0.8 of one. On the other side of that if I have 26 cubic yards of waste generated/week (26/25=1.04) I will need that number bumped up to 2, not rounded back down to 1.

In terms of the safety, it would also be a nice feature to be able to add say for summer events where I know there will be a 25% increase in traffic in the area (therefore more waste) I will be able to tell right away how many more containers to add.



I realize this is far more than just a simple question but any help would be very much appreciated. I am struggling for the most part in trying to come up with an equation that will take the garbage generated/week and tell me how many containers I will need (and round the answer correctly).


Thank you very much.

Dan