ࡱ> nm !1\pMatthew C. Lee Ba==8Je8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Calibri1Calibri1 Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *     P  P        `            a>  (   "0         $     $      #  ( "  @  (   ( *           (@@  @  ,@  (@  , @  *  @  @  @   @@  (  "4  "  "T  , "0 )  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text 0Good1 Heading 12 Heading 23 Heading 34 Heading 4 5Input6 Linked Cell 7Neutral 8Note 9Output: ;Title <Total= Warning Text`KSheet1ѵSheet21Sheet3T4CHC Long Range Financial Plan Worksheet 4-12-10.xlsSheet1Sheet2Sheet3YZ Z Z UPq|/Z 2AZ dWIAZ 333#IAZ dWIAZ %{]JAZ dWIAZ ,yJAZ  WŤqAZ  I,rAZ WŤqAZ qBSsAZ  WŤqAZ  RLD]sAZ  +@Z  qdk@Z +@Z <@Z  +@Z  G΁@Z  Z  ȴ{ AZ Z ӦR AZ  Z  ܙT'z AZ  فZ Ρ+Z Z ӦRAZ Z ܙT'zAZ E@Z E@Z E@Z E@Z E@Z E@Z AZ AZ AZ AZ AZ AZ @Z @Z @Z @Z @Z @Z XDAZ XDAZ XDAZ XDAZ XDAZ XDAZ MAZ MAZ ˔RNAZ QOAZ o_NAZ 'PAZ @UAZ @UAZ AZ AZ p= נAZ > ףpAZ x !AZ x !AZ (\:@Z (4QdZ (#d5AZ -Z -{Gz?Z -Z -{Gz?Z -Z -{Gz?Z .Z .{Gz?Z .Z .{Gz?Z .Z .{Gz?Z /Z /{Gz?Z /Z /{Gz?Z /Z /{Gz?Z 0Z 0{Gz?Z 0Z 0{Gz?Z 0Z 0{Gz?Z 1ŏ1w-!oZ 1ŏ1w-!oZ 1Z 1{Gz?Z 1Z 1{Gz?Z 2Z 2Z 2Z 2Z 2Z 2Z 3Z 3Z 3Z 3Z 3Z 3Z 4Z 4Z 4Z 4Z 4Z 4Z 5Z 5Z 5Z 5Z 5Z 5Z 6Z 6Z 6Q?Z 6{Gz?Z 6Q?Z 6{Gz?Z 7Z 7Z 7Q?Z 7{Gz?Z 7Q?Z 7{Gz?Z 8Z 8Z 8Q?Z 8{Gz?Z 8Q?Z 8{Gz?Z 9Z 9Z 9Z 9Z 9Z 9Z :Z :Z :Z :Z :Z :Z;IncludedZ;IncludedZ ;Q?Z ;Q?Z ;Q?Z ;Q?Z<IncludedZ<IncludedZ=IncludedZ=IncludedZ>IncludedZ>IncludedZ?IncludedZ?Includedj _FBeginning Fund BalanceRevenues ExpendituresAcademic SalariesClassified SalariesBenefitsSuppliesContracts and ServicesCapital OutlayTotal ExpendituresOperating Surplus/(Deficit)Ending Fund Balance Scenario A Scenario B2010-112009-102011-122012-13Step and Column Increases"Cost of Living Adjustment (COLA %))CHC/SBVC FTES Split 70/30 through 2012-13Other AssumptionsBenefits IncreasesSupplies Increases Contracts and Services IncreasesCapital Outlay IncreasesBudget/Academic Salaries Increases (Step& Column+COLA)2Classified Salaries Increases (Step & Column+COLA)Constrained Growth (%)Other OutgoingBase Funding Rate Increase*Base Funding Increase (Per Noncredit FTES)Part-time Faculty IncreaseLottery Funds IncreaseInterest Income IncreaseOther Campus Revenue Increase'Base Funding Increase (Per Credit FTES)Expenditure AssumptionsRevenue Assumptions+Revenue, Expenditure, and Other Assumptions(District-wide Costs Assessment Increase)Auxiliary Operations Assessment IncreaseSERP Costs Assessment Increase%District Reserves Assessment IncreaseMAll 2009-10 SERP and Position Vacancies Abolished for 2010-11 through 2012-13ABase Funding Rate: Total FTES <=10,000 for Multi-College DistrictTotal Credit FTES FundingGrowth Cost of Living Adjustment (COLA)Part-time Faculty Lottery FundsInterest IncomeOther Campus RevenueTotal RevenuesDistrict-wide CostsAuxiliary OperationsSERPDistrict ReserveLess AssessmentsTotal Campus BudgetTotal Noncredit FTES FundingN/A N/A: change in allocation model District Office Services,District Office Services Assessment IncreaseNotesScenario A: illustrates a "conservative" projection of revenues, assessments, and expenditures. Line items resulting from State allocations such as FTES Credit and Noncredit Funding rates, Growth allocations, COLA, PT Faculty, Lottery Funds are assumed with 0% increases. Other line items such as Interest Income, and Other Campus Revenues are also assumed with 0% increases. This scenario assumes marginal increases in District assessments and college expenditures. Scenario B: illustrates an "optimistic" projection of revenues, assessments, and expenditures. Line items resulting from all allocations including FTES Credit and Noncredit Funding rates, Growth allocations, COLA, PT Faculty, Lottery Funds, Interest Income, and Other Campus Revenues are assumed with varying percent increases based on historical trends. This scenario assumes moderate increases in District assessments and college expenditures. Scenarios A and B represent a range of scenarios from conservative to optimistic. The forecast does not account for yearly budget interventions, significant changes in college services, or other District/College changes.J$ G%% &'{()J*<+||nAL}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}A}0 a00_)[$ -}A}1 00_)[$ -}A}2 00_)?[$ -}A}3 00_)23[$ -}-}4 00_)}}5 ??v00_)̙[$ -##0.  }A}6 }00_)[$ -}A}7 e00_)[$ -}x}800_)[$##  }}9 ???00_)[$???## ???  ??? ???}-}; 00_)}U}< 00_)[$## }-}= 00_)M 20% - Accent1 ef %M" 20% - Accent2 ef %M& 20% - Accent3 ef %M* 20% - Accent4 ef %M. 20% - Accent5 ef %M2 20% - Accent6  ef %M 40% - Accent1 L %M# 40% - Accent2 L湸 %M' 40% - Accent3 L %M+ 40% - Accent4 L %M/ 40% - Accent5 L %M3 40% - Accent6  Lմ %M 60% - Accent1 23 %M$ 60% - Accent2 23ٗ %M( 60% - Accent3 23֚ %M, 60% - Accent4 23 %M0 60% - Accent5 23 %M4 60% - Accent6  23 %AAccent1 O %A!Accent2 PM %A%Accent3 Y %A)Accent4 d %A-Accent5 K %A1Accent6  F %9Bad  % Calculation  }%  Check Cell  %????????? ??? Comma( Comma [0]&Currency. Currency [0]G5Explanatory Text %;Good  a%G Heading 1 I}%OG Heading 2 I}%?G Heading 3 I}%239 Heading 4 I}%uInput ̙ ??v% K Linked Cell }%ANeutral  e%"Normalb Note  wOutput  ???%????????? ???$Percent1Title I}%MTotal %OO? Warning Text %XTableStyleMedium9PivotStyleLight16ccB !1 JtD״  dMbP?_*+%-[X&C&"Arial,Bold"&12ֱ 2010-2013 Long Range Financial Plan and Forecast&C&P&RRevised 4-12-10M HP LaserJet M2727 MFP Series P8&C odXXLetterDINU", 5CSMTJHP LaserJet M2727 MFP Series PCL 6InputBinFORMSOURCERESDLLUniresDLLESPRITSupportedTrueHPDocUISUITrueHPNUseDiffFirstPageChoiceTRUEResolution600dpiFastResTrueHPPrintInGrayScaleTrueEMFSpoolingforPLSwoMopierTrueCollateOFFOrientationLANDSCAPE_CC90HPOrientRotate180FalseDuplexHORIZONTALPaperSizeLETTERHPEnableRAWSpoolingTrueMediaTypeAUTOColorModeMonoEconomodeFalseTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineHPEnableGrafitCompressionTrueHPRequestObjectTagDumpFalseHPRequestNullStripCommandFalseHPHybridRenderSwitchHPHybridPDLHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNPrintQualityGroupPQGroup_3HPDocPropResourceDatahpzhl072.cabHPLpiSelectionNoneHPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPXMLFileUsedhpc27276.xmlHPEnableObjectTaggingTrueHPEnablePageTimerFalseHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPEnableNullStripsTrueHPEnableEfficientMonoFALSEHPEnableImageProcessingPathFALSEHPMonochromePrinterTRUEHPCallToWritePrinterRequiredTRUEHPMemoryManagerTrueHPGetCompressionRatioValue17MaxStripHeight64HPGetByteAlignedValueForWidth256HPGetDeltaRowHalfToneValue1HPPrintOnBothSidesManuallyFalseHPPaperSizeDuplexConstraintsA3HPMediaTypeDuplexConstraintsHEAVY_111_130GHPStraightPaperPathFalseHPPageExceptionsFileHPZPE072HPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionPSAlignmentFileHPZLS072PSServicesOptionHPServiceFileNameEndHPSmartHubInet_SID_263_BID_514_HID_265HPConsumerCustomPaperTrueHPPreAnalysisTrueHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotate IUPHxkAǿ@)j@o^rQ`@Vu35ōi PF+I=ƃ'x?xPPzwvSmY{3\ +2"S5.]8,l fO;@9,b?،OM,c%x^cRj^(E%m );+PNz0\<_TnjQF)kXzjDx{DQ_E"f'; p%LOY~udvKaV~Qav\譇m%slgڔuX`mexK֚­0+SzpkS8w'\>#پ$=3m %7md uތ_u[?^gUsS5[ IcqF˸g(ܴlΕ6FE,g~KƷ*]AL.Gõ#:%Y[[lXlPnOο]x}tC4_}|~zyjқ{ϻ^UjAAAAe8<"CXX??U}  } } } } } I} } } } } } } } } $ J        M l ll l ll l ll @> @ @ @  @  @ @ ?A?ZAZA4Qd D" A#d5AD" AUPq|/ZA2A"Z?PPPQAA A AA g"UUUUCCCCCCCCCC R. S?PQdWIA3ZA333#IA ZAdWIAZ  A%{]JA Z  AdWIA ZA,yJA Z T/ S>PQWŤqAZ AI,rAZ AWŤqAZ  AqBSsA@Z  AWŤqA Z ARLD]sAZ  T= S>PQ+@Z Aqdk@Z A+@Z  A<@ Z  A+@ Z AG΁@ Z  T0 S>PQZ Aȴ{ A Z AZ  AӦR A Z  A Z AܙT'z AZ  T1 S> P Q فZ AΡ+8Z AZ  AӦRA$Z  A Z AܙT'zAZ T2 S> P QE@ Z AE@Z AE@ Z  AE@ Z  AE@ Z AE@Z T3 S> P QA Z AA Z AA Z  AA Z  AA Z AA Z T4 S> P Q@ Z A@ Z A@ Z  A@ Z  A@ Z A@ Z `5 a> X ZXDA Z F GXDA Z F GXDA Z  F GXDA Z  F GXDA Z F GXDA Z [6bcz*zqAD c#c~duA % ]#]wvA % ]#]yz vA %  ]# ]>wA % L ]# ]yz vA % L ]#_exA % L"PPPQAAAAAAAAAA g;"UUUVDDDDDDDDDD T@ S>PQMA ZAAMAZAA˔RNAZ  A AQOAZ  A Ao_NA Z AA'PA Z T7 S>PQ@UAZAA@UAZAAAZ  A AA Z  A Ap= נA Z AA> ףpAZ T8 S>PQx !AZAAx !AZAA(\:@ Z# e~ YX AX~ ZG~ GG~ G G~  G G~  G G~ GD6lblF4]&4&4((((( !"#$%&'()*@+, @- . /0123456789:;<=>? f  \# cz*zqA %  d# cp= qAA %  ]# ]p= qA %  ]# ]2qA %  ]# ]Zd;޹?rA %   ]# ](rA" %   ]# _nԸrA % !AAAAAAAAAAA "[ "\!"] DD "^!"]4Qd DD "]!"]#d5A DD "]!"]'J#$ DD " ]!" ]O\'A  D D " ]!" ]`-$ D D " ]!"_eA$ DD #AAAAAAAAAAA $? $H D"$?$H4Qd Z($H$H#d5A Z($H!$HUPq|/$ DD"$ H!$ H2A@ D D" $ H!$ H07K> D D" $ H!$HZ}:A$ DD"%? %H?HHHHHHHHHHH&? &H?HHHHHHHHHHH 'gB"'Ckgkkkkkkkkkkk (JE (H?HHHHHHHHHHH)J )H?HHHHHHHHHHH *mC"*mmmmmmmmmmmmmm+? +H?HHHHHHHHHHH ,mD",mmmmmmmmmmmmmm -?( -l -ll -l - ll - l - ll .O' .CC .@ .@ .@ . @ . @ .@ /? //h1Z-/M/h{Gz?1Z-/M/h?Z- / M/ h{Gz?1Z- / M/ h1 Z-/ M/h{Gz?1 Z-0? 0J%0h/Z.0M0h{Gz?/Z.0M0h/Z. 0 M0 h{Gz?/ Z. 0 M0 h/ Z.0 M0h{Gz?/Z.1? 1J 1h0Z/1M1h{Gz?0Z/1M1h0Z/ 1 M1 h{Gz?0 Z/ 1 M1 h0 Z/1 M1h{Gz?0Z/ 22i2Z02i2i{Gz?Z02i2iEZ0 2 i2 i{Gz?3Z0 2 i2 i3 Z02 i2i{Gz?3 Z0 33iŏ1w-!o2Z13i3iŏ1w-!oZ13i3i2Z1 3 i3 i{Gz?2 Z1 3 i3 i2 Z13 i3i{Gz?2Z1 4J!4i Z24i4i7Z24i4i7Z2 4 i4 i7Z2 4 i4 i7 Z24 i4i7 Z2 5J"5i4Z35i5i4Z35i5i4Z3 5 i5 i4 Z3 5 i5 i4 Z35 i5i4Z3 6J#6i5Z46i6i5Z46i6i5Z4 6 i6 i5 Z4 6 i6 i5 Z46 i6i5Z4 7J$7i6Z57i7i6Z57i7i6Z5 7 i7 i6 Z5 7 i7 i6 Z57 i7i6Z5 8JA8i7Z68i8i<Z68i8iQ?9Z6 8 i8 i{Gz?9 Z6 8 i8 iQ?9 Z68 i8i{Gz?9Z6 9J)9i8Z79i9i8Z79i9iQ?:Z7 9 i9 i{Gz?: Z7 9 i9 iQ?: Z79 i9i{Gz?:Z7 :J*:i9Z8:i:i9Z8:i:iQ?8 Z8 : i: i{Gz?8 Z8 : i: iQ?8Z8: i:i{Gz?<Z8 ;J+;i:Z9;i;i:Z9;i;i<Z9 ; i; i<Z9 ; i; i< Z9; i;i< Z9 <L,<i;Z:<i<i;Z:<i<i;Z: < i< i; Z: < i< i; Z:< i<i;Z:=L=iiiiiiiiiii >O& >OC>jjjjjjjjjjj ??iZEZ; Included?i?i0ZAZ; Included?i?iQ?? Z; ? i? iQ?Z; ? i? iQ?3Z;? i?iQ?? Z;Dle W ?..42.4.4bp*<@ABCDEFGHI @#@iŏ1w-!o %3?@i#@iŏ1w-!o %3?@i@iQ?"Z@ i@ iQ?EZ @ i@ iQ?E Z@ i@iQ?E Z A#Aiŏ1w-!o %3?Ai#Aiŏ1w-!o? %3?AiAiQ?@ZA iA iQ?@ Z A iA iQ?@ ZA iAiQ?@Z BBiDZ1Z< IncludedBiBiXZEZ< IncludedBiBiQ?AZ B iB i?A Z B iB iQ?A Z B iBi?AZ  CCilZBZ= IncludedCiCiZBZ= IncludedCiCiBZ!C iC i?B Z! C iC iB Z!C iCi?BZ! DDiZCZ> IncludedDiDiZCZ> IncludedDiDiCZ"D iD i?C Z" D iD iC Z"D iDi?CZ" EEiZDZ? IncludedEiEiZDZ? IncludedEiEiDZ#E iE i?D Z# E iE iD Z#E iEi?DZ#FKBKBBBBBBBB GO GCCGNNNNNNNNNNN H I-$$$$ <><KB ---- -- **,,7&KJggD !1   dMbP?_*+%"??U>@7&ggD !1   dMbP?_*+%"??U>@7&ggD Oh+'0HP`x TommiMatthew C. LeeMicrosoft Excel@IXx@U #@`x՜.+,0 PXd lt| # Sheet1Sheet2Sheet3  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\^_`abcdfghijklRoot Entry F0T4WorkbookSummaryInformation(]DocumentSummaryInformation8e