Question

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

Answer 1

Statement of Revenue and Expenditure as on May 31, 2018
Income:
Operating Revenue	$2,57,05,000
Interest	$       36,000
Total Income		$2,57,41,000
Expenditure:
Employee Wages	$   86,54,000
Temporary Labor	$     7,50,000
Repairs and Maintenance	$   64,25,000
Depreciation	$   45,32,000
Utilities	$     9,48,000
Interest Expense	$     4,75,000
Total Expenditure		$2,17,84,000
Profit		$   39,57,000
Less: Transfer to General Fund		$     3,15,000
Transfer to Balance sheet		$   36,42,000
Changes in Fund Net Position for the fiscal year ending May 31, 2018
Net position on June 1, 2017	$   38,20,000
Add:Profit during the year	$   39,57,000
Add: Additional contribution during the year	$   12,00,000
	$   89,77,000