Departments, Expenditures, and Funding Sources Department Expenditure ($) 51,860,554 Funding Source Administration General Fund Administration 35,320,649...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
My question is how to write the code in WareHouse.java This is WareHouse.java package warehouse; /* * * This class implements a warehouse on a Hash Table like structure, * where each entry of the...
-
COMPANY, INC BALANCE SHEET as of December 31, 2022 ASSETS CASH $50,000 62.5% ACCOUNTS RECEIVABLE $30,000 37.5% TOTAL ASSETS $80,000 100% LIABILITIES ACCOUNTS PAYABLE $ % NOTES PAYABLE $2,000 2.5%...
-
1. You are required to compare the results of your printed reports and the results of reports of the MYOB assignment book in your MYOB assignment. If it is assumed that two results of the reports are...
-
In 2015, Ed, Fran, and George form Jet Corporation. Ed contributes land (a capital asset) having a $35,000 FMV purchased as an investment in 2011 for $15,000 in exchange for 35 shares of Jet stock....
-
You are a funds manager for a large bank. On April 15, your bank lends a corporation $35 million, with interest payments to be made on July 16, October 15, January 16, and next April 16. The amount...
-
Explain why it would be virtually impossible to set an exchange rate between the Japanese yen and the U.S. dollar and to maintain a fixed exchange rate.
-
The Osborn Construction Company began operations January 2, 2007. During the year, Osborn entered into a contract with Redbeard Razor Corporation to construct a manufacturing facility. At that time,...
-
Determine the t-value in each of the cases, Click the icon to view the table of areas under the t-distribution. (a) Find the t-value such that the area in the right tail is 0.01 with 27 degrees of...
-
Evaluate the function at the specified values of the independent variable. Simplify the result. f(x) = |x| + 7 (a) f(-2) 9 (b) f(x + 3) -3 x (c) f(x + 2)-f(x)
-
1.- Sara opens an account with an initial deposit of $16,500.She plans to deposit $1850 at the end of every three months for 10 years into an account paying 4.25% compounded monthly. What will be the...
-
Can you please explain the process step-by-step? Do I need to use the effective rate first and then transfer it to the nominal rate to match the compounding periods( six-month annuity and the rate...
-
1.Define (a).Isotope: (b).Radionuclide: 2. What is the difference between ionizing radiation adsorbed dose and ionizing radiation effective dose? 3.Identify and describe the physical process for...
-
If Company Z has a beta of 1.3, the market return is 14%, and the risk-free rate is 3%, what is the company's cost of equity capital?
-
Given that f(x) = 5x - 5 and g(x) = 7 x, calculate (a) f(g(0))= (b) g(f(0))=
-
(2) scenarios involvingthe applicability of thedoctrine of respondeat superior . -In the first scenario, the doctrine is used to find that an employer is liable for the negligence of his...
-
Solve each equation or inequality. |6x8-4 = 0
-
Ganados Phases. What are the main phases that Ganado passed through as it evolved into a truly global firm? What are the advantages and disadvantages of each?
-
Why Go. Why do firms become multinational?
-
Financial Globalization. Explain the twin agency problems. How do the twin agency problems limit financial globalization?
Study smarter with the SolutionInn App