Loading...
HomeMy WebLinkAbout2020/12/01-Attachments-CT_walkthru_.pdf20101 Current Budget Actuals New Budget per Windup Recommendation Changes Receipts 38,991,294.00 25,578,281.86 25,578,281.25 (13,413,012.75) Transfer from General 3,544,846.00 2,213,836.75 2,213,836.75 (1,331,009.25) Total Revenue 42,536,140.00 27,792,118.61 27,792,118.00 (14,744,022.00) Use of FB 73,632.04 - 5,934,782.00 5,861,149.96 Total Source 42,609,772.04 27,792,118.61 33,726,900.00 (8,882,872.04) Operating Expense 38,583,442.00 30,244,969.01 30,241,963.96 (8,341,478.04) Operating Transfers 1,355,688.00 1,355,688.00 1,355,688.00 IT Refresh Transfer 21,837.00 21,837.00 21,837.00 - VERF Transfer 196,000.00 196,000.00 196,000.00 - Capital Transfers 1,108,632.04 1,108,632.04 1,112,722.04 4,090.00 Debt Transfers 798,689.00 798,689.00 798,689.00 - Total Op Expense 42,064,288.04 33,725,815.05 33,726,900.00 (8,337,388.04) Contribution to FB 545,484.00 - - (545,484.00) Total Use of Funds 42,609,772.04 33,725,815.05 33,726,900.00 (8,882,872.04) Beginning FB 19,477,673.00 19,477,674.00 42,536,140.00 +Revenue 27,792,118.61 27,792,118.00 8,809,240.00 Reserve Requirement 16.67% FY21 Expense 36,426,837.00 13,543,976.56 6,072,353.73 7,471,622.83 13,542,892.00 7,470,538.27 im I 20101 Current Budget Actuals Amendment Recommendation Changes Receipts 34,013,309.00 31,067,384.00 (2,945,925.00) Transfer from General 1,210,641.00 1,210,641.00 - Total Revenue 35,223,950.00 - 32,278,025.00 (2,945,925.00) Use of FB 1,202,887.00 - 2,484,591.00 1,281,704.00 Total Source 36,426,837.00 - 34,762,616.00 (1,664,221.00) Operating Expense Operating Transfers IT Refresh Transfer VERF Transfer Capital Transfers Debt Transfers 33,520,604.00 1,036,743.00 22,520.00 - 1,047,000.00 799,970.00 32,863,383.00 1,036,743.00 22,520.00 - 40,000.00 799,970.00 (657,221.00) - - (1,007,000.00) - Total Op Expense 36,426,837.00 - 34,762,616.00 (1,664,221.00) Contribution to FB - - - Total Use of Funds 36,426,837.00 - 34,762,616.00 Beginning FB +Revenue -Expense Reserve Requirement 16.67% FY21 Expense 13,542,892.00 32,278,025.00 34,762,616.00 11,058,301.00 11,058,301.00 V 20103 Current Budget Actuals New Budget per Windup Recommendation Changes Receipts 3,691,447.00 4,272,847.88 4,272,847.00 581,400.00 Total Revenue 3,691,447.00 4,272,847.88 4,272,847.00 581,400.00 Use of FB - - - - Total Source 3,691,447.00 4,272,847.88 4,272,847.00 581,400.00 Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers - - - - Debt Transfers 3,691,447.00 3,691,447.00 3,691,447.00 - Total Op Expense 3,691,447.00 3,691,447.00 3,691,447.00 - Contribution to FB - - 581,400.00 581,400.00 Total Use of Funds 3,691,447.00 3,691,447.00 4,272,847.00 50i,-tv0.00 Beginning FB 719,511.00 719,512.00 7,261,447.00 +Revenue 4,272,847.88 4,272,847.00 2,988,600.00 -Expense 3,691,447.00 3,691,447.00 Ending FB 1,300,911.88 1,300,912.00 Reserve Requirement 16.67% FY21 Expense 5,870,007.00 978,530.17 322,381.71 322,381.83 20103 Receipts Current Budget Actuals 5,870,007.00 Amendment Recommendation Changes 5,344,094.00 (525,913.00) Total Revenue 5,870,007.00 - 5,344,094.00 (525,913.00) Use of FB - - - - Total Source 5,870,007.00 - 5,344,094.00 (525,913.00) Operating Expense Operating Transfers IT Refresh Transfer VERF Transfer Capital Transfers Debt Transfers - - - - 2,180,757.00 3,689,250.00 - - - - - - - - - 1,654,844.00 3,689,250.00 - - - - (525,913.00) - Total Op Expense 5,870,007.00 - 5,344,094.00 (525,913.00) Contribution to FB - - - Total Use of Funds 5,870,007.00 - 5,344,094.00 Beginning FB +Revenue -Expense Ending FB Reserve Requirement 16.67% FY21 Expense 1,300,912.00 5,344,094.00 5,344,094.00 1,300,912.00 1,300,912.00 20104 Current Budget Actuals New Budget per Windup Recommendation Changes Receipts 6,370,314.00 2,610,658.02 2,610,658.00 (3,759,656.00) Advance repayment - 650,000.00 650,000.00 650,000.00 Debt Surplus Transfer In 3,361,130.00 3,361,130.00 Total Revenue 6,370,314.00 3,260,658.02 6,621,788.00 251,474.00 Use of FB 5,609,674.00 - 5,358,200.00 (251,474.00) Total Source 11,979,988.00 3,260,658.02 11,979,988.00 - Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers - - - - Debt Transfers 11,979,988.00 11,979,988.00 11,979,988.00 - Total Op Expense 11,979,988.00 11,979,988.00 11,979,988.00 - Contribution to FB - - - - Total Use of Funds 11,979,988.00 11,979,988.00 11,979,988.00 - '3,719,329.98,' FY20 Operating M&C to recognize amendment to source: Debt M&C to authorize transfer of debt surplus Beginning FB 7,355,264.92 7,355,264.92 +Revenue 3,260,658.02 6,621,788.00 -Expense 11,979,988.00 11,979,988.00 Ending FB (1,364,065.06) 1,997,064.92 Reserve Requirement 16.67% FY21 Expense 5,689,334.00 948,411.98 (2,312,477.04) 1,048,652.94 M 0 20104 Current Budget Actuals Amendment Recommendation Changes Receipts 4,500,000.00 2,450,612.00 (2,049,388.00) Transfer from C&T Capital 1,189,334.00 1,189,334.00 - Debt Surplus Transfer In Total Revenue 5,689,334.00 - 3,639,946.00 (2,049,388.00) Use of FB - - - Total Source 5,689,334.00 - 3,639,946.00 (2,049,388.00) Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers - - - - Debt Transfers 5,689,334.00 3,639,946.00 (2,049,388.00) Total Op Expense 5,689,334.00 - 3,639,946.00 (2,049,388.00) Contribution to FB - - - - Total Use of Funds 5,689,334.00 - 3,639,946.00 Beginning FB +Revenue -Expense Reserve Requirement 16.67% FY21 Expense 1,997,064.92 3,639,946.00 3,639,946.00 1,997,064.92 1,997,064.92 20105 Current Budget Actuals New Budget per Windup Recommendation Changes Receipts 5,900,000.00 6,795,606.56 6,795,606.56 895,606.56 Total Revenue 5,900,000.00 6,795,606.56 6,795,606.56 895,606.56 Use of FB - - - - Total Source 5,900,000.00 6,795,606.56 6,795,606.56 895,606.56 Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers 2,870,908.00 2,870,908.00 2,870,908.00 - Debt Transfers 3,029,092.00 3,029,092.00 3,029,092.00 - Total Op Expense 5,900,000.00 5,900,000.00 5,900,000.00 - Contribution to FB - - 895,606.56 895,606.56 Total Use of Func 5,900,000.00 5,900,000.00 6,795,606.56 895,606.56 Beginning FB 1,683,060.00 1,683,060.00 +Revenue 6,795,606.56 6,795,606.56 -Expense 5,900,000.00 5,900,000.00 Ending FB 2,578,666.56 2,578,666.56 Reserve Requirement 16.67% FY21 Expense 2,662,825.00 443,892.93 2,134,773.63 2,134,773.63 20105 Current Budget Actuals Receipts 3,660,000.00 - Amendment Recommendation Changes 1,500,000.00 (2,160,000.00) Total Revenue 3,660,000.00 - 1,500,000.00 (2,160,000.00) Use of FB - - 1,162,825.00 1,162,825.00 Total Source 3,660,000.00 - 2,662,825.00 (997,175.00) Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers 997,175.00 - - (997,175.00) Debt Transfers 2,662,825.00 - 2,662,825.00 ToOp Expense 3,660,000.00 - 2,662,825.00 (997,175.00) Contribution to FB - - - Total Use of Func 3,660,000.00 - 2,662,825.00 Beginning FB +Revenue -Expense Ending FB Reserve Requirement FY21 Expense 16.67% 2,578,666.56 1,500,000.00 2,662,825.00 1,415,841.56 1,415,841.56 20106 Current Budget Actuals New Budget per Windup Recommendation Changes Receipts 6,217,740.00 3,815,521.14 3,815,521.00 (2,402,219.00) Debt Surplus Transfer In - - 515,991.00 515,991.00 Total Revenue 6,217,740.00 3,815,521.14 4,331,512.00 (1,886,228.00) Use of FB - - - - Total Source 6,217,740.00 3,815,521.14 4,331,512.00 (1,886,228.00) Operating Expense - - - - Operating Transfers - - - - IT Refresh Transfer - - - - VERF Transfer - - - - Capital Transfers - - - - Debt Transfers 515,991.00 515,991.00 515,991.00 - Total Op Expense 515,991.00 515,991.00 515,991.00 - Contribution to FB 5,701,749.00 - 3,815,521.00 (1,886,228.00) Total Use of Funds 6,217,740.00 515,991.00 4,331,512.00 (1,886,228.00) 3,zyv,:,. w.1-• FY20 Operating M&C to recognize amendment to source: Debt M&C to authorize transfer of debt surplus Beginning FB - - +Revenue 3,815,521.14 4,331,512.00 -Expense 515,991.00 515,991.00 Ending FB 3,299,530.14 3,815,521.00 Reserve Requirement 16.67% FY21 Expense 8,859,285.00 1,476,842.81 1,822,687.33 2,338,678.19 ISM 20106 Current Budget Actuals Amendment Recommendation Changes Receipts 6,000,000.00 4,250,000.00 (1,750,000.00) Debt Surplus Transfer In - - Transfer from C&T Capital - Total Revenue 6,000,000.00 - 4,250,000.00 (1,750,000.00) Use of FB 2,859,285.00 - 2,390,264.00 (469,021.00) Total Source 8,859,285.00 - 6,640,264.00 (2,219,021.00) Operating Expense Operating Transfers IT Refresh Transfer VERF Transfer Capital Transfers Debt Transfers - - - - - 8,859,285.00 - - - - - - - - - - - 6,640,264.00 - - - - - (2,219,021.00) Total Op Expense 8,859,285.00 - 6,640,264.00 (2,219,021.00) Contribution to FB - - - - Total Use of Funds 8,859,285.00 - 6,640,264.00 Beginning FB +Revenue -Expense Reserve Requirement 16.67% FY21 Expense 3,815,521.00 4,250,000.00 6, 640, 264.00 1,425,257.00 1,425,257.00