Distribute Total

F

Fable

Greetings,

I’m trying to distribute from a monthly projected amount of let say
“Twinkies” by day. Based on last year performance which is represente
by % (percentages) by day of the week (Sun., Mon., Tue., Etc.). Is i
possible to input a total amount per month example 1,500 boxes o
Twinkies and according to the percentage of the day of the week i
would distribute it accordingly?

I kind of stumped with variables how many Mondays in a month etc, how
avoids get an incomplete result like in the case 1,498 or 1503 Twinki
boxes. Any help would be deeply appreciated
 
Top