Creating a budget
Experts should create a budget based on the information.
eu Grand Can, X | | StudentPo X | € Word Mic x | Il Document: x | @) ADM626T x | @) ADM6267 x | g GrandCan Xx @ chen2eb x () ADM626T x C @ viewer.geu.edu/HGAK PROJECTED CASH FLOW FOR VEAR ONE OF OPERATIONS A opie duly 1, 2014 to June 30, 2015 or July August September October November December January February March April May June TOTAL CASH INFLOW REVENUES FROM STATE SOURCES Per Pupil Revenue TOTAL REVENUE 26906 - 206906 - 296906 - 296.906 206906 - 296906 - 178143 FROM STATE SOURCES ed TOTAL REVENUE 14250 = = - 2500 2843 - 2000 - - 28438 362,875 FROM FEDERAL SOURCES TOTAL REVENUE FROM ~~ = z a - a0 - = 2 c 60813 110,750 LOCAL and OTHER SOURCES TOTAL CASH INFLOW 439.406 — 26906 26906 142500 375281 - 37906 - 206906 89250 265068 CASH OUTFLOW TOTAL PERSONNEL 2885 131246 131246 131246 131.246 131246 131246 131246 131246 131246 131.246 131246 1472558 SERVICE COSTS TOTAL CONTRACTED ~~ 1955 5.543 6623 6623 6623 6623 6623 6623 6628 6623 6628 21628 88726 SERVICES TOTAL SCHOOL 20300 9.488 1805 7988 18722 1805 48480 12572 6380 19972 555 10488 250574 OPERATIONS TOTAL FACILITY 0943 44738 28238 26238 28238 28238 28238 28238 28238 28238 26238 28238 348064 OPERATION & MAINTENANCE [~] TOTALCASH OUTFLOW 72054 278015 167.012 174095 184820 167912 214505 178678 172495 186079 171662 191595 21592f NET CASH FLOW 36735 (278015) 126994 (174095) 112.078 (25412) 160686 (178678) 145.411 (186.079) 125.044 (10235) 95.142 Beginning Cash 13382 380734 102719 231714 57610 160696 144284 304970 126292 271703 85625 210.860 108524 ie Balance ENDING CASH 380,734 102,719 231,714 57,619 169,696 144,284 304,970 126,292 271,703 85,625 210,869 108,524 203,665 @MBQ xa 2 e B Are 64300 ®0 eu Grand Can, X | | StudentPo x | € Word Mic x C @ viewer.geu.edu/HGAI Balance ENDING CASH 380734 102719 231,714 57,619 169.696 144.284 304,970 126,202 271,703 85.625 210,869 BALANCE Cash safe margin 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50000 50,000 Cash shortage to 330734 52,719 181,714 7,619 119.696 94.284 254,970 76,202 221,703 35625 160,869 borrow or surplus to invest Note: Original table downloaded from New York State Education Dept. with simplication and minor modification for ilustration purpose. FORECASTING AND MANAGING CASH FLOW Summary ll Document x | @ ADM6267 Xx | @) ADM6267 X | x GrandCan x @ chenzen x {) ADM6267T X | + vo _ B x 108,524 203,665 50,000 58,524 Public organizations need to carefully manage their cash flow in addition to implementing accrual based budgetary control. A useful tool for managing cash is cash flow forecasting or cash budgeting. Mo; public organizations prepare a cash budget on at least a monthly basis so that they can foresee cash shortages and surpluses. Management is therefore prepared if corrective actions are needed. There are multiple ways of dealing with short-term cash shortages and surpluses. Much of the effort must be focused on sustaining uninterrupted public services and safeguarding the nuhlic funds that have heen entrusted ta the aranization Timely undating of the cash flow hid- @OEMBQ ao de B ar 64300 ®0