{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["I - FTES History","II - Alloc Illustration","III - Budget Model Net Alloc","v","x","-"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"I - FTES History","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"2005-2006 Actual","%","2006-2007 Actual","%","2007-2008 Actual","%","2008-2009 Actual","%","4 Year Average % of Total"]
[]
["SBVC",9531.7900000000009,{"$f":"B9/B11","v":0.71730695423793867},9415.1200000000008,{"$f":"D9/D11","v":0.68351809503067262},9857.02,{"$f":"F9/F11","v":0.69894311393168007},10727.72,{"$f":"H9/H11","v":0.70053638665811657},{"$f":"(I9+G9+E9+C9)/4","v":0.70007613746460196}]
["CHC",3756.51,{"$f":"B10/B11","v":0.28269304576206133},4359.38,{"$f":"D10/D11","v":0.31648190496932738},4245.7299999999996,{"$f":"F10/F11","v":0.30105688606831998},4585.8599999999997,{"$f":"H10/H11","v":0.29946361334188348},{"$f":"(I10+G10+E10+C10)/4","v":0.29992386253539804}]
["Total",{"$f":"SUM(B9:B10)","v":13288.300000000001},1,13774.5,1,14102.75,1,15313.579999999998,1,{"$f":"(I11+G11+E11+C11)/4","v":1}]

{"sheet":"II - Alloc Illustration","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Base Allocation Revenue per SB361 for Medium and Small Colleges",null,"State Funded FTES Credit","%","State Funded Rate Credit FTES","Credit Funding","State Funded FTES Noncredit","%","State Funded Rate Noncredit FTES","Noncredit Funding","Total State Base Revenue"]
[]
["SBVC",3875136,null,9636.51,{"$f":"D6/D8","v":0.70000014528084242},4564.8251,{"$f":"(D6*F6)","v":43988982.724401005},7.82,{"$f":"H6/H8","v":0.70008952551477177},2744.96,{"$f":"H6*J6","v":21465.587200000002},{"$f":"B6+G6+K6","v":47885584.311601005}]
["CHC",3321545,null,4129.93,{"$f":"D7/D8","v":0.29999985471915763},4564.8251,{"$f":"D7*F7","v":18852408.125243001},3.35,{"$f":"H7/H8","v":0.29991047448522828},2744.96,{"$f":"H7*J7","v":9195.616},{"$f":"K7+G7+B7","v":22183148.741243001}]
["Total",{"$f":"SUM(B6:B7)","v":7196681},null,{"$f":"SUM(D6:D7)","v":13766.44},null,null,{"$f":"SUM(G6:G7)","v":62841390.849644005},{"$f":"SUM(H6:H7)","v":11.17},null,null,{"$f":"SUM(K6:K7)","v":30661.203200000004},{"$f":"SUM(L6:L7)","v":70068733.052844003}]

{"sheet":"III - Budget Model Net Alloc","index":2,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"A","B","C",null,"D","E","F","G",null,"H","I","J","K","L"]
[null,"Total Base State Revenue             ","Growth","COLA                   -0.38%                   ","Total Base Revenue             ","Part-Time   Faculty            ","Lottery Funds       ","Interest Income      ","Other Campus Revenue       ","Total Income","Assessment for District Office        ","Assessment for District-Wide Costs","Assessment for Auxiliary Operations","Assessment for SERP","Assessment for District Reserve","Budget Allocation"]
[null,null,null,"  "]
["SBVC",47885584,0,-181965,{"$f":"SUM(B10:D10)","v":47703619},135092,987855,263746,446032,{"$f":"E10+F10+G10+H10+I10","v":49536344},-9136649,{"$f":"-1781331-(-1156931)","v":-624400},{"$f":"-152565+(-1156931)","v":-1309496},-876711,0,{"$f":"SUM(J10:O10)","v":37589088}]
[null,null,null,{"$f":"SUM(B11*0.38%)","v":0}]
["CHC",22183149,0,-84296,{"$f":"B12+C12+D12","v":22098853},57896,423367,113034,232054,{"$f":"E12+F12+G12+H12+I12","v":22925204},-3915706,{"$f":"-763427-(-495827)","v":-267600},{"$f":"-65385+(-495827)","v":-561212},-269238,0,{"$f":"SUM(J12:O12)","v":17911448}]
[]
["Total",{"$f":"SUM(B10:B12)","v":70068733},{"$f":"C12+C10","v":0},{"$f":"D12+D10","v":-266261},{"$f":"E12+E10","v":69802472},{"$f":"F10+F12","v":192988},{"$f":"G12+G10","v":1411222},376780,678086,72461548,-13052355,-892000,{"$f":"SUM(M10:M12)","v":-1870708},{"$f":"SUM(N10+N12)","v":-1145949},{"$f":"O12+O10","v":0},{"$f":"SUM(P10:P12)","v":55500536}]
[]
[]
[]
["A. FTES based computational revenue includes state apportionment, student fees (98%) property taxes.  From Worksheet II."]
["B. Growth will not be allocated until it is in the final budget.  This will avoid overbudgeting and overspending."]
["      Will assume even distribution for 2010-2011 since both colleges are over enrollment cap."]
["C. Based on Governor's Budget for 2010-2011 applied to Total Base State Revenue."]
["D. Based on 2009-2010 Advance Apportionment revised November 2009 adjusted by proposed Governor's cut of $120,000.  Allocated based on 4-year average percentage of FTES."]
["E. 90% of Actual income generated two fiscal years prior to budget year (i.e., for 2010-2011 budget use 90% of 2008-2009 "]
["    actual income) and allocated based on 4-year average percentage of FTES.  Adjustment to 100% of one year prior actual will be made in October of budget year."]
["F. 90% of Actual income generated two fiscal years prior to budget year (i.e., for 2010-2011 budget use 90% of 2008-2009 "]
["    actual income) and allocated based on 4-year average percentage of FTES.  Adjustment to 100% of one year prior actual will be made in October of budget year."]
["G. 90% of Actual income generated by each site two fiscal years prior to budget year (i.e., for 2010-2011 budget use 90% of 2008-2009 "]
["    actual income.  Adjustment to 100% of one year prior actual will be made in October of budget year."]
["H. Includes all District operations including HR, Fiscal, Police, DETS, PDC.  Allocated based on 4-year average percentage of FTES."]
["I. Includes transfer for Property/Liability Insurance ($550,000 and Retiree funds for GASB 45 compliance ($342,000).  Allocated based on 4-year average percentage of FTES."]
["J. Assessment for KVCR ($1,652,758) Auxilliary Services Accounting Staff -- bookstore, cafeteria, trust funds ($217,950).  Allocated based on 4-year average percentage of FTES."]
["K. Funding for 20% of retiree salary plus retiree benefits (five years) of 2009-2010 SERP. "]
["L.  Potential for funds to meet District reserve requirements."]
[]
["NOTES:"]
["Site budgets with life spans other than 00 and subprograms other than 0000 must submit a balanced budget."]

{"sheet":"v","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"x","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"-","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}