Data Auditing As a member of the audit team examining MPL’s payroll expense, you have gathered a list of current employees names and salary amounts. Prepare a descriptive analysis of payroll expense using data visualization. Summarize your findings in a data story

PAC 9.3 Financial Accounting: Visualize Revenue and Expense Analysis

Data and Financial Accounting You have been asked to prepare an analysis of revenue and expenses from 2016 to 2025. Use the MPL financial data to prepare visualizations that can be shown to your manager.

Databases: Dane County Library System Contractual Services Facilities $1,537,180 $1,227,112 $1,515,114 $1,456,628 $1,357,358 LINKcat Online Computer $623,845 $609,444 $611,337 $592,158 Operations Debt Retirement $2,826,376 $2,648,112 $2,745,463 $2,720,545 Supplies and Capital Assets $482,606 $497,976 $390,440 $330,283 Purchased Services, Miscellaneous $541,895 $745,755 $578,811 $604,312 $21,306,200 $19,715,634 $19,136,347 $18,125,521 $(107,047) Net Inflow/(outflow) $ (624,450) $(470,320) $101,275 This financial information shows that the library has incurred an increase in net outflows in the last two years. The MPL Board is concerned that if the net outflows continue, the libraries will have to reduce their community services. The following is a list of metrics that can be used to evaluate MPL performance. Metric: Checkouts 2025 3,454,156 2024 2023 2022 3,575,215 3,698,903 3,800,000 Digital Checkouts 462,416 382,068 289,309 Internet Uses 227,370 247,129 564,787 635,363 Library Card Registrations 15,544 12,154 11,775 13,245 Library Employees 137 135 131 128 Meeting Room Uses 22,714 22,278 23,010 20,782 Program Attendance (all ages) 107,447 Visits 1,779,552 136,303 1,911,287 134,666 1,965,014 110,744 2,170,000 PAC 9.1 Accounting Information Systems: Visualize Computer Systems Usage Data Accounting Information Systems MPL has seen an increase in computer usage over the last two years. They want to ensure they are providing computers in the branches with the most usage and reducing the number of computers in the branches with lower usage. Use the MPL computer usage data to prepare an interactive visualization to help the accounting information systems department evaluate computer and technology usage by branch.