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.
STATE AND LOCAL GOVERNMENT REPORTING
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?
Paper Requirements:
- Submit your responses to the questions in a 3-4-page document in MS Word/MS Excel as indicated. Label each question clearly. For computations, please include them in a table.
- For written answers, please make sure your responses are well written.
- Assignment should follow APA guidelines (Links to an external site.) with respect to use of subheadings, 1″ margins, and double spaced.
- The required number of pages for the assignment does not include the title page and references page.
- References need to include your textbook plus two additional credible academic references. All sources used, including your textbook, must be referenced; paraphrased and quoted material must have accompanying citations and cited per APA guidelines.
Review the grading rubric, which can be accessed from the Course Information page. Reach out to your instructor if you have any questions about the assignment.
