Spreadsheet: 119859d1314800070-sum-of-count-greater-than-x-formula-forecast-file
Sheet: 2012 Forecast Budget

 | Temp Staff Budget 2012
 | Average Hours Per Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | easter | easter | bank holiday |  |  |  | bank holiday
 | Week Commencing | Weeks Working | Over 12 Weeks? | Current Rate | 2012-01-30 00:00:00 | 2012-02-06 00:00:00 | 2012-02-13 00:00:00 | 2012-02-20 00:00:00 | 2012-02-27 00:00:00 | 2012-03-06 00:00:00 | 2012-03-13 00:00:00 | 2012-03-20 00:00:00 | 2012-03-27 00:00:00 | 2012-04-02 00:00:00 | 2012-04-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-11 00:00:00 | 2010-07-18 00:00:00 | 2010-07-25 00:00:00 | 2010-08-01 00:00:00 |  | Bonus Applicable Hours | Bonus Pay | TOTAL HOURS | TOTAL COST
 | Temp 1 |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 | Temp 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40
 | Temp 3 |  |  |  |  |  |  |  |  |  | 37.5 | 37.5 | 37.5 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 40 | 50 | 80 | 80
 | Temp 4 |  |  |  |  |  |  |  |  |  | 37.5 | 37.5 | 37.5 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 40
 | Temp 5 |  |  |  |  |  |  |  |  |  | 37.5 | 37.5 | 37.5 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 0
 | Temp 6 |  |  |  |  |  |  |  |  |  | 37.5 | 37.5 | 37.5 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 0
 | Temp 7 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 40
 | Temp 8 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 40
 | Temp 9 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 40
 | Temp 10 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 40
 | Temp 11
 | Temp 12 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 13 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 14 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 15 |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50
 | Temp 16
 | Temp 17 |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50
 | Temp 18 |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50
 | Temp 19 |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50
 | Temp 20 |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 21 |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 22 |  |  |  | 35 | 37.5 | 38 | 37.5 | 37.5 | 37.5 | 40 | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 50 | 50 | 50 | 50 | 50 | 80 | 80 |  | 37.5 | 37.5 | 37.5 | 37.5 | 37.5
 | Temp 23 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 24 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 25 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 28 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 50 | 50 | 80 | 80
 | Temp 29 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 50 | 50 | 80 | 80
 | Temp 30 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 45 | 50 | 50 | 80 | 80
 | Temp 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 34 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 35 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 36 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 50 | 50 | 80 | 80
 | Temp 37 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 50 | 50 | 40
 | Temp 38 |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50
 | Temp 39 |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50
 | Temp 40 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 50 | 50 | 50 | 80 | 80
 | Temp 41 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 50 | 50 | 50 | 80 | 80
 | Temp 42 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 50 | 50 | 50 | 80 | 80
 | Temp 43 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 45 | 45 | 50
 | Temp 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 40 | 45 | 45 | 50
 | Temp 45 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 46 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 47 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 80 | 80
 | Temp 49 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 45 | 40 | 50 | 50 | 80 | 80
 | Temp 50 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 45 | 40 | 50 | 50 | 80 | 80
 | Temp 51 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 45 | 40 | 50 | 50 | 80 | 80
 | Temp 52 |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 53
 | Temp 54 |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 40 | 32 | 32 | 40 | 40 | 40 | 40 | 50 | 50 | 80 | 80
 | Temp 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 40 | 40 | 40 | 40 | 40
 | Estimated Cost |  |  |  | 438.9150862068966 | 470.2661637931035 | 476.5363793103448 | 470.2661637931035 | 971.8834051724139 | 971.8834051724139 | 5392.385344827585 | 17431.19913793103 | 19437.66810344827 | 21569.54137931034 | 21569.54137931034 | 17255.63310344828 | 17664.56772899894 | 22256.27569573142 | 24528.48147311256 | 25155.50302483669 | 25290.45837574054 | 28864.48122056812 | 23507.91227783685 | 34616.17756342093 | 34635.27964453895 | 511.1682819383259 | 990.3885462555064 | 479.2202643171805 | 479.2202643171805 | 479.2202643171805 | 479.2202643171805
 | Telesales Staff
 | Telesales Staff 1 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Telesales Staff 2 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Telesales Staff 3 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Telesales Staff 4 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Telesales Staff 5 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Telesales Staff 6 |  |  |  |  |  |  | 32 | 40 | 40 | 40 | 40
 | Total  Hours
 | Rate |  |  |  | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 | 12.5 |  |  |  | 12.5
 | Estimated Cost
 | Temp Rates <=12 Weeks
 | [NAME]
 | HP Fee | 1.7
 | Total
 | Temp Rates >12 Weeks
 | [NAME] | 1.7
 | HP Fee
 | Total
 | Bonus Pay - Hours before Cannes | 0.57