Spreadsheet: 36907d1234876614-using-list-function-with-hiding-irrelevant-outputs-monthly-models-6-2-
Sheet: Staff Number Calculation

 | Select Time Period | Month by Month
Branch 26
Work Items | Transactions Received to be Processed | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
AAA
AAB
AAC
AAD
AAE
AAF
AAG
AAH
AAI
AAJ
AAK
AAL
AAM
AAN
AAO
AAP
AAQ
AAR
AAS
AAT
AAU
AAV
AAW
AAX
AAY
AAZ
AAZA
AAZB
AAZC
AAZD
AAZE
AAZF
AAZG
AAZH
AAZI
Period | Monthly Volume | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
Total Staff Required (Jan 2008) | 5003 | 1007.062236016666 | 2026.840039783333 | 1516.9511379 | 12.13145292596496 | 24.41608239461929 | 18.27376766029213
Total Staff Required (Feb 2008) | 3308 | 646.7940349666669 | 1309.131175558334 | 977.9626052625 | 7.791525793906544 | 15.77028972213021 | 11.78090775801837
Total Staff Required (Mar 2008) | 3608 | 643.3305297166669 | 1341.602118558333 | 992.4663241374999 | 7.749803098529342 | 16.16144699362546 | 11.9556250460774
Total Staff Required (Apr 2008) | 5134 | 1023.399064575 | 1977.138707733333 | 1500.268886154167 | 12.32825254720674 | 23.81736133393566 | 18.0728069405712
Total Staff Required (May 2008) | 7324 | 1404.649396516667 | 2702.710364741667 | 2053.679880629167 | 16.92093837092808 | 32.55787218481154 | 24.7394052778698
Total Staff Required (Jun 2008) | 7256 | 1662.134762433333 | 3034.201015033333 | 2348.167888733332 | 20.02270456176279 | 36.55113404647894 | 28.28691930412086
Total Staff Required (Jul 2008) | 6647 | 1501.202312783333 | 2733.925721774999 | 2117.564017279167 | 18.08405135110175 | 32.93390419244089 | 25.50897777177132
Total Staff Required (Aug 2008) | 6361 | 1107.279691675 | 2137.831274433333 | 1622.555483054167 | 13.33871033488932 | 25.75312482377152 | 19.54591757933043
Total Staff Required (Sep 2008) | 8353 | 1677.9045446 | 3489.497393700001 | 2583.70096915 | 20.21267332751091 | 42.03580657973198 | 31.12423995362145
Total Staff Required (Oct 2008) | 8890 | 2124.074663883333 | 3890.996426183333 | 3007.535545033333 | 25.58740748541886 | 46.87241591547458 | 36.22991170044672
Total Staff Required (Nov 2008) | 6366 | 1242.575090691667 | 2621.632679966666 | 1932.103885329166 | 14.96852992852482 | 31.58117970145058 | 23.2748548149877
Total Staff Required (Dec 2008) | 6165 | 1203.193069058333 | 2579.147911366668 | 1891.1704902125 | 14.49411918757215 | 31.0693920959695 | 22.78175564177081
 |  | 138.3541666666667
 |  | 0.6
 |  | 83.01249999999999
 |  | 1270.299949743056 | 29844.65482883334 | 22544.127112875 | 183.6301689133163 | 359.5200099844402 | 271.5750894488781
 |  | 1270.29994974306 | 2440.575402402778 | 1840.33194690625 | 15.30251407610969 | 29.40009519533538 | 22.16933530379461
For Calculation Purposes Only
Year | Number of Months
Month by Month | 1
First Quarter only | 3
Second Quarter only | 3
Third Quarter only | 3
Fourth Quarter only | 3
Annualized Year | 12