Examine the following tables from the Financial Trend Monitoring Report for the Town of Oakdale that reports on fiscal year 2017. 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. Since local government budgeting in this state is driven by the property tax levy cap, this is a key variable in comparing municipalities.

Aaa-Rated Municipality	FY17 Total Revenue	FY17 Rev per Cap	State Rank	Comparison Municipality	FY17 Total Revenue	FY17 Rev per Cap	State Rank
Delta	$49,794,904	$4,342	12	Dover	$356,895,723	$3,521	27
Monroe	111,784,312	3,683	21	Oakdale	175,058,152	3,065	45
Schoolcraft	47,219,656	3,605	24	Cook	71,477,390	2,,954	51
Dover	356,895,723	3,521	27	Lakeview	245,812,303	2,932	53
Bentley	103,338,507	3,307	33	Frankenmuth	76,196,553	2,863	63
Oakdale	175,058,152	3,065	45	Walden	59,310,311	2,850	65
Harris	59,373,338	2,986	48	Superior	161,444,163	2,726	80
Cook	71,477,390	2,954	51	Cedar	89,441,958	2,644	97
Lakeview	245,812,303	6,196	53	Pittsfield	169,322,957	2,531	116
Caro	49,726,361	2,926	55	Lodi	99,100,870	2,338	168
Frankenmuth	76,196,553	2,863	63	Huron	120,977,460	2,169	210
Walden	59,310,311	2,850	65	Pineview	116,134,368	2,151	217

Aaa-Rated	FY17 Total Revenue	FY Rev per Cap		Oakdale
Median Comparison	$73,836,972	$3,026	Aaa-Rated LQ	1.01
RF Median	118,555,914	2,788	Comparison RG LQ	1.10
State Median	23,487,291	2,314	State LQ	1.32

Where RG = reference group; LQ= location quotient showing how much above or below the median this government is.

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 2017 total revenue and a separate graph for FY 2017 revenue per capita.

b. Evaluate the financial performance of Oakdale for FY 2017. 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?