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

TABLE 16.2 Personnel and Nonpersonnel Fundina Sources Type of Expenditure Personnel Services Capital Services Capital Personnel Services Capital Type of Fund General Fund General Fund General Fund Capital Fund Capital Fund Special Revenue Special Revenue Special Revenue Amount ($) 446,941,184 560,931,401 13,363,748 59,849,210 314,681,043 452,049,638 325,577,585 34,759,758