Professional Application Case: Madison Public Library The Madison Public Library (MPL) is an agency of the City of Madison, Wisconsin. The mission of the library is to provide free and equitable access to cultural and educational experiences. Its vision is to be a place to learn, share, and create. The library is governed by a nine-member board of directors appointed for three-year terms by the mayor of Madison. The library board works with the mayor, library staff, and the Madison Common Council to plan, fund, and implement public library service in Madison. The library is supported financially by the city of Madison and the Madison Public Library Foundation. The foundation promotes and supports Madisons public library facilities, services, and programs. Its board is comprised of 30 members. Board initiatives include growing restricted gifts, improving fundraising, building strategic collaboration to fund innovation and urgent needs, and supporting racial equity and inclusion in the library and foundation activities through funding, staff, and board makeup. The library is comprised of eight locations. Library Locations An excel spreadsheet has five columns, and the column headers are: Library Name, Street Address, City, State, and Zip Code. The data from the table are presented as follows: Library Name, Alicia Ashman; Street Address, 733 N High Point Road; City, Madison; State, W I; Zip Code, 53717; Library Name, Central; Street Address, 201 W Mifflin Street; City, Madison; State, W I; Zip Code, 53703; Library Name, Hawthorne; Street Address, 2707 E Washington Avenue; City, Madison; State, W I; Zip Code, 53704; Library Name, Lakeview; Street Address, 2845 N. Sherman Avenue; City, Madison; State, W I; Zip Code, 53704; Library Name, Meadowridge; Street Address, 5726 Raymond Road; City, Madison; State, W I; Zip Code, 53711; Library Name, Pinney; Street Address, 516 Cottage Grove Road; City, Madison; State, W I; Zip Code, 53716; Library Name, Sequoya; Street Address, 4340 Tokay Road; City, Madison; State, W I; Zip Code, 53711; Library Name, South Madison; Street Address, 222 S Park Street; City, Madison; State, W I; Zip Code, 53713. MPL operates as a not-for-profit entity. The financial information for the previous four years follows. Library Financial Information An excel spreadsheet presents the library financial information in two divisions. The first division at the top has five columns, and the column headers are: Library Revenues; Year Ended December 31: 2025, 2024, 2023, and 2022. The data from the table are presented as follows: Library Revenues, City of Madison Library Appropriation; 2025, $17,703,566; 2024, $17,779,030; 2023, $16,915,564; 2022, $16,288,835; Library Revenues, South Central Library System Contractual Services; 2025, $395,478; 2024, $337,246; 2023, $337,361; 2022, $356,336; Library Revenues, Dane County Library System Contractual Services; 2025, $1,144,935; 2024, no data; 2023, no data; 2022, no data; Library Revenues, LINK Contractual Services; 2025, $404,255; 2024, $454,290; 2023, $454,255; 2022, $454,255; Library Revenues, Fines and Fees; 2025, $335,984; 2024, $383,403; 2023, $395,421; 2022, $404,399; Library Revenues, Grants; 2025, $602,994; 2024, $149,459; 2023, $1,010,390; 2022, $370,254; Library Revenues, Other; 2025, $74,538; 2024, $121,886; 2023, $104,631; 2022, $124,395; Library Revenues, Endowment; 2025, $20,000; 2024, $20,000; 2023, $20,000; 2022, $20,000; Library Revenues, no data; 2025, $20,681,750; 2024, $19,245,314; 2023, $19,237,622; 2022, $18,018,474. The second division below has five columns, and the column headers are: Library Expenses; Year Ended December 31: 2025, 2024, 2023, and 2022. The data from the table are presented as follows: Library Expenses, Salaries and Benefits; 2025, $13,026,440; 2024, $12,659,647; 2023, $12,352,852; 2022, $11,474,221; Library Expenses, Library Books, Media, and Databases: 2025, $1,040,746; 2024, $1,039,586; 2023, $1,000,816; 2022, $1,046,644; Library Expenses, Dane County Library System Contractual Services; 2025, $1,537,180; 2024, no data; 2023, no data; 2022, no data; Library Expenses, Facilities; 2025, $1,227,112; 2024, $1,515,114; 2023, $1,456,628; 2022, $1,357,358; Library Expenses, LINK cat Online Computer Operations; 2025, $623,845; 2024, $609,444; 2023, $611,337; 2022, $592,158; Library Expenses, Debt Retirement; 2025, $2,826,376; 2024, $2,648,112; 2023, $2,745,463; 2022, $2,720,545; Library Expenses, Supplies and Capital Assets; 2025, $482,606; 2024, $497,976; 2023, $390,440; 2022, $330,283; Library Expenses, Purchased Services, Miscellaneous; 2025, $541,895; 2024, $745,755; 2023, $578,811; 2022, $604,312; Library Expenses, no data; 2025, $21,306,200; 2024, $19,715,634; 2023, $19,136,347; 2022, $18,125,521; Library Expenses, Net Inflow or (Outflow); 2025, negative 624,450 (shown in parentheses); 2024, negative 470,320 (shown in parentheses); 2023, $101,275; 2022, negative 107,047 (shown in parentheses). 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. An excel spreadsheet has five columns, and the column headers are: Metric: 2025, 2024, 2023, and 2022. The data from the table are presented as follows: Metric: Checkouts; 2025, 3,454,156; 2024, 3,575,215; 2023, 3,698,903; 2022, 3,800,000; Metric: Digital Checkouts; 2025, 462,416; 2024, 382,068; 2023, no data; 2022, 289,309; Metric: Internet Uses; 2025, 227,370; 2024, 247,129; 2023, 564,787; 2022, 635,363; Metric: Library Card Registrations; 2025, 15,544; 2024, 12,154; 2023, 11,775; 2022, 13,245; Metric: Library Employees; 2025, 137; 2024, 135; 2023, 131; 2022, 128; Metric: Meeting Room Uses; 2025, 22,714; 2024, 22,278; 2023, 23,010; 2022, 20,782; Metric: Program Attendance (all ages); 2025, 107,447; 2024, 136,303; 2023, 134,666; 2022, 110,744; Metric: Visits; 2025, 1,779,552; 2024, 1,911,287; 2023, 1,965,014; 2022, 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.