# I can't for the life of me figure this out!!!!

• Aug 4th 2009, 12:09 PM
uneakbreed
I can't for the life of me figure this out!!!!
Sorry for the vague subject header, but this problem is driving me crazy!!! (Angry). I'm trying to figure out the average volume distribution on a daily basis within a month as a percentage contribution. In other words, every Monday in August accounts for 5% of our volume for that month, every Tuesday accounts for 3.5%, every Saturday accounts for 1.5%, etc.

Here is the data that I have:

1)Days in month =31

2)Weeks in month =4.4

3)# of occurances for each day within month:
Mon, Sat, Sun = 5
Tue-Fri =4

4)% Contribution for each day within a normal week
Monday =21%
Tuesday =18%
Wednesday =17%
Thursday =16%
Friday =18%
Saturday =8%
Sunday =2%

5)Average Day contribution to week (day/days in week) =14.3%

6)Average Daily Contribution to month (day/days in month) =3.2%

How do i calculate the Daily contribution for each day over a month? Could anyone give me a hand?
• Aug 4th 2009, 02:21 PM
uneakbreed
I've gotten close
I thought i figured it out, but when i tried to check my work, i came up with 99.9376% instead of 100% when i summed every-days contribution.

I tried:

$x= AvgNumberOfWeekdaysMonth* \frac{AvgDayContributionToMonth}{AcutalNumberOfWee kdayInMonth}$

% Contribution of Individual Day to Month $= ActualContributionOfWeekdayToWeek *\frac{x}{AvgContributionOf WeekdayToWeek}
$

Any ideas? (Crying)
• Aug 4th 2009, 03:15 PM
uneakbreed
got it
looksl like i overcomplicated it. got it!