I'm suffering from number blindness, or confidence in the figures I'm producing and need some help, please.
I'm looking to calculate some averages for waste collection figures.
What I have;
Weight collected in a day for entire year - 1,967,660 Kg (w)
Number of properties collected from in that day - 6222 (pd)
Number of properties within a collection route, within that day - there are 6 routes of which the route I'm using has 1208 properties (pr)
Route size as % of day - 6222 / 1208 (rp)
Number of collection visits across the year. - 26 No. (v)
For example purposes, let's use Monday.
Deal with the easy stuff first.
Average collection weight for a Monday property is; w / (pd*v)
I'm doubting myself when it comes to the route figures, do I use....
(w*rp) / (pr*26)
or
((w/26)*rp) / pr
or is there another way?
I'm looking to calculate some averages for waste collection figures.
What I have;
Weight collected in a day for entire year - 1,967,660 Kg (w)
Number of properties collected from in that day - 6222 (pd)
Number of properties within a collection route, within that day - there are 6 routes of which the route I'm using has 1208 properties (pr)
Route size as % of day - 6222 / 1208 (rp)
Number of collection visits across the year. - 26 No. (v)
For example purposes, let's use Monday.
Deal with the easy stuff first.
Average collection weight for a Monday property is; w / (pd*v)
I'm doubting myself when it comes to the route figures, do I use....
(w*rp) / (pr*26)
or
((w/26)*rp) / pr
or is there another way?