Question

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

Departments, Expenditures, and Funding Sources

DepartmentExpenditure ($)Funding SourceAdministration51,860,554General FundAdministration35,320,649

Special Source FundingAdministration388,553,192CapitalAttorney71,441,747

General FundAttorney22,287,191Special Source FundingCorrections42,410,651

General FundCorrections40,613,139Special Source FundingCourts77,109,840

General FundCourts17,093,360Special Source FundingEducation2,260,912

Special Source FundingEducation62,328,934General FundTransportation106,871,908

Special Source FundingTransportation82,089,011

CapitalTroopers86,584,089

General FundTroopers211,573,117

Special Source Funding

Answer 1

(value in $) Funding Source Table 16.1 Particulars General Fund Special Source Funding Capital Totals Administration Attorney Corrections Courts 5,18,60,554 7,14,41,747_4,24,10,651 7,71,09,840 3,53,20,649 2,22,87,191 4,06,13,139 1,70,93,360 38,85,53,192 47,57,34,395 9,37,28,938 8,30,23,790 9,42,03,200 Departments Education 6,23,28,934 22,60,912 Transportation Troopers 8,65,84,089 10,68,71,908 21,15,73,117 8,20,89,011 18,89,60,919 29,81,57,206 Total for Funding Source 39,17,35,815 43,60,20,276 47,06,42,203 1,29,83,98,294 6,45,89,846