The departments associated with Funding source

/in /by

Based on the data in Table 16.1, create totals for each funding source while still showing the departments associated with 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.TABLE 16.1Departments, Expenditures, and Funding SourcesDepartmentExpenditure ($)Funding SourceAdministration51,860,554General FundAdministration35,320,649Special Source FundingAdministration388,553,192CapitalAttorney71,441,747General FundAttorney22,287,191Special Source FundingCorrections42,410,651General FundCorrections40,613,139Special Source FundingCourts77,109,840General FundCourts17,093,360Special Source FundingEducation2,260,912Special Source FundingEducation62,328,934General FundTransportation106,871,908Special Source FundingTransportation82,089,011CapitalTroopers86,584,089General FundTroopers211,573,117Special Source FundingTABLE 16.2Personnel and Nonpersonnel Funding SourcesType of ExpenditureType of FundAmount ($)PersonnelGeneral Fund446,941,184ServicesGeneral Fund560,931,401CapitalGeneral Fund13,363,748ServicesCapital Fund59,849,210CapitalCapital Fund314,681,043PersonnelSpecial Revenue452,049,638ServicesSpecial Revenue325,577,585CapitalSpecial Revenue34,759,758TABLE 16.3Expenditures by Department and ProgramDepartment and ProgramExpenditure ($)Corrections Inmate Substance Abuse Recovery557,850Corrections Inmate Education339,032Corrections Inmate Intake and Release1,674,610Corrections Inmate Housing5,982,125Corrections Information and Communications Technology 195,475Troopers Dispatch2,604,257Troopers Disaster Response2,167,148Troopers Enforcement Support2,464,721Troopers Investigations1,678,722Troopers Patrol5,355,280Troopers Administration1,439,370FO