Home

Budget Explorer User Guide - Fiscal Crisis & Management

1. 47 23 2 FOD UP THE DUC estem rem a ge RC ae to 48 3 0 COME xt Eel psiiesicdtu e etat ls b mais beds dais Tuc totes maldad luu dole ep cM Men ad ysis 50 SN BEND E EDT 50 4 Workims withipEo JeCcUOn ee perdita den EE MEINTE T R 52 At Operations WLM PLOT CLIO eco d oot te oo PE Ra eb Us Duce Ia pARME Tu he II S eben pui ia until 52 d LpCreatne a New ProjecuOniie se diei bri eoa Fat Ve eue uo se brleo etate fat veau oae uae 53 d LC OD Pro ec iOi aa aa na 58 EE OE Oa E E 60 dL 4 Rename Projeccion dd abris budget Nl te onte Malta dca dq Nu tus obidds 60 A Ale Mabe PrO CUO osi ati tete a a fes A uU PIEUDE reae ieu 60 TIO O eLA E E E entente entier MM A EE 6l 21 7 Remove proe MOM siina E a e 62 42 Welcome to Budget Explorer SCECON roit oS iras a dente aces 62 2 9 Projector Aduse otia R dudiesa Du ETE ndo apa nt leido asa NUTS EuR 63 A Toes UTddt E E KES bee ee ae NORA ete NOE E uo PEE A E Ue DNA aA DEM LEE LM Eia 64 2 5 Individual Resource SCEGED 2n DR Ue eas queen noses eects 65 dO PTOIE CHOR UN Si eot eat ap ie seo nte mete oreste ed nai bere tinea eese HUE 67 ZO ADDV TOS RUNES 2 5 ce atu metido Cae desta tutu uae iah sda CA uae dep IRA tu CUP 67 AST wisivPAN BUSVIVI IUBE T OT TI NT 70 Ak View L Enrollment for Districts siete nete p dien ro md exe e de ostendentes daa eus 71 4 7 2 View 2 stating by Grade for Districts o Sie ero et on ro Id Ore ect aas 75 4 7 3 View 3 Staffing by Resource for Districts esee 78
2. projection Simply select a user from the list and click on Change button If you decide not to change owner this time click on Return to Projection List button Notice if you change owner of the projection you will have no access to the projection anymore 4 1 7 Remove projection Select the projection from the projection list see Figure 4 1 on p 52 and click on Remove Projection button A warning massage will appear Click OK to delete projection or Cancel to keep the projection in the list 4 2 Welcome to Budget Explorer screen Welcome to Budget Explorer screen is displayed when you first create or retrieve a projection see Figure 4 9 on p 63 Overview of main modules and icons explanations is presented at this screen There is a link to Projection Adjustment page see chapter 4 3 63 Figure 4 9 Welcome to Budget Explorer screen Projection Title Link to the list of Base Year_ projections ABC Unified Preliminary budg t Base Year 2011 2012 Welcome Ajit Proffction List logout BudgetExplorer FCMA 1 Home 2 Rules 3 Enr ADA Staffing 4 Salary Forecaster 5 Revenue Limit 6 CashFlow 7 Auto Balancing 8 Tools 9 Reports gt ABC Unified Preliminary budget 2012 Projection warning messages 7 13 2011 2011 12 Object 8011 Cash Flow Distribution Schedule with Deferrals s Please note that the Salary Forecaster Rule has been applied in one or more I resources Nov Dec
3. HW Health amp Welfare Benefit Increase 0 00 0 00 0 00 g Tier I Tier I Programs 0 00 3 20 2 70 p TierIl Tier II Programs 0 00 3 20 2 70 yi Tierll Tier III Programs 0 0096 3 2096 2 7096 ig CustAmt Custom Amount 0 00 0 00 0 00 y Cust Custom Percent 0 00 0 00 0 00 CustlAmt Custom One Time Amount 0 00 0 00 0 00 v Cust196 Custom One Time Percent 0 00 0 00 0 00 ManInput Manual Input 0 00 0 00 0 00 g PRO Proportional 0 00 0 00 0 00 Zap Zero Out 0 00 0 00 0 00 Enr Year to Year Change in Enrollment 1 25 1 05 0 02 y RL ADA Year to Year Change in RL ADA 0 0096 0 7896 0 02 a Note One click on the desired rule name to enter Edit View mode The value for the Base Year is displayed for information purposes only Excluding Statutory COLA The projection variables listed below reflect information gathered from the LAO School Services of California and economic indicators from federal state and local sources FCMAT cautions that these figures are estimates which are subject to revision at any time Please carefully review all projection variables to ensure that they are appropriate for your K 12 funding perspective and economic outlook When user creates User Defined rule its name and description should be entered as well as some options see Figure 3 24 User should set some options to define rule properties Different combinations of options available allows user to create any kind of rule Options for User
4. amp Jul Budget Projected Revenue Limit Sources 8010 8099 4 637 968 14 49 612 95 Federal Revenues 8100 8299 380 293 00 0 00 Other State Revenues 8300 8599 1 048 315 00 16 296 35 Other Local Revenues 8600 8799 401 286 00 0 00 Interfund Transfers In 8900 8929 0 00 0 00 Y Financing Sources 8930 8 Ta Disbursements to edit value Certificated Salaries 1000 1999 3 482 628 00 5 IER Classfied Salanes 2000 2999 1 046 948 00 31 408 44 Employee Benefits 3000 3999 1 098 170 00 32 945 10 Books and Supplies 4000 4999 189 894 00 28 484 10 Services and Other Operating 5000 5999 481 359 00 37 016 51 Capital Outlay 6000 6900 0 00 0 00 Other Outgo 7000 7299 35 000 00 0 00 Direct Support Indirect Cost 7300 7399 8 961 00 0 00 Debt Service 7430 7439 0 00 0 00 Interfund Transfers Out 7600 7629 0 00 0 00 Al Other Financing Uses 7630 7699 0 00 0 00 Total Disbursements 6 325 038 00 234 332 99 Revolving Cash Account 9130 1 000 00 Cash with a Fiscal Agent Trustee 9135 0 00 Accounts Receivable 9200 0 00 Due from Other Funds 9310 0 00 Total Assets 1 000 00 ey To input Actuals for Receipts navigate to Receipts Object Group screen by clicking Object group link on the left column and in the Object Group screen edit values see Figure 4 37 Figure 4 37 Cash Flow Detail Data Input Mode Receipts Resource 0000 Unrestricted Object Group 8010 8099 Revenue Limit Sources Resource 0000 Unrestricted Object G
5. 11 000 1 000 12 000 Year 2 41 Step 1 First rule is applied 12 000 10 1 200 growth Step 2 Intermediate total for next rule 12 000 1 200 13 200 Step 3 Second rule is applied 13 200 2 000 15 200 In Case 2 Custom Amount rule was calculate first and Custom Percent rule was calculated second In Edit Rules for 4700 Food screen see Figure 3 21 Custom Amount rule is the first in the list and Custom Percent rule is the second in the list Figure 3 21 Example of rule influence case 2 Edit Rules for 4700 Food Applied Rules Base Year Year 1 Year 2 Te 2011 12 2012 13 el Commands Custom Amount 0 00 1 000 00 2 000 00 7 Kaa wv Custom Percent 0 00 10 0000 10 00 hay Remove all Rules Object Detail 4000 4999 Books and Supplies Commands fy Add Objects Historical 1 Base Year Year 1 Year 2 iM 2010 11 2011 12 Rules 2012 13 2013 14 cash Flow Notes Del Textbooks and Materials 4100 467 425 00 fe 53272212 604 280 98 Books and Reference Mat ls 4200 4 117 00 S 71400 f 73900 762 06 Jj Materials and Supplies 4300 483 38000 fe 44 4292 45563116 T Noncapitalzed Equipment 4400 70 240 00 A S 59 200 54 6104796 7 Food 4700 0 00 fes 12 100 00 15 510 00 D 7 Books and Supplies 4000 4999 1 025 162 00 962 720 00 1 046 604 58 13723216 Calculations made by Budget Explorer for the case 2 are shown below Year 1 Step 1
6. 5 144 130 481 87 amp Tiam r21 78 5 125 118 521 80 Cartfcatad Sabres 1000 1508 i 15 064 000 13 118 083 00 5 1211 8 091 00 13 118 093 00 bh g Cussfied Salaries 2050 209 SIE j 55 516 75 00 sss rs100 ssmmuo E Employee panefite 3000 3989 2 amp 00820445 S 25 230 178 00 i 25 290178 00 S eo Books amd Suppbes 40 9 176556144 4 614 565 00 5 A4614 566 00 aiia a Senes and Other Operating 5000 5999 3 147 501 05 5 AALESAL UT OO i 44 354 817 80 3 AAESS 108 15 i Canta Outlay gdi ajoa Hih 1 055 171 00 3 1455 171 00 18517100 e Other Dutgo 7000 7299 2931600 5 20 000 000 00 5 20 0000000 00 5 mouw gr Drect Support Indrect Cost 7300 7399 daaa 23754 1600 2874060 pee A el Debt Serice 7430 7439 onm 2 234 555 00 223455500 114950 Ti Total Expenditures S anager 117 951 297 00 5 ULSSVRLAD S Lora Meere prece eei mE apii BOR aaam 80 000 00 OOO 80 000 00 g Interfund Transfers Qut 7600 7629 sse cra 0 00 5 ao 5 1 00 T Al Other Financing Sources agai 897a Loo 0 00 C60 0 00 T Al Other Firrancng Uses 7530 7600 5 eum s 0 00 5 om 3 O00 gr Contributions Edit Values anai apaa Ja0T S 17 137 420 00 47 137 420 00 3 17177 a Total Other Anancny Sources leas 3 5 742 055 45 17 057 420 00 47 057 420 00 17 057 420 00 g Net increase Decrease in Fund Balance 5 10 800 865 71 g 10 818 125 02 5 21 607 46585 278 879 193 55 DARREN Fon
7. Books and Media for New School Libraries or Major Expansion of 6300 ie School Libraries 6400 Equipment 6500 Equipment Replacement 4106 Custom Object 106 Attention Remember to review results of auto balancing carefully to be sure all changes are adequate and new object values are acceptable 4 11 1 2 How to change auto balancing order Auto Balancing tab opens Auto Balancing screen Right side of the screen contains two management blocks see Figure 4 56 on p 106 Auto Balance Object List and Auto Balance Exception Resource List Figure 4 56 Auto Balancing management Auto balance order Enter object or Auto Balance Object List management object range NE You may enter object code s or range s in either of these formats Delete icon to remove object or object range e 4000 e 4000 9999 5200691 Unnecessary values can be removed by clicking the 5 image Objects order for auto balancing Reset auto balance object list to default ae Save List Reset List To Default Exception resource Autobalance Except Resource List list management Auto balancing is set to 8980 object only Enter resource NE the following list of resources You may enter resource code s or range s in either of these formats e 65000 e 72300 e 72400 e 4000 e 4000 9999 e 15 Delete icon to T7 pe remove resource Unnecessary values can be removed by clicking the 5 image Save L
8. E a Calk Se PET Ene aTh T Temm WT T Cam acteais data can be uploaded ekectronicali Tul Aug Sep Det Nov Dec Jan Feb Mar Ape May Jum Accraals Cash Flow screens are more spresdsheet Eke Username i l Data can be exported to the state s SACS software 4 P sw ee P mA ooi oo unes ce ex ES Password On behali of FCALAT thank you for your continued use amd support of Budget Explorer v 4 0 Multi Year Financial Projection and Cash Flow saltware A Zap Al nie can be wed to sunset entre resources Performance acceleration BEv5 was recreated from the ground up to take full advantage of the lates advances m appbcation database and hardware technologies Remember My Password Anthony L Bridges Cenified Fraud Examiner Depoty Executive CHficer Fiscal Crisis amp Management Assistance Team Improved user experience BEv5 n more weer fnendly than ever and offers a cleaner user mierface H also has more extensive help facibbes and now rans on such web browsers Fecho Chrome and Internet Explorer Pd Bee to about Budget Explorer As you can see the BE login screen allows you to either log into Budget Explorer or request an account in the system Because BE is a secure system you must first establish an account before you can begin working with the software Click on the Request an Account link A screen simil
9. K 3 CSR This rule 1s used for 1300 resource only Out year calculation Current K 3 Enrollment 0 95 SSC CSR 3 2 6 Applying rules 3 2 6 1 Rule Sets There could be several rule sets in Budget Explorer At least one FCMAT Default Object Code Rule is available and set as active User can enter Rule Sets page by clicking Rules Management Tab and Projection Rules button see Figure 3 11 Figure 3 11 34 FCMAT Budget Explorer v5 0 Tab to access rule management buttons My Profile Users LEA s Code Management Rule Management St Avg RLs Modify Content Projection List J Base Yea pA Rules Cashflow Rules Object Rules Tab to review modifyrule sets to review Tab to review modifyrule sets rule sets Search Criteria Z All Ot J F Tab to review modify LL to Seti ail 3 cash flow rules default b rules Rule Sets page has a list of available rule sets Active rule set 1s checked There are several buttons to perform various operations see Figure 3 12 Table 13 Rule Set buttons Button Edit Ruleset Delete Ruleset Add Ruleset Edit description Add Copy Share Activate Description Purpose Edit title and default rules settings for selected rule set Delete selected rule set Creates new empty rule set Edit description for selected rule set Makes copy of the rule set that 1s highlighted by mouse click selection Share selected rule set Selected rule set will be used by default for new pr
10. MS Excel for reports Adobe Acrobat Reader for reports 2 Getting Started with Budget Explorer The system requirements to use Budget Explorer are few and you must first obtain an account before you can use BE System Requirements Budget Explorer requires use of Internet Explorer IE v 8 Firefox 3 54 Chrome 5 or Safari 4 and screen resolution should be set to 1 024 by 768 pixels or higher for best viewing 2 1 Obtaining an Account on Budget Explorer User must first obtain an account before you can use BE A unique user account assigned by FCMAT provides access to the BE Web site User account is password protected ensuring that budget forecasts are safe confidential and cannot be accessed by unauthorized users Follow the steps outlined below to obtain an account Run Internet Browser and go to https www budgetexplorer org A screen similar to the one shown in Figure 2 1 on the next page will be displayed Figure 2 1 The Budget Explorer Login Screen FCMAT BUDGET EXPLORER v 5 0 ASSISTANCE TEAM Multiyear Financial Forecasting Software for K 12 School Agencies CSIS California School Information Services Budget Explorer Update NEWS Wath the mirodocton of verson 5 Budget Explorer BEv5 packs 2 10 4 2010 20 0 Object 011 Cash Fine Distribunon Shedule with vanetv of powerfal new and upgraded features defers Easter Deferral performance and c more user friezully than ever Sign In ew and upgraded features
11. Below are specifics about Cash Flow Revenue data is broken down by individual resource and object Object 8011 Revenue Limit funding is automatically distributed by month in accordance with the rules set forth by the applicable schedule A B C or D All Revenue Limit deferrals are automatically calculated in accordance with the latest information relative to state budget and revenue limit apportionment Expenditure data is broken down by major object range 1000 s 2000 s etc A lookup is performed for each and every object creating a default cash flow distribution based upon unique resource object combinations These distributions are based upon valid resource and object combinations tied to unique cash flow characteristics associated with that particular federal or state funding resource Cash Flow tab opens Cash Flow overview screen see Figure 4 32 88 Figure 4 32 Cash Flow Overview screen Upload actuals to Cash Flow cash flow Commands 4 Upload Actuals H Save changes Help ij Fix Variances You are working in Detailed Data Input Mode Switch to Aggregate Data Input Mode Click to reset Create new projected or actual cash flow NC amounts to zero 2012 13 Create 2013 14 2014 15 Reset Values to Zero Schedule Review Applied Schedules x Excel Jul Aug Sep Oct Nov Dec Jan Feb Mar Budget Projected mue ME Create Excel report Poesia 1 566 277 60 for the current page Revenue Limt
12. Date from 4 27 2007 to 4 27 2007 Resource Object Year Old Value New Value Changed Changed On By 3310 4300 2007 08 4016 36 2007 04 27 Ajit Mandal 12 46 14 3310 5800 2008 09 776950 78 758741 00 2007 04 27 Ajit Mandal 12 46 14 3310 5800 2007 08 774353 24 758741 00 2007 04 27 Ajit Mandal 12 46 14 Auto Balancing Report shows following information e Resource column shows Resource Code s which were balanced Object column shows Object Code s which were changed Year column indicates in what year value was changed Old Value is the value of the object before modification delete New Value is a new value of the object after modification adding Changed On is date and time of change Changed By name of a person who made this change User may select several reports simultaneously They will be generated in one file 125
13. First rule is applied 1 000 growth Step 2 Intermediate total for next rule 10 000 1 000 11 000 Step 3 Second rule is applied 11 000 10 1 100 Step 4 Total 11 000 1 100 12 100 Year 2 Step 1 First rule is applied 2 000 growth Step 2 Intermediate total for next rule 12 100 2 000 14 100 Step 3 Second rule is applied 14 100 10 1 410 Step 4 Total 14 100 1 410 15 510 Notice that results of calculations for case 1 and case 2 are different due to different order of rules only 42 There some rules assigned to objects object groups and Revenue Limit lines by default These default rules are set by Budget Explorer administrator and are assigned to corresponding items every time you create projection If you fill default rules are incorrect you may remove them see item 3 2 6 4 or change their values there are some exceptions 1 e rules you can not delete e g RevLim rule which affects Revenue Limit calculation 3 2 6 4 Remove rules In case you need to remove rule s applied go to Edit Rules for screen see item 3 2 6 2 on p 37 click on button on the right of the rule You may remove all rules simultaneously by clicking on Remove All Rules button see Figure 3 22 below Figure 3 22 Edit Rules for screen Remove Rule button Edit Rules for 4100 Textbooks and Materials Applied Rules Year to Year Change in RL ADA 0 0096 0 7895 0 02 California
14. Form O together with all of the enrollment categories and associated revenue calculations that are unique to county offices Creating a multi year projection for a county office has never been easier 1 1 4 COE External Business Services Uses As the list below indicates Budget Explorer is a reliable tool for county office external business services staff members to use for keeping track of school district fiscal positions When authorized county office external business services users log into BE they are greeted with projection folders for each of the local school districts within their county jurisdiction organized alphabetically by the names of the school districts Multi year projections created within the district named but county office owned projection folders are private visible only to the authorized county office staff When necessary special flags can be turned on providing district office staff with read only or read write access to their district respective projection s for reviewing and or editing The ability to spot fiscal trends before they are irreversible is a critical requirement of any county office The multi year projection component of district interim reports requires districts to submit a projection that reflects the current year plus two subsequent years for fiscal review Although these projections may not lead a county office to assign a qualified or negative certification they can provide useful informati
15. Go Autobalancing Do you want the system to balance the variance in the remaining months of the projection holding the actuals distributing the or variance for the remaining months where actuals have not been posted thus keeping the budget balanced and eliminating the variances without visiting each line item Ok Cancel Review and consider two radio button options e Adjust Budget option opens Change Budget window see Figure 4 50 on p 100 Figure 4 50 Change Budget window Change Revenue Budget x BE Budget Variance New Budget Resource 0000 Object s 8021 9 384 00 14 40 9 398 40 Result after updating 0 00 9 398 40 Resource 0000 Object 8021 9 384 00 14 40 3 398 40 Update Cancel e Go Autobalancing proceeds on balancing variance in the remaining months of projection Fix Variances button is available on the Cash Flow Overview screen In this case variances will be fixed for all objects 1n projection 4 10 6 Upload Actuals Upload Actuals functionality allows to enter actuals using data file see Figure 4 51 Figure 4 51 Upload Actuals button Cash Flow Create Commands a Upload Actuals H Sar You are working m Detaled Data Input Mode Switch to Aggregate Data Input Mode 101 Upload Actuals button opens Upload Cashflow Actuals window see Figure 4 52 Figure 4 52 Upload Cashflow Actuals Upload Cashflow Actuals x 1 What do you want to do Select action Upload a new act
16. Go Back Next gt gt Figure 4 69 Update Projection from SACS File Step 2 poste Mora from SACS File Step 2 Select Data to Import Select Data to Import LEA Los Angeles County Office of Education 2010 2011 Second interim Actuals to date 2010 2011 Second interim Board approved operating budget 2010 2011 Second interim Original budget 2010 2011 Second interim Projected totals Select a Set Of Default Rules For Objects amp Resources FCMAT Default x Previous Next gt gt Click Next to upload data 118 When the projection is uploaded successfully the Step 3 screen will appear see Figure 4 70 on p 118 When the projection 1s updated with new values you may continue working with it in a usual way changing rules values adding objects or notes etc Figure 4 70 Update Projection from SACS File Step 3 Update Projection from SACS File Click on Finish to continue working with projection Finish 4 11 5 3 Auto balancing 8091 8093 8095 objects All 8091 8093 8095 objects in Restricted resources are totaled and mapped as negative value on the corresponding object within Resource 0000 This operation is performed automatically every time any object from 8091 8093 8095 range is updated 4 12 Reports 4 12 1 Overview Reports screen 1s shown in Figure 4 71 on p 119 There are 3 steps Step 1 lists all available reports There are 2 sections of reports
17. If CertColumn and CertStep rules are applied to one object they are processed as one rule despite the order they are applied These rules are not applied one by one but as one rule with values calculated as sums of CertColumn and CertStep values Notice that even screen tip shows them as a union see Figure 3 25 CertColumn amp sStep 46 Figure 3 25 CertColumn and CertStep rules combination Object Detail 1000 1999 Certificated Salaries Commands Ej Add Objects Base Year zu Year 1 Year 2 ed kes Eh 2011 12 Rules 2012 13 2013 14 cash Flow Notes Del b wk Cert Salaries 1000 Fe 425 000 0 x Certificated Teachers Salaries 1100 fe 2320077285 23706 202 58 Cert Compensation 1101 died 000 0 00 D i Substitute Salaries 1110 f 000 0 00 Extra Duty Stipends 1120 dinis 000 0 00 Cert Pupil Support Salaries 1200 t 541 289 59 557 203 50 Cert Superv Admin Salaries 1300 Je 2567308792 275167670 F Other Cert Salaries 1900 303 671 00 ora 0 12 321 039 10 Certificated Salaries 1000 1999 26 195 642 00 CertColunn amp Step 0 48 27 761 121 88 3 3 Reports generating concept As it was mentioned above many screens of Budget Explorer have similar interface Generating reports is the same for every screen where reports are available There are two types of formats you may create reports MS Excel and Adobe PDF If reports could be generated from your current screen you wil
18. Summary Version no Resource Object Detail 2 Please enter values for each of the following a Beginning Cash Balance b General Ledger Accounts i Assets Revolving Cash Account Cash with a Fiscal Agent Trustee Accounts Recervable Due from Other Funds i Liabilities Accounts Payable Current Liabilities Due to Grantor Governments Due to Other Funds Deferred Revenue 00 Previous Next gt gt Step 4 This step includes final adjustments to create a projection see Figure 4 4 e Select Fund Select a Fund from the list which shows all funds in the SACS file e Select the number of years to project Default value is 2 years though you may select any value from 2 to 5 e Enter projection title Type a descriptive name for the projection e g Anyname 1 Interim w 2 COLA 56 57 Figure 4 4 Import SACS File step 4 Import SACS File LEA ABC Unified Select fund 01 General Fund County School Service Fund Select the number of years to project forward 2 default Projection title zz Previous Next gt gt Note Funds 3 and 6 are always added to Fund 1 projection during load After making all adjustments click on Next gt gt link to proceed Step 5 This screen shows data verification notes concerning newly created projection see Figure 4 5 on p 58 Finish Cancel If you agree with notes of step 4 click on button otherwise click on button t
19. e Standard reports e System reports 119 Figure 4 71 Reports screen Step 1 Report Generator Step 1 Report Selection Select report s Standard report s BS Standard report s Standard report s O Enrollment O staffing by Grade o Staffing by Resource O Revenue Limit O SACS Form 01 CIFCMAT Report a Summary u Salary Forecaster O Resource Detail O unrestricted Cost of 1 O Resource Object With Rule s calculation System report s O Restricted Cost of 1 O projection Rules C Combined Cost of 1 O Projection Mistakes O projection Notes 1 Audit Logging Report D Autobalancing Report Review System Changes Standard OfFiscal Health Risk Analysis report s O Public Disclosure of Collective Bargaining Agreement AB1200 O Cash Flow Summary O Cash Flow Revenue Detail Step 2 customizes report Figure 4 72 Reports screen Step 2 Report Generator Step 2A Report Audit Logging Report Customization Customize report s MEIN m 7 es PIECE T DOLI NEL IUE ae ae x R F 1 i p 1 x M 4 amp L4 All Resources T Man Unrestricted Resources 2 Mau Restricted Resources _ Sort results by Resource object year O Date Step 3 customizes report orientation and notes 120 Figure 4 73 Reports screen Step 3 Report Generator Step 3 Report Confirmation A Choose your report options and confirm
20. 00 21 958 547 21958 547 00 Other State Revenues syM 550 58 455 911 00 33 2605 524 00 5 5237458500 ee 2 Other Local Revenues 8600 8759 490404 A1 815 441 00 41 555743 00 Ald 58l74 Total Revenues 5 3340494 S are ISS WA 2 Certificated Salaries 1000 1900 S poma S 11 118 00 00 5 noo 5 1218 003 00 i Cied Solara i000 2990 5 57580 983 12 55 72 028 00 5 55 775 019 00 5 95 728 019 00 Employes Benefits 3000 30097 20a S 25 17 758 00 25 H7 758 amp 00 BONIS yy S Books end Supplies 4000 4999 421411255 5 625 001 00 i 5 575 001 00 625 001 00 Sencrs and Other Operating 5000 9000 40 hbi da5 3 4 amp DOR 379 00 5 46 007 780 3 A amp DO THT 5 Catal Qutisy 6000 5000 MTT 1 051 371 00 Lo 37100 10 YDLOD 2 Other Qutga 7000 7209 f 20 931 67 00 20 000 600 00 i 20 000 000 00 70 000 000 00 Direct Support Indirect Cost 7300 7399 Mamaa o 287547600 WT IO qs Debt Service 7430 7439 1082 2 136 585 00 i 11256 5800 2 5 588 00 g Total Expenditures iwi 1421138500 10317 5240 14013 2405 ge Interfund Transfers In aon 8o79 5 mam 80 600 00 E ahdida 80 000 00 Interfund Transfers Qut 7500 2620 5450 b76 4g 100 a oo 00 g Al Other Financing Sources aon ao7a f po 00 i aw 600 g Al Other Financing User 7530 7669 Go amp 00 0 00 6 qo Contrbutions Bomn moog F Moret S 17 137 420 00 5 Ra 5 17137 4200 igh Total Other Financing Sources
21. 00 0 00 0 00 Charter Schools to calculate in lieu property taxes 0 00 0 00 0 00 0 00 Total 00 000 000 0 00 Staffing Ratios Base Year Year 1 Year 2 Year 3 2011 12 2012 13 2013 14 2014 15 K 0 0000 0 0000 0 0000 0 0000 1 0 0000 0 0000 0 0000 2 0 0000 0 0000 0 0000 3 0 0000 0 0000 0 0000 4 Spp Enter Staffing Ratios for 5 TT all years 6 0 0000 7 0 0000 8 0 0000 9 0 0000 10 0 0000 Figure 4 23 Staffing by grade page 3 option Mode switchers Calculate FTE from Base Year Values Manually Enter Staffing Ratios Start Fresh K 0 00 0 00 0 00 0 00 1 0 00 0 00 0 00 0 00 2 0 00 0 00 0 00 0 00 3 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 5 0 00 0 00 0 00 0 00 eS aan Y Enter Staffing FTE for emp _allvears 7 0 00 0 00 0 00 0 00 8 0 00 0 00 0 00 0 00 Subtotal 6 8 0 00 0 00 0 00 0 00 9 0 00 0 00 0 00 0 00 10 0 00 0 00 0 00 0 00 11 0 00 0 00 0 00 0 00 12 0 00 0 00 0 00 0 00 Subtotal 9 12 0 00 0 00 0 00 0 00 Ungraded Elementary 0 00 0 00 0 00 0 00 Ungraded Secondary 0 00 0 00 0 00 0 00 Subtotal Excluding Charter Schools 0 00 0 00 0 00 0 00 Charter Schools to cakulte in leu property taxes 0 00 0 00 0 00 0 00 Total 00 00 000 000 Staffing Ratios Base Year Year 1 Year 2 Year 3 2011 12 2012 13 2013 14 2014 15 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000
22. 12 2012 13 2013 14 Fiscal Year Close window Revenue f button Expenditun FCMAT 2005 2011 Question Sugqestion T exient Technologies Inc Close 51 If necessary you may print these graphs by clicking on Print Graph button Notice that values on graphs are calculated according to specific rules Table 17 explains how data series are calculated Table 17 Data Calculation for Graphs Graph Title Data Sum of object group Projected Revenues and Expenditures Revenues 8010 8799 8910 8929 8930 8979 Expenditures 1000 7439 7600 7629 7630 7699 Fund Ending Balance Revenues 8010 8799 8910 8929 8930 8979 Expenditures 1000 7439 7600 7629 7630 7699 Compensation vs Total Expense Compensation 1000 1999 2000 2999 3000 3999 Expenditures 1000 7439 7600 7629 7630 7699 52 4 Working with projection Projection may be created for District or County of Education Projections for County of Education are designed in Navy Blue color scheme 4 1 Operations with projections Figure 4 1 The Projection List screen FCMAT Budget Explorer 9 0 Welcome Marnie logout BudgetFxplorer FCMAT MIUII4 ERIS My Profile Eo eene ERR Projection List List of available projections e Search Criteria Search Show All Base Yea Local Education Agency Title Date Created Author Last Modified By 1 2011 12 Lagunitas Elementary E21J201A D 06 23 2011 02 51 Phnata 06 23 2011 05 50 P ajit 2 2010 11 Vallejo City Unified 2011
23. 12 Estimate Budget with low ADA D 06 21 2011 11 16 PNnata 06 21 2011 11 39 PNnata Projection settings District 01 Fund 2 Years Mouse over First interim k Projected totals question mark to Projection shares 0 RO 0 RW review projection settings Click to add Click to copy Click to change new selected owner of selected projection projection projection Edit Projection Add Projection Delete Projection s Copy Projection Rename Projection Share Projection Change Owner View 1 2 of2 Note DNible click on the desired projection to enter Edit View mode Click any column header t sort the list by that column s data Click to edit Click to delete Click to rename Click to share selected selected projection selected selected projection can not be restored projection projection The Projection List screen displays all of the forecasts that you have created Of course when you log into Budget Explorer for the first time there will be no projections in your projection list However as you work with BE your list of projections will begin to grow as you experiment with various projection scenarios If you click on any column header the blue link text at the top of any column BE will redisplay your list of projections according to the order of the column that you selected For example if you click on the Base Year column header BE will display your projections in chronological order based on the base year within the
24. 1s to click on it with left mouse button If group operations are allowed e g selecting several resources to auto balance or several reports to print etc then checkboxes are used 3 1 1 Navigation Tree Navigation Tree see Figure 3 3 on p 17 has links to display in the working area following reports e Combined Summary e Unrestricted Summary e Restricted Summary Budget forecast is displayed in SACS Form 01 format see Figure 3 3 on p 17 17 Figure 3 3 Navigation Tree Hover your mouse over Navigation Tree Click here to dock the tree icon to reveal the tree Expand collapse tree N Navigation Tree Combined Resource Summary 3 Unrestricted Resource Summary 0000 Unrestricted 1100 Lottery Unrestricted 1300 Class Size Reduction Operations Grades K 3 pr Hd 20 rrunm u 1j J E Add Resource List of Unrestricted resources 5 E Remove Resource Add Remove resource 3 Restricted Resource Summary functionality 3010 NCLB Title Part A Basic Grants Low Income and 3011 Custom Resource 3030 NCLB Title Part B Reading First Program 3031 NCLB Title I Part B Reading First Spec Educ Teact List of Restricted resources xA 3181 Custom Resource 3205 Education Jobs Fund 3310 Special Ed IDEA Basic Local Assistance Entitleme 3313 Custom Resource 3315 Special Ed IDEA Preschool Grants Part B Sec 61 3320 Special Ed IDEA Preschool Local Entitlement Par You may click on
25. 4 63 Auto Balancing log Auto Balancing for Projection Please wait until operation not finished message and Finish button will appear Operation log Resource 3345 autobalancing started Auto balancing log sess D Cancel There are report icons in the table of resources see Figure 4 62 Click on the icon will generate PDF report with information about last auto balance You may run auto balance many times after you made some changes so every time you click this icon you will see last report only Auto balance report can be generated from Reports screen as well see item 4 12 3 2 on p 123 4 11 2 Reset to default rules This operation will remove all rules within selected resource s added by a user User may select one several or all resources from the list All default rules will be restored for 113 all objects within selected resource s 1 e all user rule adjustments will be removed All object values will remain unchanged To execute this operation go to Auto Balancing screen see Figure 4 64 on p 113 by clicking the Auto Balancing tab Select the resources by clicking Reset button and click Start button to reset the rules To reset all resources click Select Reset to Default Rules for All Resources and click Start button ATTENTION after you click Start button all your rules for selected resources in current projection will be replaced by the default rules There is no way to roll back your projecti
26. 713 689 678 757 750 729 4 342 4 270 4 140 4 294 4 439 4 540 4 596 716 742 689 707 691 765 759 7no 727 7nc CaA 73 cot 7Ct 9 021 8 948 8 748 9 038 9 252 9 522 9 717 Total 9 021 8 948 8748 9 038 9252 9522 9717 P2ADA Pies Field to enter data History Detail Excluding Charter Schools 8 384 12 8 344 01 8 174 13 8 436 97 8 695 95 8 906 88 9 094 14 Charter Schools to calculate in lieu property taxes 0 00 0 00 0 00 0 00 0 00 0 00 0 00 COE CommSchs SpEd 0 00 0 00 0 00 0 00 0 00 0 00 8 174 13 8436 97 2605 Q5 2 ON6 nf 9o 094 14 Read only field editing not allowed T2 TS EEEN WERT UR 59 Enrollment Factors Excluding Charter and COE 0 9294 0 9325 0 9 Charter Schools to calculate in leu property taxes 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 There are two ways of navigation e Using Tab key to move cursor from one cell to another e Clicking at the cell you are going to edit Commands Start Fresh 780 4 743 740 ne 3 ONE 9 905 EE aii 9 903 ew 9 274 88 0 00 0 00 0 9361 0 0000 48 When you click at the cell you will see cursor in it Use Delete and or Backspace key s to Delete old value and enter the new one or edit old value The other way to enter data is to triple click the target cell The value will be marked and you can enter new value into the cell without prior deleting old value 3 5 Pop up menu All data you have access to could be changed be entering values
27. 824 869 07 General Ledger Assets Revolving Cash Account 13 Remove object from GL 0 00 0 00 Add object to GL 0 00 Cash with a Fiscal Agent Trustee 9135 Accounts Receivable 9200 4 10 2 Creating Cash Flow during SACS File import process Projection upload creates Cash Flow Step 3 of Import SACS file requires selecting revenue view 89 Figure 4 33 Import SACS file Step 3 Cash Flow Parameters Import SACS File Cash Flow Parameters 1 Which method would you prefer to use for entering revenue data By Resource and Object Best Practice Highly Recommended O By Major Object Range Summary Version no Resource Object Detail 2 Please enter values for each of the following a Beginning Cash Balance b General Ledger Accounts i Assets Revolving Cash Account Cash with a Fiscal Agent Trustee Accounts Recervable Due from Other Funds i Liabilities Accounts Payable Current Liabilities Due to Grantor Governments Due to Other Funds Deferred Revenue lt lt Previous Next gt gt There are two methods of entering revenue data e By Resource and Object allows entering revenues per each Resource Object combination e By Major Object Range allows entering revenues per Object range as total of all resources It is highly recommended to use By Resource and Object option Step 3 of Import SACS file provides opportunity to enter Cash Flow values User can adjust these
28. All unsaved changes to cell will be discarded Last saved value will appear in the cell Calculator with common arithmetic operations will appear Final result of calculations will be inserted into current field 0 00 0 00 D 0 00 0 00 0 00 0 00 t 0 00 0 00 t I 40 000 00 D 0 00 0 00 D 40 000 00 45 000 00 H Save changes Notes 3 EEBBRBEBEBBI 50 3 6 Context Help Almost every screen in Budget Explorer has reference to help file with explanations about the screen Click on Help icon which is located in Menu Bar see Figure 3 on p 15 will show you help for your current page 3 7 Graphs It is possible to generate graphs automatically from many pages by clicking Graph icon 4 which is located in Menu Bar see Figure 3 1 on p 15 If there is no such icon in Menu Bar you can not generate graph s for current page For some pages you will see buttons on graph which allow you to choose what data to map on a graph Click one of the buttons 1s there are any to see graph you need If there no such buttons it means you can generate only one graph for current page Figure 3 30 Graphs in Budget Explorer General Fund County School Service Fund Unrestricted Resources Only Resource 0000 Unrestricted Commands Print Graph Projected Revenues and Expenditures Fund Ending Balance Compensation vs Total Expense ed Select one of Print button available graphs 2011
29. Balance e 55006 Save List Reset List To Default 3313 Custom Resource Reset 3315 Special Ed IDEA Preschool Grants Part B Sec 619 Reset Balance Reinier s Facer Boda Tek 3319 Custom Resource Reset Auto balancing is set to 8980 object only 3320 Special Ed IDEA Preschool Local Entitlement Part B Sec 611 Reset Balance for the following list of resources 3324 Custom Resource Reset You may enter resource code s 65 or range s in either of these c 3345 Special Ed IDEA Preschool Staff Development Part B Sec 619 Reset Balance oss formats 3385 Special Ed IDEA Early Intervention Grants Reset Balance e 724 4000 e 81500 4000 9999 3710 NCI R Title IV Part A Drua Free Schook Reset Select Reset to Default Rules for All Resources Select Balance for All Resources Start Save List eset List To Default Click Start button p di t xception resource to start the process list management Clicking Start button creates warning message Click OK to proceed auto balancing Figure 4 39 Warning message rg says ER Please note that there is NO UNDO ABILITY after operation has completed Click Ok to proceed with operation or click Cancel to abort the operation process While auto balancing 1s running a user will see its log see Figure 4 63 After balancing all resources Finish button will appear at the bottom of the screen Click Finish button will return to previous screen 112 Figure
30. Classified Salaries 2000 2999 Employee Benefits Books and Supplies Services and Other Operating Capital Outlay Other Outgo Direct Support Indirect Cost Debt Service Interfund Transfers Out All Other Financing Uses Revolving Cash Account Cash with a Fiscal Agent Trustee Accounts Receivable Due from Other Funds Accounts Payable Current Liabilities Due to Crantor Governments Due to Other Funds Deferred Revenue 31 408 44 j Click to move 329910 value to Actual column UUU 5335 7000 7299 7300 7399 7430 7439 000 76007629 S 0 00 7630 7699 S 000 9130 200 00 9135 9200 9310 9500 amount Uncheck to cted amount Le 9590 C a 7 9610 0 00 0 00 M7 9650 29 914 80 0 00 Save Cancel Undo Changes To access Actuals for Receipts navigate to Receipts Object Group screen by clicking Object group link on the left column Click on the pencil icon on the right of the month to edit values by Month in the Object Group screen see Figure 4 41 on p 95 95 Figure 4 41 Cash Flow Detail Data Input Mode Receipts by month Resource 0000 Unrestricted Object Group 8010 8099 Revenue Limit Sources Resource 0000 Unrestricted e Select Resource Object Group 8010 8099 Revenue Limit Sources Principal Apportionment 8010 0 00 Revenue Limit State Aid Current Year 8011 3 645 709 14 o 502 85
31. Debt Service 7430 7439 0 00 Interfund Transfers Out 7600 7629 0 00 All Other Financing Uses 7630 7699 0 00 Total Disbursements 6 325 038 00 5 General Ledger Assets rr Revolving Cash Account 9130 1 000 00 Cash with a Fiscal Agent Trustee 9135 0 00 Accounts Receivable 9200 0 00 Due from Other Funds 9310 0 00 Total Assets 1 000 00 4 10 4 2 Entering Actuals by Month Entering Actuals by Month provides monthly view for all Objects It is recommended to use this screen to reset actual values to projected Detail Data Input mode allows to enter Actuals for Disbursements and General Ledger accounts Click on the pencil icon on the right of the month to input data see Figure 4 39 on p 94 94 Figure 4 39 Cash Flow Detail Data Input Mode Edit by Month link Revenus Limit Sources Federal Revenues 8100 8299 Other State Revenues 8300 8599 Other Local Revenues 8600 8799 Interfund Transfers In BB 00 B825 8010 8099 169 920 297 37 Jul Budget LAND Bop ot Projected aang Projected 1 566 277 60 Click on the pencil 34 013 836 00 0 00 i l to edit values by 77 315 8561 00 l 0 60 1 5 869 541 00 ot month o0 ag oO O0 6 00 Enter actuals for the month window will open see Figure 4 40 Figure 4 40 Cash Flow Detail Data Input Mode Enter actuals for the month r Enter actuals for the month of July 2011 x Name Object Budget Actual Use Code Certificated Salaries 1000 1999
32. Resource 0000 9999 Resource View f Delete All Object View de Delete Add New E 6oback 36 ad 3 2 6 2 Edit Rule screen Rule s may be assigned to objects object groups and Revenue limit lines If a rule may be assigned to the object you will see rule icon in that line When you rest your mouse pointer on rule icon then screen tip appears with information about rule s applied see Figure 3 16 If current item is a group then in screen tip you will see information about rule s applied to this group and whether there are some rules applied to object s 1n this group see Figure 3 16 When you print your reports see chapter 4 12 on p 118 one mouse click may include all your rules in reports to clarify calculations made in your projection Click on rule icon opens Edit Rules for screen see Figure 3 17 Screenshot on Figure 3 17 shows Edit Rules for 4300 object As you can see RL ADA and CPI rules are applied to this object The same information is in the screen tip when your mouse is hovered over rule icon see Figure 3 16 with tip for 4300 object so using screen tips 1s much faster Figure 3 16 Rules for Object Object Detail 4000 4999 Books and Supplies Commands fj Add Objects Screen tips provide information about rules applied rect code iaoa 201112 Textbooks and Materials 4100 467 425 00 S 467 911 00 484 292 84 499 405 78 Books and Reference Mat ls 4200 4 117 00 S 71400
33. Sources 8010 8099 169 920 297 37 Click on the pencil Federal Revenues 8100 8299 34 013 836 00 e to edit values by Other State Revenues 8300 8599 77 315 661 00 Other Local Revenues 8600 8799 5 869 541 00 month Interfund Transfers In 8900 8929 0 00 Al Other Financing Sources 8930 8979 0 00 0 0 0 00 20 0 00 0 00 0 0 0 0 Total Receipts 287 119 335 3 2 890 018 347825 4 858 389 17 45 893 617 11 14 366 207 85 6 055 738 79 Actual amount Projected amount iia a NEN NNNM T a Certificated Salaries 1000 1999 138 641 356 23 4 159 240 69 5 545 654 25 12 477 722 0 12 477 722 0 2 477 722 0 2 477 722 0 12 477 722 0t 2 477 722 2 477 722 06 Classfied Salaries 2000 2999 44 702 131 00 1 341 063 93 4 023 191 7 4 1917 4 023 4 Employee Benefits 3000 3999 72 795 263 77 2 183 857 91 z 6 551 573 74 E Click on the cell to Books and Supples 4000 4999 20 567 690 60 3 085 153 59 5 153 5 439 738 Services and Other Operating 5000 5999 29400 3840 226089371 y edit value gt 260 Capital Outlay 6000 6900 522 589 00 78 388 35 8 388 35 6 581 2 Other Outgo 7000 7299 84 00 000 Direct Support Indrect Cost 7307399 Click on the link to edit D 7430 7439 values by object group Interfund Transfers Out 7600 7629 5300 0 00 Al Other Financing Uses 7630 7699 0 00 0 00 5 5 Total Disbursements 307 183 667 0 108 598 18 15 669 985 69 28 476 923 24 26 789 700 87 26 789 700 87 26 895 698 37 26 789 700 87 26 824 869 07 26
34. Summary 0000 Unrestricted 1100 Lottery Unrestricted E Add Resource SJ Remove Resource 3 Restricted Resource Summary 3010 NCLB Title Part A Basic Grants Low Income z 3011 Custom Resource 3025 NCLB Title Part D Local Delinquent Programs 3026 Custom Resource 3185 Custom Resource Context menu 3200 Custom Resource for resource vita P 3313 Cus About Resource 3315 Spe Auto Balance this Resource art B Sec 3319 Custom Resource Figure 4 59 Auto Balancing for Resource screen Start Auto Balancing for Resource Resource 3310 Special Ed IDEA Basic Local Assistance Entitlement Part B Sec 611 formerly P Click the Start button below to auto balance this resource or click Cancel to return to the previous screen Please note that there is NO UNDO ABILITY after Auto Balancing has completed Click Start to proceed with Auto Balancing or click Cancel to abort the Auto Balancing process Start Cancel When the resource is balances next screen will appear see Figure 4 60 You should press one of two buttons e Report to see auto balancing report e Finish to return to balanced resource screen Figure 4 60 Auto Balancing for Resource screen Finish Auto Balancing for Resource Resource 3310 Special Ed IDEA Basic Local Assistance Entitlement Part B Sec 611 formerly P Auto Balancing has been completed for this resource Click the Report button below t
35. Time Amount Custi amp Custom One Time Percent ManiInput Manual Input PRO Proportional zap Zero Out Zap Resource Apply Rule And Go Back Projection Rules Overvien CertCOLA JassCOLA CertCoumn CertStep ClasStep CPI LOT Res LOT Unr INT NetCOLA RLDef SpEdCOLA CatCOLA StCOLA HW Tier I TierII TierIII CustAmt Cust CustlAmt Cust196 Maninput Enr RL ADA Link to Zap Resource screen Enr Year to Year Change in Enrollment Toe eI mE ILI me Aem o Mu o o o T om om I om EUER mo Apply Rule 0 0096 m Go Back Certificated COLA 0 00 Cassfied COLA 0 00 0 00 Certificated Staff Column Increase 0 00 0 00 Certificated Staff Step Increase 0 00 0 00 Classified Staff Step Increase 0 0096 0 0096 California CPI SSC 1 20 1 70 California Lottery Restricted SSC 17 50 17 50 California Lottery Unrestricted SSC 112 50 111 00 Interest Rate Trend for 10 Year Treasuries SSC 3 20 3 80 Net Funded Revenue Limit COLA SSC 5 17000 0 36900 Revenue Limit Deficit K 12 SSC 17 96300 19 60800 Special Education COLA SSC 0 00 0 00 State Categorical COLA SSC 0 00 0 00 Statutory COLA SSC 0 39000 1 67000 Health amp Welfare Benefit Increase 0 00 0 00 Tier I Programs 0 00 0 00 Tier II Programs 0 00 0 00 Tier III Programs 0 00 0 00 Custom Amount 0 00 0 00 Custom Percent 0 00 0 00 Custom One Time Amount 0 00 0 00 Custo
36. Ue A705 S 17 057 400 47 057 00 00 17 057 420 00 5 Met Increase Decrease in Fund Balance 3 Wena 10087 426 03 5 1 8546 566 05 23 142 254 55 us a o s tst Ko c amp k5s wv 5 amp o rsvr s nnn 1 UU I ILtLLAIT amp aa oon ooooedqiiooi5 e d Hard B 5 Beginning Fund Bainc 57591 5 31 262 4339 41 5 TU 425 257 88 5 1 157 811 8 5 50 285 00 Audie Adjustments wn s aw E ew ex Other Rest3temenite 8705 amp eon E 0 00 E e s 0 00 All summary screens contain Components of Ending Fund Balance that is not available on individual resource screen 4 5 Individual Resource screen This screen is available for resource view projections only To open Individual Resource screen see Figure 4 12 click the resource you need from the list of resources in Navigation Tree see Figure 3 3 on p 17 66 Figure 4 12 Individual Resource screen General Fund County School Service Fund Unrestricted Resources Only Commands Add Objects L Savechanges Graph Heip Reports jy Excel Resource 0000 Coresericced Remame Resource Tithe 4 p mU T 1 a Y Revenue Lint Sources Bol A099 3 Henini HM 5 3 es LF 2 122 514 02 x Federal Revenues 8100 0200 SO MAITAT 21998 5700 5 2L5EMLO S nsuscso e Other State Revenues wion s590 5 Jaara 57 068 740 00 55 237 500 3 SEH B o p Other Local Revenues 8600 8709 SOLID ST TO 5 assum s 44s A Total Rewer 5 14 0 DES
37. Unaudited Actuals 10 14 2010 2 07 58 PM 58 IMALAT ECN AYrTILAL NANO OFPgPIg 49 97 45 E38 m 1 Remove selected E 6n0Back Next gt gt Step 2 A new screen will appear on this step see Figure 4 3 For importing new SACS file only 55 As you can see from Figure 4 3 Budget Explorer inspects the contents of the specified data file and then display a list of all of the data types that were found within the file e Step 2a Select the desired data type by clicking its associated radio button The data 1s read from SACS file selected by the user on step 1 e Step 2b Select a Fiscal Year which will be used as the Base Year in your projection The software will always default to the current budget year After selecting data and fiscal year click on Next gt gt link to proceed Figure 4 3 Import SACS File step 2 Import SACS File Step 2a Select Data to Import LEA ABC Unified 1 2010 2011 None amp First interim Projected totals Step 2b Select a Fiscal Year to use as the Base Year 2011 2012 Step 2c Select a Set Of Default Rules For Objects amp Resources FCMAT Default z lt lt Previous Next gt gt Step 3 Set up Cash Flow by selecting data entry type and entering values Import SACS File Cash Flow Parameters 1 Which method would you prefer to use for entering revenue data By Resource and Object Best Practice Highly Recommended By Major Object Range
38. amounts on Cash Flow screen see Figure 4 34 on p 90 therefore it can be left blank or filled with preliminary data Figure 4 34 Cash Flow Parameters on the Cash Flow screen Object Code Total Receipts Ct Te Certificated Salaries 1000 1999 Balance 104 478 84 Classified Salaries 2000 2999 ID USS UU 31 408 44 Employee Benefits 3000 3999 1 098 170 00 Books and Supplies 4000 4999 189 894 00 28 484 10 Services and Other Operating 5000 5999 481 359 00 37 016 51 Capital Outlay 6000 6900 0 00 Other Outgo 7000 7299 35 000 00 Direct Support Indirect Cost 7300 7399 8 961 00 Debt Service 7430 7439 0 00 00 Interfund Transfers Out 7600 7629 All Other Financing Uses 7630 7699 Accounts Total Disbursements mp mae Revolving Cash Account 9130 Cash with a Fiscal Agent Trustee 9135 Accounts Receivable 9200 Due from Other Funds 9310 Total Assets General Ledger Liabilities Accounts Payable Current Liabilities 9500 0 00 Due to Grantor Governments 9590 0 00 Due to Other Funds 9610 450 000 00 0 00 Deferred Revenue 9650 149 574 00 29 914 80 Total Liabilities 599 574 00 7 29 914 80 Ending cash Balance 168 768 49 4 10 3 Create new Cash Flow in existing projection Cash Flow can be recreated in existing projection by clicking button Create in the left corner of the screen The Cash Flow Creation window will be displayed see Figure 4 35 on p 91 Refer to the paragraph 4 10
39. base year dollar amounts Example 1 Explanation The user has started out with a Base Year Amount of 100 000 The projection rule that has been selected is exerting 10 downward force or pressure thereby causing the Base Year Amount to decrease in Projected Year 1 and again in Projected Year 2 etc see Figure 3 8 Figure 3 8 Decreasing Rule Base Year Year 1 Year 2 Year 3 Year4 Year5 Amount 100 000 90 000 81 000 72 900 65 610 59 049 f downward pressure 23 Example 2 The user has started out with a Base Year Amount of 100 000 The projection rule that has been selected is exerting 10 upward force or pressure thereby causing the Base Year Amount to increase in Projected Year 1 and again in Projected Year 2 etc see Figure 3 9 Figure 3 9 Increasing Rule Base Year Year 1 Year 2 Year 3 Year 4 Year 5 Amount 100 000 110 000 121 000 133 100 146 410 161 051 Nw upward pressure Now Future Example 3 The user has started out with a Base Year Amount of 100 000 The projection rule that has been selected is exerting no force or pressure thereby causing the Base Year Amount to remain the same in Projected Year 1 and again in Projected Year 2 etc see Figure 3 10 Figure 3 10 No change Rule Base Year Year 1 Year 2 Year 3 Year 4 Year 5 Amount 100 000 100 000 100 000 100 000 100 000 100 000 No change Hi Future Where do the Rules C
40. buttons on the left side of the screen and below Tab Bar see Figure 3 1 These buttons could make working area larger see Figure 3 2 on p 15 Figure 3 1 Design and Navigation Concept Projection Title 74 Information about Base Year Vallejo City Unified 2011 12 Estimate Budget Base Year 2010 2011 1 Home 2 Rules Name of current page f Revenue Limit Current View is Unrestricted Current page view Salary Forecaster 6 Cash Flow 7 Auto Balancing 8 Tools 9 Reports 15 C Link to the list of projections Welcome Mamie Projection List logout BudgetExplorer ams Commands Save changes Q Help Generate reports x Excel 2 PDF Other views Restricted Unrestricted Cost Of 1 Restricted Cost Of 1 Combined Cost Of 1 Base year Unrestricted Teacher Salary Teacher Salary Data Step and Column Data Resource Salary Ratio Base Year Total Tchr Salaries 35 468 139 00 FTE Receiving a Avg Value Resource 0000 35 468 139 00 100 00 Base Year FTE 0 00 Step Increase FTE 0 00 0 001 Avg Tchr Salary 0 00 Total Base Year Unrestricted ae rage ara 000 and Restricted FTE i Notes Avg Retiree Salary 0 00 Avg New Hire Layoff Salary 0 00 Salary Forecaster Data 35 468 139 00 35 468 139 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 35 468 139 00 35 468 139 00 35 468 139 00 Tchr Sal Increase N A 0 00 0 0
41. flow in aggregate mode using default schedules Ok Cancel Attention Create new option will delete all existing data in Cash Flow Convert will summarize existing amounts by groups 4 11 Special Services of Budget Explorer 4 11 1 Auto Balancing Auto balancing helps to eliminate negative resource balances automatically This procedure works for e Restricted resources only e Resources with negative balance You should always review results of auto balancing carefully to be sure all changes are adequate 4 11 1 1 Algorithm description The algorithm is the same for any resource in the projection Algorithm consists of 2 steps e Step reduces expenditures up to zero e Step 2 increases Financing Sources 104 Figure 4 55 Auto balancing algorithm Step 1 Reducing Expenditures Select first object from List Select next object from the List Reduce object value to compensate deficit Calculate rest of deficit Rest is C22 greater Finish wan Step 2 Increasing Financing Sources Increase object 8980 to compensate deficit Finish Step 1 This step is not applied to 6500 7230 and 8150 resources Auto balancing of all other resources starts from this step 105 The procedure processes objects in a defined order Default order shown in Table 25 It always starts from 4100 object If this object does not exist the procedure checks next object from the list in Table 25 4200 430
42. for resource 0000 object 1100 CertCOLA Certificated COLA 406 CertColumn Certificated Staff Column Increase CertStep Certificated Staff Step Increase TchrStfg Year to Year Change in Teacher Staffing There are 3 options to enter staffing data e Calculate FTE from Base Year Values see Figure 4 21 A user has to enter Staffing FTE for the base year only Projected years will be calculated automatically considering staffing ratios to be constant for all years within every grade e g Staffing Ratio for grade 7 see Figure 4 21 remains 30 for all years e Manually Enter Staffing Ratios see Figure 4 22 A user has to enter staffing ratios for base and projected years e Manually Enter FTE see Figure 4 23 A user has to enter Staffing FTE for base and projected years Figure 4 21 Staffing by grade page 1 option Staffing by Grade Enrollment a Current View is Staffing by MESES page view Ober views ENDE arama buieanence arr Page message ics a M D E E NE B Race icine c eel A screen exclusively to enter teacher population data Mode switchers Manually Enter Staffing Ratios Manually Enter FTE Start Fresh 0 00 0 00 0 00 0 00 336 Enter Staffing FTE for 0 00 00 0 00 0 00 sarin troll 3 0 00 0 00 0 00 0 00 4 0 00 0 00 0 00 0 00 Staffing FTE in read only 5 0 00 oo0 m77 oo mode for projected years Subtotal K 5 0 00 0 00 0 00 0 00 6 0 00 0 00 0 00 0 00 7 0 00 0
43. gne wri Andrea McNeill vmeneill Angela Foster afoster Read write Group Andrea Stubbs astubbs27 Andrew Prestage Instructor Andy Prestage aprestage peni ne Add to Read write Angelia Nava anava Ann Cridelich acrid254 Group button Ann Peters apeters Anna Leung aleung Anna Pimentel apimentel Anne Barron AnneBarron Remove from Annie Lachance shandon Anthony Bridges Anthony Read write Group Anthony Brown abrown button Anthony Hemandez anthony49hern Anton Jungherr ajungherr April Spencer April X Return to Projection List Select a user from the list of registered users and click on the appropriate button to add this user to Read only or to Read write group see Figure 4 7 If you are not going to share the projection with someone you gave such permissions earlier then simply select that user in the list of Read only or Read write Group and click on the remove button see Figure 4 7 After making necessary modifications click on Return to Projection List button 4 1 6 Change owner Sometimes you might need to change the owner of a projection In this case select the projection and click on Change owner button You will see the following screen 62 Figure 4 8 Projection Changing Owner screen Projection Changing Owner Selected Projections Description Prehmmary budget New Owner Not Selected CM Select from list a Return to Projection List New Owner of
44. income can be made with the RL calculation screen e Total contributions to restricted resources can be determined and accurately projected using a very unique and simple to use Contributions Edit window e Cash Flow module allows to project revenues and expenditures flow month by month e Resource format of the budget forecast allows input of revenues and expenditures by Resource and object code using the SACS Resource format 1 1 2 County Office Uses County office users will find BE useful because it serves the needs of both internal and external business services requirements Internal business services users need projection tools that are compatible with the unique funding characteristics of county offices And external business services users need projection tools that will help them better track local district fiscal positions and review fiscal trends 1 1 3 COE Internal Business Services Uses Funding for county offices 1s very different from that of district offices and there s never been a software tool that could handle the unique requirements of the COE funding model Special enrollment categories specific to county offices receive uniquely calculated funding streams requiring a software tool that offers the entire range of calculation algorithms necessary to create county office projections With Budget Explorer county office internal business services users now have access to the county office revenue limit calculation form
45. inedit mode for Historical data Calculate Enrollment Projection Mode switchers 9 Manually Enter ADA Base and Future Years Future Years Only Start Fresh Manually Enter Enrollment Factor Enter Historical and Projected Years K 3 208 3 134 3 085 3 212 3 087 3 060 3 034 3 005 2 969 1 3 270 3 223 3 125 3 057 3 032 3 009 2 971 2 939 2 909 7 3 135 3 138 3 056 2 980 2 840 2 860 2 833 2 795 2 764 r 3 057 3 053 2 991 2 915 2 781 2 691 2 703 2 675 2 639 4 3 004 2 985 2 905 2 897 2 837 2 692 2 605 2 620 2 592 3 3 063 2 888 2 865 2 816 2 731 2 712 2 571 2 486 2 499 Subtotal K 5 18 737 18 421 18 027 17 877 17 308 17 024 16 717 16 520 16 372 S 3 088 3 009 2 827 2 757 2 679 2 631 2 607 2 468 2 387 ADA in ADR inedit modefor for ADA inread EX I P2ADA ki u years for Ecc 4 years History Detail 0 00 Excluding Charter Schools 258 08 33 922 99 0 00 31 854 02 31 087 04 30 449 84 Charter Schools to calculate in leu property taxes 0 00 0 00 0 00 0 00 0 00 COE CommSchs SpEd 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 2 31 087 04 30 44 j 31 77 2 0 Enrollment Factors Excluding Charter and COE 0 0000 0 0000 0 0000 0 9579 0 9848 0 0000 0 9758 0 9758 0 9758 Charter Schools to calculate in lieu property taxes 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 Case 2 With other options selected see Figure 4 20 on p 74 you can not edit ADA though Enrollment factors for all year
46. is in the Page column e Section column describes the item changed name of the resource object rule Resource Code is in Resource column Object Code is in Object column Year column indicates in what year value was changed Action column shows the type of change added removed modified Old Value is the value of the object before modification delete New Value is a new value of the object after modification adding Changed On is date and time of change Changed By name of a person who made this change RV Add Object Resource Object Value Custom Object 0000 EN 2006 07 Added MEME 500 00 2007 04 27 Ajit Mandal 14 55 31 123 All pages resources and objects changes add modify delete are recorded Different items in Budget Explorer have different attributes but all necessary information about them is in the report Some fields in the report could be blank in case there was no value before or current item has no such attribute If a rule was changed than in Object column there will be object code the rule is assigned to and in Resource column there will be resource code the object belongs to 4 12 3 2 Auto Balancing Report Auto Balancing Report section is enabled for resource view projections only You can not generate this report in a projection by object codes This report is generated similarly to Audit Logging Report see item 4 12 3 1 Steps to generate Auto Balancing Report see Figure 4 76 Step 1 Check the bo
47. on p 15 and Table 4 on p 18 Remove object s using Ef icon in every object line Change objects values Apply rules see chapters 3 2 on p 22 and 4 6 on p 67 Add notes see paragraph 3 1 5 on p 19 Rename object by clicking on its name and entering new name on the screen appeared see Figure 4 14 Figure 4 14 Edit Object Details screen Edit Object Details Object Code Save Globally 4300 Saves title for an Enter new object title rale ra m mad es object for all resources itle Descriptor Materials and Supplies Saves description for an Object Description object for all resources Enter object description if needed Save Cancel 4 6 Projection Rules 4 6 1 Applying Rules If you click on the Rules button in the upper left corner of the screen Budget Explorer will display a screen similar to the one shown in Figure 4 15 below 2 Rules Buttons Bar and Menu Bar are described in paragraphs 3 1 2 p 17 and 3 1 3 p 18 The number of columns depends on your choice of years to forecast when you add a projection On Figure 4 15 it was 2 year projection so there are 2 projected years year 1 and year 2 The default rules in BE are downloaded into new projections only once at the time the projection is first created If the default rules in BE are updated based on new information from SSC the new rules will not automatically update existing rules within existing projections Instead rules within
48. projections Similarly if you click on the Title column header BE will display your projections in alphabetical order by the projection description etc 53 The buttons displayed above the list of projections of the Projection List screen are explained in the Table 18 on the next page Table 18 Buttons Displayed on the Projection List Screen Button Function assigned to the button Edit Projection Open an existing projection for editing Add Projection Create a new projection by importing uploading data from a SACS data file downloaded from your financial system x Delete Projections Remove an existing projection from the projection list amp Copy Projection Make a copy of an existing projection Rename Projection Change title of the existing projection 2 Share Projection Share selected projection with other users amp Change Owner To change the owner of the projection 4 1 1 Creating a New Projection There are 4 steps to add a projection To create a new projection click on the Add Projection m i d button in the left side of the Projection List screen Step 1 The Import SACS File screen see Figure 4 2 will be displayed after you click on add projection button On this screen the source of data should be selected Import methods available are the following e Import data from a SACS file Import SACS Data File provides a method of retrieving data from your financial system SACS download file or the state SACS F
49. specific resource to view its information Table 2 below explains the meaning of the symbols in the Navigation Tree Table 2 Symbols in Navigation Tree Symbol E Means that is used to this Navigation Tree entry is expanded Clicking on this symbol will change the symbol to l and will collapse the subordinate items that are displayed below the entry this Navigation Tree entry is collapsed Clicking on this symbol will change the symbol to and will expand the subordinate items that are hidden within this entry add a resource Clicking on this symbol will display the Add Resource page which allows the user to add unrestricted resource remove resource Clicking on this symbol will display the Remove Resource page which allows the user to delete unrestricted resource 3 1 2 Tab Bar Tab Bar see Figure 3 1 on p 15 consists of 6 7 buttons each of which is explained in Table 3 below Table 3 Tab Bar Tab Description Clicking on the Home button will take you back to the Welcome 18 Tab Description 1 Home to Budget Explorer screen 2 Rules Projection rules are used to control out year behavior of base year data You should review the default Projection Rules and make any changes you feel are necessary to match your K 12 funding perspective and local economic outlook Projection rules will be discussed in detail in chapter 4 6 on p 67 3 Enr ADA Staffing The Enrollment ADA a
50. that resource 3310 has negative balance It is an additional message red font indicates resource has negative balance Figure 4 57 Screen tips in Navigation Tree F 30 rr iu u Dib Navigation Tree x 3 Restricted Resource Summary Combined Resource Summary 3 Unrestricted Resource Summary g the Balance buttor RESISTIT t clicking the Reset b 1100 Lottery Unrestricted E Add Resource NERA Remove Resource B come and Neglected 3010 NCLB Title Part A Basic Grants Lt 3011 Custom Resource 3025 NCLB Title Part D Local Delinque rams 3026 Custom Resource When you point 3185 Custom Resource mouse over 3200 Custom Resource Th eom tip appears 3310 Special Ed IDEA Basic Local Assistance Entitlement Part B Sec 611 formerly P 3315 Special Ed IDEA 3319 Custom Resource 3320 Special Ed IDEA Resource has negative balance 108 Right mouse click will show context menu for selected resource see Figure 4 58 If you click Auto Balance this Resource item will show you Auto Balancing for Resource screen see Figure 4 59 You have to click on Start button to balance the resource according to algorithm see paragraph 4 11 1 1 on p 103 or to click Cancel button to return to previous screen 109 Figure 4 55 Context menu in Navigation Tree N Navigation Tree E za i Combined Resource Summary 3 B Unrestricted Resource
51. the terms and conditions outlined within the License Agreement simply click the button Enter the Username desired by the user then click Net A screen will be displayed indicating that your request has been transmitted to FCMAT If desired click on the button to return to the Budget Explorer login page 2 2 Retrieving forgot password Forgot Password link allows retrieving lost forgotten password or login to established account You will be required to enter email that is matching to email stored in your account information Figure 2 3 Retrieve Lost Forgotten Password screen Retrieve Lost Forgotten Password Enter your Valid E mail E mail Cancel Next 2 3 Logging Into Budget Explorer Once your account has been established you can log into BE and begin creating and maintaining projections Follow the steps outlined below to log into BE Run your Internet Browser and go to https www budgetexplorer org A screen similar to the one shown in Figure 2 1 see p 8 will be displayed Type your Username and Password into the appropriate fields then press Enter or click Login button In case the BE Administrator let you change password Budget Explorer will display My Profile screen see Figure 2 4 on p 11 There all common personal information and your 11 password may be changed You should select Challenge Questions and enter the answer to restore your password if you would happen to forget it Next
52. then every object where this rule 1s used will be recalculated with new rule values see more about Standard rules in p 3 2 2 on p 25 One time rule is used for one year only No changes will be made 45 Option Description Options for other year s values On Time or Ongoing Ongoing rule allows users to enter specific value for every year Options described in the Table 15 allows user to create multiple rules e g e Dollar dynamic one time rule Dollar dynamic ongoing rule Dollar static one time rule Dollar static ongoing rule Percent dynamic one time rule Percent dynamic ongoing rule Percent static one time rule Percent static ongoing rule Such rules allow user to make projection more flexible and clearer by using intelligible rule names and comments in rule notes 3 2 6 6 Rules exemptions There are some cases where applied rules are processed differently from general concept described in item 3 2 6 3 These cases are explained below Case 1 Manual Input ManInput Rule Manual Input ManInput Rule can not be applied with any other rule It means you can apply this rule without other rule s only If you try to add ManInput Rule to other rule s the system will remove all other rule s and apply ManInput Rule only If you try to add any other rule when ManInput Rule is applied you will see a warning message that the rule can not be applied if ManInput is used Case 2 CertColumn and CertStep rules combination
53. 0 etc Default order can be changed in projection Please refer to paragraph 4 11 1 2 When object with positive value is found this value is decreased up to zero to eliminate deficit If the value becomes zero but deficit exists the procedure moves to the next object from the list in Table 25 This next object is reduced up to zero exactly as previous one to eliminate deficit If deficit still exists then the procedure moves to the next object from the list in Table 25 etc If the last object has been processed and deficit still exists then the procedure starts step 2 otherwise it stops Step 2 If there are no more objects to reduce expenditures remaining deficit is written to 8980 object Contributions from Unrestricted Resources It means that for current expenditures deficit could be covered by Contributions from Unrestricted Resources only Table 25 Default Objects from Expenditures section affected by Auto Balance Object code Object name 4100 Textbooks and Materials 4200 Books and Reference Mats 4300 Materials and Supplies 4400 Noncapitalized Equipment 4700 Food 5200 Travel and Conferences 5300 Dues and Membership 5400 Insurance 5500 Operation and Housekeeping Svcs 5600 Rentals Leases Repairs and Noncapitalized Improvements 5700 Direct Costs Transfers 5800 Professional Consulting Services and Operating Expenditures 5900 Communications 6100 Sites and Improvement of Sites 6200 Buildings and Improvement of Buildings
54. 0 0 00 0 00 Yr End Avg Salaries 0 00 0 00 0 00 Yr End Total Salaries 35 468 139 00 35 468 139 00 35 468 139 00 Salary Component by FTE Ratio Year 2 2011 12 2012 13 FTE Ratio Salary Ratio FTE Ratio Salary Ratio 0000 Unrestricted A 100 0000 35 468 139 00 100 0000 35 468 139 00 X Working Area e e e Figure 3 2 Expanded working area Salary Forecaster Commands H Save changes Durrer View p Enrextricred Ober views Restricted unrestricted Cast CH T Kestricred Cori Of 19 Combined Cost Of 1 ee cns than te tata Forecaster nile z ective Blezse use the Staffing by Grade screen to enter teacher population data LO Base year Unrestricted Teacher Salary Teacher Salary Data Step and Colama Data No Resarces selected Base Year Total Tchr Salaries 0 00 FTE Receives a Avg Value Base Yea ETE 0 00 Shep inzsease FTE 0 00 150 55 Avg Tele Salary 0 00 Taal Buse Year Unrestricted Mna Colum Increase FTE 0 00 0 00 and Rewrite FTE Niger Avg Retree Salary ii oo Avg New HieLayelT Salary 4 ooo Salary Forecaster Data Siting ai 5 Start FTE WA O00 5 can 5 Retret ETE WA 00 0 00 ati 0 00 Step Cost 0 00 0 00 auma Cost 20 00 20 00 Ending FTE 0 00 0 00 00 Subtotal 80 00 80 00 80 00 Tchr Sal Incnease 55 HIA 0 00 80 00 0 00 50 00 Yr End Aug Salaries 000 i god Poo f Yr End Total Sabries 0 00 0 00 0 00 Salary Component by FIE Ratio 000 Unrestricted Year 1 2011 12 FT
55. 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 StaffingRatios in read only mode for all years Oo oni a uw a w N m EN H e 78 Notice that your choice changes screen appearance different cells become editable depending on option selected Use any of these three described option to enter data you need 4 7 3 View 3 Staffing by Resource for Districts Staffing by Resource button opens third view of Enr ADA Staffing screen see Figure 4 27 This screen allows user to distribute salary between resources based on FTE Ratio columns shows the percentage used to allocate salary to resources with FTE entered The Staffing by Grade and Staffing by Resource screens are mutually incompatible and should not be used simultaneously Use the Staffing by Resource screen to enter teacher population data into those resources where the Salary Forecaster rule has been applied To enable resource for FTE entry apply Salary Forecaster rule for object 1100 in this resource Figure 4 24 Staffing by Resource Staffing by Resource Select Unrestricted or ttt BERBERET page view Restricted Resources to view hes ijorph Help Reports Current View is Staffing by Resource EE View Resources Unrestricted Restricted eer a Please note that the Salary Forecaster Rule has been applied in one or more resources Consequently please use the Staffing by Reso
56. 0 in the first projected year then return to the same level as the base amount in the 2nd projected year the Cust Amt rule would be the perfect rule to use This rule can be used to increase or decrease specific percentage amounts When you select this rule for use on an object line Budget Explorer will prompt you to enter the percentage amounts that you want to adjust by for both the Ist and or 2nd projected years The percentages that you enter can be either positive or negative Similar to the CustPct rule the Cust Pct rule can be used to increase or decrease specific percentages However as the name of this rule implies the Cust Amt rule allows you to make changes that affect only 1 of the projected years For example if you knew that Instructional Aides Salaries Object 2100 was going to increase by 2 in the first projected year due to an off the schedule salary increase then return to prior levels in the 2nd projected year the Cust Pct rule would be the rule to use This rule can be used to allow direct input of exact amounts into the projected year fields Typically used in the Benefits screen object range 3000 3999 the Proportional rule allows the user to increase or decrease an amount by the proportional increase or decrease in one of the major object ranges For example it is safe to assume that expenditures for Certificated STRS will increase or decrease proportionally with increases or decreases in certificated salar
57. 00 0 00 0 00 8 0 00 0 00 0 00 0 00 Subtotal 6 8 0 00 0 00 0 00 0 00 9 0 00 0 00 0 00 0 00 10 0 00 0 00 0 00 0 00 11 0 00 0 00 0 00 0 00 12 0 00 0 00 0 00 0 00 Subtotal 9 12 0 00 0 00 0 00 0 00 Ungraded Elementary 0 00 0 00 0 00 0 00 Ungraded Secondary 0 00 0 00 0 00 0 00 Subtotal Exduding Charter Schools 0 00 0 00 0 00 0 00 Charter Schools to calculate in leu property taxes 0 00 0 00 0 00 0 00 Total 00 000 000 000 Staffing Ratios Base Year Year 1 Year 2 Year 3 Staffing Ratios inread only 2011 12 2012 13 2013 14 Iu EL mode for all years 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 K e 1 2 0 0000 3 4 Figure 4 22 Staffing by grade page 2 option Mode switchers Calculate FTE from Base Year Values 9 Manually Enter Staffing Ratios Manually Enter FTE Start Fresh K 0 00 0 00 0 00 0 00 1 0 00 0 00 0 00 0 00 0 00 0 00 0 0Q 0 00 3 0 00 0 00 oof Staffing FTE in read only 2 0 00 mode for all years 5 0 00 0 00 0 00 700 Subtotal K 5 0 00 0 00 0 00 0 00 6 0 00 0 00 0 00 0 00 7 0 00 0 00 0 00 0 00 8 0 00 0 00 0 00 0 00 Subtotal 6 8 0 00 0 00 0 00 0 00 9 0 00 0 00 0 00 0 00 10 0 00 0 00 0 00 0 00 il 0 00 0 00 0 00 0 00 12 0 00 0 00 0 00 0 00 Subtotal 9 12 0 00 0 00 0 00 0 00 Ungraded Elementary 0 00 0 00 0 00 0 00 Ungraded Secondary 0 00 0 00 0 00 0 00 Subtotal Excluding Charter Schools 0 00 0
58. 00 1999 Certificated Salaries 1007 Custom Object 9 1000 1999 Certificated Salaries 1008 Custom Object 10 1000 1999 Certificated Salaries 1009 Custom Object 1000 1999 Certificated Salaries 1010 Custom Object 12 1000 1999 Certificated Salaries 1011 Custom Object 13 1000 1999 Certificated Salaries 1012 Custom Object 14 1000 1999 Certificated Salaries 1013 Custom Object 15 1000 1999 Certificated Salaries 16 1000 1999 Certificated Salaries 17 1000 1999 Certificated Salaries 18 1000 1999 Certificated Salaries 19 1000 1999 Certificated Salaries 1014 Custom Object 1015 Custom Object 1016 Custom Object 1017 Custom Object 1018 Custom Object Click to Edit Object Default Rules Edit Object Code Delete Object Code Add Object Code Q Edit Resource Rules View 1 50 of 7 387 If there are no rules applied to the object the user will see the page to select the range of resources to apply rules for Figure 3 14 Figure 3 14 Resources For Default Rules Resource Group Resource View Start Resource Code 0000 End Resource Code 9999 Save Cancel When resource range 1s selected default rules may be changed see Figure 3 15 Buttons to change object rules are described in Table 14 Table 14 Change Rules Buttons Button Description Purpose Add new Adding new rules to selected resource range see item 3 2 6 2 on p 37 Edit Edit resource range Remove Delete all rules for selected resource range Figure 3 15 Object Code
59. 00 96 54 685 64 7 789 64 June 0 00 0 0000 S 0 00 Accruals 38 4000 Actions Actions Save User Schedule Save Actuals As a User Schedule Load FCMAT Schedule Load User Schedule Totals 100 0000 3 645 709 14 100 000 HS 2 274 436 00 356 792 99 Notes Aggregate Data Input mode allows to enter Actuals for Receipts Disbursements and General Ledger accounts in same Object Range view screen see Figure 4 48 on p 99 99 Figure 4 48 Cash Flow Aggregate Data Input Mode Cash Flow Edit for the object range Cash Flow Edit Commands Go back Upload A 8010 8099 Revenue Limit Sources Choose another Budget Amount Fiscal Year nea siglas Ride December HELE mE ERR clie 0 m nas imi Accruals 30 2500 Actions Actions Save User Schedule Save Actuals As a User Schedule Load FCMAT Schedule Load User Schedule x Totals 100 0000 96 4 637 968 14 100 000 96 4 2 282 896 00 952 086 78 Notes 4 10 5 Reconciling Variances Variance in the Cash Flow Edit can be reconciled Use Fix Variances option to zero variance in active object or object range Click Fix Variances link on the right bottom corner of Cash Flow Edit window Autobalance Variance window will be displayed see Figure 4 49 on p 100 100 Figure 4 49 The Autobalance Variance window Autobalance Variance x C Adjust Budget Do you want to adjust the budget in BXE to eliminate the variances
60. 000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 represent the single largest expenditure category of any school district operating budget it is again apparent that accurate enrollment projections are a fundamental prerequisite to ensuring precision for certificated salary forecasting 4 7 1 View 1 Enrollment for Districts Enr ADA Staffing tab in Tab Bar see 3 1 2 on p 17 opens first page of Enrollment Staffing screen see Figure 4 18 The same screen will be displayed if you click Enr rule or RL ADA rule on Projection Rules screen see Figure 4 15 on p 68 Figure 4 18 Enrollment page of Enr ADA Staffing screen Button to change eae page eae Select time Mode switchers 9 Manually Enter ADA period and data to be entered 9 Enter Historical Data Manually Enter Enrollment Factor Enter Historical and Projected Years view to Staffing by Grade page Enrollment N oliment PLADA amp Enrollment Factors Other views Staffing by Grade Staffing by Resource Calculate Enrollment Projection Base and Future Years Button to change view to Staffing by Resource page SEE EE Buttons for Autocalculations Start Fresh Future Years Only Commands 71 Save changes Enrollment kd m 700809 201011 2011 12 E 20
61. 1 2188 There is a special page to create various reports which provides you access to all reports available in Budget Explorer see chapter 4 12 on p 118 3 4 Entering data There are many screens in Budget Explorer to enter various data see Figure 3 27 and Figure 3 28 Data could be entered in different formats e Text e Currency e Percentage If some data have background color which is the same as the row or column it means you can not edit this data see Staffing Ratios section on Figure 3 28 If a field or cell is marked out with different color you may enter change data there see Figure 3 27 and Staffing FTE section on Figure 3 28 Figure 3 27 Edit Custom Rule screen Edit Custom One Time Amount Rule for 8019 Revenue Limit State Aid Prior Years Rule CustlAmt Description Text field Custom One Tim Amount Dollars 0 00 Amount field Year Year 1 2012 13 Year 20131 Selection Year 2 2013 14 Selection Save Cancel Figure 3 28 Staffing screen Enrollment Current View is Enrollment P2ADA amp Enrollment Factors Other views Staffing by Grade Staffing by Resource Mode switchers Calculate Enrollment Projection 9 Manually Enter ADA Enter Historical Data Base and Future Years Future Years Only D Manually Enter Enrollment Factor Enter Historical and Projected Years 1 724 730 756 806 2 749 768 3 763 767 4 731 706 671 753 746 727 776 5 727
62. 1 4 Icons 19 Description Go to the previous screen usually upper level Add a new object Save changes made on the page Export page to Excel Export page to PDF format See graphs Read contextual help Data on several pages is presented with icons Table 5 Icons Icon ee Description apply rules for projecting data in future years Hover your mouse over this icon to reveal the list of rules applied see more about rules in chapter 3 2 on p 22 To help you keep track of the assumptions that you make while creating your projection click on the Notes icon to the right of the corresponding line item see paragraph 3 1 5 on p 19 Click on this icon to delete the line this icon belongs Note these icons are available not for every line You may apply rules add notes and delete lines only in case there is such icon in that line 3 1 5 Notes Notes are used to help you document your assumptions while you create your forecast Notes are available for different objects object groups rules Revenue Limit lines everywhere you see note icon hg as shown on Figure 3 4 To add or change note simply click on this icon to see Edit screen 20 Figure 3 4 Note icons Object Detail 4000 4999 Books and Supplies General Fund County School Service Fund Unrestricted Resources Only Commands gAddObjects Save changes Resource 1100 Lottery Unrestricted 595 878 75 596 289 07 400 000 00 580 21
63. 12 13 2013 14 em 2014 15 K 3 208 3 134 3 085 3 212 3 087 3 060 3 034 3 005 2 969 Field to 1 3 270 3 223 3 125 3 057 3 032 3 009 2 971 2 939 2 909 enter edit data 2 3 35 3 138 3 056 2 980 2 840 2 860 2 833 2 795 2 764 3 3 057 3 053 2 991 2 915 2 781 2 691 2 703 2 675 2 639 4 3 004 2 985 2 905 2 897 2 837 2 692 2 605 2 620 2 592 5 3 063 2 888 2 865 2 816 2 731 2 712 2 571 2 486 2 499 Click to edit Subtotal K 5 18 737 18 421 18 027 17 877 17 308 17 024 16 717 16 520 16 372 row title 6 3 088 3 009 2 827 2 757 2 679 2 631 2 607 2 468 2 387 7 AC gt nin 7 a10 gt can 7 Eca gt EE 472 FAAS 221 Subtotal Excluding Charter Schools 38 323 37 517 35 764 34 447 33 508 32 644 31 858 31 205 Charter Schools to calculate in heu property 294 823 1 350 2 377 3 805 6 760 11 540 19 757 33 831 Total 38 617 38 340 37 833 38 141 38 252 40 268 44 184 51 615 65 036 P2ADA History Detail Excluding Charter Schools 0 00 0 00 0 00 34 258 08 33 922 99 0 00 31 854 02 31 087 04 30 449 84 Charter Schools to calculate in leu property taxes 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 COE CommSchs SpEd 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Total 0 00 0 00 0 00 34 258 08 33 922 99 0 00 31 854 02 31 087 04 30 449 84 Enrollment Factors Excluding Charter and COE 0 0000 0 0000 0 0000 0 9579 0 9848 0 0000 0 9758 0 9758 0 9758 Charter Schools to calculate in leu property taxes 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 This screen ha
64. 2 for description of selection choices 91 Figure 4 35 Cash Flow Creation Cash Flow Creation x Cash Flow Parameters 1 Which method would you prefer to use for entering revenue data By individual object and resource a little more work but more accurate By major object range less work but less accurate 2 Please enter values for each of the following a Beginning Cash Balance b General Ledger Accounts i Assets Revolving Cash Account 1 000 00 oes Accounts Receivable Due from Other Funds ii Liabilities LU COGUK Current Due to Grantor Govemments Due to Other Funds 5 450 000 00 Deferred Revenue Create Cancel Attention Create operation will delete existing Cash Flow data 4 10 4 Entering Actuals There are three ways to enter actuals in the Cash Flow e Enter Actuals from Cash Flow overview screen e Enter Actuals by Month e Enter Actuals by Object Range 4 10 4 1 Entering Actuals from Cash Flow overview screen Entering Actuals from Cash Flow overview screen is quickest way to enter Actuals Typing amount in the cell changes amount setting from Projected to Actual Detail Data Input mode allows to enter Actuals from overview screen for Disbursements and General Ledger accounts see Figure 4 36 on p 92 Figure 4 36 Cash Flow Detail Data Input Mode Cash Flow Overview Commands You are working in Detailed Data Input Mode Switch to Aggregate Data Input Mode
65. 20 2 592 5 3 063 2 888 2 865 2 816 2 731 2 712 2 571 2 486 2 499 Subtotal K 5 18 737 18 421 18 027 17 877 17 308 17 024 16 717 16 520 16 372 6 3 088 3 009 2 827 2 757 2 679 2 631 2 607 2 468 2 387 an m TC ae POA Ef R Lam a n ter gt OS TO CAaAKulate m ap S 9C Oc gt 2u perc tayvoc i VO AS ADA inread only mode P2ADA for all years History Detail Excluding Charter Schools 0 00 0 00 0 00 34 258 34 33 923 41 0 00 31 854 02 31 087 04 30 449 84 Charter Schools to calculate in ieu property taxes 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 COE CommSchs SpEd 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Enrollmentfactors inedit 23 41 0 00 31 854 02 Enrollment Factors HORE trot yan E Excluding Charter and COE 0 0000 0 0000 0 0000 0 9579 0 9848 0 0000 0 9758 0 9758 0 9758 Charter Schools to calculate in lieu property taxes 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 75 4 7 2 View 2 Staffing by Grade for Districts Staffing by Grade button opens second view of Enr ADA Staffing The same screen will be displayed if you click TchrStfg rule on Projection Rules screen see Figure 4 15 on p 68 The Staffing by Grade and Staffing by Resource screens are mutually incompatible and should not be used simultaneously Use the Staffing by Grade screen to enter teacher population data if the Salary Forecaster rule is not in use anywhere in the projection The following rules are recommended
66. 3 00 f Textbooks and Materials 4100 Books and Reference Mat ls 4200 7 843 25 7 09246 709734 Materials and Supplies 4300 53 859 78 fe 60989217 61031214 Noncapitalzed Equipment 4400 36 019 76 f 28 606 06 28 625 76 Food 4700 0 00 oo 0 00 s__ 00 f Note icon color indicates there is a note for 4400 object Note icon color indicates there is no notes for 4700 object The design of a screen may vary for different objects but anywhere you will see Note field to enter your assumptions explanations see Figure 3 5 Figure 3 6 Figure 3 5 Note field for the object Edit Object Notes Object Code Save Globally 4400 E Title Title D w Noncapitalized Equipment Object Note This is my note for an object Save Cancel Field to Enter Note Hanau 21 Figure 3 6 Note field for the rule Edit Projection Rule Rule CPI Title California CPI SSC Prc Base Yr Year 1l Year 2 2011 12 2012 13 2013 14 3 10 2 10 3 10 For negative impact amounts use the minus sign e g 1 000 00 or 1 12 The value for the Base Year is displayed for information purposes only Notes California CPI Save Cancel Reset to Default Field to Enter Note When you print your reports see chapter 3 3 one mouse click may include all your notes in reports to clarify calculations made in your projection 3 1 6 Screen tips On some screens headers of sections or rows are underl
67. 4 7 4 Form A for County Office of Education sese 78 4 7 5 Staffing by Resource for County Office of Education euuuuss 79 4 0 dft FOr CAS UCN oanien addat astoa edes pda ute bp audio a Do toa muse pdt 80 4 8 1 Cost of 1 screen Unrestricted Restricted Combined Sl a eis tis Bim E a a a a and nae ent a et tees 82 4 9 1 Revenue Limit for DISCI pent ee tt eo e ua esie ard eR aE 82 4 9 2 Revenue Limit for County Offices of Education eeeeeeessssss 84 NIC OW acta saetee se steree ances E E mba ssaaeequae tous 86 ASTE GC ol gl Co geen eee UR 86 4 10 2 Creating Cash Flow during SACS File import process 88 4 10 3 Create new Cash Flow in existing projection cccccccccssseeeeeeeeeeeeeneeeeeees 90 ZO UAE Ete ere A EUO S oec as oer p tut eotoe oM Suet idea iu ce ouae deu M Leu co metido den neces 91 4 10 5 Reconciling Variances Joa oett e ett Ee a a ed Pe es ue uo 90 2 L0 0 UpIO3Q JA CIUS eiie pesto he et ede vi o Ue a esos ud ed eoe tau am Pe esa und 100 ANd eset Values LO ZrO esconde botte Mo etd bd Ed dtt 101 4 10 8 Chanse Cash Flow np THOU zs esnd dete sins um etu eat bd he t Com itis 102 4 II special Services or Budeet iE x plone oce raten cce itr e aoa ea coa tue cos 103 d DEL AUto Dalancifg us e mp a dept att aime bee tau Saeed ec aur drEE 103 4 LL RE SCL GO derault S saci tet debut a ue ER SU a
68. 4 751 739 64 134 751 345 61 Cost of 196 1 352 555 42 1 347 517 40 1 347 517 40 1 347 513 46 Certificated Management Salaries 1300 7 887 765 00 7 887 765 00 7 887 765 00 7 887 765 00 Benefits 3000 3999 48 415 210 00 47 911 238 44 47 911 238 44 47 911 182 81 Total 56 302 975 00 55 799 003 44 55 799 003 44 55 798 947 81 Cost of 196 563 029 75 557 990 03 557 990 03 557 989 48 Classified Staff Salaries 2100 2200 2400 2900 22 415 030 00 22 415 030 00 22 415 030 00 22 415 030 00 Benefits 3000 3999 48 415 210 00 47 911 238 44 47 911 238 44 47 911 182 81 Total 70 830 240 00 70 326 268 44 70 326 268 44 70 326 212 81 Cost of 196 708 302 40 703 262 68 703 262 68 703 262 13 Classified Management Salaries 2300 3 374 074 00 3 374 074 00 3 374 074 00 3 374 074 00 Benefits 3000 3999 48 415 210 00 47 911 238 44 47 911 238 44 47 911 182 81 Total 51 789 284 00 51 285 312 44 51 285 312 44 51 285 256 81 Cost of 196 517 892 84 512 853 12 512 853 12 512 852 57 Click to change range s Figure 4 29 Edit range screen Edit Salary Forecaster Object Range for Classified Management Benefits Range 3000 3399 22S Range 3000 3999 Example 3100 3199 3200 3300 3399 Save Cancel 4 9 Revenue Limit 4 9 1 Revenue Limit for Districts The Revenue Limit calculation screen is designed to be very easy to use and yet extremely accurate After the current year base revenue limit per ADA amount is calculated Budget Explorer a
69. 53 on p 102 102 Figure 4 53 Reset Values to Zero Reset Values to Zero for El July actuals present August actuals present September actuals present October actuals present November actuals present December actuals present January actuals present February actuals present March actuals present April actuals present May actuals present C June actuals present Select type of values C Projected Actuals Clear Cancel It is recommended to reset projected values to zero for the month where all actuals are entered This will eliminate including projected amounts in grand total for month 4 10 8 Change Cash Flow input mode There are two modes of Cash Flow e Detailed Data Input Mode allows entering revenues per each Resource Object combination e Aggregate Data Input Mode allows entering revenues per Object range as total of all resources It is highly recommended to use Detailed Data Input Mode option However it is possible to switch from Detail Mode to Aggregate Mode Reverse action 1s not available Aggregate Data Input Mode link opens Preferred Data Input Mode window see Figure 4 54 on p 103 103 Figure 4 54 Preferred Data Input Mode Preferred Data Input Mode Detailed enter revenue data by mdividual object and resource Aggregate enter revenue data by major object range 9 Convert existing cash flow to aggregate mode Create new cash
70. 70 2 20 7 LOT Res California Lottery Restricted SSC 17 50 17 50 17 20 y Click to see all objects LOT Unr California Lottery Unrestricted SSC 112 50 111 00 110 00 affected by this rule INT Interest Rate Trend for 10 Year Treasuries SSC 3 20 3 80 4 10 P NetCOLA Net Funded Revenue Limit COLA SSC 5 17000 0 36900 1 80000 y RLDef Revenue Limit Deficit K 12 SSC 17 96300 19 60800 19 60800 y SpEdCOLA Special Education COLA SSC 0 0096 0 0096 1 8096 ye CatCOLA State Categorical COLA SSC 0 00 0 00 1 80 p StCOLA Statutory COLA SSC 0 39000 1 67000 1 80000 yy HW Health amp Welfare Benefit Increase 0 00 0 00 0 00 Tier I Tier I Programs 0 00 0 00 1 80 ye TierIl Tier II Programs 0 00 0 00 1 80 p TierIII Tier III Programs 0 0096 0 0096 1 8096 ye CustAmt Custom Amount 0 00 0 00 0 00 Cust Custom Percent 0 00 0 00 0 00 CustlAmt Custom One Time Amount 0 00 0 00 0 00 Cust Custom One Time Percent 0 00 0 00 0 00 ManInput Manual Input 0 00 0 00 0 00 PRO Proportional 0 00 0 00 0 00 Zap Zero Out 0 00 0 00 0 00 Enr Year to Year Change in Enrollment 0 0096 0 0096 0 0096 RL ADA Year to Year Change in RL ADA 0 0096 0 0096 0 0096 69 You may roll back to default values by clicking on Reset to Default button or click Cancel to leave this screen without saving changes see Figure 4 16 If you want to save changes of the rule click on Save button see Figure 4 16 Figure 4 16 Edit Project
71. 9 00 Charter Schools General Purpose Enttlement State Aid g015 0 00 0 00 Revenue Limit State Aid Prior Years 8010 0 00 Click on the f 000 Tax Relief Subventions 8020 0 00 pencil to edit F 0 00 Homeowners Exemption 8021 938400 values by month 169 20 Enter actuals for the month window will open see Figure 4 42 on p 95 Figure 4 42 Cash Flow Detail Data Input Mode Enter actual receipts for the month Enter actuals for the month of July 2011 x Name Object Budget Actual Use Code Principal Apportionment 8010 2 Revenue Limit State Aid 8011 Current Year Charter Schools General 8015 Purpose Entitlement State Aid Revenue Limit State Aid Prior 8019 amount Uncheck to Years projected amount Tax Relief Subventions 8020 0 00 1 0 00 a Homeowners Exemption 8021 469 20 0 00 3 7 Timber Yield Tax 8022 0 00 0 00 M Iz Other Subventions In Lieu 8029 0 00 0 00 F Taxes County and District Taxes 8040 0 00 0 00 F Secured Rolls Tax 8041 41 274 40 0 00 F Unsecured Roll Taxes Click to move 1 68255 s 0 00 j 7j Prior Years Taxes value to Actual E column Supplemental Taxes Education Revenue 8045 3 675 00 Augmentation Fund ERAF Supplemental ERAF 8046 0 00 A Community Redevelopment 8047 0 00 F Funds Revenue Limit Transfers 8090 0 00 F Revenue Limit Transfers 8091 S 22 70 gt F Save Cancel
72. CPI SSC 3 10 2 70 3 10 s Custom Percent 10 0096 10 0096 10 00 7 Remove all Rules Delete rule 3 2 6 5 Add user defined rule User may add his her own rule to the projection see Figure 3 23 or remove rule s created earlier User defined rules can be used as any other rule throughout the projection 43 Figure 3 23 Add remove user defined rule buttons Commands Add User Defined Rule Delete User Defined Rule Q Help Generate reports PDF NS Button to Delete User Defined rule CertCOLA i Certifica ed COLA 0 00 0 00 T 0 00 l Button to Add User Defined rule ClassCOLA Classified COLA 0 00 0 00 0 00 Projection Rules CertColumn Certificated Staff Column Increase 0 00 0 00 0 00 CertStep Certificated Staff Step Increase 96 0 00 0 00 0 00 Y ClasStep Classfied Staff Step Increase 96 0 0096 0 0096 0 0096 CPI Calfornia CPI SSC 3 1096 2 7096 3 1096 g LOT Res California Lottery Restricted SSC 17 50 17 20 17 20 LOT Unr California Lottery Unrestricted SSC 111 00 110 00 108 75 p INT Interest Rate Trend for 10 Year Treasuries SSC 3 80 4 10 4 30 NetCOLA Net Funded Revenue Limit COLA SSC 0 00000 3 20000 2 70000 RLDef Revenue Lim amp Deficit K 12 SSC 19 75400 19 75400 19 75400 p SpEdCOLA Special Education COLA SSC 0 00 3 20 2 70 WW CatCOLA State Categorical COLA SSC 0 0096 1 8096 2 30 p StCOLA Statutory COLA SSC 2 24000 3 20000 2 70000
73. Component by FTE Ratio by Resource screen Rule Year 1 Year 2 Year 3 2012 13 2013 14 2014 15 FTE Ratio Salary Ratio FTE Ratio Salary Ratio FTE Ratio Salary Ratio 0000 Unrestricted 60 000096 50 759 971 20 60 000096 50 759 971 20 60 000096 50 759 971 20 1100 Lottery Unrestricted Se 40 000296 33 840 150 00 40 000296 33 840 150 00 39 999896 33 839 811 60 After entering a few required input fields the Budget Explorer Salary Forecaster screen will calculate projected certificated salaries These values Yr End Total Salaries will update corresponding years for specified Resources for Object 1100 4 8 1 Cost of 1 screen Unrestricted Restricted Combined This screen calculates 196 of the sum according to object ranges see Figure 4 28 User may change object range s used for calculation by clicking current range to open Edit 82 range screen see Figure 4 31 These ranges can be modified per each screen Unrestricted Restricted and Combined Figure 4 28 Cost of 1 screen Salary Forecaster Unrestricted Cost of 1 uerrop r Vien T gt 0 Current View is Unrestricted Cost of 1 page vie Other views Unrestricted Restricted Restricted Cost Of 196 Combined Cost Of 196 Unrestricted Teachers Salaries 1100 1200 1900 86 840 332 00 86 840 501 20 86 840 501 20 86 840 162 80 Benefits 3000 3999 48 415 210 00 47 911 238 44 47 911 238 44 47 911 182 81 Total 135 255 542 00 134 751 739 64 13
74. Defined rules are explained in the Table 15 on p 44 44 Figure 3 24 Add User Defined rule screen Add User Defined Rule Name Short Rule Name Rule Description User Rule Name Pa Enter short rule name ra Enter rule description Dollar Amount or Percentage 9 Dollar Amount select number format of the rule Percentage Rule Type m Select type of the rule 9 Static the same value s will be used in every instance where it is applied Dynamic new values can be input m every instance where it is applied Rule Timing Options Select timing options of the rule 9 Ongoing impacts year of entry then remains at stated level One Time tmpacts one year only then returns to normal m Cancel operation Save Cancel Save create new rule Table 15 User Defined rules options Option Dollar Amount or Percentage Rule Type Dynamic or Static Rule Timing Description Select the type of data used for rule values For Dynamic Custom rule its value should be entered each time the rule is applied And if user changes rule value s for any object it will have no impact on other instances where the rule is applied see more about custom rules in p 3 2 3 on p 28 For Static Standard rule its values can be entered 1n advance e g on Projection Rules screen This rule retains its values throughout the entire projection regardless of where it 1s used If user changes rule value s for any object
75. E Ratio ape FCMAT 3563 2011 Gusstian Susdasiun Salary Ratio Year 2 2012 13 FTE Rate Sabry Ratio PO 0 00 0 00 Collapse Expand Button irene Hap Generate reports g Excel d rur T eaiemt Tes halo gie s Inc 16 Navigation Tools There are several tools to navigate throughout BE or to run a command e Buttons e Navigation Tree e Hyperlinks e Icons Buttons are usually used to run a command open close save back etc Navigation Tree is used to navigate through summaries and resources Hyperlinks are used to go to other pages usually to a lower level of data e g from object group to list of its specific objects or to open item in edit mode On some screens font of hyperlink is blue Hyperlinks could be organized as lists When a user double clicks on a specific item from the lists he she does to the page corresponding to the item selected In some cases when you point your mouse over name or code of the object cursor turns from R to th If so one mouse click will activate hyperlink Icons as well as hyperlinks have links to other pages and indicate by color or screen tips if there is additional information or object s assigned to the item selected Selecting the item There are two ways to select the item e Click on the item and it will be highlighted with different color e Check the box of the item If group operations are not allowed the only way to select an item
76. FCMAT FISCAL CRISIS amp MANAGEMENT ASSISTANCE TEAM CSIS California School Information Services Hudget Explorer Update Wath the miredocton of version 5 Budget Explorer HEV packs 2 wanety of pewerfd new and upgraded features defers Easter performance and 5 more uscr Triendly than ever New and upgraded features Cash actaals data can be uploaded clectromcally Cash Flow screens are more spresdsheet like Data can be exparted to the state s SACS software A Zap AUP nde can be wod to sunset entre resources Performance acceleration BEx5 was recreated from the ground up to take full advantage of the latest advances m appbcation database and hardware techoologies Improved user experience BEvS s more user fend than ever and offers a cleaner user mterface It also has more extensive help Facibtes and now rans on such web browsers Feefox Chrome and Intermet Explorer I d Bee to lcazn more about Budget Explorer BUDGET EXPLORER v 5 0 Multiyear Financial Forecasting Software for K 12 School Agencies Username Password 3s f Remember My Password D Login Forgot Password Request Account Budget Explorer User Guide MEWES 10 4 2010 MAE Object 041 Cash Flow Distriburon Shedule with Deferral Jum Aceraals ere ian DEIEIESESEJESESESESECIES On behalf of FCXLAT thank vou for your continued use amd support of Budget Explorer v 4 0 Alulti Year Financial Projection and Cash Flo
77. Funding 6 392 00 o e un N i m gt 33 922 99 33 922 99 o o o N N a w A w N Wo UJ N naNO n oo o w o 1 064 880 0 o Rule icon c N N oo oo oo o o Commands 6 535 00 S 6 529 34 203 00 0 00 6 732 34 6 732 34 0 00 0 00 31 854 02 31 854 02 0 00 0 00 31 854 02 214 452 093 01 0 00 0 00 1 064 880 00 0 00 0 00 0 00 0 00 278 818 00 H Save changes 6 744 00 6 926 00 6 732 34 6 921 3 18900 208 00 692134 7 129 34 6 921 34 7 129 34 31 854 02 31 087 04 31 854 02 31 087 04 31 087 04 30 449 84 31 854 02 31 087 04 0 00 0 00 0 00 0 00 31 854 02 31 087 04 220 472 502 79 221 630 077 75 0 00 0 00 0 00 0 00 1 064 880 00 1 064 880 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 278 818 00 278 818 00 Help 2011 12 Rules 2012 13 2013 14 2014 15 available see more about screen tips in paragraph 3 1 6 on p 21 and Figure 3 7 on p 22 There are dependencies between Objects and Revenue Limit rows Revenue Limit line 21 Less PERS Reduction is updated from Resource 0000 Object 8092 Revenue Limit line 25 Property Taxes is updated from total of Objects 8020 8046 Resource 0000 Revenue Limit line 27 Property Taxes Transfers 1s updated from Resource 0000 Object 8097 Revenue Limit line 28 Community Redevelopment Fund is updated from Re
78. Jan Feb Mar Apr May Jun Accruals Salaries for Restricted resources are not projected because no FTE is entered for restricted resources on Staffing by Resource page Jul Aug Sep Oct 4 60 1 50 0 38 40 ox 0x 11 70 0 9x 9X 25 30 0 50 ox m 4 11 x it unm Navigation Tree ounty Link to update base values in projection Please note that the amounts from line 27 TOTAL REVENUE LIMIT are not automatically transferred to resource 0000 object 8011 You will have to manually adiust the TOTAL REVENUE LIMIT values to deduct Property Tax Revenues and Local Sources The purpose of First time here Click on any button at the top Ursa aggregate i e one amount for each maye listed in the Navigation Tree to start working Note that you can input revenue and expenditure data in t projection is created for 2 years abject code range or in detailed format i e up to 4 digits of detail within any code range Click here if you want to update all base values in the projection Projection Rules Review the Projection Rules and make any changes you feel are necessary to match your K 12 funding perspective and local economic Salary Forecaster If you wish to change the forecasting period or projection description please click ter certificated salary data into the Salary Forecaster here outlook Link to Projection Enrollment ADA Staffing Revenue Limit Quick Start Gu
79. L EDUCATION PROGRAMS 15 Property Taxes other than Special Education 3067 41 567 293 00 41 567 293 00 41 567 293 00 Total Other Revenue Line 15 16 17 3031 41 567 293 00 41 567 293 00 41 567 293 00 Total State Aid Portion of Revenue Limit for Non Special Education Programs Line 14 18 3032 49 932 552 58 48 554 388 78 50 150 449 53 20 County School Tuition Out of State E C 2005 and 2554 3033 S 0 09 S 0 09 S 0 00 Some lines have sub screens Principal Appt Software Data ID of such lines are links to their sub screens ATTENTION When projection is created Revenue Limit screen takes values from the SACS data file Sub screens have no influence on main screen values of Revenue Limit If user change or save data on sub screen then this sub screen 1s set as linked to the proper line of the main screen Since that time all changes of this sub screen will start recalculation of Revenue Limit It means that sub screen will be recalculated its values will update parent line of the main Revenue Limit screen and dependent objects in dependable resource s There are dependencies between Objects and County Revenue Limit rows Amount of Revenue Limit line 1 3217 transfers to either Resource 2400 2410 2420 Object 8091 only if there 1s no data in detail screen If detail screen calculation for 3217 1s present amount from line A 5 3202 from 3217 detail screen transfers to Resource 2410 2400 Object 8091 If
80. Salaries 00 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 4 7 Enr ADA Staffing Careful estimations of projected enrollment are prerequisite to an accurate ADA projection And since school districts are funded on ADA FCMAT cannot stress strongly enough the importance of accuracy with regard to the enrollment projections that underlie projected ADA counts Similarly enrollment populations are the primary driving force behind determining projected teacher populations And since certificated salaries 1100 Certificated Teachers Salaries 1110 Substitute Salaries 1120 Extra Duty Stipends 1200 Cert Pupil Support Salaries 1300 Cert Superv Admin Salaries 1900 Other Cert Salaries 1100 Certificated Teachers Salaries 1110 Substitute Salaries 1120 Extra Duty Stipends 1200 Cert Pupil Support Salaries 1300 Cert Superv Admin Salaries 1900 Other Cert Salaries 1100 Certificated Teachers Salaries 1110 Substitute Salaries 1120 Extra Duty Stipends 1200 Cert Pupil Support Salaries 1300 Cert Superv Admin Salaries 1900 Other Cert Salaries 1100 Certificated Teachers Salaries 1110 Substitute Salaries 1120 Extra Duty Stipends 0 0000 160184 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 160184 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0
81. Undo Changes Aggregate Data Input mode allows to enter Actuals for Receipts Disbursements and General Ledger accounts from same Month view screen see Figure 4 43 on p 96 96 Figure 4 43 Cash Flow Aggregate Data Input Mode Enter actuals for the month r x Enter actuals for the month of July 2011 x Name Object Budget Actual Use Code Revenue Limit Sources 8010 8099 Federal Revenues 8100 8299 cell toedit Other State Revenues 8300 8599 Other Local Revenues 8600 8799 Check to use actual Interfund Transfers In 8900 8929 amount Uncheck to All Other Financing Sources 8930 8979 0 E ected E Liz Certificated Salaries 1000 1999 104 478 84 gt 0 00 F Classified Salaries 2000 2999 31 408 44 0 00 Employee Benefits 3000 3999 32 945 10 0 00 m Books and Supplies 4000 4999 28 484 10 0 00 Services and Other Operating 5000 5999 37 016 51 0 00 0 00 Capital Outlay 6000 6900 O D F9 F9 E D3 f o amp o o o e b o o Other Outgo Click to move 0 00 Direct Support Indirect Cost value to Actual 0 00 Debt Service column 0 00 F Interfund Transfers Out 7600 7629 E 0 00 gt All Other Financing Uses 7630 7699 E o00 p Revolving Cash Account 9130 200 00 F Cash with a Fiscal 9135 0 00 0 00 F Agent Trustee Accounts Receivable 9200 0 00 F ZIAN N asin la ed ile nlm dPL Sav
82. View Compatibility View Settings Full Screen Toolbars Explorer Bars Developer Tools Suggested Sites OneNote Linked Notes Send to OneNote Blog This in Windows Live Writer Internet Options Internet Browser out of date message will disappear the proper BE v5 0 login screen will appear 13 14 3 Budget Explorer General Concepts 3 1 Design and Navigation Concept All pages of Budget Explorer have similar design and navigation see Figure 3 1 on p 63 LEA s name projection title and its base year is presented at the top of the screen There is a link to the list of projections to leave current projection and go to Projection List screen see Figure 4 1 on p 52 The screen see Figure 3 1 on p 15 1s divided into 4 sections as outlined in Table 1 below Table 1 Main sections of the screen Section Name Function Tab Bar Provides quick access to different areas of the projection The Tab Bar always remains visible at the top of the screen while you are editing a projection see paragraph 3 1 2 on p 17 Navigation Provides quick access to different revenue and or expenditure data The Tree Navigation Tree always remains visible on the left side of the screen while you are editing a projection see paragraph 3 1 1 on p 16 Working Area Entering data working with projection rules displaying reports Menu Bar Saving data changes create reports see help see paragraph 3 1 3 on p 18 There are collapse expand
83. ague to work with and keep original projection for reference Try to change values and or rules for what if analysis and keep original projection for reference To remove all rules and or enrollment details and or salary forecaster values which were added manually Make a new projection with user defined rules and values for another budget cycle etc 59 Figure 4 6 Copy Projection screen Copy Projection Select the number of LEA forecasted years for ABC Unified projection Select the n er of years to project forward 2 default Budget cycle 2011 12 Projection title 77 Copy from Preliminary budget Check the items to copy Check items to be copied 7 Projection Rules 7 from the source projection 7 Enrollment and Staffing Values VI Revenue Limit Values V Salary Forecaster Values lv Cash Flow Start Copy Cancel All options of Copy Projection screen are explained in the Table 19 below Table 19 Options of Copy Projection screen Option Field Description Select the number You can make a copy which would have the number of years of years to project different from source E g if your source projection is for 2 years forward you may make a copy projection for 5 years and vice versa Budget cycle You may select different budget cycle for your copy Projection title Any new title convenient to you Copy from Select one of your projection to be the source for a cop
84. anges made its balance negative Other Icons ww The rule icon is used to apply rules for projecting data in future years Hover your mouse over this icon to reveal the list of rules applied To help you keep track of the assumptions that you make while creating your projection click on the Notes icon to the right of the corresponding line item nit im swe This is your common menu bar Use it to navigate to the previous screen add objects save your changes export your Be results to Excel PDF see graphs and read contextual help files FCMAT 2005 2011 Question Suagestion Teexient Technologies Inc Update Projection screen is similar to Import SACS file screen see Figure 4 2 on p 54 User may select either new SACS data file or previously imported SACS data file see Figure 4 68 on p 117 When SACS data file is defined click on Next gt gt link will open Step 2 Select data to import screen Figure 4 690n p 117 This screen allows user to select the interim ATTENTION after you click Next gt gt at the step 2 all your data in current projection will be replaced by new values from SACS data file according to algorithm described in item 4 11 5 1 on p 115 There is no way to roll back your projection to its previous state or reset its values and or rules to initial ones 117 Figure 4 68 Update Projection from SACS File Step 1 D Projection from SACS File Step 1 Choose an Import Me 1 All objects from a n
85. ar to the one shown in Figure 2 2 will be displayed Figure 2 2 The Request an Account Screen Budget Explorer v5 0 Account Request First Name Last Name Phone Ext E mail LEA Select LEA Iz Desired Username Security Question Select a Question m Answer Budget Explorer v5 0 License Agreement End User License Agreement Version 5 2011 Fiscal Crisis and Management Assistance Team 1300 17th Street Bakersfield CA 93301 Please take a moment to read the license agreement now If you accept the terms below chick I accept the terms in the license agreement then click Next Otherwise click I do not accept the terms in the hcense agreement IMPORTANT PTE ASE REATO CAREPFTITT W 4 I accept the terms in the license agreement I do not accept the terms in the license agreement Cancel Fill the form with your information e Enter the first name of the user then press the Tab key e Enter the last name of the user then press the Tab key e Enter the phone number of the user then press the Tab key e Enter the e mail address of the user then press the Tab key 10 e Select the LEA Local Educational Entity name for which the projections will be created then press the Tab key After reading the agreement and if you agree to the terms outlined within the agreement click the radio button to the left of I accept the terms in the license agreement Note If you do not agree to
86. ce Summary Proj Year 3 Combined Resource Summary Proj Year 4 O X Or X S v9 Combined Resource Summary Proj Year 5 Cash Flow Base Year Cash Flow Proj Year 1 Cash Flow Proj Year 2 Cash Flow Proj Year 3 Cash Flow Proj Year 4 Cash Flow Proj Year 5 Pacific Coastal Unified School District Pacific Coastal 2 Million in Cuts DDeal Base Year 2011 2012 D 1 Home 2 Rules 3 Enr ADA Staffing 4 Salary Forecaster 5 Revenue Limit 6 Cash F General Fund County School Service Fund Unrestricted and Restricted Resources eee E E 2011 12 Revenus EE ULL Revenue Limit Sources 8010 8099 129 005 378 79 Federal Revenues 8100 8299 20 560 819 32 Other State Revenues 8300 8599 41 899 767 77 Other Local Revenues 8600 8799 15 968 447 00 Total Revenues 207 434 412 88 2 Expenditures m L Certificated Salaries 1000 1999 97 371 416 00 Classified Salaries 2000 2999 30 409 122 00 Employee Benefits 3000 3999 44 432 239 00 Books and Supplies 4000 4999 7 810 509 47 Services and Other Operating 5000 5999 26 589 838 82 Capital Outlay 6000 6900 220 413 00 Other Outgo 7000 7299 4 254 256 00 Direct Support Indirect Cost 7300 7399 538 723 00 Debt Service 7430 7439 99 000 00 Total Expenditures 210 648 071 29 CLLLIILLILTLIC CER RR d RR GA 87 All values in Cash Flow are projected by default using standard distribution for each Object Resource
87. cords by user Ajit Mandal O Filter records by object ne m Sort results by Resource object year O Date Previous Click Next Audit Logging report looks similar to the one shown in Figure 4 75 Figure 4 75 Audit Logging Report LEA San Diego Unified Projection alex 0425 07 Audit Logging Filter Date from 4 27 2007 to 4 27 2007 Page Resource Year Old Value New Value Changed Changed On By Object Detail Resource Object Value Noncapitalized Equipment 0000 4400 2006 07 Modified 150 00 2007 04 27 Ajit Mandal Screen 14 55 04 Object Detail Resource Object Value Noncapitalized Equipment 0000 4400 2007 08 Modified 150 00 2007 04 27 Ajit Mandal Screen 14 55 04 Object Detail Resource Object Value Noncapitalized Equipment 0000 4400 2008 09 Modified 150 00 2007 04 27 Ajit Mandal Screen 14 55 04 RV Delete Resource Object Value Textbooks and Materials 0000 4100 2006 07 Deleted 2007 04 27 Ajit Mandal Object 14 57 16 RV Resource Resource Object Rule Code Cust 0000 4400 2006 07 Rule 0 0000 2007 04 27 Ajit Mandal Object Rule Added 14 57 20 Update RV Object Rule Resource Object Rule Code Cust 0000 4400 2007 08 Rule 0 0000 5 0000 2007 04 27 Ajit Mandal Update Modified 14 57 25 RV Object Rule Resource Object Rule Code Cust 0000 4400 2008 09 Rule 0 0000 7 0000 2007 04 27 Ajit Mandal Update Modified 14 57 25 Name of the screen page in which change occurred
88. creation E wt report Report orientation p Portrait O Landscape Notes and Documentation in report Include O Suppress Reports you have selected Revenue Limit Audit Logging Report Previous Click Next 4 12 2 Standard reports There are several standard reports in the Reports screen e Revenue Limit SACS Form 01 FCMAT Report Summaries Salary Forecaster Unrestricted Cost of 1 Restricted Cost of 1 Combined Cost of 1 Fiscal Health Risk Analysis Public Disclosure of Collective Bargaining Agreement AB1200 Cash Flow Summary Cash Flow Revenue Detail Enrollment Staffing by Grade Staffing by Resource Resource Detail Resource Object With Rule s calculation Projection Rules Projection Mistakes Projection Notes To generate the report s you need simply check the boxes of the report s and click Next button 121 All reports except SACS Form 01 and FCMAT Report are the same reports that could be generated from their screens Additional options for standard reports include e Select what summary report to generate Restricted Unrestricted Combined or all e Resource tree to select resource codes to generate resource detail report for You may use and l to collapse expand resource tree 4 12 3 System reports There 2 system reports currently in Budget Explorer e Audit Logging Report e Auto Balancing Report 4 12 3 1 Audit Logging Report Audit Logging Report will sh
89. d IDEA Preschool Local Entitlement Part B Sec 611 NEOON Reset Balance for the following list of resources You may enter resource code s or range s in either of these formats 3324 Custom Resource Leave as is Reset 3345 Special Ed IDEA Preschool Staff Development Part B Sec 619 VOGO Reset Balance 3385 Special Ed IDEA Early Intervention Grants TOUT Reset Balance e 724 e 4000 81500 e 4000 9999 3550 Vocational Programs Voc amp Appl Tech Secondary II C Sec 131 Carl Perkins Act KI etait Reset Balance Unnecessary values can be 3710 NCI R Title IV Part A Drua Free Schook ETT reset emoved by clicking the image Select Reset to Default Rules for All Resources Select Balance for All Resources Start Click Start button pra to start the process eset List To Default Exception resource list management Save List 4 11 3 Tools Tools tab provides access to two items e Public Disclosure of Collective Bargaining Agreement AB1200 see Figure 4 65 on p 114 e Fiscal Health Risk Analysis Report Adjustment see Figure 4 66 on p 114 114 Figure 4 65 Public Disclosure of Collective Bargaining Agreement CGanerata Save Public Disclosure of Collective Bargaining Agreement AB1200 a_i mm ru Add Select Bargaming Unit Unnamed tJ 2 Explanation i Explamarinns da impact Unrestricred General Fund 4bzimpact Restricted GenaralFumd c impact Combi
90. d balance v isexwusm S wesen Bas 507 208 04 E ws s ZEE E ss Note icon mean you can add notes see paragraph 3 1 5 on p 19 to object groups To see objects of a group click object group code to enter Object Detail screen see Figure 4 13 Notice Rules column on this screen indicating you can apply rules see chapters 3 2 on p 22 and 4 6 on p 67 to object Figure 4 13 Object Detail screen Object Detail 4000 4999 Books and Supplies marra Fund Count Soeheod Service Find Unread Resources only Commands fa Add Objects rd Sve changes E Go Bark Help Reports gy Excel NKesagrce OQUO IE mrestricit d T Bm a S Omom obet am 0 00 E 143 060 00 5 wu c B Books and Reference Mat 430p 5 one wi AS no 5 oo S n Custom Object a210 5 0 00 5 mue 5 mae A eB Materls and Supphes 4300 S 21mm LS 0x 5 w VH Custom Object 4310 5 0 00 5 24MM S 2144889 A pe B Custom Object 4320 5 o an E enm s sumo B5 o BH Custom Ohjeet 4352 0 00 HE monum moa 3 e B Custom Otjact 4353 0 00 E 5p nno e B Custom Object 4370 E 0 00 277 155 00 miso B m Custom Object 4380 o oo s ET 500 00 sum p Nancaptalred Covgmant 4400 4 904 600 68 fA 4 ooo ux e B Cusco Qiect 4410 s 0 00 s 40577400 oe b v Food 4700 ao 7 A aw 0 s B On the object detail screen you may POF JPOF 67 e Add object s you need using Add button in Menu Bar see Figure 3 1
91. detail screen calculation for 3217 is present total amount from lines A 14 3212 and A 18 3216 transfers to Resource 2420 2400 Object Amount from Revenue Limit line 25 3045 transfers to Resource 2420 2400 Object 8091 Revenue Limit line 13 3098 must agree with Objects 8092 and 3801 3802 Revenue Limit line 16 3029 must agree with Object 8070 Amount from Revenue Limit line 28 transfers to Object 8011 of Resource 0000 4 10 Cash Flow 4 10 1 Cash Flow The Cash Flow module is a fully integrated component of Budget Explorer The following information illustrates the direct interaction and data sharing that occurs between Budget Explorer and the cash flow module e The base year and number of projected years included in your projection are exactly equal to the number of years of cash flow data that the cash flow module will display for you For example if your projection is for the current year plus two projected years then the cash flow module will similarly reflect the base year plus two projected years e When viewing the Cash Flow Overview screen the data displayed for the base year precisely matches the base year data displayed by the Combined Resource Summary from the Navigation Tree see Specifically depending upon how many years your projection reflects the following will hold true Combined Resource Summary Base Year Combined Resource Summary Proj Year 1 Combined Resource Summary Proj Year 2 Combined Resour
92. e Cancel Undo Changes 4 10 4 3 Entering Actuals by Objects Range Entering Actuals by Objects Range provides object view for all months It 1s recommended to use this screen to reset actual values to projected or change distribution schedule Click on the object group link on the left column of the table to input data see Figure 4 44 on p 97 Figure 4 44 Cash Flow Detail Data Input Mode Edit by Object Range link Revenue Limt Sources 8010 6099 169 920 297 37 1 566 277 60 1 424 Federal Revenues 8100 8299 34 013 836 00 0 00 Other State Revenues 8300 8599 Z7 315 661 00 1 323 740 50 1323 Other Local Revenues 8600 8799 5 869 541 00 0 00 Interfund Transfers In 8900 8929 0 00 0 00 All Other Financing Sources 8930 8979 0 00 0 00 Total Receipts 287 119 335 3 2 890 018 20 2 748 Certificated Salaries 1000 1000 138 641 356 23 4 159 240 69 5 5451 Classfied Salaries 2000 2999 44 702 131 00 1 341 063 93 1 7884 Employee Benefits 3000 3999 72 795 263 77 2 183 857 91 2 9114 Books and Supples 4000 4999 20 567 690 60 3 085 153 59 3 085 1 Services and Other Operating 5000 5999 29 400 438 40 2 260 893 71 2260 Capital Outlay 6000 6900 522 589 00 78 388 35 78 Other Outgo 7000 7295 175 24 00 o oo Drect Support Indirect Cost 7200 7359 Click on the link to edit DICE SMVER 5354599 values by object group Interfund Transfers Out 7600 7629 EEEE DIN Cash Flow Edit for the object range window will open see Figure 4 45 on p 97 F
93. e to step advancement on a salary schedule 3 2 3 Custom Rules Custom Rules can not be edited in advance Like the Standard Rules these rules are meant to be used multiple times throughout a projection At the time that you apply a Custom Rule you will be asked to enter the appropriate dollar or percentage amount s Custom Rules include the following Table 8 Custom Rules in Budget Explorer Rule CustAmt Custl Amt Cust1Pct CustPct ManInput PRO ZAP Full Title Custom Amount Custom One Time Amount Custom One Time Percent Custom Percent Manual Input Proportional Zero Out Table 9 below lists each of the Custom Rules along with typical uses and scenarios where each rule may be used 20 Table 9 Custom Rules Description Rule CustAmt Custl Amt CustPct Cust1 Pct ManInput Pro ZAP Description Purpose The rule may be used to add or subtract specific amounts When you select this rule for use on an object line Budget Explorer will prompt you to enter the dollar amounts you want to adjust for the Ist and or 2nd years The amounts you enter can be either positive or negative Similar to the CustAmt rule the Cust Amt rule can be used to add or subtract specific amounts However as the name of this rule implies the Cust Amt rule allows you to make changes that affect only 1 of the projected years For example if you knew that Interest Income Object 8660 was going to increase by approximately 50 00
94. eceipts by object Resource 0000 Unrestricted Object Group 8010 8099 Revenue Limit Sources Resource 0000 Unrestricted Select Resource Object Group 8010 8099 Revenue Limit Sources Principal Apportionment 8010 0 00 0 00 0 00 Revenue Limit State Aid Current Year 8011 3 645 709 14 0 00 y 502 459 00 CharterS4 Click on the link to 0 00 0 00 aN Revenue edit values by object 0 00 0 00 0 00 Tax Relief Subventions 8020 0 00 0 00 0 00 Cash Flow Edit for the object window will open see Figure 4 47 on p 98 Figure 4 47 Cash Flow Detail Data Input Mode Cash Flow Edit for receipts object Cash Flow Edit Commands Go back Upload Ac Resource 0000 Unrestricted e 8011 Revenue Limit State Aid Current Year Click on the Budget Amount 3 645 709 14 Fiscal Year 2011 12 column header to enable editing Projected Actual B Variance B A July 0 0000 Mis 0 0 August 0 0000 Mis 0 00 502 459 00 502 459 00 September 426 547 97 5024594 Click on 75 911 03 thecell to 0 October 0 0000 96 0 00 2 334 983 aftie 334 983 00 Mi eiue zxpr3 E December 9 0000 96 328 113 82 17 6733 401 967 00 73 853 18 January 25 3000 96 922 364 41 7 3631 167 468 00 754 896 41 February 0 5000 96 18 228 55 0 7355 6 S 16 729 00 1 499 55 March 0 0000 0 00 Check to use actual 3 0 00 April 167 702 62 amount Uncheck to Q K 133 772 38 May 1 50
95. elect Balance for all resources When resources are selected click Start button to run the procedure ATTENTION for auto balancing use Balance button only as it is shown on Figure 4 62 p 111 Reset button is used to reset rules see paragraph 4 11 2 on p 112 111 Figure 4 62 Auto Balancing screen Auto Balancing for Projection Select Reset to update all Select Balance to Anto balancing check the resource s by clicking the Balance i rules in resource to default i balance resource Reset to default rules check the resource s by clicking the Reset button of the table to select the resource s t reset rules for gnd press Start button Auto balance order management Auto Balance Ofjec gt 3550 Vocational Programs Voc amp Appl Tech Secondary I C Sec 131 Carl Perkins Act KFO Reset Balance Unnecessary values can be emoved by clicking the image Reset Balance 3011 Custom Resource Reset e 41008 You may enter object code s or range s in either of these formats 3025 NCLB Title I Part D Local Delinquent Programs Reset Balance 42000 43000 e 4000 3026 Custom Resource Reset e 44000 4000 9999 e 47000 3185 Custom Resource Reset e 5200 Unnecessary values can be 3200 Custom Resource Reset Balance mere oO removed by clicking the image 3310 Special Ed IDEA Basic Local Assistance Entitlement Part B Sec 611 formerly P Reset
96. eporting period m Enable disable Audit Unaudited actuals Export projection Logging data to csv file Type of financial data Budget Note Change financial data type Save Cancel On this screen a user can make some modifications to the projection see Table 20 Table 20 Projection adjustment settings Field Description Projection Title Displays projection s name Enter new value and click on Save button to rename the projection Years to forecast Select number of years to forecast from the list All data in your projection will be recalculated for the number of years you have selected Show Historical Year Check uncheck to show hide historical data on Resource Summary and Individual Resource screens Enable Audit Logging Check uncheck to switch on off Audit Logging see chapter 4 11 4 on p 114 4 4 Summary screen There three types of summaries in Budget Explorer e Combined Summary e Unrestricted Summary e Restricted Summary 65 Click on Navigation Tree button see Figure 3 1 on p 15 select the summary see Figure 3 3 on p 17 summary screen will open see Figure 4 11 Figure 4 11 Summary screen General Fund County School Service Fund Unrestricted Resources Only Expermaditarr Commands H Save changes H Graph Help yerum mats Generate reports a Excel Rivinad Limit Sources mpo sp 44 819 05 18 S Ta THT HSL S LO S Federal Revenues 8100 8290 2347 tar 7158 47
97. erminates import SACS File process Warning will appear and if you click OK button no projection will be created and you will see Projection List screen Click I7 5 wil complete adding a new projection and open it for you 58 Figure 4 5 Import SACS File step 5 Import SACS File Data Verification Notice Historical enrollment data values are drawn from state reported CBEDS data Please review these values to ensure they are m alignment with expected values or change the values if necessary Current and Prior Year ADA Data values are drawn from supplemental RL form data if available Revenue Limit Calculation values are drawn from imported data if available The selected SACS data file contams the following ADA values to be used for Revenue Limit calculation Fiscal Year Report Period CotlumnCode Value Using either the Enr ADA Staffing screen or the Revenue Limit calculation screen please verify the fiscal year placement of these data values to ensure that BE uses the correct ADA values for Revenue Limit calculation Please review the Enrollment ADA and Revenue Limit calculation values to ensure that the data conforms to local student population and economic expectations Click Finish to mdicate acceptance of these Information Messages or click Cancel to return to the Projection List screen Finish Cancal 4 1 2 Copy Projection There are a number of reasons to copy projections Make a copy for a colle
98. ew DAT file are uploaded 2 All user adjustments remain unchanged rules and notes 3 All objects which are absent in a new DAT file but present in the projection become zeroes all rules and notes are removed 4 All objects added by default will be restored with default rules and zero value in case they are absent in a new DAT file 5 For resource view projections all resources absent in a new DAT file will be removed all resources from a new DAT file will be uploaded Import a new SACS data file Select new SACS data file Use the field below to provide a description for the selected SACS data file OR Select previously imported SACS data file elect a Previously Imported SACS data file 9 Lagunitas 2010 11 Expanded Data File Production 1 25 2011 3 34 55 PM 1 0 0 LACOE 10 11 2IntlP Detail Verified 5 10 5 11 2011 10 26 20 AM 0 10 11 LACOE 2nd Interim Testing 5 2 2011 12 19 40 PM O 0 LACOE 09 10 Unaudited Actuals for Comparison with SACS 5 2 2011 4 33 57 PM 0 LACOE 10 11 2IntlP Summary w Missing Historical Objects 01 5 5 2011 1 43 13 PM O 0 LACOE 10 11 2nd Interim Detail From Spreadsheet 5 4 2011 11 14 15 AM O0 LACOE 10 11 2nd Interim for Comparison with SACS 5 3 2011 10 18 34 AM O 0 Test of Changing BYT 5 16 2011 12 43 32 PM 1 that works 1 31 2011 2 43 34 PM 1 that works 2 1 31 2011 2 47 01 PM m Remove selected V
99. existing projections must be updated manually These projection rules listed in Figure 4 15 represent the forces that can be applied to base year amounts to control out year behavior 68 There are 2 icons in the Note Rule Mapping column First icon indicates if there is a note for the rule Second note is the link to see all objects object groups and Revenue Limit lines this rule is applied to Double click the rule to see Edit Projection Rule screen see Figure 4 16 Make any changes to values you feel necessary to adjust the rule Use Note field to include documentation it 1s not obligatory Notice that you can add a note that will help you remember what your assumptions were at the time you set the rule values Another way to enter notes for the projection rules is to click on the Notes icon to the right of any rule in the Projection Rule screen see Figure 4 15 on p 68 Notice that note icon changes color when rule exists Figure 4 15 Projection Rules screen Projection Rules Rule Title 2010 311 2011 12 CertCOLA Certificated COLA 96 0 0096 0 0096 0 0096 ClassCOLA Classified COLA 0 00 0 00 0 00 CertColumn Certificated Staff Column Increase 96 0 0096 0 0096 0 0096 Note icon indicates by CertStep Certificated Staff Step Increase 96 0 00 0 00 0 00 color if there a ese ClasStep Classified Staff Step Increase 96 0 00 0 00 0 00 for this rule CPI California CPI SSC 1 20 1
100. f 73900 762 06 Materials and Supplies 4300 483 380 00 426 897 00 f 441 842 92 455 631 16 BR gi Noncapitalzed Equipment 4400 70 240 00 57 198 00 f a ADA 59200 54 61 047 96 T Food 4700 0 00 f CPI 0 00 oo0 Books and Supplies 4000 4999 1 025 162 00 952 720 00 986 075 30 1 016 846 96 38 Figure 3 17 Edit Rules for screen List of applied rules Edit Rules for 4300 Materials and Supplies Applied Rules Title vomn Year to Year Change in RL ADA 0 00 0 00 0 00 0 00 Ege Calfornia CPI SSC 3 20 2 80 3 00 3 10 hav Remove all Rules Apply New Rule a ClassCOLA Classified COLA CertColumni Certificated Staff Column Increase CertStep Certificated Staff Step Increase ClasStep Classified Staff Step Increase INI Interest Rate Trend for 10 Year Treasuries SSC x NetCOLA Net Funded Revenue Limit COLA SSC List of RLDef Revenue Limit Deficit K 12 SSC available p sapere Special Education COLA SSC CatCOLA State Categorical COLA SSC rules StCOLA Statutory COLA SSC HW amp Health amp Welfare Benefit Increase Tier I Tier I Programs TierII Tier II Programs Link to Zap Resource screen TierIII Tier III Programs CustAmt Custom Amount Cust Custom Percent CustiAmt Custom One Time Amount Custl Custom One Time Percent Maninput Manual Input PRO Proportional Ta i aD Zero Out Enr Year to Year Change
101. from a keyboard Many screens where you enter data have pop up menu which could be accessed by right click on the value see Figure 3 29 This menu has several commands to make your work easier and more convenient These commands are explained in Table 16 49 Figure 3 29 Pop up menu for editing values Object Detail 6000 6900 Capital Outlay a You have unsaved changes Land Buildings and Improvement of Buildings Books and Media for New School Libraries or Major Expansion of School Libraries Custom Object Equipment Equipment Replacement Capital Outlay Commands 3 Add Objects Pop up menu to work with values Table 16 Pop up menu items Menu item Cut amount Copy amount a Paste amount Add amount Subtract Source from Destination B Subtract Destination from Source amp Reset a value to initial View calculator Description Current amount will be cut into the clipboard current field value will be set to O Current amount will be copied into the clipboard current field value will remain unchanged Amount from the clipboard will be inserted into current field to substitute current data Amount from the clipboard will be added to current field value Amount from the clipboard will be subtracted from current field value result will substitute current data Current field amount will be subtracted from the amount in the clipboard result will substitute current data
102. hanged 4 11 5 2 Update Projection Interface Open Home page see Figure 4 67 on p 116 in the left most column you will find a sentence that reads Click here if you want to update all base values in the projection Click on the here link and BE will display a Update Projection screen see Figure 4 68 on p 117 that will allow you to select a new SACS data file to be uploaded 116 Figure 4 67 Link to updating base values screen Los Angeles County Office of Education LACOE ACTIVE Working Copy Base Year 2010 2011 Welcome Ajit Projection List logout Bud getExplorer FCMAT 2 Rules 3 Form A Staff 4 Salary Forecaster 5 Revenue Limit 6 Cash Flow 7 Auto Balancing 8 Tools 9 Reports RES Clic ee e c rm SSS eee Los Angeles County Office of Education LACOE ACTIVE Working Copy ene Attention 4 11 2011 State Aid Portion of Revenuie Limit a Please note that the Salary Forecaster Rule is no longer in use anywhere in the projection County Office Users Please note that the amounts from line 27 TOTAL REVENUE LIMIT are not automatically transferred to resource 0000 object 8011 ee Reni DEN ar AOL PrO ecd Socana RD EC CUIU NE restricted resources on Staffing by Resource page You will have to manually adjust the TOTAL REVENUE LIMIT values to deduct Property Tax Revenues and Local Sources The purpose of these deductions will be to determine the State Aid Portion of Revenue Limit These State Aid Portion values can
103. ide Adiustment Page Enter your Enrollment ADA Teacher Staffing data Enter your Revenue Limit data J 8 Reports Create and view reports Navigation Tree Resources listed in navigation tree have following color marks 3177 Custom Resource Resource has positive balance 3177 Custom Resource Resource has negative balance 3175 Custom Resource Resource was autobalanced 3175 Custom Resource Resource was autobalanced but following changes made its balance negative Other Icons v The rule icon is used to apply rules for projecting data in future years Hover your mouse over this icon to reveal the list of rules applied To help you keep track of the assumptions that you make while creating your projection click on the Notes icon to the right of the corresnondina line item FCMAT 2005 2011 Question Suggestion Peroxient Technologies Inc 4 3 Projection Adjustment Click on the link to Projection Adjustment located at Welcome to Budget Explorer screen see Figure 4 9 on p 63 This will display a screen shown at Figure 4 10 64 Figure 4 10 Projection Adjustment screen Projection IEEE Change Adjust Projection Title Projection Title LACOE ACTIVE Working Copy Years to forecast Select Number of years gt Se T Show Historical Year Other commands i wee J Shows hides historical T Show page help data on Resource Enable Audit Logging Summary and Individual p Export to file Resource screens Financial r
104. ies object range 1000 1999 Using the Pro rule on an object line tells Budget Explorer to make a proportional and corresponding adjustment to the amounts on the line where the Pro rule is being used To be specific if expenditures for Certificated salaries were going up by 346 annually then any object line where the rule PRO 1000 1999 was used would also increase by the same 3 rate This rule sets values for all next years to zero ZAP Resource rule is available from two screens e Object Rule Screen e Projection Rules Screen Edit Rules for 4100 Textbooks and Materials Applied Rules Year to Year Change n RLADA 0 00 07 California CPI SSC Link to Zap Resource screen r7 12 13 4 2 7096 3 1096 3 1096 e 002 Ea j pja v LA ClassCOLA ert Certificated COLA Classified COLA CertColumn amp Certificated Staff Column Increase CertStept Certificated Staff Step Increase ClasStep Classified Staff Step Increase INT Interest Rate Trend for 10 Year Treasuries SSC NetCOLA Net Funded Revenue Limit COLA SSC RLDef Revenue Limit Deficit K 12 SSC SpEdCOLA Special Education COLA SSC CatCOLA State Categorical COLA SSC StCOLA Statutory COLA SSC HWt Health amp Welfare Benefit Increase Tier I Tier I Programs TierII Tier II Programs TierlII Tier III Programs CustAmt Custom Amount Custt Custom Percent CustiAmt Custom One
105. iew of Salary Forecaster screen see Figure 4 27 The same screen will be displayed if you click SalF restr rule on Projection Rules screen see Figure 4 15 on p 68 Salary Forecaster screen has 5 sections e Base Year Teacher Salary distribution Amounts are taken from Restricted or Unrestricted resources from Object 1100 depending on active Tab e Teacher Salary Data Base Year Total Tchr Salaries is total of Base Year of Object 1100 of Unrestricted Restricted resources with Salary Forecaster rule Base Year FTE 1s total FTE for Unrestricted Restricted resources from Total Staffing FTE of Staffing by Resource screen Total Base Year Unrestricted and Restricted FTE is total FTE for Unrestricted and Restricted resources from Total Staffing FTE of Staffing by Resource screen Average values of Retiree Layoff and New Hire salaries should be entered manually 81 e Step and Column data It allows the user to account for step and column increases on the district s certificated salary schedule e Projected Certificated Salaries calculation To calculate Total Salaries for projected period enter Retiree FTE and Layoff FTE e Projected Salary Distribution Shows how projected salaries will be distributed between resources according to values on Staffing by Resource screen Figure 4 27 Salary Forecaster screen Salary Forecaster Commands Savechanges Help nt View is Unrestricted Unrestricted Resources page view Butto
106. igure 4 45 Cash Flow Detail Data Input Mode Cash Flow Edit for the object range Cash Flow Edit 1000 1999 Certificated Salaries Choose another Commands Go back Upload Ac Click on the Budget Amount 3 482 628 00 Fiscal Year 2011 12 column header to enable editing Projected A Projected Actual B Variance A B July ERT 104 478 84 0 0000 August 4 0000 139 305 12 0 0000 September 9 00009 ME S 313 436 52 0 0000 s Of Clickon zs L uw October 9 0000 96 31343652 0 0000 sesion November 9 0000 96 313 436 52 0 0000 a 000 December 9 0000 313 436 52 0 0000 L January 9 0000 313 436 52 0 0000 L February 9 0000 313 436 52 0 0000 0 00 March 3 0000 313 436 52 fi Check to use actual 0 L April 9 0000 96 313 436 52 amp mount Uncheckto jq LJ projected amount ai My 900009 S 31243652 d June 10 0000 S 348 262 80 0 0000 Ej a Accruals S 69 652 56 Actions Actions Gave User Schedule Save Actuals As a User Schedule Load FCMAT Schedule Load User Schedule SOAR 100 0000 3482 628 00 0 0000 S 0 00 Notes Type note 98 To access Actuals for Receipts navigate to Receipts Object Group screen by clicking Object group link on the left column Click on the object link on the left of the month to edit values by Object see Figure 4 46 on p 98 Figure 4 46 Cash Flow Detail Data Input Mode R
107. in Enrollment IchrStfg Year to Year Change in Teacher Staffing RLDefCOE COE Revenue Limit Deficits SSC Zap Resource Apply Rule And Go Back Apply Rule Go Back On the Edit Rules for screen you may add remove change value s of rule s 3 2 6 3 Add rule s To add a rule select it from the list of all rules in Apply New Rule section see Figure 3 17 above and click Apply Rule button Standard Rules and System Rules will be added to the list of applied rules in the Applied Rules section Their values are set on Projection Rule screen see paragraph 3 2 2 on p 25 and paragraph 3 2 4 on p 31 If you add a custom rule then click on Apply Rule button will open Edit Custom Rule screen see Figure 3 18 below 39 Figure 3 18 Edit Custom Rule screen Edit Custom Percent Rule for 4100 Textbooks and Materials Rule Cust Title Custom Percent Pre Base Yr Year 1 Year 2 2011 12 2012 13 2013 14 0 00 0 00 0 00 For negative impact amounts use the minus sign e g 1 000 00 or 1 12 The value for the Base Year is displayed for information purposes only Save Cancel On the Edit Custom Rule screen enter values for every year into proper fields You may enter negative or positive values or leave the field s with O value s When you enter all values click on Save button to record your changes or Cancel button to leave without changes You may assign several rules to one object and these r
108. inancial Reporting Software Click on Browse button and navigate to the drive and directory where your data file 1s stored then double click on the desired data file Then enter description for this file e Select a Previously Imported SACS data file Select a proper file from the list to create a new projection 54 Note after you once create a projection from a SACS file you may select this file from the list to create other projections It 1s faster than browsing each time to find a SACS file To remove previously imported SACS file select this file and click on Remove selected button After you define Import Method and enter description click on Next gt gt link to proceed Figure 4 2 Import SACS File step 1 Import SACS File Choose File Mo file chosen Use the field below to provide a description for the selected SACS data file Select a Previously Imported SACS data file UA 2009 10 11 8 2010 7 50 49 PM a UA 2009 10 11 20 2010 1 55 08 PM UA revised 10 11 8 23 2010 8 49 14 AM Un audited Actuals 70 14 2010 3 36 34 PM Unadited Actuals 2010 fiscal year 10 1 1 2010 10 15 32 AM unaduit 10 15 2010 4 36 01 PM Unaudited Act 08 09 10 12 2009 9 42 21 AM Unaudited Actuals 10 14 2010 10 17 09 AM Unaudited Actuals 12 4 2009 12 3 41 PM Unaudited Actuals 1 1 1 2010 9 41 02 AM unaudited actuals 10 22 2009 1 23 47 PM Unaudited Actuals 9 22 2010 3 17 54 PM
109. ined with dotted lines It means they have screen tips explaining underlined item To see a screen tip simply point your mouse without clicking over underlined item These screen tips may look differently see Figure 3 7 but they are aimed at providing additional information about the item they are assigned to 22 Figure 3 7 Screen tip on Revenue Limit screen Revenue Limit Calculation Commands Save changes Q Help Generate reports x Excel PDF Base Year 1 Year 2 Title 2011 12 Rules 2012 13 2013 14 1 Base Revenue Limit Per ADA a State Avg Base RL Per ADA Prior Yr 6 392 00 653500 6 744 00 b Base RL per ADA Prior Yr 652934 6738 34 2 Inflation Increase 143 00 20900 182 0 4 TOTAL BASE REVENUE LIMIT PER ADA 6 529 34 673834 6 920 34 1 Revenue Limit Subject To Deficit Point your mouse over text This screen tip explains how the values in line 2 Inflation Increase underlined with dotted line are calculated line 1 a is multiplied by StCOLA rule value 3 2 Rules in Budget Explorer and Forecasting Concept 3 2 1 Rules Concept Understanding the concept of Projection Rules how they work why they are necessary and how to use them to make your projections more accurate is fundamental to your success and forecasting accuracy with Budget Explorer The following conceptual examples may help illustrate how projection variables can be used to affect out year behavior of
110. input data entered by the user System Rules include the following Table 10 System Rules in Budget Explorer Rule Full Title Enr Enrollment RL ADA Revenue Limit ADA TchrStfg Year to Year Change in Teacher Staffing SalFrestr Salary Forecaster Table 11 below lists each of the Custom Rules along with typical uses and scenarios where each rule may be used Table 11 System Rules Description Rule Description Purpose Enr Values for the Enr rule are calculated by the system For example for values of the 2 year enrollment projection this rule will have such values Enrollment Projection Base Year Proj Year 1 Proj Year 2 1000 1 020 1 046 Enr 2 2 590 2 Growth 2 5 Growth Rule RL ADA TchrStfg SalFrcstr 32 Description Purpose The enrollment projection above shows an increasing enrollment trend of 2 in the 1 projected year and 2 5 in the 2 projected year Using this example if the Enr rule were applied to an object line the amount displayed in the 1 projected year would be increased by 2 over the base year amount and the amount displayed in the 2 projected year would be increased by 2 5 over the 1 projected year amount In other words Budget Explorer calculates the percentage rate of growth or decline in annual enrollment and then applies those same calculated percentage values to the base year amount on the object line where the Enr rule is being applied The Enr rule is typically used on revenue o
111. io buttons group By default they are Manually Enter ADA Enter Historical Data 1 e 1 Enrollment data for historical base and future years and 2 ADA for historical and base years could be entered manually see Table 23 If you change radio buttons combination some cells will become read only and some cells will be in edit mode Table 23 Radio buttons to define data entering Radio buttons group a Manually Enter b Manually Enter ADA Enrollment Factor Time period 1 Enter Historical l a Enrollment data 1 b Enrollment data for Radio Data for historical base historical base and buttons group and future years future years ADA for historical Enrollment factors for and base years historical years 2 Enter Historical and 2 a Enrollment data 2 b Enrollment data and Projected Years and ADA for enrollment factors for historical base and historical base and 73 future years future years Examples of settings Case 1 If you select default settings see Figure 4 19 below you will be able to enter Enrollment data and ADA for historical years Projected ADA and enrollment factors for all years are not editable This case is described as 1 a in Table 23 above Figure 4 19 Enrollment options case 1 Enrollment Current View is Enrolment P2ADA amp Enrollment Factors Commands J Save ch Other views Staffing m Grade Staffing by Resource For these Ppa s ADA
112. ion Rule screen Edit Projection Rule Rule iet l litle Tier Programs CM UE Enter values into Base Yi Year 1 Year I4 input fields 2010 11 2011 12 2012 13 0 00 0 00 1 80 T 1 b P noaga rU vc f 2 I Pry 11702 H LL ak hl 4 1 P UOI litc2zduvc BHiilpdct dailiouil USC UIC il i value for the Base Year 1s displaved nformation purposes onh Notes Enter or change Programs Affected Fi note 6010 After School Education and Safety 7230 Home to School Transportation Child Development 1300 K 3 Class Size Reduction Save Cancel Reset to Default In the list of rules there are four system rules see paragraph 3 2 4 on p 31 so double click on these rules does not open Edit Projection Rule screen see Figure 4 16 but opens corresponding screens to edit values see Table 21 Table 21 System rules and their calculation screens Rule Screens for calculation Enr Enr ADA Staffing Screen 1 Enrollment see paragraph 4 7 10n p 71 RL ADA Enr ADA Stafting Screen 1 Enrollment see paragraph 4 7 10n p 71 TchrStfg Enr ADA Staffing Screen 2 Staffing see paragraph 4 7 2 on p 75 SalFrestr Salary Forecaster see chapter 4 8 on p 80 Click on a dependency icon see Figure 4 15 on p 68 opens a screen similar to the 70 one shown on Figure 4 17 On this screen there is a list of objects and or Revenue Limit lines this rule is assigned to Codes of object groups and resources are shown as wel
113. ist Reset List To Default Auto Balance object list sets up object list for Step 1 balancing described in paragraph 4 11 1 1 on p 103 Enter new object or range and press Enter New object or object range always appears at the end of the list Click Save list button to save changes Auto Balance Exception Resource List sets up resource list to be exempted from Step 1 balancing process 107 4 11 1 3 How to use auto balancing There are 2 ways to work with auto balancing e Via Navigation Tree e Via Auto Balancing Screen When using Navigation Tree you may only auto balance one resource by clicking on it Via Auto Balancing Screen you may select several resources or all of them and auto balance them In Navigation Tree and in Auto Balancing Screen there are several color marks used to inform users about resource see Table 26 Table 26 Color marks Color Example Description black 3177 Custom Resource Regular color for all information red 3177 Custom Resource All resources with negative fund balance green 3175 Custom Resource All balanced resources purple 3175 Custom Resource All resources which were balanced but further violet projection editing made them negative 4 11 1 3 1 Auto balancing via Navigation Tree Click Navigation Tree button to pull Navigation Tree see Figure 3 3 on p 17 Notice that screen tips for Navigation Tree show information if a resource has negative balance see Figure 4 57 So screen tip says
114. k to a projection that you ve been working on only to discover that the rules have been changed without your knowledge leading to a completely unknown projection outcome How to Update Rules in My Projection with New Values from Revised District Rules When a new set of default rules is created based on a newly revised Projection Dartboard all users receive notification e mail Log in to the system and open projection Navigate to Rules tab 2 Rules Select rule that was updated by SSC CPI California CPI SSC LOT Res California Lottery Restricted SSC LOT Unr California Lottery Unrestricted SSC INT Interest Rate Trend for 10 Year Treasuries SSC NetCOLA Net Funded Revenue Limit COLA SSC RLDef Revenue Limit Deficit K 12 SSC SpEdCOLA Special Education COLA SSC CatCOLA State Categorical COLA SSC StCOLA Statutory COLA SSC 25 l lecti Reset to Default In Edit projection Rule screen click 77 7777 latest rule set in the Budget Explorer Edit Projection Rule button Rule will synchronise with Rule CPI Title California CPI SSC Pre Base Yr Yearl Year 2 2011 12 2012 13 2013 14 3 20 2 80 3 00 For negative impact amounts use the minus sign e g 1 000 00 or 1 12 The value for the Base Year is displayed for information purposes only Notes California CPI Save Cancel Reset to Default Types of Rules There are four types of Rules e Standard Rules e Custom Rules e Sys
115. l 79 45 PDF Help 2ZU142 1J d 3 PX n n A 71 26 44 Export to PDF Q Help 80 4 8 Salary Forecaster The Salary Forecaster is designed specifically to forecast regular teacher salaries since teachers typically comprise the largest staffing population of all employee groups within a school district For salary forecasting it is recommended using the Staffing by Resource and Salary Forecaster functionality with the following resources 1 0000 Unrestricted because of the size of the 1100 expenditures within 2 6500 Special Education because 1100 s here may also be large Also consider using functionality for e any other resource within which the 1100 expenditure amount is materially significant e any resource where sharp declines or increases in the teacher population is anticipated as a result of program changes attrition substantial changes in student enrollment or teacher retirement For other resources where there is NOT a materially significant 1100 Certificated Salaries expenditure amount you might consider the simplest and quickest forecasting route which would be to use the following combination of projection rules CertCOLA Certificated COLA CertColumn Certificated Staff Column Increase CertStep Certificated Staff Step Increase TchrStfg Year to Year Change in Teacher Staffing Salary Forecaster tab in Tab Bar see 3 1 2 on p 17 will open Unrestricted Resources v
116. l All values of objects with the rule applied are shown for every year of forecasted period As you can see on Figure 4 17 forecasting period of the projection is two years Note sometimes you could find that values are different from those you expect to appear The only reason is the influence of other rules assigned to the object 1 e if there are several rules assigned to the object read more about it in item 3 2 6 3 on p 38 On Rule Mapping screen you will see final result of all rules applied but not only of current rule Table on Figure 4 17 shows values which are used in further calculations in the projection Figure 4 17 Rule Mapping screen Resource affected by the rule Object Group affected by the rule Object or Revenue Limit line the rule is assigned to Certificated Staff Column Increase CertColumn ee 2010 11 2011 12 2012 43 0 0000 160184 0000 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated Salaries 1000 1999 Certificated
117. l see report icons in Menu Bar see paragraph 3 1 3 on p 18 x Excel Export page to Excel PDF Export page to PDF format Some pages have only one of these icons It means you can generate only one type of report usually it is PDF Some pages have no such icons It means you can not generate report for current page When you are going to generate PDF report after clicking 8 button additional menu will appear see Figure 3 26 Here a user may select whether notes and or rules to be included into report A click on one of 4 items in the menu will generate report according to option selected 47 Figure 3 26 Printing PDF report Object Detail 1000 1999 Certificated Salaries Commands j Add Objects J save changes Go Back Help Reports Excel j PDF Include notes inculde notes and rules Include rules SS Goris Rues 2012 13 201314 cash iow notes pai Select if notes or rules rines Cert Sabres 100 amp o should be pririted Certficated Teachers Salaries 1100 Je 2320077285 2370620258 Cert Compensation 1101 V INK 000 0 00 D Substtute Salaries 1110 4 s 0 00 0 00 D Extra Duty Stipends 1120 TE 0 00 o0 Cert Pupi Support Salaries 1200 A iS 541 289 59 557 203 50 Cert Superv Admin Salaries 1300 2560281200 2 673 087 92 275167670 D Other Cert Salaries 1900 AS 311 870 12 3210393310 Certificated Salaries 1000 1999 26195 4200 2715202048 2776
118. lity Title II Part D Enhancing Education through Technology Title III Language Acquisition Title IV Safe and Drug Free Schools Title V Part A Innovative Programs Title V Part B 21st Century Learning Centers Title I Part B Subpart 1 Reading First Rule EvenStart CTechEdGrant 27 Full Title Title I Part B Subpart 3 Even Start Career and Technical Ed Grants Table 7 below lists each of the Standard Rules along with typical uses and scenarios where each rule may be used The list of uses 1s not intended to be exhaustive in fact it is likely that users will discover unique and creative rule combinations as they work with the software Table 7 Standard Rules Description Rule CatCOLA ClasCOLA CertColumn CPI INT HW LOT Res LOT Unr Description Purpose Use of the rule is typically associated with restricted revenue objects The rule is usually associated with classified expenditure items within object range 2000 2999 For example if your district or county office has a bargained agreement that calls for a 1 5 salary increase for the classified group for the next fiscal year and a 2 increase in the fiscal year after that the ClasCOLA rule would easily accommodate these increases in the projection The rule is typically associated with increases in expenditures due to column advancement on a salary schedule The rule is typically associated with expenditure objects tha
119. llows the user to enter add ons and deducts that are all 83 subject to the deficit State aid and local sources portions are calculated and the user then adds supplementals Finally Budget Explorer allows the user to account for restricted revenue limit sources separately from unrestricted providing a very accurate picture of base and projected year revenue limit income Attention Revenue Limit is active in Fund 1 projections in projections created for all other funds Revenue Limit is zeroed out Revenue Limit tab see 3 1 2 on p 17 opens Revenue Limit screen see Figure 4 30 Figure 4 30 Revenue Limit screen for Districts Notice that on this screen there are many underlined row headers so screen tips are Revenue Limit Calculation 1 Base Revenue Limit Per ADA 3 State Avg Base r ADA Pri b Base RL per ADA Prior Yr 3 All Other Adjustmen ther Adjustments Tooltip is available 4 TOTAL BASE REVENUE LIMIT PER ADA Tm for this line Revenue Limit Suec To Deficit 5 Total Base Revenue Lim GIITT 22122707 2 T7l77 227 l i Current Yr Charter Schl ADA amp Deduct Necessary Small Schools ADA i COE CommSchs SpEd 7 Gain or Loss from Interdistrict Attendance Agreements 8 Meals for Needy Pupils 9 Special Revenue Limit Adjustments 10 One time Equalzation Adjustments 11 Miscellaneous Revenue Limit Adjustments 12 Less All Charter District Revenue Limt Adjustments 13 Beginning Teacher Salary Incentive
120. m One Time Percent 0 00 0 00 Manual Input 0 00 0 00 Proportional 0 00 0 00 Zero Out 0 00 0 00 Year to Year Change in Enrollment 0 00 0 00 Year to Year Change in RL ADA 0 00 0 00 0 00 0 00 0 00 0 00 2 20 17 20 110 00 4 10 1 80000 19 60800 1 80 1 80 1 80000 0 00 1 80 1 80 1 80 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 8gWwuwuus 4 TIE A TIE TIA TIA es m 30 ZAP resource allows zeroing out projected values in selected year Applying ZAP rule to selected years will zero out these years and change all rules in all objects to Man Input 31 Edit Projection Rule The rule you are trying to edit is a Custom Rule Custom rules are not editable at the projection level These rules are meant to be used multiple times throughout the system At the time that you apply a custom rule you will be asked to enter the appropriate dollar or percentage amounts You can apply ZAP rule to every object in selected resource Applying ZAP rule to selected years will zero out these years and change all rules in all objects to Man Input Attention This is NO UNDO for this operation Apply Zap to Projected Years 3180 NCLB Title School Improvement Grant W Projected Year 1 2012 13 v Projected Year 2 2013 14 Select Resource to ZAP Apply Cancel Select Year to ZAP 3 2 4 System Rules System Rules are automatically calculated by the system using
121. nd Teacher Staffing button is used to access the screen where this type of data can be entered The data entered on these screens is used in many other areas of the software and is therefore critical to the accuracy of your forecast 4 Salary Forecaster The Salary Forecaster button provides access to a screen where you can enter certificated salary data to be projected separately This is an important button since certificated salaries are the single biggest expenditure category of any district budget espe pe YO Revenue Limit is the single largest revenue item in any district budget The revenue limit calculation in Budget Explorer matches the state RL calculation and provides you all the fields you need to tie out to the dollar with your RL source documents 6 Cash Flow Create cash flow for budget 7 Auto Balancing Balance resources with negative Ending Fund Balance or set all rules in resource to default 8 Tools Create Public Disclosure of Collective Bargaining Agreement AB1200 Fiscal Health Risk Analysis Report Adjustment 9 Reports Click the Reports button to display a very easy to use report generator where you can print any information you can think out of your budget forecast 3 1 3 Menu Bar Menu Bar see Figure 3 1 on p 15 allows you to run a number of commands available for current page All buttons are explained in Table 4 Table 4 Menu Bar Button Description Button LE lg ij k k 3
122. ned General Fund S Multlypar Projections h Reserve Lewels 2 Explanations 8 Compare t BRL Change 5 Certification M 1 fa Assumptionis PUBLIC DISCLOSURE OF COLLECTIVE BARGAINING AGREEMENT in accordance with AB 1200 Chapter 1213 1991 GC 3547 5 and CCR Title V Section 15449 Page 1 Agreement Hame of Bargaining Unit Cirtificated Claxsifsecl Chir The proposed adpreement covers the period beginning july 1 2011 aed ending june 30 2012 The Governing Board will act upon this agreement om Mata This farm along with a copy of the proposed agreement must be sibmirtad to tha Coury Ofca at least ten 10 workine days pring to the date rhe Governing Moard will take action A Proposed Change in Compensation Com pomta thon Fiscal impact of Proposed Agreement Anmial Cost Tear 1 Toad 2 ear Print to bette Decrease incre erie aie lores ere Prapossd Arrpemen T Salary Schedule Percentage L oe sg E 0 00 al o0 zA Value Irem pie g ooo 5 0 60 go 70 00 Fall value 000 5 ooo ooo 5 0 00 T OUBEF CONDOS ON lh ools ool cols coo Percentage w a 8 0054 1 awo 220 5i Value from pre g noo non ona n0 Full valun amp non 5 0 00 s ooo 3 0 00 Desiri hon of otter compensation 1 Statutory Benef rs Figure 4 66 Fiscal Health Risk Analysis Report Adjustment Deficit Speeding Fund Balance Reserve for Economic Uncertainty Enrollment intertumd Horrowimg Rargaini
123. ng Agreements Goneral Rend Eacroachment Management information Systema Position Citi migen Hanit aris itetires health nenefii Leadership Si ahili Charter Schools Audit kopari facilities General Ladja is the district s Ascal health acceptable In the following areas Yeshow A V Daten Spending hn the diviricr avoiding decir spending in the punent yer r H the direct ieee detit spenadav in the b tubiegquent fiscal years a s Mas the dics controled d fis Tending ower the past Dec Apcal years h the hue of deficit spending addressed by fund balance ongoing revensies or expenditure reductions a Haa the board appeoved a plan t eumd d an ipining Generale 4 11 4 Audit logging Audit logging allows user to record all changes made by anyone to projection To start record check the box on the Projection Adjustment screen see Figure 4 10 on p 64 When this option 1s enabled all user changes are recorded Recording stops when this option is disabled unchecked Audit logging report can be generated from Reports screen only see 4 12 3 1 on p 121 4 11 5 Update projection from SACS data file This feature was developed to save time for users who would like to keep all their adjustments for new projections It means that user can update the projection with new SACS data file and all rules applied manually will remain unchanged after updating So once created projection can be used many times by simple updating base year val
124. nged in both cases see Figure 3 20 and Figure 3 21 but the order of rules is different In Case 1 Custom Percent rule was calculate first and Custom Amount rule was calculated second In Edit Rules for 4700 Food screen see Figure 3 20 Custom Percent rule is the first in the list and Custom Amount rule is the second in the list Figure 3 20 Example of rule influence case 1 Edit Rules for 4700 Food Applied Rules Base Year Year 1 Year 2 2011 12 2012 13 2013 14 Custom Percent 0 00 10 00 10 00 Z ja Custom Amount 0 00 1 000 00 2 000 00 4 Remove all Rules Object Detail 4000 4999 Books and Supplies Commands fj Add Objects lomaa eer Gene ieee oes meis SERE Textbooks and Materials 4100 467 425 00 S 467 911 00 532 722 12 604 280 98 X Books and Reference Mat ls 4200 4 117 00 71400 f 73900 762 06 gt 7 Materials and Supplies 4300 483 380 00 426 897 00 f 441 842 92 455 631 16 D T Noncapitalzed Equipment 4400 70 240 00 5719800 f 59200 54 61 047 96 BR z Food 4700 0 00 10 000 00 A 12 000 00 15 200 00 amp Books and Supplies 4000 4999 1 025 162 00 962 720 00 1 046 50458 1 136922 6 Calculations made by Budget Explorer for the case 1 are shown below Year 1 Step 1 First rule is applied 10 000 10 1 000 growth Step 2 Intermediate total for next rule 10 000 1 000 11 000 Step 3 Second rule is applied
125. nother way to rename a projection via Projection Adjustment screen see Figure 4 10 on p 64 4 1 5 Share Projection In some cases a user may want to share his her projection s with others There are two ways to share a projection in Budget Explorer e Read only access e Read write access 61 Select a projection on the Projection List screen see Figure 4 1 on p 52 and click on Share Projection button A screen similar to the one shown on Figure 4 7 will appear Figure 4 7 Projection Sharing screen Projection Sharing Selected Projections Description Preliminary budget List of users in Read only Group Available Users Read only Group Aaron Asplund aasplund Alejandro Rojas arojas List of users Abdollah Saadat Abby Aaron Thornsberry athornsberry abdus samad abdus samad 4 registered in adam musch amusch Budget Explorer m Admin Administrator Add to Read only Adrian Vargas avargas drian Vargas avargasPV Group button Ajit Kumar ajithotmail Ajit Mandal ajitkm Albert Alt aalt lt Albie Taliani ataliani Remove from Alex Acosta aacosta Alice Miller alicem Read only Group Alice Salazar asalazar Allan Garde agarde button Allan Pelletier apelletier Alonna Wentland awentland Alvina Keyser alkeyser Amy Prescott aprescott ANA BARILLAS MENDEZ ABARILLAS Andie Salvador Andie Read write Group List of users in Andrea Alvarado aalvarado
126. ns to change page view Other views Restricted Unrestricted Cost Of 1 Restricted Cost Of 1 Combined Cost Of 1 FTE total for Unrestricted resources Base year Unrestricted Teacher Salary Teacher Salary Data ep and Column Data Resource lt Salary Ratio Base Year Total Tchr Salaries 84 599 952 00 FTE Receiving a Avg Value Resource 0000 84 585 778 00 99 98 Base Year FTE 1000 Step Increase FTE 0 00 0 00 54 a o Resource 1100 14 174 00 0 02 Avg Tchr Salary 84 599 95 Column Increase FTE 0 00 0 00 Total Base Year Unrestricted 1000 00 FTE total for Unrestricted em i Restricted FTE Notes and Restricted resources Avg Retiree Salary 0 00 Avg New Hire Layoff Salary 0 00 Salary Forecaster Data 84 599 952 00 84 599 952 00 84 599 952 00 Starting Salaries Starting FTE N A 1 000 00 974 22 950 77 Retiree FTE N A 25 78 0 00 23 45 0 00 19 49 0 00 New Hire Layoff FTE Res 0000 N A 0 00 0 00 0 00 0 00 0 00 0 00 New Hire Layoff FTE Res 1100 N A 0 00 0 00 0 00 0 00 0 00 0 00 Step Cost 0 00 0 00 0 00 Column Cost 0 00 0 00 0 00 Ending FTE 1 000 00 974 22 950 77 931 28 Subtotal 84 599 952 00 84 599 952 00 84 599 952 00 84 599 952 00 Tchr Sal Increase N A 0 00 0 00 0 00 0 00 0 00 0 00 Yr End Avg Salaries 84 599 95 86 838 65 88 980 46 90 842 66 Yr End Total Salaries 84 599 952 00 84 599 952 00 84 599 952 00 FTE Ratio from Staffing Salary
127. ntea a esse tu SUeU Ead 112 dL EOS it peat tasers oct atlas et auo ERU eet fit see nan OLEUM eee t ced ED 113 ANI E trenes m ad cana ie aera tut ubdust ge aite Merrn itu teins 114 4 11 5 Update projection from SACS data file ecccccccecceesseseeeeeeeeeeeeeeeeees 114 aM Ao DOUUS m TT Im I Dm 118 AND OVNI OW rrene t ec bue d edat er xe pas beard eta edet ve pactis earum dedut 118 2 12 2 Sandar EEPO S uoto ones be wasn sales atte oe aede dca ut sagrada 120 d 125 5 Sle teDOLouecoerc o E COM Ee rod dista Mot oEed Peu 121 1 Creating Multi Year Projections using Budget Explorer 1 1 Introduction to Budget Explorer Welcome to Budget Explorer BE the Web based easy to use budget forecasting software designed for California school districts and county offices of education Because BE is Web based it 1s possible to access create and edit projections from anywhere a Web connection 1s available From the first day of development BE had 2 prerequisites e it must be simple to learn and e it must be user friendly The design of BE has met these objectives and it 1s our hope that your experience with the software will be a productive one Features of the Software simplicity notwithstanding powerful functionality has been packed into BE SACS compatibility what if modeling capability and powerful reporting features make BE an excellent tool for your CBO toolkit Many new features and modules enhance the software s capability S
128. nty Offices of Education Revenue Limit County Commands Save changes zum dicas Toe Year 1 Year 2 ear ear Description Software 2011 12 2012 13 Note Total Special Schools and Classes Sum Lines 1 through 5 3244 32 196 318 63 31 702 870 56 32 273 530 86 Direct Services 3000 189 136 00 192 110 00 195 568 00 Other County School Service Fund Operations iens 53 573 624 00 54 214 735 80 55 190 601 04 4 Minimum Teacher Salary Adjustment 3013 19 789 00 19 590 00 19 958 00 Teachers Retirement Board 3015 284 919 00 289 677 00 294 891 00 6 Community Day School 3103 23 634 538 29 24 012 468 14 24 444 688 01 Beginning Teacher Salary Incentive Funding E C 45023 1 45023 4 3085 390 347 30 397 461 67 402 062 47 8 TOTAL REVENUE LIMIT 3018 110 288 672 24 110 828 913 17 112 821 299 38 DEFICIT CALCULATION Deficit Factor 3019 0 18250 0 19892 0 19892 10 TOTAL FUNDING AFTER DEFICIT FACTOR Line 8 times 1 Line 9 3020 90 160 989 56 88 782 825 76 90 378 886 51 Revenue Limit for Handicapped Adults E C 14054 Cruz only i i Additionalinformation about Unemployment Insurance Increases Pa 1 817 157 00 1 817 157 00 1 817 157 00 PERS Reduction E C 2558 6 must agree with objects 8092 and 3801 3802 3098 478 300 98 478 300 98 478 300 98 14 TOTAL ADJUSTED REVENUE LIMIT Lines 10 11 4 12 13 3027 91 499 845 58 90 121 681 78 STATE AID PORTION OF REVENUE LIMIT FOR NON SPECIA
129. o view the Autobalancing Report or click Finish to return to the previous screen If you click Report button then PDF report will be generated see Figure 4 61 This report shows e Code of resource which was auto balanced e Object code where value was changed Year which year this change occurred Old Value value of the object before auto balancing New Value new value of the object after auto balancing Changed On date and time of change Changed By name of a person who started auto balance Figure 4 61 Auto Balancing Report Projection title em AutoBalance for Resource 3310 110 LEA Stockton City Unified Projection test schedule new2 test copy Resource Object Year 3310 4300 2012 13 3310 4300 2013 14 3310 4300 2014 15 i Old Value 222626 76 217684 15 218699 29 New Value 216563 00 216563 00 216563 00 Changed Changed On By 2011 07 28 Ajit Mandal 14 46 08 2011 07 28 Ajit Mandal 14 46 08 2011 07 28 Ajit Mandal 14 46 08 4 11 1 3 2 Auto balancing via Auto Balancing screen Click Auto Balancing tab see Figure 3 1 on p 15 to open Auto Balancing screen see Figure 4 62 on p 111 This screen has extended functionality Auto balancing and Reset to default rules see paragraph 4 11 2 on p 112 A user may select several or all resources to auto balance by clicking buttons on the right side of resource title or clicking the button S
130. ojections 35 Figure 3 12 Rule Management G Search Criteria Search Show All Name Title Date By Is Active Ajit s test Ruleset Ajit s test Ruleset 2 FCMAT Default FCMAT Default Object Code Rules Share Edit Description for selected selected Rule Set Rule Set Edit Ruleset Delete Ruleset Add Ruleset Edit description Add Copy Share Activate View 1 2 of 2 Edit Remove P E Copy selected selected uen selected Rule Set Rule Set Rule Set Column Action see Figure 3 12 allows user to view or edit rule set Click on View or Edit action will open Object Code List see Figure 3 13 If the rule set is opened in View mode no changes can be made If the rule set is opened in Edit mode default rules may be added modified or removed from objects To change applied rule s select an Object row and click Edit Resource Rules see Figure 3 13 Activate selected Rule Set Indicates active Rule Set Figure 3 13 Object Code List e Search Criteria Search Show All Other commands import from file Object Group Group Title Code Title Always A Close Date 1000 1999 Certificated Salaries 1000 Cert Salaries 2 1000 1999 Certificated Salaries 1001 Custom Object 3 1000 1999 Certificated Salaries 1002 Custom Object 4 1000 1999 Certificated Salaries 1003 Custom Object 5 1000 1999 Certificated Salaries 1004 Custom Object 6 1000 1999 Certificated Salaries 1005 Custom Object 7 1000 1999 Certificated Salaries 1006 Custom Object 8 10
131. ome From FCMAT uses the School Services of California SSC Financial Projection Dartboard as the source for the default rules in BE FCMAT will update the default projection rules promptly with each revision of the Dartboard As SSC cautions These figures are estimates which are subject to revision at any time Please carefully review the projection variables to ensure that they are appropriate for your K 12 funding perspective and local economic outlook 24 User can create his her own rule sets to use for new projections see item 3 2 6 1 on p 33 How do the Rules get Into a Projection Projection rules are downloaded into a projection automatically and only once at the time the projection is created From that point forward changes that FCMAT makes to the default rules based on new Projection Dartboards will have no impact on existing projections Instead any new projections that you create will download and automatically reflect the new default rules How Often are the Rules Updated The default projection rules within Budget Explorer are updated every time the SSC Projection Dartboard is revised by SSC SSC revises the Projection Dartboard 4 or 5 times per year Will New Rules Change My Existing Projections When a new set of default rules is created based on a newly revised Projection Dartboard projections that you have already created are NOT changed in any way This is intentional you would not want to come bac
132. ome of these modules include Enrollment Projection Module Revenue Limit Calculation Module Salary Forecasting Module Resource Auto balancing Module Audit Logging Module Update Projection Module Cash Flow Module 1 1 1 District Office Uses The primary objective of BE 1s to help districts make more informed budgeting decisions by projecting the fiscal impact of current decisions on future fund balance The following list outlines just a few of the other uses that make Budget Explorer such a useful tool e Budget Explorer can be used to create multi year projections for inclusion in first and second interim reports e Users can predict how an increase or decrease in enrollment will impact fund balance e What if analysis can help districts accurately determine how a salary increase or COLA will impact expenditures e Sensitivity analysis can be used to determine the impact of a change in a single variable over an entire projection e Projection reports can be provided to board members and the community to convey long term fiscal health e The impact of changes in class size ratios on teacher staffing requirements and certificated expenditures can be accurately determined e Valuable information can be provided in a very timely manner during negotiation meetings with staff units e Information crucial for budget creation and maintenance is provided by BE when budget time rolls around e Fine tuning adjustments in revenue limit
133. on on district fiscal trends allowing remedial action before it s too late Maintaining AB1200 fiduciary oversight over the fiscal condition of local school districts is the legislatively assigned responsibility of every county office in the state However there is no standard for the source structure or system to be followed by district staff in creating the multi year projections contained within submitted interim reports Some districts user spreadsheets while others use dedicated multi year projection software such as MYP marketed by School Services of California Without standards for how multi year projections are to be created it is impossible for county office staff members to easily review and confirm the validity of the assumptions variables and rules that are integral to the projection integrity As a result county office staff members are sometimes forced to accept the validity and integrity of local school district projections with little or no quantitative analysis on which to base the acceptance Budget Explorer changes this by providing a standard for projection rules that can be easily reviewed for validity by county office staff Suddenly projections become a true tool for reviewing long term fiscal health offering a true and accurate insight into the fiscal well being of local school districts 1 1 5 System requirements MS Windows XP Windows Vista Windows 7 MS Internet Explorer v 8 Firefox 3 5 Chrome 12 Safari 5
134. on to its previous state or reset its rules to initial ones Figure 4 64 Reset to default rules Auto Balancing for Projection Select Reset to update all Select Balance to Auto balancing check the resource s by clicking the Balance t rules in resource to default we balance resource es ae Reset to default rules check the resource s by clicking the Reset button of the table to select the resource s th reset rules for gnd press Start button management and Auto Bal O Auto balancing en e report CEVEA Reset Balance a 3010 NCLB Title I Part A Basic Grants Low Income anc 3011 Custom Resource EFEO Reset 41008 You may enter object code s or 000 range s in either of these formats 3025 NCLB Title I Part D Local Delinquent Programs EZE Reset Balance 3 4 1 43000 e 4000 3026 Custom Resource CEA Reset e 44000 4000 9999 47000 3185 Custom Resource CKG Reset e 52000 Unnecessary values can be e 53006 removed by clicking the image 3200 Custom Resource TUA tei Reset Balance 54000 3310 Special Ed IDEA Basic Local Assistance Entitiement Part B Sec 611 formerly P TTE Reset Balance e 550068 Save List Reset List To Default 3313 Custom Resource Leave as is Reset 3315 Special Ed IDEA Preschool Grants Part B Sec 619 cei etme Reset Balance Autobalance Except Resource List 3319 Custom Resource ZALEGE Reset Auto balancing is set to 8980 object only 3320 Special E
135. ow all changes which took place when Audit Logging function was enabled on the Projection Adjustment screen see Figure 4 10 on p 64 Steps to generate Audit Logging Report see Figure 4 74 on p 122 Step 1 Check the box of Audit Logging Report Click Next Step 2 Select time period All changes made during this period will be shown in the report 1f audit logging was enabled during that period Select resources to include in the report By default all resources are checked You may use and Hl to collapse expand resource tree Filter by object If needed check Object box and enter the object code in the field This would be the only object to be displayed in the report Filter by user Check the User box and select a user from the list All changes of the selected user will be in the report Click Next Step 3 Select Report orientation and select option to include or exclude notes Click Next button to create PDF report 122 Figure 4 74 Audit logging Report Report Generator Step 2A Report Audit Logging Report Customization SPSL PRR RY CS RENI ST SEEN IES AEF RCS REE Q 4 aA Adjust this form to make your own Audit Logging Report to review User Changes i _ Customize report Select a date range IUDI c IT s TO Choose resources that will be included to the report M Alt Resources 9 m An Unrestricted Resources M All Restricted Resources M Filter re
136. problem when their browser is out of date or 1f compatibility view is on in IE 8 Please follow the steps below to correct this situation Step 1 Upgrade browser to Firefox 3 5 Chrome 12 Internet Explorer 8 or IE 9 Safari 4 Click on the icon link in the message to upgrade browser In case you do not have administrative rights on the workstation you would need to contact your system administrator to complete this installation Once you upgrade your browser Internet Browser out of date message will disappear and the proper BE v5 0 login screen should appear If you are still receiving the above message please follow the recommendations in step 2 Step 2 Set compatibility view off in Internet Explorer 8 or IE 9 1 Navigate to Tools 2 Click on Compatibility view fr Bi il i L7 d Pagev Safety Tools hagnose Connection Problems Reopen Last Browsing Session Pop up Blocker Manage Add ons Work Offline p x 3 b el ii Compatibility View Compatibility View Settings Full Screen Toolbars Explorer Bars Developer Tools Suggested Sites OneNote Linked Notes Send to OneNote Blog This in Windows Live Writer Internet Options J Check mark will disappear on the left of Compatibility view n en m imum a ee iio cm dnx L m Diagnose Connection Problems Reopen Last Browsing Session Pop up Blocker Manage Add ons Work Offline Compatibility
137. r expenditure items where the out year behavior generally correlates with enrollment patterns Textbooks and Materials Object 4300 is a good example of using the Enr rule similar to the Enr rule values for the RL ADA rule are calculated by the system Budget Explorer calculates the percentage rate of growth or decline in annual ADA and then applies those same calculated percentage values to the base year amount on the object line where the Enr rule is being applied The RL ADA rule is typically used on revenue or expenditure items where the out year behavior generally correlates with ADA patterns Similar to the Enr and RL ADA rules values for the TchrStfg rule are calculated by the system Budget Explorer calculates the percentage rate of growth or decline in annual teacher staffing populations and then applies those same calculated percentage values to the base year amount on the object line where the TchrStfg rule is being applied The TchrStfg rule is typically used on revenue or expenditure items where the out year behavior generally correlates with teacher staffing populations Salary Forecaster rule 1s calculated by the system Budget explorer calculates annual projected certificated salaries This rule 1s assigned to 1100 object of 0000 resource Salary Forecaster rule enables Staffing by resource module The Staffing by Grade and Staffing by Resource screens are mutually incompatible and should not be used simultaneously 1 Use
138. roup 8010 8099 Revenue Limit Sources Principal Apportionment Revenue Limit State Aid Current Year Charter Schools General Purpose Entitlement State Aid 8915 Revenue Limit State Aid Prior Years Tax Relief Subventions Homeowners Exemption zi Select Resource 8010 8011 8019 8020 8021 w 4 4 A Budget 0 00 3 645 709 14 502 459 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 9 384 00 469 20 469 20 92 93 Aggregate Data Input mode allows to enter Actuals from overview screen for Receipts Disbursements and General Ledger accounts see Figure 4 38 Figure 4 38 Cash Flow Aggregate Data Input Mode Cash Flow Commands You are working m Aggregate Data Input Mode amp Jul p 7 jected Click on the cell m to edit value Receipts Revenue Limit Sources 8010 8099 4 637 968 14 Federal Revenues 8100 8299 380 293 00 Other State Revenues 8300 8599 1 048 315 00 Other Local Revenues 8600 8799 401 286 00 Interfund Transfers In 8900 8929 0 00 All Other Financing Sources 8930 8979 0 00 Total Receipts 6 467 862 14 Certificated Salaries 1000 1999 3 482 628 00 Classified Salaries 2000 2999 1 046 948 00 Employee Benefits 3000 3999 1 098 170 00 Books and Supplies 4000 4999 189 894 00 Services and Other Operating 5000 5909 481 359 00 Capital Outlay 6000 6900 0 00 Other Outgo 7000 7299 35 000 00 Direct Support Indirect Cost 7300 7309 8 961 00
139. s both historical and projected are in edit mode This case is described as 2 b in Table 23 on p 72 74 Different ways of entering data are developed to let you choose the most comfortable way for you to work with data There is no dominant or better way you may switch between modes during your work but you should carefully check all data after switching the mode There are 2 buttons for auto calculations described in Table 24 Table 24 Controls of Enrollment Tab Control Description Calculate Base and All values for base and future years will be re calculated Future Years button automatically Calculate Future All values for future years will be re calculated automatically Years Only button Figure 4 20 Enrollment options case 2 Enrollment Commands Savec Current View is Enrollment P2ADA amp Enrollment Factors a mm Other views Staffing by Grade Staffing by Resource For these options Enrollment factors for all years in edit mode Calculate Enrollment Projection Mode switchers Manually Enter ADA a a Base and Future Years Future Years Only Start Fresh Enter Historical Data PORUM nw nc K 3 208 3 134 3 085 3 212 3 087 3 060 3 034 3 005 2 969 1 3 270 3 223 3 125 3 057 3 032 3 009 2 971 2 939 2 909 2 3 135 3 138 3 056 2 980 2 840 2 860 2 833 2 795 2 764 r 3 3 057 3 053 2 991 2 915 2 781 2 691 2 703 2 675 2 639 l 4 3 004 2 985 2 905 2 897 2 837 2 692 2 605 2 6
140. s three views e Page I Enrollment e Page 2 Staffing by Grade e Page 3 Staffing by Resource Enrollment view is absent because this is current active page The Enrollment screen is comprised of 3 tables as follows e Top Enrollment Table e Middle P2 ADA Table e Bottom Enrollment Factors Table There are several formats combined in the enrollment table see Table 22 Table 22 Formats of Enrollment Data Format Appearance Description Uj Graph o 72 Format Appearance Description Grade by Grade Enrollment This format is particularly well suited for districts receiving Class Size Reduction CSR funding This enrollment format allows the user to compute and or adjust enrollment to ADA correlation factors and pupil teacher ratios on a grade by grade ui w wW R basis J18 19 Format Enrollment This format conforms to the J18 19 report Subtotal K 5 and allows the user to review enrollment and ADA data by grade groupings which is particularly useful when tying your enrollment data out to the J18 19 report Lump Sum Total Simplest of the three the Lump Sum Format Format allows the user to see a single enrollment value for each year At first user should select what data should be entered in these tables other values will be calculated automatically There are two sets of radio buttons their combinations are described in Table 23 User should select one of the options for every rad
141. source 0000 Object 8047 Revenue Limit line 43 Total State Aid Portion of Revenue Limit must agree with Resource 0000 Object 8011 84 Revenue Limit line 49 Total Restricted Revenue Limit Sources is updated from total of Restricted Resources Objects 8090 8099 except 8092 8096 8097 Revenue Limit line 50 Revenue Limit State Aid Prior Year is updated from Resource 0000 Object 8019 Projected Years of Resource 0000 Object 8096 Transfers to Charter Schools In Lieu of Property Taxes gets its values from line 29 Less Charter Schools In lieu Taxes on the Tab Revenue Limit screen Therefore in order to change the values displayed by object 8096 you must make the changes that will impact the amounts calculated on RL screen line 29 Please note that projected charter schools in lieu taxes will not calculate on line 29 until you have entered projected charter school ADA within the Charter Schools row of the Tab Enr ADA Staffing screen The amounts calculated by line 29 automatically flow to Resource 0000 Object 8096 Note Base Year in Object 8096 must be negative 4 9 2 Revenue Limit for County Offices of Education Revenue Limit for County Offices of Education looks similar to the one for Districts The main difference 1s links to sub screens see Figure 4 31 on p 85 Some lines have additional information about formulas used for calculations or lines been updated with this amounts 85 Figure 4 31 Revenue Limit screen for Cou
142. t are exposed to market forces For example Object 4300 Textbooks and Materials is an expenditure item where use of the CPI rule makes good sense Textbook costs like many other items are directly subject to market forces and therefore an increase each year in expenditures for Object 4300 roughly equivalent to increases in the Consumer Price Index is a safe assumption The rule is typically associated with revenue objects For example if your district or county office has a small amount of cash generating interest income the INT rule could be set to the local percentage rate and the rule used on Object 8660 Interest in Other Local Revenues The rule is associated with items within object range 3000 3999 The rule is typically associated with revenue and expenditure items that receive restricted Lottery funding The rule is typically associated with revenue and expenditure items that receive unrestricted Lottery funding Rule NetCOLA RLDef SpEdDef StCOLA SertStep 28 Description Purpose The rule is typically associated with revenue limit calculation items The rule is typically associated with revenue limit calculation items The rule is typically associated with special education restricted revenue items The rule is typically associated with revenue limit calculation items specifically determination of the amount of the Inflation Increase The rule is typically associated with increases in expenditures du
143. tem Rules e Complex Rules 3 2 2 Standard Rules Standard Rules can be edited in advance These rules retain the same settings throughout the entire projection regardless of where they are used For example say you have used one of the standard rules in 5 different locations in a projection If you edit this values associated with this rule in the Projection Rules window the rule change will be made in each of the 5 different locations in the projection where the rule is being used Standard Rules include the following Table 6 Standard Rules in Budget Explorer Rule Full Title CatCOLA State Categorical COLA SSC ClasCOLA Classified Salary Increase Rule CertCOLA CertColumn CPI INT HW LOT Res LOT Unr NetCOLA RLDef SpEdDef StCOLA SertStep ClasStep RLDefCOE BasicGrant SpecEduc TeachQual EnEducTech LangAcqu SafeDrugFree InnProg ZICILC ReadFirst 26 Full Title Certificated COLA Certificated Staff Column Increase California CPI SSC Interest Rate Trend for 10 Year Treasuries SSC Health amp Welfare Benefit Increase California Lottery Restricted SSC California Lottery Unrestricted SSC Net Funded Revenue Limit COLA SSC Revenue Limit Deficit K 12 SSC Special Education Base Deficit SSC Statutory COLA Certificated Staff Step Increase Classified Staff Step Increase County Office Revenue Limit Deficit Title I Part A Basic Grant Special Education Title II Part A Teacher Qua
144. the Staffing by Grade screen to enter teacher population data if the Salary Forecaster rule is not in use anywhere in the projection The following rules are recommended for resource 0000 object 1100 CertCOLA Certificated COLA 490 CertColumn Certificated Staff Column Increase CertStep Certificated Staff Step Increase TchrStfg Year to Year Change in Teacher Staffing 33 2 Usethe Staffing by Resource screen to enter teacher population data into those resources where the Salary Forecaster rule has been applied 3 2 5 Complex Rules Complex Rule combines several rules even of different types Many of these rules can be applied to specific objects or in specific resources only Table 12 below lists each of the Custom Rules along with typical uses and scenarios where each rule may be used Table 12 Complex Rules Description Rule Description Purpose LOT Unr When these rules are used together then object value is calculated P2ADA according to special procedure P2ADA previous year ADA is multiplied by LOT Unr In case the base year value is zero all projected values will be zeroes as well LOT Res When these rules are used together then object value is calculated P2ADA according to special procedure P2ADA previous year ADA is multiplied by LOT Unr In case the base year value is zero all projected values will be zeroes as well SSC CSR This dollar rule is calculated as Future year Prior year stCOLA
145. then be manually transferred to resource 0000 object 8011 7 13 201 1 201 1 12 Object 8011 Cash Flow Distribution Schedule with Deferrats P TR Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Accruals Click on any button at the top or item listed in the Navigation Tree to start working Note that you can input revenue and expenditure data in aggregate Your current projection is created for 2 years i e one amount for each major object code range or in detailed format i e up to 4 digits of detail within any code range Click here if you want to update all base values in the projection Projection Rules Salary Forecaster if you wi change the forecasting period or projection description please click here Review the Projection Rules and make any changes you feel are necessary Enter certificated salary data into the Salary Forecaster to match your K 12 funding perspective and local economic outlook us Li nk tou pdate base Enrollment ADA Staffing Revenue Limit 5 Enter your Enrollment ADA Teacher Staffing data Enter your Revenue Limit data values in projection Reports Create and view reports Navigation Tree Resources listed in navigation tree have following color marks 3177 Custom Resource Resource has positive balance 3177 Custom Resource Resource has negative balance 3175 Custom Resource Resource was autobalanced 3175 Custom Resource Resource was autobalanced but following ch
146. time after login you will see The Projection List screen see Figure 4 1 on p 52 Figure 2 4 My Profile Screen My Profile This is Your First Login You Must Reset Your Password Username User C Kole ommon Ho Information E mail User email com LEA Lakeside Jomt Elementary E First Name 4 Name Personal um eii Information Lastname Contact Phones 415 415 41 41 New Password Confirm New Password Chanze Password Question Template What is your pet s name or Current Question Change What iw R Challenge at is your pet s name Question Answer Pet Save Changes User Access Management Attention If you open www budgetexplorer org site in your Internet Browser and instead of BESO log in page you may see the following screen see Figure 2 5 on p 12 12 Figure 2 5 Compatibility message Your Internet Browser is out of date Your browser is aut of date and is not compatible with our website A list af the most popular web browsers can be found below Just click an the icons to get to the download page Firefox 3 54 Chrome 5 Internet Explorer amp Safari 4 By closing this window you acknowledge that your experience on this website may be degraded Note Check if you use Internet Explorer 8 with Compatibility view Mode you should disable this option See image FCMAT BE Support team If you have any questions please contact be_suppomte fcmat org Users encounter this
147. tting Started with Budget EXpIOFEGE iiie eoe ee etas hene eot ree eene o Enea aUo Ue ne gea eee en rta ne eu aus 8 2 1 Obtaining an Account on Budget Explore areniscas aa 8 2 2 Retri ving TOrpot DassWOTQz uisis ceo diro rab beet woncnacdaarced davtentt exe beu Pd age tard das 10 2 9 goeeine Into BuUudeet Explorer ausente vue tbe mete eh veto vene stands 10 3 Budget Explorer General Concepts cc ccce ecce eee ee eee eee e eee eee eee eee sete eeee 14 oL Desieuand lNavieati n CONCE DL us a cp Pa Rate op ORUM LA MR Inde bau OP Dasad 14 SLLLN Ion TT O 2 eii sentence i pedet od eee a usus as 16 SA ROAD Eo Ty AN NT TEES 17 Ge es MEBITD Ub orietur M dtd e I ESI scare 18 S T WIC ONS tm EM T A E N 19 FN DS DI Wc 19 PLOSE MIPS ESTE D S 21 3 2 Rules in Budget Explorer and Forecasting Concept ccccccsssssseeeeeeeeeeeeeeeeeeees 22 2 2 ISISUTO SE OBCOD Dante utere teet oer Mar ete Rie MM UM UN heres E a he 22 922 2 SANG ATC RUNG editio UNE die Ut MOM a dieta dad OM Eta uM 25 3225 9 CUSTOM RUGS oasccacsetesst editio dett te odeu tad ossa tuat suited sv dustaue satus usu ted dut etin sucess 28 S 2A SUSem R Ule Sau tastes IM M oM EI DEM 3l 3 225 Come IR UNC S nosset dp coetui n arte Anu docata ttn attached aaa manatee 33 9 2 9 JXDDIV TOS TU Se E ea ae ote URN nee tle o ax eet mee nee Coe NIE 33 2 9 Se DOFES OETIETAT DB Conce Plora ees orsa diris eese dd iud domo ris ebd ote tS uus 46 S LCT MIN OG ACA M
148. uals data file do you need sample file Reload a previously uploaded actuals file aukio Delete all existing actuals data in the cashflow upload Click the Browse button to select a new upload file sample file Browse Please enter a description of the upload file below F Upload new file Select a previously uploaded actuals file Test 1 1 28 2011 8 55 48 AM Load format 1 2 7 2011 1 11 14 PM Load small format 1 2 7 2011 1 20 30 PM Non matching Woodland 2010 11 July Actuals 3 2 2011 10 40 32 AM objects action 2 Salect action for records within the upload file that don t have a matching object in BE Ignore Them Include Them and add matching object to BE 3 Select import mode Data Add to Existing adds actuals in file to existing actuals import Substract from Existing substracts actuals in file from existing actuals mode Delete All then Upload deletes all existing actuals then loads actuals from file Replace Corresponding replace corresponding actuals with actuals in file Remove Corresponding deletes corresponding actuals identified in file Proceed Cancel 4 10 7 Reset Values to zero Detailed Data Input Mode in the Cash Flow often requires manual adjustments for all Resource Object combinations Reset Values to Zero helps to speed up the process Button Reset Values to Zero located in the right top corner of the Cash Flow screen This button opens Reset Values to Zero screen see Figure 4
149. ues 115 ATTENTION there is no way to roll back to initial projection after updating it with new data 4 11 5 1 Assumptions and rules of updating projection The core idea of updating procedure is to union all information from current projection and from the uploaded SACS data file Accepting this idea the following rules are implemented during uploading procedure e All objects from a new DAT file are uploaded If such objects exist in projection their base year values are updated all rules and notes remain unchanged e For objects which are absent in a new DAT file but present in the projection a values become zeroes b all notes are removed c all non default rules are removed d all rules that can make the value of a zero amount object go up like LOT Res rule are removed including default rules e All objects added by default will be restored with default rules and zero value in case they are absent in a new DAT file e All resources which are present in the projection but absent in a new DAT file will be removed all resources which are absent in the projection but present in a new DAT file will be uploaded into the projection e If there is a historical dataset available the base year beginning fund balance is set to be equal to previous year historical ending fund balance If there is no historical dataset user can edit the base year beginning fund balance value manually e All Cash Flow actuals will remain unc
150. ules will be applied to the final amount one by one in the order shown in the list of Applied Rules section To change the order of rules in Applied Rules section click Move Up or Move Down arrows on the right end of the rule line see Figure 3 19 The rule will be moved according to command Click Edit Rule pencil to change values of the rule This button is available for Custom Rules only see paragraph 3 2 3 on p 28 Figure 3 19 Edit Rules for screen for the object with applied rules Edit Rules for 4100 Textbooks and Materials Applied Rules Tile Base Year Year1 Year2 2011 12 2012 13 2013 14 Edit rule Move rule Year to Year Change in RL ADA 0 00 0 78 0 02 Y EM ee onelevelur California CPI SSC 3 10 27 70 3 10 Z in F Move rule one Custom Percent 10 00 10 00 10 00 a VW level down Remove all Rules Delete rule 40 The order of rules will affect the final result of calculation so do not be mistaken while using several rules simultaneously The following example illustrates the difference in calculations when several rules are applied to one object Example of multiple rules applying Base value of the object 4700 of 0000 resource 1s 10 000 2 rules are applied to this object Custom Percent rule and Custom Amount rule Custom Percent rule is set to 1096 for year 1 and year 2 and Custom Amount rule is set to 1 000 for year 1 and 2 000 for year 2 Values for rules were not cha
151. urce screen to enter teacher population data and the Salary Forecaster screen teacher salaries Other views Enrollment Staffing by Grade 0000 Unrestricted 84 585 778 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 1100 Lottery Unrestricted 14 174 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Apply SalFrcstr rule in resource ET td um Enter FTE for resources to for ME 1100 to enable entry distribute salary 4 7 4 Form A for County Office of Education County Office of Education projections gave slightly different tab bar Third tab 1s called 3 Form A Staff It opens Form A see Figure 4 25 Figure 4 25 Form A Tab for County Office of Education Form A page view 2 J 10 20 11 201 1 2011 13 Form A Staffing by Resource Commands Current View is Form A Other views 2 Staffing by Resource 2 1 13 l County School Tuition Fund 2 Juvenile Hals Homes and Caros A _ County Group Home sd stun up 4 Community School Pups a Probation E C 1981 c 1 2 b Pupis expeled E C 1981 c 3 c Hamels E C 19811 5 Opportunty Schools and Ful day Opportunty Classes 6 CUESAFE County Classroom 7 Community Day Schook 8 TOTAL ELEMENTARY 132 19 71 26 7 26 71 26 71 26 HIGH SCHOOL 9 county Schoo Tuition Fund 10 Juvenie Hals Homes and Camos County Group Home and Insttution Pupis 12 Community School Pupis a Probation E C 1981 c 1 2 b Pupis e
152. w software Anthony L Bridges Cenified Fraud Examiner Depoty Executive CHficer Fiscal Crisis amp Management Assistance eam Fiscal Crisis and Management Assistance Team Date Last Revised August 3 2011 This manual was developed to help users improve their performance in Budget Explorer Part 1 1s the overview of Budget Explorer features and its value for different user groups Part 2 describes registration process to start working with Budget Explorer Part 3 1s the most important part of the manual All major concepts assumptions and considerations are explained in this chapter This chapter is crucial to core understanding of Budget Explorer functionality and interface It is strongly recommended to read at least part 3 and chapters 4 11 4 11 4 before you start working with Budget Explorer Part 4 gives detailed explanation of every module of Budget Explorer and describes all aspects of every page in Budget Explorer Content 1 Creating Multi Year Projections using Budget Explorer 5 11 Introd c on to Budet EXDIOEGE su ood te ivt T A A E 5 Id T DUSECICE OMICE USE Sana A E Meats 5 12 COUNTY OMC USES eraa EA A Eei 6 1 1 3 COE Internal BUSINESS SCEVICES EJS6S ciebat estacion Restat ae n 6 1 1 4 COE External Business Services USES i ora oet eti En Eee eee ixi cute 7 LS System Tequite tlie BES iusso cocotte inte sted va ae imt o Ua qat ioc kadar sada nio etas da ate uana 7 2 Ge
153. x of Auto Balancing Report Click Next Step 2 Select time period All changes made during this period will be shown in the report 1f audit logging was enabled during that period Select resources to include in the report By default all resources are checked You may use and to collapse expand resource tree Filter by object If needed check Object box and enter the object code in the field This would be the only object to be displayed in the report Filter by user Check the User box and select a user from the list All changes of the selected user will be in the report Step 3 Select Report orientation and select option to include or exclude notes Click Next button to create PDF report Auto Balancing Report looks similar to the one shown in Figure 4 77 124 Figure 4 76 Auto Balancing Report options Report Generator Step 2A Report Autobalancing Report Customization Adjust this form to make your own Autobalancing Report to review System Changes Ed A O report Select a date range From a Tees a Choose resources that will be included to the report E M All Resources M au Unrestricted Resources 8 M All Restricted Resources O Filter records by user O Filter records by object pu Sort results by Resource object year O Date Click Next Figure 4 77 Auto Balancing Report LEA San Diego Unified Projection alex 0425 07 Auto Balancing Report
154. xpeled E C 1981 c 3 c Homeless E C 1981 4 I3 Opportunty Schools and Fulkday Opportunty Casses 14 CaLSAFE County Classroom H Save x Excel oo 70 a z S User may change historical and or base year values in projection Some changes will update correspondent values in Revenue Limit sub screens and then Revenue Limit screen will be recalculated as well Attention Read about Revenue Limit updating rules in paragraph 4 9 2 4 7 5 Staffing by Resource for County Office of Education This screen looks the same as for Districts see paragraph 4 7 3 on p 78 The only difference is its color scheme Figure 4 26 Staffing by Resource Tab for County Office of Education Staffing by Resource Hager page view Select Unrestricted or VA Restricted Resources to view os Enrollment Current Vien H Save Commands is Staffing by Resource Other views 1 Form A View Resources Unrestricted O Restricted ica at nde td asaya dl den Pea leh cali e Cd ails 0 00 0 00 0000 Unrestricted 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 PNET Enter FTE for resources to distribute salary 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0001 FCMAT ADJUSTMENTS Unrestricted 0 00 1100 Lottery Unrestricted 0 00 0 00 0 00 Apply SalFrcstr rule in resource rper for Object 1100 to enable entry _ Export to Exce
155. y Option Field Check the 1tems to copy Description You make select items to copy Item Projection Rules Enrollment and Staffing Values Revenue Limit Values Salary Forecaster Values Cash Flow Checked All rules are copied with their current values All enrollment and staffing values are copied All Revenue Limit values are copied All Salary Forecaster values are copied Cash Flow values are copied 60 Unchecked Ruled are copied with default values Enrollment and staffing Values are set to 0 all other values are copied Revenue Limit values are set to 0 all other values are copied Salary Forecaster values are set to 0 all other values are copied Cash Flow values are set to O all other values are copied 4 1 3 Edit projection On the Projection List screen see Figure 4 1 on p 52 select the projection you would like to view edit or print report s and click on Edit Projection button to get into selected projection Another way to enter the projection is to double click on the title of the projection All steps of projection editing are described in chapters 4 2 p 62 4 12 p 118 4 1 4 Rename Projection In some cases you may want to rename a projection You may do so on the Projection List screen see Figure 4 1 on p 52 by selecting a projection you would like to rename one click on the title of the projection and click on Rename Projection button Note there is a

Budget Explorer User Guide - Fiscal Crisis & Management

Contents

Download Pdf Manuals

Related Search

Related Contents

Budget Explorer User Guide - Fiscal Crisis &amp; Management

Contents

Download Pdf Manuals

Related Search

Related Contents

Budget Explorer User Guide - Fiscal Crisis & Management