Examine the following tables from the Financial Trend Monitoring Report for the Town of Oakdale for the most recent fiscal year-end. The performance indicators selected are total revenue and revenue per capita. The town provides three reference groups with which to compare Oakdale: Aaa-rated municipalities, comparison municipalities, and the state median. Because local government budgeting in this state is driven by the property tax levy cap, this is a key variable in comparing municipalities.

Required
a. Prepare a histogram or bar graph that shows Oakdale in relation to the three reference groups: Aaa-rated median, comparison reference group, and state median for FY total revenue and a separate graph for FY revenue per capita.
b. Evaluate the financial performance of Oakdale for the fiscal year. Use information from the tables and the graph you prepared for part a to support your analysis.
c. What other performance measures would you like to see before you conclude the town is in good or bad shape for the fiscal year shown?

Transcribed Image Text:

FY Rev FY Rev State FY Total FY Total Aaa-Rated State Comparison Municipality Municipality Revenue Rank Revenue per Cap per Cap Rank $ 49,794,904 $4,342 $356,895,723 $3,521 Delta 12 Dover 27 Oakdale Monroe 111,784,312 3,683 21 175,058,152 3,065 45 71,477,390 Schoolcraft 47,219,656 3,605 24 Cook 2,954 51 Dover 356,895,723 3,521 27 Lakeview 245,812,303 2,932 53 Frankenmuth 76,196,553 Bentley 103,338,507 3,307 33 2,863 63 2,850 Oakdale 175,058,152 3,065 45 Walden 59,310,311 65 Superior Harris 59,373,338 2,986 48 161,444,163 2,726 80 71,477,390 2,954 Cook 51 Cedar 89,441,958 2,644 97 245,812,303 53 169,322,957 116 Lakeview 2,932 Pittsfield 2,531 Lodi Caro 49,726,361 2,926 55 99,100,870 2,338 168 120,977,460 Frankenmuth 76,196,553 2,863 63 Huron 2,169 210 65 59,310,311 217 Walden 2,850 Pineview 116,134,368 2,151 FY Total FY Rev per Cap Medians Revenue Oakdale $ 73,836,972 $3,026 1.01 Aaa-Rated Median Aaa-Rated LQ Comparison RG LQ State LQ Comparison RG Median 118,555,914 2,788 1.10 State Median 23,487,291 2,314 1.32 where RG = re ference group LQ = location quotient showing how much above or below the median this government is.