Personnel and other-than-Personnel expenditures

/in /by

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.)

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.)

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,370FOR