Departments, Expenditures, and Funding Sources Department Expenditure ($) 51,860,554 Funding Source Administration General Fund Administration 35,320,649 Administration 388,553,192 Special Source Funding Capital Attorney 71,441,747 Attorney 22,287,191 Corrections 42,410,651 Corrections Courts Courts Education 40,613,139 77,109,840 17,093,360 2,260,912 Education 62,328,934 Transportation 106,871,908 Transportation 82,089,011 Troopers 86,584,089 Troopers 211,573,117 General Fund Special Source Funding General Fund Special Source Funding General Fund Special Source Funding Special Source Funding General Fund Special Source Funding Capital General Fund Special Source Funding TABLE 16.2 Personnel and Nonpersonnel Funding Sources Type of Expenditure Type of Fund Amount ($) Personnel General Fund 446,941,184 Services General Fund 560,931,401 Capital General Fund 13,363,748 Services Capital Fund 59,849,210 Capital Capital Fund 314,681,043 Personnel Special Revenue 452,049,638 Services Capital Special Revenue 325,577,585 Special Revenue 34,759,758 TABLE 16.3 Expenditures by Department and Program Department and Program Corrections Inmate Substance Abuse Recovery Corrections Inmate Education Corrections Inmate Intake and Release Corrections Inmate Housing Expenditure ($) 557,850 339,032 1,674,610 5,982,125 Corrections Information and Communications 195,475 Technology Troopers Dispatch 2,604,257 Troopers Disaster Response 2,167,148 Troopers Enforcement Support 2,464,721 Troopers Investigations 1,678,722 Troopers Patrol Troopers Administration 5,355,280 1,439,370 (b) Prepare a verbal briefing of no more than 10 minutes that reviews the background of the issue, identifies why it must be addressed, describes what your proposal will do to address the issue, and gives the amount of your budget request. (c) Prepare a one-page summary, with 1-inch margins and 12-point font, that provides the highlights of your issue and proposal. This This study source was downloaded by 100000761677079 from CourseHero.com on 07-17-2023 08:55:12 GMT-05:00 https://www.coursehero.com/file/92917938/Module-8-assignmentdocx/ may be the only document a legislator reads on your issue and request. (d) Prepare a more thorough frequently asked questions (FAQ) document that could be used by the department director giving the briefing, a legislator hearing the information, or you as you give the briefing to answer questions that require a little more explaining. 1. Based on the data in Table 16.1, create totals for each funding source while still showing the departments associated with each funding source. (Hint: Subtotals and/or pivot tables are good tools to help you accomplish this in Excel.) 2. Based on the data in Table 16.2, create totals for each funding source for personnel and other-than-personnel expenditures. (Hint: Subtotals and/or pivot tables are good tools to help you accomplish this in Excel.) 3. Based on the data in Table 16.3, create a summary graph showing the percentage of the total expenditures associated with each department. Next, create a graph for the Corrections Department and one for the Troopers Department, showing the proportion of the budgeted expenses associated with each program. 4. Select a current issue for which you can find background material. Become familiar with the issue and build a budget request that provides a solution to the issue. If a solution is already publicly available, work through the data so that you can re-create the budget request. (a) Prepare no more than two PowerPoint slides to address the issue and the proposed solution. You have a well-formatted slide when you can print it fullsize, place it on the ground, take two steps back, and read all the material on the slide. (b) Prepare a verbal briefing of no more than 10 minutos