ADM-626 Topic 8 Module Assignment

ADM-626 Topic 8 Module Assignment

Complete all questions in assignment section of Module. Assignments can be completed in Word documents and/or Excel spreadsheets.

Module 16: page 156-158

Click here to Find all Assignments for ADM-626 Course Didn’t find your answers? Don’t worry we are here to help you! Ask Questions

Module 16

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.
   1. 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.
   2. 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.
   3. 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 legislator reads on your issue and request.
   4. 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.

Course: ADM-626 Public Budgeting and Financial Management
School: Grand Canyon University

• Due Date (Double Check): 02/02/2022
• Willing to Pay (USD): 250