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 full-size, 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 minutes that reviews the background of the issue, identifies why it must be addressed, describes what your pro-posal 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 may be the only document a leg-islator reads on your issue and request.
(d) Prepare a more thorough fre-quently asked questions (FAQ) document that could be used by the department director giv-ing the briefing, a legislator hear-ing the information, or you as you give the briefing to answer ques-tions that require a little more explaining.
1. Based on the data in Table 16.1, create totals for each funding source while
Need help Working on This or a Similar Assignment?
We specialize in custom-written, original papers. No prewritten essays here—order your plagiarism-free and AI-free paper today for guaranteed originality.