The information below should be used to prepare (in proper form in Excel) a Public Transportation column for the proprietary fund Statement of Revenues, Expenses, and Changes in Fund Net Position for the fiscal year ending May 31, 2018.

Operating Revenue (Services) $25,705,000
Interest Revenue $36,000
Intergovernmental Revenue $140,000
Capital Contributions $1,200,000

Operating Expenses:

Employee Wages $8,654,000
Temporary Labor $750,000
Repairs and Maintenance $6,425,000
Depreciation $4,532,000
Utilities $948,000
Interest Expense $475,000
Transfer to General Fund $315,000
Net position, June 1, 2017 $3,820,000

Please also answer the following questions in MS Word:

What observations can you make about the fund’s activity from June 1, 2017-May 31, 2018?

Identify the other proprietary fund statements and what measurement focus and basis for accounting are used in those statements.

What reports and schedules are included in the CAFR as required supplementary information?