Question

1 Approved Answer

Posted on Jul 26, 2024

Q3. Mayor McClain has appointed you to head the newly created Recycle Department for the Jefferson City. Your first task is to prepare a series

Q3. Mayor McClain has appointed you to head the newly created Recycle Department for the Jefferson City. Your first task is to prepare a series of budgets for your department. More specifically, the mayor has given you $450,000 in FY 2018 and $500,000 in FY 2019 to run the department. Using the attached Excel template* (which has three separate worksheets), prepare a budget estimate for FY 2018 and a budget projection for FY 2019 using: 1) a line-item budget, 2) a program budget and 3) a performance budget. A. Line Item Budget: In your line-item budget, use the categories (personnel, operating and capital outlay) that are listed in the text. You are free to spend the funds any way that you see fit. However, remember that personnel costs usually consume the majority of a budget. B. Program Budget: Consider the different types of activities (divisions) that a recycling department would be engaged in (recycling glass, paper, plastic, aluminum, etc). Your goals and/or objectives should be slightly modified in the second year to show growth in one area and a decrease in another area. C. Performance Budget: Set some specific goals that you can attain for either one of the divisions that you created in your performance budget (i.e., collect six tons of paper during the first year of operation). Suggestion: In addition to staff, a Recycling Department may need the following: recycle bins, aluminum compressors, trucks, marketing brochures, and trailers to hold the recyclable materials.

A. Line Item Budget: In your line-item budget, use the categories (personnel, operating, and capital outlay) that are listed in the text. You are free to spend the funds any way that you see fit. However, remember that personnel costs usually consume the majority of a budget.

B. Program Budget: Consider the different types of activities (divi-recycling department would be engaged in (recycling glass, paper, plastic, aluminum, etc). Your goals and/or objectives should be slightly modified in the second year to show growth in one area and a decrease another area.

C. Performance Budget: Set some specific goals that you can attain for either one of the divisions that you created in your performance budget (i.e., collect 6 tons of paper during the first year of operation).

Suggestion:

In addition to staff, a Recycling Department may need the following: recycling bins, aluminum compressors, trucks, marketing brochures, and trailers to hold the recyclable materials.

tamplets: https://s3.amazonaws.com/d2l-docbuilder-prod-us-east-1-converted/3491bd3f-f173-4aee-951e-dcd7adef86a6/92ded10f7b7f26cac4067a31ce9e0dfb.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA5AF533RDVVDPUMVQ%2F20200825%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20200825T203050Z&X-Amz-Expires=5460&X-Amz-Signature=da4ce329f928755f6697d5ffb8a4b5275d93f3e57899983e852283ec10b777d2&X-Amz-SignedHeaders=host#pdfjs.action=download

image text in transcribed

Jefferson City Program Budget FY 2018-2019 EY 2018 Recycling Department Goat Objectives: Division Management Recycling Collection Maintenance Public Outreach TOTAL $0.00 EY 2019 Recycling Department Goal Objectives: Division Management Recycling Collection Maintenance Public Outreach TOTAL $0.00 Page 1 G3 Chap 1 FY 2018 (est) EY 2019.pro Jefferson City Performance Budget Recycle Department Division Recycling Operating Expenses Personnel Operating Capital Outlay TOTAL Department Performance Objectives: A 8 c. $0.00 $0.00 EY 2018 est EY 2019 (pro Performance Review C 2:27 s3.amazonaws.com Appendix 1B EXAMPLES Jelskau Cit Indige Summary FY 2015-2019 General Fuel Central Garage Water&Sewer Sanitation Grand To al SD PUNUNG SRCE Iranny lisare Taxes Vente Schen SI 41000 85.000 9 41.500 SI 41,000 926.500 150,000 14215 195,00 I MB 50.000 ther Changes Spil AS Other & Moe. dass 50190 245.000 662,779 2,239 - TOTAL KEVE S230 S11,50 $385.00 SI 04 $25,00 lleginning TOTAL Available unde 54.450,29 200.000 SI0_019,629 S116,250 53,658,000 S1,584,000 EXPENDITA 51.309454 91 51309.454 0.125 116.250 356,35 116.250 1954,500 1. WOD Public Safety Public Works Central Garage Santa Water Concler Go System Oper Capital Espand TOTAL 14 DNI 5116,50 53.658,000 SIM SIM2430 510 Page 7 Appendix 10 EXAMPLE Jefferson City Sources of Revenue FY 2018 EN. FY 2019 EL. FY 2020 En. Nel Change XChange 525,756. MI $174.168.50 SS11,621.10 BALANCE FORWARD 5.91% Sales and Use Tax Income Tax-Ind. Income Tax and Other TOTAL Base Revenue S2.555.557.00 $2.715,000.00 $2,875,500.00 $160,500.00 2095 499.11 2,299.760.00 2,472,728.180 172.168.180 426C12301 $12,000.00 $12,000 II. 208.760.60 65788290 674.568.80 16.685.90 56.181,596.90 $6,359,511.40 S6,585,417.90 $350,153.90 11.1111% 5.51% 2:27 s3.amazonaws.com Page 8 Appendix 10 EXAMPLE Source of Expenditures Nowhere Mississippi (amounts in millions) General Goverment Public Safety Health and Human Services Public Education Higher Education Judiciary Natural Resources Business & Economic Dev Regulatory Article IX Other DEPARTMENT TOTAL FY 2018 App $2,345,00 7.129.00 27,189.00 28.000.00 13,685.00 386.00 1.693.00 10.456,00 456.00 721.00 250.00 $92,310.00 FY 2019 Request $2,498,00 7.893.00 31.890.00 30,000.00 14,589,00 399,00 1.785.00 11,000.00 469.00 732.00 255.00 $101,510.00 Net Change Change SI53. 6.52% 764.00 10.729 4,701.00 17.29% 2,000.00 7.14% 904.00 6.61% 13.00 3.37% 92.00 5.43% 544.00 5.20% 13.00 2.85% 11.00 1.53% 5.00 2.00% S9,200.00 9.97% Page 9 Appendix 1E 2:27 s3.amazonaws.com 10 of 10 Page 9 Appendix 1E City of Hardin Fire Dept SALARIES Education Life Insurance Medical Insurance Social Security State Incentive Workmen's Compensation Kentucky Retirement Subtotal FY 2018 Actual FY 2019 Bude. FY 2020 Est. Net Change % Change S658.939.XI $731,000.00 $765,00X1.10 $34.000.00 150.00 S00.00 S00.00 0.00% 1,268.00 2.150.00 1,50x200 650.000 -30.23% 110,467.00 120,000.00 120,000.00 0.00 0.00% $1,689.00 57.50XXI 57.5.XI.00 0.00 0.01% 70.054 IX) 72,500.00 72,50X1.40 72.5 0.00% 38.660). 36,000.00 40,000.00 4,000.00 11.11% 126.850.00 137.00 145.000 8.000.00 5.84% $1,058,000.00 $1,156,650.00 $1,202,000.00 $45,350.00 3.92% OPERATING EXPENSES Station Il Facility Fire Hydrants Water, Sewer & Gas Electricity Ollice Supplies Casoline Uniforms Training School & Supplies Vehicle Repair and Maint Housekeeping Supplies Travel & Meetings Dues & Subscriptions Miscellaneous Fire Marshall Onice Reappropriations Subtotal $5,575.00 23,414 IX 3,344.00 1,641.00 1,581.00 4,854.00 15,554. 703.00 8,514.00 1,130.00 1.262.00 20).XI 5,014.00 3,707.00 1.223.00 577,746.00 $3,500).XI 23,500.00 3.500.IXI 2,000.XI 1.500.X 5,000.00 12,00).XI 2,500).XI 15,000.00 1,000.00 1,500.00 306.XI 5,000.00 3.500.X 1,500.00 581,300.00 S3,50X). 24,250.00 3.5IXI.NO 2.DIXI.00 1,50.00 5,000.00 12,00.00 2.500.0 15,000.00 1,002. 1,500.00 31.CO 5,000.00 3,500.00 1.500.00 $82,050 00 SI).00 750.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% 3.19% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $750,00 0.92% Ni CAPITAL EXPENDITURES Equipment Fire Truck Payment Subtotal $8.209.IXI 24,369.00 $32,578.00 $39,00%). 24.502.00 $63,500.X $ $10,000.00 24,500.00 $ $34,500.00 -74.36% 0.00% 45.67% MW TOTAL S1.168,454.00 SI 301.450.00 $1,318.550.00 $17.100,00 1.31% Page 10 Jefferson City Program Budget FY 2018-2019 EY 2018 Recycling Department Goat Objectives: Division Management Recycling Collection Maintenance Public Outreach TOTAL $0.00 EY 2019 Recycling Department Goal Objectives: Division Management Recycling Collection Maintenance Public Outreach TOTAL $0.00 Page 1 G3 Chap 1 FY 2018 (est) EY 2019.pro Jefferson City Performance Budget Recycle Department Division Recycling Operating Expenses Personnel Operating Capital Outlay TOTAL Department Performance Objectives: A 8 c. $0.00 $0.00 EY 2018 est EY 2019 (pro Performance Review C 2:27 s3.amazonaws.com Appendix 1B EXAMPLES Jelskau Cit Indige Summary FY 2015-2019 General Fuel Central Garage Water&Sewer Sanitation Grand To al SD PUNUNG SRCE Iranny lisare Taxes Vente Schen SI 41000 85.000 9 41.500 SI 41,000 926.500 150,000 14215 195,00 I MB 50.000 ther Changes Spil AS Other & Moe. dass 50190 245.000 662,779 2,239 - TOTAL KEVE S230 S11,50 $385.00 SI 04 $25,00 lleginning TOTAL Available unde 54.450,29 200.000 SI0_019,629 S116,250 53,658,000 S1,584,000 EXPENDITA 51.309454 91 51309.454 0.125 116.250 356,35 116.250 1954,500 1. WOD Public Safety Public Works Central Garage Santa Water Concler Go System Oper Capital Espand TOTAL 14 DNI 5116,50 53.658,000 SIM SIM2430 510 Page 7 Appendix 10 EXAMPLE Jefferson City Sources of Revenue FY 2018 EN. FY 2019 EL. FY 2020 En. Nel Change XChange 525,756. MI $174.168.50 SS11,621.10 BALANCE FORWARD 5.91% Sales and Use Tax Income Tax-Ind. Income Tax and Other TOTAL Base Revenue S2.555.557.00 $2.715,000.00 $2,875,500.00 $160,500.00 2095 499.11 2,299.760.00 2,472,728.180 172.168.180 426C12301 $12,000.00 $12,000 II. 208.760.60 65788290 674.568.80 16.685.90 56.181,596.90 $6,359,511.40 S6,585,417.90 $350,153.90 11.1111% 5.51% 2:27 s3.amazonaws.com Page 8 Appendix 10 EXAMPLE Source of Expenditures Nowhere Mississippi (amounts in millions) General Goverment Public Safety Health and Human Services Public Education Higher Education Judiciary Natural Resources Business & Economic Dev Regulatory Article IX Other DEPARTMENT TOTAL FY 2018 App $2,345,00 7.129.00 27,189.00 28.000.00 13,685.00 386.00 1.693.00 10.456,00 456.00 721.00 250.00 $92,310.00 FY 2019 Request $2,498,00 7.893.00 31.890.00 30,000.00 14,589,00 399,00 1.785.00 11,000.00 469.00 732.00 255.00 $101,510.00 Net Change Change SI53. 6.52% 764.00 10.729 4,701.00 17.29% 2,000.00 7.14% 904.00 6.61% 13.00 3.37% 92.00 5.43% 544.00 5.20% 13.00 2.85% 11.00 1.53% 5.00 2.00% S9,200.00 9.97% Page 9 Appendix 1E 2:27 s3.amazonaws.com 10 of 10 Page 9 Appendix 1E City of Hardin Fire Dept SALARIES Education Life Insurance Medical Insurance Social Security State Incentive Workmen's Compensation Kentucky Retirement Subtotal FY 2018 Actual FY 2019 Bude. FY 2020 Est. Net Change % Change S658.939.XI $731,000.00 $765,00X1.10 $34.000.00 150.00 S00.00 S00.00 0.00% 1,268.00 2.150.00 1,50x200 650.000 -30.23% 110,467.00 120,000.00 120,000.00 0.00 0.00% $1,689.00 57.50XXI 57.5.XI.00 0.00 0.01% 70.054 IX) 72,500.00 72,50X1.40 72.5 0.00% 38.660). 36,000.00 40,000.00 4,000.00 11.11% 126.850.00 137.00 145.000 8.000.00 5.84% $1,058,000.00 $1,156,650.00 $1,202,000.00 $45,350.00 3.92% OPERATING EXPENSES Station Il Facility Fire Hydrants Water, Sewer & Gas Electricity Ollice Supplies Casoline Uniforms Training School & Supplies Vehicle Repair and Maint Housekeeping Supplies Travel & Meetings Dues & Subscriptions Miscellaneous Fire Marshall Onice Reappropriations Subtotal $5,575.00 23,414 IX 3,344.00 1,641.00 1,581.00 4,854.00 15,554. 703.00 8,514.00 1,130.00 1.262.00 20).XI 5,014.00 3,707.00 1.223.00 577,746.00 $3,500).XI 23,500.00 3.500.IXI 2,000.XI 1.500.X 5,000.00 12,00).XI 2,500).XI 15,000.00 1,000.00 1,500.00 306.XI 5,000.00 3.500.X 1,500.00 581,300.00 S3,50X). 24,250.00 3.5IXI.NO 2.DIXI.00 1,50.00 5,000.00 12,00.00 2.500.0 15,000.00 1,002. 1,500.00 31.CO 5,000.00 3,500.00 1.500.00 $82,050 00 SI).00 750.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% 3.19% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $750,00 0.92% Ni CAPITAL EXPENDITURES Equipment Fire Truck Payment Subtotal $8.209.IXI 24,369.00 $32,578.00 $39,00%). 24.502.00 $63,500.X $ $10,000.00 24,500.00 $ $34,500.00 -74.36% 0.00% 45.67% MW TOTAL S1.168,454.00 SI 301.450.00 $1,318.550.00 $17.100,00 1.31% Page 10