ࡱ>  f2ɀ`\pDTMBHeffernan Ba==%`3&8@"1ZCalibri1ZCalibri1ZCalibri1ZCalibri1ZArial1ZArial1ZArial1ZArial1ZArial1ZCalibri1ZCalibri1 ZCalibri1ZCalibri14ZCalibri1 ZCalibri1ZCalibri1ZCalibri1,8ZCalibri18ZCalibri18ZCalibri1>ZCalibri14ZCalibri1<ZCalibri1?ZCalibri1h8ZCambria1ZCalibri1 ZCalibri1!ZCalibri1 ZCalibri1"ZCalibri1ZCalibri1!ZCalibri1ZCalibri17ZCalibri1ZCalibri1ZCalibri1ZTahoma1ZCalibri1ZCalibri1ZCalibri"$"#,##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\);_(* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)[$-409]mmm\-yy;@)               )                                                        ff  +  )  ,  *     P  P        `            a>  * )! )! ) @ @  ) a@ @  )  "      (a@ @     )! ) @ @  )! *  )  *     * $a@ @  )! )& )  )   )   ) ,a@ @   # ) @7 *\7 )  )! )! )  )! )  * ) @ @  ) / )  ) / )! ) 7 */ *  )# )# )! )! !)  ) @ )  )  ) / " " # " ) `a@ @  $)#X ) @ @  ) `@ @  )  ) `@ @  *  *\ *\ */ =@ 8@  M@ = )  @  )" !)  * =@ =@ )(@ @ =    )  ||D^}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-} #0\);_("}-} #0\);_("}A} #0\);_("ef;_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("ef ;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("L ;_(@_) }A} #0\);_("23;_(@_) }A} #0\);_("23;_(@_) }A} #0\);_("23;_(@_) }A} #0\);_("23;_(@_) }A}  #0\);_("23;_(@_) }A}! #0\);_("23 ;_(@_) }A}" #0\);_(";_(@_) }A}# #0\);_(";_(@_) }A}$ #0\);_(";_(@_) }A}% #0\);_(";_(@_) }A}& #0\);_(";_(@_) }A}' #0\);_(" ;_(@_) }A}( #0\);_(";_(@_) }}) }#0\);_(";_(@_)    }}* #0\);_(";_(@_) ??? ??? ??? ???}-}+ #0\);_("}-}, #0\);_("}-}- #0\);_("}-}. #0\);_("}-}/ #0\);_("}A}0 a#0\);_(";_(@_) }A}1 #0\);_(";_(@_) }A}2 #0\);_("?;_(@_) }A}3 #0\);_("23;_(@_) }-}4 #0\);_("}}5 ??v#0\);_("̙;_(@_)    }A}6 }#0\);_(";_(@_) }A}7 e#0\);_(";_(@_) }}8 #0\);_(";_(@_)    }}9 ???#0\);_(";_(@_) ??? ??? ??? ???}-}: #0\);_("}-}; #0\);_("}U}< #0\);_(";_(@_)  }-}= #0\);_("}-}> #0\);_("}-}? #0\);_("}-}@ #0\);_("}-}A #0\);_("}-}B #0\);_("}-}C #0\);_("}-}D #0\);_("}-}E #0\);_("}-}F #0\);_("}-}G #0\);_("}-}H #0\);_("}-}I #0\);_("}-}J #0\);_("}-}K #0\);_("}-}L #0\);_("}-}M #0\);_("}-}N #0\);_("}-}O #0\);_("}-}P #0\);_("}-}Q #0\);_("}-}R #0\);_("}-}S #0\);_("}-}T #0\);_("}-}U #0\);_("}-}V #0\);_("}A}W #0\);_(";_(@_) }A}X #0\);_(";_(@_) }-}Y #0\);_("}-}Z #0\);_("}-}[ #0\);_("}-}\ #0\);_("}-}] #0\);_("}-}^ #0\);_("}-}_ #0\);_("}-}` #0\);_("}A}a #0\);_("ef ;_(@_) }-}b #0\);_("}A}c #0\);_("ef ;_(@_) }-}d #0\);_("}A}e #0\);_(";_(@_) }A}f #0\);_("ef ;_(@_) }-}g #0\);_("}-}h #0\);_("}-}i #0\);_("}-}j #0\);_("}-}k #0\);_("}-}l p#0\);_("}-}m #0\);_("}-}n #0\);_("}-}o #0\);_("}A}p #0\);_("ef ;_(@_) }-}q #0\);_("}}r}-}s #0\);_("}-}t #0\);_("}-}u #0\);_("}-}v #0\);_("}-}w #0\);_("}-}x #0\);_("}-}y #0\);_("}-}z #0\);_("}-}{ #0\);_("}A}| #0\);_("ef ;_(@_) }-} p#0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_(" 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`l} Instructions Data Input &Rev rExpcPositionz ObligationsF-65 Cross-walk:#EOMONTH,5 Citizens_Guide_Instructions;A/  ;I   ;(   ;%  ;%  ;%   ;4&d+tq. =[#$%&'()*+,-./0S AA@A@    Expenditures+Stmt. Of Rev & Exp - All governmental fundsRevenueProperty taxesTaxesCharges for servicesStateFederalLicenses & feesInterest & rentOther total revenue Police & fireOther public safetyRoads & bridgesPublic transportationRoads Health & welfare Community & economic developmentParks & recreationOther public worksCapital outlay Debt serviceUnallocated fringes & insuranceInterfund transfers (net)total expendituresSurplus (shortfall)General governmentTotal expendituresExtraordinary/ Special itemsInterfund transfers out5Fringe benefits not directly allocated to departmentsRecreation & cultureOther cultural activitiesLibraryOher community developmentEconomic developmentPlanning & zoningPublic housingOther health & welfareVeterans' programsArea agency on agingHuman services Child care Ambulance Mental healthMedical examinerHospitalAlcoholism & substance abuse Health dept.Water or sewerAirports ElectricityTrash disposal & landfillingBuilding regulationsJailDispatch (if separate)Combined public safetyFirePoliceJudicialAll other gen gov.Building & groundsFinance ElectionsClerk Assessing TreasurerChief executive Legislative EXPENDITURES Total revenueInterfund transfers In Debt issuanceOther refunds & rebatesAmbulance services ContributionsSale of fixed assetsSpecial assessmentsMisc. other revenueRents & royaltiesInterest & dividendsFines, penalties & forfeitsAll other fees Parking feesParks and recreation feesOther charges for services Police feesFire run chargesAll other statutory feesRegister of Deeds feesElection chargesClerk's office chargesStatutory court fees & chargesCourt-ordered fees and chargesLocal donations - otherLocal donations - transit'Local donations - Gas, water, electric 1Local donations - housing & community development&Local donations - culture & recreationLocal donations - welfare)Local donations - health and/or hospitalsLocal donations - sanitation$Local donations - streets & highwaysLocal donations - public safety$Local donations - general governmentState aid - otherState aid - transitState aid - electricState aid - water+State aid - housing & community development State aid - culture & recreationState aid - welfare#State aid - health and/or hospitalsState aid - sanitationState aid - streets & bridges"State pass-thru of act 51(Streets)State aid - public safetyState swamp and land taxesState payment in lieu of taxesState aid - general governmentState revenue sharingFederal govt. grants - otherFederal govt. grants - transitFederal govt. grants - electricFederal govt. grants - water6Federal govt. grants - housing & community development+Federal govt. grants - culture & recreationFederal govt. grants - welfare.Federal govt. grants - health and/or hospitals!Federal govt. grants - sanitation)Federal govt. grants - streets & highways$Federal govt. grants - public safety)Federal govt. grants - general governmentNon-business licenses & permitsBusiness licenses & permits Income taxIndustrial facilities taxHotel/ motel tax Trailer taxesCommercial facilities taxTax reverted propertyREVENUE#All Governmental Funds (col. A & b) Description F-65 line% changeREVENUES+Financial position - All governmental fundsTotal fund balanceFund balance, by component:total fund balance4Liabilities not counted on a modified-accrual basis:AssetsPercent funded#Landfill closure & postclosure careEmployee compensated absencesUninsured lossesOther claims & contingenciesDebt:UnfundedStructured debtOTHER LONG TERM OBLIGATIONSTotal Per capita informationPopulation informationUndesignated fund balance DesignatedReserved$Calculated - Unreserved fund balance UndesignatedPensionsOPEBSum of all pension & OPEB plans AggregationRevenue: Expendtiures:#Graph data, pulled from above data:Unfunded (Overfunded)Capital leasesOther contractual debt61. Where our money comes from (all governmental funds)2. Compared to the prior year :3. Revenue sources per capita - compared to the prior year+4. Historical trends of individual sources 41. Where we spend our money (all governmental funds)33. Spending per capita - compared to the prior year/4. Historical trends of individual departments:F1. How have we managed our governmental fund resources (fund balance)?73. Fund balance per capita - compared to the prior year.4. Historical trends of individual components 1. Pension funding status%2. Retiree Health care funding status.3. Percent funded - compared to the prior year4. Long Term Debt obligations:M5. Debt & other long term obligations per capita - compared to the prior yearFINANCIAL POSITION Date Input Page7CITIZENS' GUIDE TO LOCAL UNIT FINANCES - City of SampleDPW FUND BALANCE- Reserved/ Restricted - Designated(- Undesignated/ unreserved/ unrestricted Total equityActuarial LiabilityContact information:SFor more information on our unit's finances, contact ENTER NAME at (XXX) 111-2222. Licenses & permitsFines & forfeitures Other revenueNet Interfund transfersBonds & contracts payable*Total long term debt (excl. pension & RHC)Date of actuarial valuation:Before publishing the spreadsheet to your website, we highly recommend you "hide" the Data Input Tab and the F-65 Crosswalk Tab so that this document will be more user-friendly. To hide a tab, right click on the tab and select "Hide".0On the first two tabs of the Citizens' Guide (revenue and expenditures), table number 4 has been built as an interactive chart. When this is put on your website, the user can choose any revenue (expenditure) from the drop-down list and see the historical trend for that particular revenue (expenditure).  % Rows 79-83 are grayed out and should be ignored. This section is necessary in order for the interactive revenue and expenditure charts to operate properly.  % Row 69 presents population information. This is presented so that we can compute measures on a per-capita basis, and will make it easier when you want to do comparisons with other local units in the future. For 2010, the population count should agree with the U.S. census figures. For all other years, estimates of population are generally available through your regional council of governments./  % Rows 57 through 67 present the debt information from the "long term debt account group." In other words, this represents all governmental liabilities not already reported in the funds themselves. This information generally can be found in the footnote disclosures of your financial statements. Many local units only have every other year (or every third year) information related to the actuarial accrued liability (AAL) for retiree health care plans. For those communities, we recommend extrapolating the information between valuations so that a fair picture can still be obt< ained. For example: if the 2007 AAL was $5 million and the 2010 AAL was $8 million, you could extrapolate to $6 million for 2008 and $7 million for 2009. This information should be in the footnote disclosures of your annual financial statements; it is also available in your actuarial valuations.  % Rows 39 through 54 presents the funded status of all "defined benefit" employee benefit plans (pension plans, retiree health care, or any other OPEB plans.) If you have any fund balance categories that are not being used by your local unit (i.e., you have no reservations or you have no designation), please "hide" those rows on the data input sheet. This will remove them from the graphs. This should include the General Fund plus all special revenue, debt service, capital project, and permanent funds (if you are using the F-65, this is the sum of columns (a) and (b).04Q  % Rows 31 through 35 present the fund balance as of the balance sheet date;{ If you have any revenue or expenditure categories that are not being used by your local unit, please "hide" those rows on the data input sheet. This will remove them from the graphs so that the graphical presentation will be easier for the citizen to understand. This will be very common; for instance, row 27-extraordinary/special items, is quite uncommon to use.  This should include the General Fund plus all special revenue, debt service, capital project, and permanent funds (if you are using the F-65, this is the sum of columns (a) and (b).15\  % Rows 4 through 29 present the revenues and expenditures from all governmental funds.E"  % The model requires 5 years of data, but allows for 10 years (10 years being preferable.) In order for the graphs to ignore the first five years, we have hidden those columns. If you want to use more than five years, just "unhide" columns C-G and the input areas will be available.To enter information in the data input tab, you will need to have copies of your financial statements, trial balances, or F-65 forms. To use the spreadsheet:#  % Other long-term obligations  % Financial Position   % Expenditures   % RevenuesThe spreadsheet is organized by tabs. The first tab to the right of the Instruction tab is titled "Data Input" and is the only tab where you should have to enter data or make modifications. The next four tabs contain the Citizens' Guide organized as follows:0INSTRUCTIONS FOR THE CITIZEN'S GUIDE SPREADSHEETfrom Federal Govt.from State Govt.Local contributions}N OO!=PQQ]RRRvhSSbT/UU/WX Y 3Z h[ \ \M].^^K_Zhab*c:ery` ccB f2ɀ @7'1  dMbP?_*+% &C&P& ףp= ?' ףp= ?(Q?)Q?Mhp LaserJet 1320 PCL 5C odXXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"dXX(\??&U} o} U_@\,@            @ @@,~,~,~,~ @,@,@@,@     @,@       } } } }  @D         ,@!@"W@# $(%@&('@(,@) * + , -,@. / 0 1,@2 3 4 5 6 7 8 9,@: ; = > ?  !} "~#~ $}%} &}'} ()*+,} -./0} 12345} 678} 9:; =>?BX          PHT0(  T>@U_b 67(+-/14  9;=?b(b(  gg}D f2ɀ W  dMbP?_*+% (&?'?(?)?Mhp LaserJet 1320 PCL 5C odXXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"dXX333333?333333?&<3cU} } U}  }  } } U WDD_Dy>                                , kY Q Q llBfD@fH@fL@fP@fT@yX@y\@y`@yd@yh@  gd@1 D @ gh@ D @   Sq r Rmmmtt Yaaaaa$aH@a@a@a8@a @  8l@   LDH A  i@   LDH AY Yaaaaa$aQ@aQ@aQ@a@R@aR@  @2@   2@  Y Yaaaaa$a@l@am@am@an@ak@  N@B   K@   Y Y aaaaa$ aO@aP@a@P@aP@a@Q@  0@   @1@  Y Y aaaaa$ aI@aJ@aK@aK@aL@  +@T   ,@T  Y Y aaaaa$ aR@aP@aK@aA@a7@  !@V  @   Y Y aaaaa$ a@a@a@a@a@  ?T   ?  Y  aaaaa$ a@a@a@a@a?  ?A   ?  Yaaaaa$a@a@a@a@a@  ?A   ?  Z ` -U````u@B u@@  u@$  u@  u@  Au@   As@  Rmmmmm Yaaaaa$a@e@ae@a@f@ad@aa@  D@   LDH A A@   LDH A Y aaaaa$a@a@a@a@a@  i@V   h@E  Y aaaaa$aI@aJ@aK@aE@aA@  %@   !@' Yaaaaa$ap@ap@ap@a`o@an@  `O@C   N@  Yaaaaa$a,@a,@a,@a.@a.@  @   @  Yaaaaa$a@a@a@a @a @  @   @A Yaaaaa$aF@aG@aH@aH@aI@  (@   )@7 Y aaaaa$aD@aD@aE@aE@aF@  %@$   &@A  Yaaaaa$aA@aA@aB@aB@aC@  "@   #@  Yaaaaa$a<@a=@a>@a>@a?@  @   @C  Yaaaaaaaaaa       Yaaaaaaaaaa     S  Yaaaaaaaaaa       @A -DAAAAv$@D v@  vX@  vx@  vܕ@A  Axv@7  Au@"  BV LLBT BB9BsG@ sA@  s0@  sI'  s`b  B)9  B`B  Dl0"""jjj ,!D" # $ %, &,' ( )h*D+D, - . / 0 1D2 3 4 5 6 7 8 9 : ; < = > ?  S mmmmm !mmmmm>> "Y"aaaaa$"ac@ag@ah@ad@aK@ " TD@% " "% LDH A" T+@' " #Y#aaaaa$#aA@aC@aD@a<@a(@ # T@# " # T@ " $Y$aaaaa$$ad@a@c@a@c@ab@a]@ $ TB@ " $ T=@V" %?%BA%%% -D%B%%%B%%%B%%%B%%%s0v@ %%sw@S %% s`x@" %% su@% %% s g@% %% UU@' " % U G@" %B&mmmmm ''''' -'''''''''''''mg@%''m@l@%'' mm@% '' mh@' '' mP@' ''' TH@# D' DH A'' T0@% D' DH A(mmmmm )S)zzzzzQQ **mmmmm>> ++{`@4 +#++ 9,(B+{1@+++{^@+++{@@+++{@+++{@+++{@@+++ {B@+++ {p@+ +~ + |@@ + Q> ,[,aaaaa$,a@a@a@a@a@ -[-aaaaa$-a4@a@a@@a̒@a`@ .[.'... LL.............mVV..ma7.. mS@7.. m@j@. .. m f@. .'. T@J@7 D. DH A'. T F@8 D. DH A/@ /A/E +D-A D,D-B/E//5// +LA LLB/E ///E ///E ///Ed R?///Edu*?/// E^z?/// Ei?/ // Eovn?/ / / GG 00mmmmm 11{`@+ 1#11 9,(B1{1@111{^@111{@@111{@111{@111{@@111 {B@111 {p@1 1~ 1 |@@ 1 Q> 2[~ 2a%2a.D2?%2a9D2?%2a9D2?%2a D2?$2aaaI@aY@ac@ 3[3aaaaa$3ah@a@a$@a@a@ 4[4mmmmm"4nh@4 D3D2"4n@4 D3D2"4 n\@4 D3 D2 "4 n@4 D3 D2 "4 n@4 D3 D2 '4 Tq@%D4 DH A'4 Tr@4D4 DH A5@ 5A5E/ +D3A D2D3B5E55555 +LA LLB5E555E555E555E555E555 EZD ?555 E ?5 5A5 E*p#?5 +D3 A D2 D3 B 5 GG 6H6mmmmm 7[7b2777 LL7b277b277b277b977w@8 77w@8 77 wؑ@. 77 w @7 77 w@:7 8[8b:888 LL8b:88b:88b:88b:88wt@.88wL@.88 w2@. 88 w&@. 88 w,@7 8 9[99999 LL9'99S99999S99m@99mP@9 99 m@99 m,@9 99 mD@9 9'9 T,u@9 D9 DH A'9 TDu@: D9 DH A :A:E7+D8A D7D8B:E8:5:: +LA LLB:E8::E8::E8::Ev?: ::EMPq?9 :: EEva?::: E^׆W?:A: EV3C?: +D8 A D7 D8 B : GG ;mmmmm <Ymnnnnnnnnnnm =\=Y=mmmmm >d>Yaaaaa$>a w@a@u@a`s@a @a0@ ?d?Yaaaaa$?aaaaa Dl"&&hJJ"hJ6"^^$,L@ A B C D E F, G,H J K R S DT U V  @d@Yaaaaa$@aA@a@@a?@a=@a;@ A]AZAIFAAA -DAIFAAIFAAIFAAIFAAxPy@FAAxPw@FAA xPu@F AA x@ AA x@V AA Tc@F A AF LDH AA Tb@F A AF LDH A BYBYcaaaa$Bad@ae@af@a g@a@h@ B T G@ A B T@H@D A CYCYcaaaa$Caaaaa C TA A C T A DYDYcaaaa$DaM@aM@aM@aM@aM@ D T-@A D T-@ A EYEYcaaaaaaaaa E T A E T A FY FYFB8FFF -DFBAFFBAFFBAFFBAFFsx@TFFs@ FF s@ FF s@F FF s@F FF Tj@ A F Ti@ A HSH^aaaaa$Ha@a@a@a@a@ JS KaKppppppppppp RWRWWWWWWWWWWW SW~ Se@SXD@ SSS LSXH@SSSXL@SSSXP@SSSXT@SSSXX@SSSX\@7SS X`@7SS Xd@ SS Xh@ STW(TeV%DSBFines & forfeituresTWTTTT -@@DSBTWVTTWTTTW8TTWVTTW@ TTW@TT W@V TT W@E TT W@ T UW~ Ue@UWWWWWWWWWW VW(VeT%@@DUB Police & fireVWVVVV -@@DUBVWTVVWTVVWTVVW8VVW@VVW@S VV W@ VV W@AVV W@ V$ ,LlL..f:       @D  B          e                     U"                  #  $  $  %% % %  %  %  '  2 55 9 9  9 E  E  F  S S S S S S S S  T  V   - (    + JڮTextBox 1" PK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!weKFdrs/shapexml.xmlWn6}/)ExmgampRhDSBro!w}q~pΐst~jZ)kr1d)l٘E.^ M)5*[ٯlJ7#0~\!tjNVֵ2[ K'p8sJV*1ڞ*irMYv2x7`fnⲳ8m~&G,^ۧ'LJG< w\ jtc1Nqewv1pԔ 2E`nh$6H3#wK9TT~GF[)bBms/:cp9ETh.]A4Hضs>|TQ;ʅSE_>UA0)-RPJ\. CjR,Zd<="0d\ӵ,Uo/ sfǠDZ|QH}Tf vd [ 0 9?S #WH+c ]U81m=B"srHs hQ3 zNz㹵m)>:%\$?ڇKE-^/JK^ްD0E@Sb :U}F4sOiE;6 uX An@wNiP +DQF5/ Pz..<֢O/dF?~i&@j| &~{=ڸw O߮ r Ŧ0 M51tΝٺZ/y{^4nΓ8ʲ~D˦48[~K[}˟~PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!weKF)drs/shapexml.xmlPK-!C#drs/downrev.xmlPK9 P]+` <Instructions: Input all data on this page. The following pages will then provide the graphs and charts which comprise the Transparency tool (citizen friendly guide). This model requires 5 years of data, but allows up to 10 years. To use more than 5 years, unhide columns D-H. Before publishing to the web site, we recommend "hiding" this tab, and the "F-65 crosswalk" tab, so that the document will be more user-friendly. (To do that, right-click on the tab and select "Hide." <&& , PPۮTextBox 2"{PK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!pndrs/shapexml.xmlUn0 } :q 3j[eXŖcIl.R̓"S/GӰPηbx>Lisxw6QJjkT.ʋ뗫U2i: g$EgIFuҟ^:$ҧ'K2$ Ɖox"`Fi=@DQlw*ax.澮N]F[:z0A}`x'+ri:[8C'Kgs! ukiqb?*@î N/HL%fyА&e]|G5;rSfM\\ eFAIG1oJRNFqTH;?=`Cp\IC0Z?"ԍv:cPRS`otDyz7.cg !C(_lZEE!.D|)BD~DXkuC["DT[oKHj.zΩlKh/[:H87^%N(.qZeV8U.,,-y*s4Jm%-3,^hڊf 4<`#(t0ah‹Ww8 8b DH1=X5nBo'iUo%J~ǃ;bPK!êddrs/downrev.xmllO0Mkt$8)ITF\Cvi+{~tON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!ҏdrs/shapexml.xmlUMS0wA;Iz)  l9 K$aW}owVV1:Ә3KS5zg ] eV:~Q|rl&t4A20|}E+tRnml+M]vY$z0$Nf}$آO(+70^QLҳ49<&yO\jڞןխeM3-Zh=06?`~fh3)@BlS۶xGG[h)2S @Qۜd|,2JJ,@;Oi0Pέ,=Qc ^!T׍R>y,[ sCPRc:ߦ)@N/(]2ȷdȼ 1Hp z)K'[%C2wzN)jmxhH#>C@tiC"kP'@)?mACFAuZ Sm#9V p7xʀKtmmE,zuiԁ\%sfr~t%F;6 J^R<}9=#ɚ~`WSAzɊpy:Yߓ4XTJx%[XPK!u drs/downrev.xmlT_O0M5M!?L쵶[Xۥl|{.Az=ӞƭF9_Z D@Vffn$Q 8񡴍Y2? !^Js߱2˭7 z@+m)X&FϹ80EL`Fa^qܜ \ {䊓~F!L;PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!ҏ)drs/shapexml.xmlPK-!u drs/downrev.xmlPK]"+%]-` <"Hide" unused rows<(>@(dA + ++ gg f2ɀ &qGOP  dMbP?_*+% &?'?(?)?Mhp LaserJet 1320 PCL 5C odXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"\X333333?333333?&<3cU}  } q}  } } }  &  h  D         D D jZ:7CITIZENS' GUIDE TO LOCAL UNIT FINANCES - City of Sampleh i  >d@Z >h@ Z  > > YM8@Z M @Z G. 1D  n/aDDDB Y@R@%Z R@Z ?; 1L  n/aLLLB Yn@Z k@Z }K` YP@Z @Q@Z g1? YK@Z L@Z )A? YA@Z 7@Z __տ Y @ Z  @ Z   Y  @ Z  ? Z    Y L@ Z  L@ Z    @# K@  % # K@ % G V:긿 1D   n/aD D D B   /x\qqqqqqq"@#@$@% % ZKVSFor more information on our unit's finances, contact ENTER NAME at (XXX) 111-2222. <xV r m mat r u anc ct " E a5 11-    eA%  0s (  n p c 4NChart 1[]p@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PH000(  0h3d23   MR R R RI3~S S4  3QQ) ; Q) ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S43_ M ff6 f Er@"B  ` MM<R RD S S43_ M 3f f FC@"B  ` MM<R RvM) S S43_ M  f N@"B  ` MM<R Ra S S43_ M ff6 f qX@"B  ` MM<R RTF S S43_ M 3f9 f A@"B  ` MM<R RC S S43_ M  f ۄ=@"B  ` MM<R R S S43_ M  f @"B  ` MM<R R+q S S43_ M 7 f ѓ@"B  ` MM<R Rn S S43_ M  f ͖@"B  ` MM<R Rv\ S S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FA|3O3" ' W 3O' b% 03O& Q423 M NMR RR RR R R R]S S4<G -$͒ K/S S 4S S4S S4D-$͒$K[fgS S 4 eTaxes-Licenses & permits-from Federal Govt.)from State Govt./Local contributions1Charges for services/Fines & forfeitures'Interest & rent# Other revenuee @R@k@@Q@L@7@@?@e*Kven-USKa vn q c 4NChart 2[!]q@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"XX333333?333333?3&<3PH@40(  4h3d23   MR R R RI3~S S4  3Q:  2009Q) ; Q) ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4  3Q:  2010Q) ; Q) ;Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FAb |3OS) 3 bR RR RV VdZ& ! u,-1H  K.(KQRs S S43* & ! ! R RHu,Hu,-$͒S S4523 M  MR R͒n]S S43"  TC3O K% 03O& Q423 M NMR RR R R R͒]S S4<O-$͒ K/S S 4S S4S S4DS) -$͒ K[S S 4 eTaxesTaxes-Licenses & permits-Licenses & permits-from Federal Govt.-from Federal Govt.)from State Govt.)from State Govt./Local contributions/Local contributions1Charges for services1Charges for services/Fines & forfeitures/Fines & forfeitures'Interest & rent'Interest & rent# Other revenue# Other revenuee8l@ i@@2@2@N@K@0@@1@+@,@!@@??????e*Kven-USKa vn r c 4NChart 3 !]r@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"XX333333?333333?3&<3PHP80(  83d23   MR R R RI3~S S4 3Q):T *Fines & forfeituresQ) ;TT Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FAz 4 3O 3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" 4S S4D Hn6va?)A?% 9 ? ) ?% p3OQ'4-$͒ K[S S 4eX@\@`@d@h@e@@@@@e*Kven-USK  s J\TextBox 4"rlPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!||Udrs/shapexml.xmlUn0?'Zl`)h hpQIK3؅{@Ǚf+Ysc[ \ǔpUU˂>?]) xAwқ69SJ!QЕs]EZqF|eTRDi"j݆Zng\o"e*-x!40zћr0[;qA&s~N8zt:s{@* J['Zv`~ if(&VOޒ!kpq[pCz,6Fe(d,MCׅXieYIӓQ2Tb Fvu?@5r[.@!jwLf… Pb d2KA@ V-'yJƻW_ïO/Q (P~f:Z<C}kx~@Ϡ82  C@DnhC":oP'@8|*mȦ~k x{);;)wC#4mG <@6u 'fn%[R9w/PK!r(drs/downrev.xmlT[O1M͘& l5A"Hkv/aے˿w@зΙtRV?vyD^6ќ~0vx(R̷_p{ oǭ%w^ZbS`iQ۝ska@OfyG$ HI:HN:qqF k'PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!||U)drs/shapexml.xmlPK-!r( drs/downrev.xmlPKaJ! $]s`  < Commentary: <& ZR 7 C @z u]j7 |:S ; >@U gg|G f2ɀ )<  dMbP?_*+% &?'?(?)?Mhp LaserJet 1320 PCL 5C odXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"UX333333?333333?&<3cU} }  } q}  } 8 } }  )    D              , @ j Z:7CITIZENS' GUIDE TO LOCAL UNIT FINANCES - City of Sample iF  >d@Z >h@ Z  > > Nd@Z Na@ Z V333333ÿ;  1L  n/aLLLB  @Z @Z Vf`Y4mt  E@Z A@Z V)kʿ  `o@Z n@ Z Vcz .@Z .@Z V  @Z  @Z V   H@Z  I@ Z  V9/?    E@ Z  F@Z  V}A_З?  B@ Z  C@Z  Vк?   >@ Z  ?@ Z  V?   Z  Z G V 1D   n/aD D D Bn/a Z Z GV 1D  n/aDDDBn/a @#Ox@ %#Oܕ@ %(Eś DDD  P(Tn\qqqqqqqqq%@&@'@( ( ZKVSFor more information on our unit's finances, contact ENTER NAME at (XXX) 111-2222. <h r m mat r u anc ct  E aV 11-  e    C    A   7  U"$  A      C      S S %(  pp (  n m c 4NChart 1&]m@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PH`<0(  <M333d23   MR R R RI3~S S4  3QQ) ; Q) ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S43_ M ff6 f @i@"B  ` MM<R Rtق S S43_ M 3f f A>@"B  ` MM<R RzL*u S S43_ M  f H@"B  ` MM<R R(R S S43_ M ff6 f iQ@"B  ` MM<R R^ς S S43_ M 3f9 f <@"B  ` MM<R RM S S43_ M  f {8@"B  ` MM<R Rg, S S43_ M ff6 f O@"B  ` MM<R R8]h S S43_ M 3f f PM@"B  ` MM<R R3Yl S S43_ M 7 f Y@"B  ` MM<R R5 S S4 3_ M ff6 f d@"B  ` MM<R R jV S S4 3_ M 31 f K@"B  ` MM<R R tD S S4 3_ M 4 f F@"B  ` MM<R R q \ S S4 3_ M  f @"B  ` MM<R R ֤ S S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FAX3ON3"  nU 3O q% 03O& Q423 M NMR RR RR R R R]S S4<S -$͒ K/AS S 4S S4S S4DN-$͒$K[fgS S 4 e-General government# Police & fire/Other public safetyRoads -Other public works)Health & welfareI Community & economic development1Recreation & culture%Capital outlay! Debt serviceG Unallocated fringes & insurance7 Net Interfund transfersA Extraordinary/ Special itemsea@@A@n@.@ @I@F@C@ ?@   e*Kven-USKa vn n c 4NChart 3>7#]n@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"XX333333?333333?3&<3PHp@0(  @3d23   MR R R RI3~S S4  3Q:  2009Q) ; Q) ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4  3Q:  2010Q) ; Q) ;Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FA@j3OW 3 bR RR RV VdZ& ! u,-1H  K.(KQRS S43* & ! ! R RHu,Hu,-$͒S S4523 M  MR R͒n]S S43" JO 3OJNK% 03O& Q423 M NMR RR R R R͒]S S4<e-$͒ K/S S 4S S4S S4DW -$͒ K[S S 4 e-General government-General government# Police & fire# Police & fire/Other public safety/Other public safetyRoads Roads -Other public works-Other public works)Health & welfare)Health & welfareI Community & economic developmentI Community & economic development1Recreation & culture1Recreation & culture%Capital outlay%Capital outlay! Debt service!  Debt serviceG Unallocated fringes & insuranceG Unallocated fringes & insurance7 Net Interfund transfers7 Net Interfund transfersA Extraordinary/ Special itemsA Extraordinary/ Special itemseD@A@i@h@%@!@`O@N@@@@@(@)@%@&@"@#@ @ @      e*Kven-USKa vn o c 4NChart 4? $]o@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHD0(  D̓3d23   MR R R RI3~S S4 3Q):V  Police & fireQ) ;VV Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FAm 3Oq 3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" 4S S4Dq S3??ݹf,?$?% p3OQ'4-$͒ K[S S 4eX@\@`@d@h@e@@@@@e*Kven-USK  p JTextBox 2"tnPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!>pdrs/shapexml.xmlUn0 }ډ5j[eX^>@Ĩ.үIiS)Bȅrl-TU6%?MgF݃Y<$Chd7KCnЫ@/eEuad<̭Skx@ 4vGL! 'qS}2mAY[q3 ?M4jxP gRz_h<Ǫީp C,V]<@om'zI\P }wHXbc` *%g萓x%EZ ܮ`طM6aL>5xVz,U~"3Tgl1K?PK!V pp%drs/downrev.xml\[O1M͘& nV5A"HkimI[;ƧvwqS0{e),_r >p#ycbWƣ!Hۚ-BIgPPE4=U{u,]I-&QQk*Uϕŏf 䦈h*h5+no#pʴrr8ڽK)mvsc0-&F蚉u{&ζHe@m(̊« Oq윕,#:pb&iǨ!Nώ~PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!>p)drs/shapexml.xmlPK-!V pp%drs/downrev.xmlPKc]$u ']p`  < Commentary: <& ZR 4 C @5 }]j4 t :U ;>@U gg|G f2ɀ &!8>?  dMbP?_*+% &?'?(?)?Mhp LaserJet 1320 PCL 5C odXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"^X333333?333333?&<3U}  } }  } }  &    D   ,  ,    ,  , j Z:7CITIZENS' GUIDE TO LOCAL UNIT FINANCES - City of Sample i  >d@Z >h@Z  > @ Z @Z (E:긿DDD x@Z ܕ@ Z (EśDDD @BIZ B`bZ (F?DDD E ?b@Z$ ]@Z$ (E88ƿDDD ?<@ Z# (@ Z# (E$I$I DDD ? d@Z"  K@ Z" ( Ew%jWvD D D  @# Bu@ % D # B g@  %  ( F1 0 ܿD D D   nR~~~~~~"@#@$@% % ZKVSFor more information on our unit's finances, contact ENTER NAME at (XXX) 111-2222. < r mS mat r u anc ct  E a 11-  e  V '  "  #  #  (%  < (  n 9 c 4NChart 1[]9@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHH0(  Hh3d23   MR R R RI3~S S4 3Q):  total revenueQ) ; Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q): (total expendituresQ) ; Q ; Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q):% (Total fund balanceQ) ;%% Q ; Q3_  MM  ""dR R R Rͨ  K"#AS S4ES S 4D$% 0&3O& QR RS S4$% &3O& Q4FA| 3ORN3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" `<3OD% 03O& Q423 M NMR RR R R R͒]S S4< -$͒ K/S S 4S S43" 4S S4DRN-$͒ K[S S 4eX@X@X@\@\@\@`@`@`@d@d@d@h@h@h@e@$@0v@@@@w@@X@`x@@x@u@@ܕ@ g@e*Kven-USKa vn : c 4NChart 2 U!]:@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHL0(  LJ3d23   MR R R RI3~S S4 3Q):" 6Undesignated fund balanceQ) ;"" Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q):#  DesignatedQ) ;## Q ; Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q):$ ReservedQ) ;$$ Q ; Q3_ M ff6 f d@"B  ` MM<R R R RjVS S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FA 3OMT3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" * . C3O,% 03O& Q423 M NMR RR R R R͒]S S4<-$͒ K/S S 4S S4S S4DMT-$͒ K[S S 4eX@X@X@\@\@\@`@`@`@d@d@d@h@h@h@ec@A@d@g@C@@c@h@D@@c@d@<@b@K@(@]@e*Kven-USKa  ; JTextBox 4"lfPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK! vϳdrs/shapexml.xmlUn0?'R?dR:H/Ee C%Y[wp/qՒӛN 6Z2RWZ":*&9rKo_]e2ʕ6B(#+,lKr694˨2l8E5UvŹ 3Fϸȩp!()ԹXd0)XgƟ /1^~~}}1Ai4WѺ0 »zm Y.0b@'К`\'"r Edy]>ϯFiH6NuI!m"C9W F{jAhZJy׷1 81p@.ʩ GX7G=7 &R%>\]<}f}$\1Rrf!/.[wR49WƗ/PK!L0$drs/downrev.xmlT_O0M5M:lsRj $Z--i+![wQ J t; ^X|>dhA`/sSrJ~cX!u:줱05!\U8+ZpCAl3VȮbxZ-mIU3E/MVp{~eK> K mCS M5֬0=Kk&b:0 O Y8A+q%8M~Ya8PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-! vϳ)drs/shapexml.xmlPK-!L0$ drs/downrev.xmlPK[2!` $];`  < Commentary:<& vn < c 4NChart 6!|!]<@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHP0(  Ph3d23   MR R R RI3~S S4 3Q):" 6Undesignated fund balanceQ) ;"" Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q):#  DesignatedQ) ;## Q ; Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q):$ ReservedQ) ;$$ Q ; Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4D$% 03O& QR RS S4$% 3O& Q4FA% 3OLT3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43"   C3O% 03O& Q423 M NMR RR R R R͒]S S4<r-$͒ K/S S 4S S4S S4DLT-$͒ K[S S 4ed@d@d@h@h@h@eD@@B@+@@=@e*Kven-USKa >@U͒ʒ ggG f2ɀ &D\6  dMbP?_*+% &?'?(?)?Mhp LaserJet 1320 PCL 5C odXXLetterDINU"0lP|&0SMTJ hp LaserJet 1320 PCL 5InputBinFORMSOURCERESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]Arial4Pd?JOE.HEFFERNAN<Automatic>R 44600dpidPrint driver host for 32bit appType new Quick Set name here-splwow64.exeC:\Windows\splwow64.exe"ZXX333333?333333?&<3cU} &   j Z:7CITIZENS' GUIDE TO LOCAL UNIT FINANCES - City of Sample i  @  J   ? (n*"@#@$@% % ZKVSFor more information on our unit's finances, contact ENTER NAME at (XXX) 111-2222. < r m%% mat Z (  n U c 4NChart 2]U@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHT0(  T3d23   MR R R RI3~S S4 3Q):, AssetsQ) ;,, Q ;++ Q3_ ff6 MM   dR R R R+ Q  K"#S S4ES S 4 3Q):- *Actuarial LiabilityQ) ;-- Q ;++ Q3_ 3f MM  !!dR R R R+Y  K"#S S4ES S 4D$% 0&3O& QR RS S4$% &3O& Q4FAw 3O)L3 boR RR RV VdN& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" ; G3O7% 03O& Q423 M NMR RR R R R͒]S S4<3 -$͒ K/S S 4S S4S S4D)L-$͒ K[S S 4e@@@@@@B@B@p@p@@@@@e@4@@@@@@@̒@@`@e*Kven-USKa vn V c 4NChart 3Z & ]V@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHX0(  X333d23   MR R R RI3~S S4 3Q):2 AssetsQ) ;22 Q ;11 Q3_ ff6 MM   dR R R R1 Q  K"#S S4ES S 4 3Q):3 *Actuarial LiabilityQ) ;33 Q ;11 Q3_ 3f MM  !!dR R R R1Y  K"#S S4ES S 4D$% 003O& QR RS S4$% 03O& Q4FA{ 3O!T3 boR RR RV VdN& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" 6 ! C3O8% 03O& Q423 M NMR RR R R R͒]S S4<+ -$͒ K/S S 4S S4S S4D!T-$͒ K[,S S 4e@@@@@@B@B@p@p@@@@@eh@@I@$@Y@@c@@e*Kven-USKa vn W c 4NChart 5!]W@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PH\0(  \333d23   MR R R RI3~S S4 3Q) ;AA "Structured debtQ) ;AA Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q) ;BB >Employee compensated absencesQ) ;BB Q ; Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q) ;CC J#Landfill closure & postclosure careQ) ;CC Q ; Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q) ;DD $Uninsured lossesQ) ;DD Q ; Q3_ M ff6 f d@"B  ` MM<R R R RjVS S4ES S 4 3Q) ;EE <Other claims & contingenciesQ) ;EE Q ; Q3_ M 31 f K@"B  ` MM<R R R RtDS S4ES S 4D$% 003O& QR RS S4$% 03O& Q4FA(w 3O 3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" x  B 3Ox % 03O& Q423 M NMR RR R R R͒]S S4<z-$͒ K/S S 4S S4S S4D -$͒ K[S S 4eX@X@X@X@X@\@\@\@\@\@`@`@`@`@`@d@d@d@d@d@h@h@h@h@h@ePy@d@M@Pw@e@M@Pu@f@M@@ g@M@@@h@M@e*Kven-USKa vn X c 4NChart 6 s5!5]X@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"XX333333?333333?3&<3PH`0(  `33l3d23   MR R R RI3~S S4 3Q):A "Structured debtQ) ;AA Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q):B >Employee compensated absencesQ) ;BB Q ; Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q):C J#Landfill closure & postclosure careQ) ;CC Q ; Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q):D $Uninsured lossesQ) ;DD Q ; Q3_ M ff6 f d@"B  ` MM<R R R RjVS S4ES S 4 3Q):E <Other claims & contingenciesQ) ;EE Q ; Q3_ M 31 f K@"B  ` MM<R R R RtDS S4ES S 4D$% 003O& QR RS S4$% 03O& Q4FA_w 3O 3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" v B 3Ov s% 03O& Q423 M NMR RR R R R͒]S S4<W-$͒ K/S S 4S S4S S4D -$͒ K[S S 4ed@d@d@d@d@h@h@h@h@h@ec@ G@-@b@@H@-@e*Kven-USKa   Y J(TextBox 1"xrPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!:9誽drs/shapexml.xmlUn0?'ȱ`)h hpQIK3)M g۝dÍmirSUFr|uCuLULhs_vɘ*lk(KfuHӬʰ-"qpV5.v[=B|T-ìԢgr.渄jFt@G<E2?t}KR C3AN=ږHVSJ9ѨW jhMѐ$Iht F?i ClWU5 hL50_J9M$bgP$%rx @}%L$xDƺ\_L`^:Om~Z8B բ!>" >0dDN ?AAH."[Hx04`ʟp2dy*cyug$KN@A4x ġ5[@ hGPSmt %xB "PO 5(Z}l6]dS^/ jR5;`i)_ְ3\í+.ta^J̷((H`su :d$\1Rrgwb'7x VX1?TPK!/MD&drs/downrev.xml\P]O1|7?4k⛴!ƈ A^K-i+w{;;3q+WΗpheMKsX}= L**k0 Y2ME^J ߲;epYE4uFs]шjQPz).4nux~]G3s< WrgDžmV d7M9D@ƕḂi1)0BSM,;֙8[sc V'2,*p&xirAb1Gugmrֶ\Qt} rlPK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!:9誽)drs/shapexml.xmlPK-!/MD&drs/downrev.xmlPKg3!k$]Y`  < Commentary: <& vn Z c 4NChart 7  ]Z@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHd0(  d#3d23   MR R R RI3~S S4 3Q:+  12/31/2008Q# ):/ :5 :: Q#)):*:0:6Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q:+  12/31/2009Q# ):/ :5 :: Q#)):*:0:6Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4D$% 003O& QR RS S4$% 03O& Q4FAV 3O #u3 bR RR RV Vd& ! u,k K.(KQRS S43* & ! ! R Ru,u,-$͒S S4523 M  MR R͒n]S S43" ED3OF% 03O& Q423 M NMR RR R R R͒]S S4<` -$͒ K/S S 4S S4S S4D #u-$͒ K[S S 4ePensionsPensionsOPEBOPEBGSum of all pension & OPEB plansGSum of all pension & OPEB plansei?ovn? ?*p#?^׆W?V3C?e*Kven-US Ka >@U  gg|G f2ɀ $%.6>wFG  dMbP?_*+% &ffffff?'ffffff?(?)?M\\sout-print1-vm\SOUT-3rd-WestS odXXLetter (8.5 x 11")PRIV0''''D\KhC3ySMTJXerox WorkCentre 7675 rev 2.0 PSLeadingEdgePageSizeLetterPageRegionDuplexDuplexNoTumbleResolution600x600dpiD1NRX vd  ,MSCFG ,90R^;//Uncompressed-Data//.d ^;CK[ pT>%i@8 l6&pִqɏ `~ q`m)V%Zy-Ψ:ӱh2ӱS2鴌c;;ܷO佽wv}{ݭoXr |56ڤܷP\!E(⪒Bd d* 8R.bौ\øBpC*\J/@T[$!OF]w >? 8fc I[7߷+} n|+gp(~,n!')%rG}{6 g}6F1ظn{CF=_f[~!aƿ1uSzcA];C:WWIk>|lCլ  (25W)l1ྪ4̕\~*|2[t٪˯=W=_7\ &õp g|КM|KZs͂0^ G#U1d.uaSWtKF{77m6+{lwؠ G .,mj8=|:/ Mt.nAVԸy-t.ߖ^*dE}G='O}\k `37b3>9)oJz{䓿7VRBIȝԋard.Rf>  3A({#2׊IWz"xS+ݎy@_d>*}ansIJm ky } Z{uv#kJW-ݥ_feRevPɪ"/SmW2(6Ѧ4ž"ҷix@V1%Z_pTAD1%.^_AߝN`*. /Z:,GD.^3WMsn'a-xbAz %+vgVNrKX{030+CTJT/A^w0_;2FNpwu&+"zX}1A5 f{-lؗ]Vc`#1wzšky[撼57 \&/Fea&C>] zxUeW>KaدarjԼ6Bj05(7#{_;z 4/¼¸ F,+xUk [v~*i:YDWx@|VVLz2%iyrPkc8VxTS:?汄G72^q~.:}u+TA_!rW8a=F\}NQzTq-trی O納SA^1?ֺ΀!嶎ӘG/$çu4"0u.^-a{/Et\ҝ<?mx VBfQ/ T0WZ@'u4*[I-n[ڈkG )ngr */g yq&+)DY3ę8e)4%%d3q)q&+m|3J31M`C8Ӝ8JȄwR<%d8ӠbBY3SLVGK)9ٯ_KYkk)~~-eկ-Hk-&Vf_;3ů\~_vr9C>s(cz!9q/%)qx<(KXO :{0dO<HX:@YDSk93vH#`A5)cm)qo;88&QX`_vNq7rmnmvԒZԃI_2Zaw?xsiĿ߷+ǃŔҮ\M4veѮ%IY=B飾E|RLR.;\(r2\8s%<ɬjzf^̇GӓQsfcɲuO/WPRΌh2SƉcpL'!E2}2[O'RO~gh:pm@z-73k20Ǘfebq}=C*"}O$Nfa5zd&ѫr4^|&7 h' p&ʊ]r7pv^vɝ~ -=Hq_:v8YXS_8pA};u a=ȆBo+ޗcj>zkc9.~ EBݰP[TSiǐ kᇎxL.["%&TمgrF_M?[L(##ޫ0hD+ ;^COM5Joe.Heffernan  o "dXX333333?333333?&<3U} 0} U!} 8 }  8   D                                D D DDD@ ZDH@ZDL@ZDP@ZDT@ZDX@Z D\@Z D`@ Z  Dd@ Z  Dh@ Z  CC ~ @Y@  Y~ Y@  Y~ Y@  Y~ Z@  Y~ @Z@  Y~ Z@  Y~ Z@  Y~ [@  Y~ @[@  Y~ [@  Y~ [@  Y~ \@  Y~ @\@  Y~ \@  Y~ \@  Y~ ]@  Y~ @]@ ~ Y~ ]@ } Y~ ]@ | Y~ ^@ { Y~ @^@ z Y~ ^@ y Y~ ^@ x Y~ _@ w Y~ @_@ v Y~ _@ u Y~ _@ t Y~ `@ s Y~  `@ r YDl~****************************  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? ~ @`@ q Y~ !``@ !p !Y~ "`@ "o "Y~ #`@ #n #Y~ $`@ $m $Y~ %`@ %l %Y~ &a@ &k &Y~ ' a@ 'j 'Y~ (@a@ (i (Y ~ )`a@ )h )Y ~ *a@ *g *Y ~ +a@ +f +Y ~ ,a@ ,e ,Y ~ -a@ -d -Y ~ .b@ .c .Y ~ / b@ /b /Y ~ 0@b@ 0a 0Y ~ 1`b@ 1` 1Y ~ 2b@ 2_ 2Y ~ 3b@ 3^ 3Y~ 4b@ 4] 4Y~ 5b@ 5\ 5Y~ 6c@ 6[ 6Y~ 7 c@ 7Z 7Y~ 8@c@ 8Y 8Y~ 9`c@ 9X 9Y~ :c@ :W :Y~ ;c@ ;V ;Y~ <c@ <U <Y~ =c@ =T =Y~ >d@ >S >Y~ ? d@ ?R ?YDl*******************************@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ~ @@d@ @Q @Y ~ A`d@ AP AY ~ Bd@ BO BY ~ Cd@ CN CY ~ Dd@ DM DY ~ Ed@ EL EY ~ Fe@ FK FY~ G e@ GJ GY ~ H@e@ HI HY ~ I`e@ I IY ~ Je@ JH JY ~ Ke@ K@GK@ LF~ M i@ ME MY~ N`i@ ND NY~ Oi@ OC OY~ Pi@ PB PY~ Qi@ QA QY~ Ri@ R@ RY~ Sj@ S? SY~ T j@ T> TY~ U@j@ U= UY~ V@i@ V< VY~ W`j@ W; WY ~ Xj@ X: XY ~ Yj@ Y9 YY ~ Zj@ Z8 ZY ~ [j@ [7 [Y ~ \k@ \6 \Y ~ ] k@ ] ]Y ~ ^@k@ ^ ^Y~ _`k@ _ _YDl***********&******************` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ ~ `k@ `5 `Y~ ak@ a2 aY~ bk@ b4 bY~ ck@ c3 cY~ dl@ d dY~ e l@ e2 eY~ f@l@ f fY~ g`l@ g1 gY~ hl@ h0 hY~ il@ i/ iY~ jl@ j. jY~ kl@ k- kY~ lm@ l, lY~ m m@ m+ mY~ n@m@ n* nY~ o`m@ o) oY~ pm@ p( pY~ qm@ q' qY~ rm@ r& rY~ sm@ s% sY~ tn@ t$ tY~ u n@ u# uY~ v@n@ v vY ~ w`n@ w" wY ~ xn@ x! xY ~ yn@ y yY~ zn@ z zY~ {n@ { {Y~ |o@ | |Y~ } o@ } }Y~ ~@o@ ~@BtX******************************      H~ @ o Y~ @ o Y~ @ o Y~ @ ??P***lS S  S S 3S s7  7    S e>@A   gg Oh+'0HPh Joe.HeffernanJoe.HeffernanMicrosoft Excel@/("@`"@p&4՜.+,0  PXx  Plante & Moran, PLLC  Instructions Data InputRevExp Position ObligationsF-65 Cross-walk)Instructions!Citizens_Guide_Instructions'Data Input'!Print_AreaExp!Print_AreaObligations!Print_AreaPosition!Print_AreaRev!Print_Area'Data Input'!Print_Titles  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F?`BWorkbookHSummaryInformation(DocumentSummaryInformation8