Sales needed per day calculator...

I have a question for the resident experts, and I'm really hoping one or more of you can help me out. I’ll say upfront that I haven't spent a ton of time trying to wrap my head around a solve, rather my thinking was to spare some frustration and turn to the minds of people who are far sharper than me in this regard and see what can be made of this?

So here's what I am after... I want to be able to create a visually simple way of showcasing the amount of sales that are needed on a per day basis in order to realize a monthly goal. Take the month of May for example, as is shown below, and a sales goal of $22. In my environment, there are 22 business days this month, as is also shown. Simple enough, right? A goal of $22 and 22 days to do it, but... It's not that simple. I performed a study using a 90-day period of sales to show what percent of my monthly goal is realized in the given weeks of the month. Think of it like this... Maybe in the first week my sales aren't as high as they are in the second, and maybe that's just because I'm coming off the crescendo of the week prior, but whatever the reason, there are inherent week over week differences within a given month that influence the percent of sales that are realized.

If possible, and for the purposes of simplicity, let's just say those peaks and valleys don't exist and I always sell 20% of my monthly goal in every 5-week month. Sounds easy again, right? I mean 20% * 5 weeks does = 100%, no? Okay, let's maybe muddy the water a little (or not) and say that on each 5 day week (assumes no holidays, closures, etc.) that I also sell 20% of my weekly goal. In other words, I sell 20% on M, T, W, TH, and F. Or... 100% of the 20% for that week is sold.

So...

I'd like a formula that allows that to add up. More specifically though, in real life it's just not that simple. Some weeks aren't 5 days either begin (for a given month) on a Wednesday (May as an example) and have holidays in them (Memorial Day), and what's more, as mentioned above there are differences in how much is sold on given days and given weeks.

Heck... If what I am shooting for works, and isn't already created and available on the web, maybe this is something that could benefit more than just my cause, and those who subscribe to these forums, but... Dare I say it? The WORLD. I'd do an evil laugh if I could. I'll spare you.

A picture is worth a thousand words, so visually, here's where I am (and where I'm not): (see attached)

Whatever you can do to help me here would be appreciated.

As a F.Y.I., the actual (average) percentages (replacing the 20's) that were used in the illustration are as follows:

22
20.5
20.5
20.5
18

18.2
21.2
20.2
21.2
19.2

Thank you!