Can you post an example workbook, with some sample results somewhere?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MeMe" wrote in message
...
Heya,

the MTD is comprised of daily reports that show each day's service levels,
or how well we are doing. The YTD is comprised of the monthly MTD service
levels. Does this make sense?

thanks,

"DCSwearingen" wrote:


I do a lot of Key Indicators requiring Daily, WTD, MTD, & YTD
percentages.

You have to be careful of averaging averages and percents. This would
be OK if all had equal weighting, but not if they are differing in
magnitude, particularly the magnitude of individual divisors.

Example, we have a seasonal production year in the food industry. The
month of July may only have 10 Million pound produced and have 1
Million pounds Held, a Held Rate of 10%, while the remaining months may
all have 30 Million pound produced an also have 1 Million pounds held in
each of the months, or 3.3% Held Rate for each of those months.

3.3% times 11 months = 36.7%; Add the 10% for July gives 46.7%.
Divide by 12 months gives a Year End (YTD after 12 Mos) percentage of
3.9%.

But, if I take the actual YTD pound held (12 Million) and divide by the
actual YTD production (340 Million), I get 3.5% Held Rate.

Can you explain what your MTD and YTD percents are calculated from?


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile:
http://www.excelforum.com/member.php...o&userid=21506
View this thread:
http://www.excelforum.com/showthread...hreadid=568776