Loading...
HomeMy Public PortalAboutLOT Projection Graphs Use 2 & 4Monthly Actual Percentage of the Total per Year Month October November December January February March April May June July August September Total Month October November December 1st Qtr January February March 2nd Qtr April May June 3rd Qtr July August September 4th Qtr Total FY05 0 0 0 9.99445743620734E-02 9.52789479012331E-02 6.44336234938601E-02 4.16279219405296E-02 5.21175317791161E-02 0.102488119098432 0.223135344695278 0.186801831940744 0.134172104788734 1 FY05 0 0 0 0 9.99445743620734E-02 9.52789479012331E-02 6.44336234938601E-02 0.259657145757167 4.16279219405296E-02 5.21175317791161E-02 0.102488119098432 0.196233572818077 0.223135344695278 0.186801831940744 0.134172104788734 0.544109281424756 2 FY06 5.52696712475013E-02 4.36453571471993E-02 0.071814822240493 6.67236938100846E-02 7.91684119806873E-02 5.85073787966049E-02 2.82422591112362E-02 4.64418477630824E-02 9.07662414489293E-02 0.184516766591944 0.170462061577699 0.104441488284539 1 FY06 5.52696712475013E-02 4.36453571471993E-02 0.071814822240493 0.170729850635194 6.67236938100846E-02 7.91684119806873E-02 5.85073787966049E-02 0.204399484587377 2.82422591112362E-02 4.64418477630824E-02 9.07662414489293E-02 0.165450348323248 0.184516766591944 0.170462061577699 0.104441488284539 0.459420316454182 1.54057968354582 FY07 6.02899222803488E-02 3.46990658072511E-02 7.74045267924618E-02 6.65864303154159E-02 8.16643480539582E-02 4.86526020259299E-02 2.86514750815549E-02 0.039972887839811 8.76040852908237E-02 0.193196032401181 0.188470768162803 9.28078559484598E-02 1 FY07 6.02899222803488E-02 3.46990658072511E-02 7.74045267924618E-02 0.172393514880062 6.65864303154159E-02 8.16643480539582E-02 4.86526020259299E-02 0.196903380395304 2.86514750815549E-02 0.039972887839811 8.76040852908237E-02 0.15622844821219 0.193196032401181 0.188470768162803 9.28078559484598E-02 0.474474656512445 1.52552534348756 FY08 5.40547747699903E-02 2.99218641849054E-02 8.34928165690189E-02 7.56215514293632E-02 0.10248172004634 8.07400172158257E-02 2.40975427936212E-02 3.51349191230873E-02 9.53612422338537E-02 0.176471589855737 0.154108043989731 8.85139177885251E-02 1 FY08 5.40547747699903E-02 2.99218641849054E-02 8.34928165690189E-02 0.167469455523915 7.56215514293632E-02 0.10248172004634 8.07400172158257E-02 0.258843288691529 2.40975427936212E-02 3.51349191230873E-02 9.53612422338537E-02 0.154593704150562 0.176471589855737 0.154108043989731 8.85139177885251E-02 0.419093551633994 1.58090644836601 FY09 4.89445146346599E-02 3.09402048630737E-02 7.02382547987942E-02 7.76319945473285E-02 0.107476574015582 6.91338411964846E-02 2.57760723171637E-02 3.72076687197305E-02 0.09631680596192 0.183591455541887 0.140610064376434 0.112 0.999867450973058 FY09 4.89445146346599E-02 3.09402048630737E-02 7.02382547987942E-02 0.150122974296528 7.76319945473285E-02 0.107476574015582 6.91338411964846E-02 0.254242409759395 2.57760723171637E-02 3.72076687197305E-02 0.09631680596192 0.159300546998814 0.183591455541887 0.140610064376434 0.111803056183573 0.436004576101894 1.56333643821137 FY10 4.79036802186329E-02 2.67294640481016E-02 6.53139741126445E-02 7.77130618260938E-02 8.62397022310736E-02 0.040782564637966 2.82530641071758E-02 3.35170993411183E-02 9.82025878582103E-02 0.22274819926128 0.180028177210822 9.25684251468812E-02 1 Total averages 5.32925126302266E-02 3.31871912101062E-02 7.36528789026825E-02 7.28553463856572E-02 9.14061512655283E-02 5.95632807745622E-02 2.70040826821503E-02 3.84548845573659E-02 9.36501925587474E-02 0.192104808730406 0.166735823063498 9.80663374336809E-02 0.999973490194611 Quarter averages 0.165178948833924 0.228597140858401 0.158893261921203 0.447248275175629 0.999917626789158 1st Quarter Total 7.73702177150599E-02 9.20516173714791E-02 6.03750045611119E-02 2nd Quarter Total 2.94413892252135E-02 4.07319924276576E-02 9.51231803153614E-02 3rd Quarter Total 0.197276564724551 4th Quarter Total FY11 Budget dollars 9561 6090 13254 28905 12537 16222 11245 40004 4671 6946 16190 27807 32278 28597 17408 78283 174999 175000 185417.0899 155710.6089 FY11 actual and forecast based on trend 11520 5173 15459 32152 17510 19921 11126 48557 6210 8074 20505 34789 49798 39957 23499 113254 228752 224245 30627 35595 Percentage +/- based on budget 0.204894885472231 -0.150574712643678 0.166364870982345 0.112333506313787 0.396665869027678 0.228023671557145 -1.05824811027123E-02 0.213803619638036 0.329479768786127 0.162395623380363 0.266522544780729 0.251087855575934 0.54278455914245 0.397244466202749 0.349896599264706 49245 Year to date totals Actual total 11520 16693 32152 49662 69583 80709 86919 94993 115498 165296 1.2814 Budget total 9561 15651 28905 41442 57664 68909 73580 80526 96716 128994 total +/- YTD 0.204894885472231 6.65772155133857E-02 0.112333506313787 0.198349500506732 0.206697419533851 0.171240331451625 0.181285675455287 0.179656260089909 0.19419744406303 0.281423942198862 216165.450481425 155873.390045275 209889.962623538 226314.472378585 216411.189383102 184281.559577163 210927.546675745 198222.564593173 215562.599274119 252427.347716292 Month October November December January February March April May June July August September Total Difference compared to prior year October November December January February March April May June July August September Actual Dollars Earned per Month FY06 14274.11 11271.98 18547.11 17232.26 20446.27 15110.29 7293.93 11994.21 23441.56 47653.85 44024.04 26973.37 258262.98 Average 13482.676 8398.936 18614.454 18208.176 22882.462 15040.072 6781.056 9704.324 23443.594 48027.358 41987.886 24546.044 FY07 16937.65 9748.24 21745.77 18706.57 22942.51 13668.3 8049.25 11229.85 24611.2 54275.85 52948.35 26073.13 280936.67 22673.69 Budget 9561 6090 13254 12537 16222 11245 4671 6946 16190 32278 28597 17408 FY08 14412.45 7977.97 22261.42 20162.73 27324.37 21527.45 6425.05 9367.91 25425.86 47052.05 41089.33 23600.18 266626.77 -14309.9 FY11 Actual 11520 5173 15459 17510 19921 11126 6210 8074 20505 49798 44505 FY09 11305.76 7146.92 16224.43 17932.32 24826.16 15969.32 5954.05 8594.65 22248.35 42408.04 32479.71 25825.54 230991.36 -35635.41 Forecast 11520 5173 15459 17510 19921 11126 6210 8074 20505 49798 44505 23499 FY10 10483.41 5849.57 14293.54 17007 18873 8925 6183 7335 21491 48747 39398 20258 218843.52 -12147.84 Averages 13482.676 8398.936 18614.454 18208.176 22882.462 15040.072 6781.056 9704.324 23443.594 48027.358 41987.886 24546.044 251117.038 Actual FY11 11520 5173 15459 17510 19921 11126 6210 8074 20505 49798 44505 209801 Forecast 23499 23499 Month Total Month October November December January February March April May June July August September Total FY06 258262.98 FY05 0 0 0 9.99445743620734E-02 9.52789479012331E-02 6.44336234938601E-02 4.16279219405296E-02 5.21175317791161E-02 0.102488119098432 0.223135344695278 0.186801831940744 0.134172104788734 1 FY07 280936.67 FY06 5.52696712475013E-02 4.36453571471993E-02 0.071814822240493 6.67236938100846E-02 7.91684119806873E-02 5.85073787966049E-02 2.82422591112362E-02 4.64418477630824E-02 9.07662414489293E-02 0.184516766591944 0.170462061577699 0.104441488284539 1 FY08 266626.77 FY07 6.02899222803488E-02 3.46990658072511E-02 7.74045267924618E-02 6.65864303154159E-02 8.16643480539582E-02 4.86526020259299E-02 2.86514750815549E-02 0.039972887839811 8.76040852908237E-02 0.193196032401181 0.188470768162803 9.28078559484598E-02 1 FY09 230991.36 FY08 5.40547747699903E-02 2.99218641849054E-02 8.34928165690189E-02 7.56215514293632E-02 0.10248172004634 8.07400172158257E-02 2.40975427936212E-02 3.51349191230873E-02 9.53612422338537E-02 0.176471589855737 0.154108043989731 8.85139177885251E-02 1 Averages 259185.4175 FY09 4.89445146346599E-02 3.09402048630737E-02 7.02382547987942E-02 7.76319945473285E-02 0.107476574015582 6.91338411964846E-02 2.57760723171637E-02 3.72076687197305E-02 0.09631680596192 0.183591455541887 0.140610064376434 0.112 0.999867450973058 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY10 4.79036802186329E-02 2.67294640481016E-02 6.53139741126445E-02 7.77130618260938E-02 8.62397022310736E-02 0.040782564637966 2.82530641071758E-02 3.35170993411183E-02 9.82025878582103E-02 0.22274819926128 0.180028177210822 9.25684251468812E-02 1 0.0524 0.0235 0.0703 0.0796 0.0906 0.0506 0.0282 0.0394 0.0958 0.1965 0.1705 0.1003 175000 175000 175000 175000 175000 175000 175000 175000 175000 175000 175000 175000 Total averages 5.31437605251889E-02 3.15726593417552E-02 7.30940657522354E-02 7.76887580414799E-02 9.18442434612678E-02 5.89785753380959E-02 2.92640479073259E-02 4.05417077951351E-02 9.52198688417384E-02 0.197165626906758 0.170140135322605 0.10354339885102 0.999973490194611 FY11 Projection 5.46397207331251E-02 3.48016230006074E-02 0.075737605100192 7.16409175255481E-02 0.092697763524142 6.42584598087113E-02 0.026691837325894 3.96893308614278E-02 9.25120937338817E-02 0.184443961097687 0.163412734526667 9.94408155053809E-02 0.999966862743264 1st Quarter Total 7.73702177150599E-02 9.20516173714791E-02 6.03750045611119E-02 2nd Quarter Total 3rd Quarter Total 4th Quarter Total 9561.9511 6090.284 13254.0809 28906.316 12537.1606 16222.1086 11245.2305 40004.4997 4671.0715 6945.6329 16189.6164 27806.3208 32277.6932 28597.2285 17402.1427 174994.201 FY11 Budget dollars 9561 6090 13254 28905 12537 16222 11245 40004 4671 6946 16190 27807 32278 28597 17408 78283 174999 175000 28906 41443.1606 FY11 actual and forecast based on trend 11520 5173 15459 32152 17510 19921 11126 48557 6210 8074 20165 33519.7523295213 39713.346846815 34468.8798623592 20273.0087718213 94455.2354809955 208683.987810517 206727.5 FY 12 Projection 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 227500 Percentage +/- based on budget 0.204894885472231 -0.150574712643678 0.166364870982345 0.112333506313787 0.396665869027678 0.228023671557145 -1.05824811027123E-02 0.213803619638036 0.329479768786127 0.144497861694912 0.19580421137668 0.205442957871087 0.230353393853864 0.205332023021969 0.164580007572454 31727.5 0.0524 0.0245 0.0703 0.0796 0.0906 0.0506 0.0279 0.0394 0.0958 0.1966 0.171 0.1013 1 Actual total 11520 16693 32152 49662 69583 80709 86919 1.1813 11921 5573.75 15993.25 18109 20611.5 11511.5 6347.25 8963.5 21794.5 44726.5 38902.5 23045.75 227500 Budget total 9561 15651 28905 41442 57664 68909 73580 33488 50232 37105.25 106674.75 total +/- YTD 0.204894885472231 6.65772155133857E-02 0.112333506313787 0.198349500506732 0.206697419533851 0.171240331451625 0.181285675455287 11520 5173 15459 32152 17510 19921 11126 48557 6210 8074 20165 34449 11520 5173 15459 17510 19921 11126 6210 8663 21083 43222 37507 22073 219467 0.0524 0.0235 0.0703 0.0796 0.0906 0.0506 0.0282 0.0394 0.0958 0.1965 0.1705 0.1003 0.9977