1

The information below should be used to prepare (in proper form in Excel) a Public Transportation...

Question

The information below should be used to prepare (in proper form in Excel) a Public Transportation...

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

Answers

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


Similar Solved Questions

1 answers
Please do by hand. Thanks in advance. 4. Let X1 - uniform(0,3) and X2 – uniform(0,2)...
Please do by hand. Thanks in advance. 4. Let X1 - uniform(0,3) and X2 – uniform(0,2) and suppose that Xi and X2 are independent. Find the pdf of Y1 = X1 + X2. (Hint: First find the joint pdf of Yi and Y2 = X2.)...
1 answers
Investigators want to determine the effectiveness of a new drug in lowering cholesterol. They conduct a...
Investigators want to determine the effectiveness of a new drug in lowering cholesterol. They conduct a small clinical trial in which patients were randomized to receive the new drug or placebo. The total cholesterol was measured after ten weeks on the assigned treatment. The table below shows the r...
1 answers
55) List the hormones that are produced by two of the following endocrine glands and indicate...
55) List the hormones that are produced by two of the following endocrine glands and indicate their effect: thyroid, testes, ovaries, pancreas, or pineal gland 56) Describe the ono...
1 answers
A. Identify the type of inhibition occurring. Explain how you know. b. Describe the difference or...
a. Identify the type of inhibition occurring. Explain how you know. b. Describe the difference or similarity between the Vmax and Km values for the different conditions C. Having identified the type of inhibitor indole is, explain what this means for where indole binds to chymotrypsin. + Inhibitor 1...
1 answers
[References] CHEMWORK The Ksp for SrSO4(s) is 3.2x10-7. Calculate the solubility of SrSO4(s). Ignore any potential...
[References] CHEMWORK The Ksp for SrSO4(s) is 3.2x10-7. Calculate the solubility of SrSO4(s). Ignore any potential reaction of the ions with water. Solubility for SrSO4(s) = mol/L Sun...
1 answers
What was the government’s objective in developing the Medicare and Medicaid programs? Was it a good...
What was the government’s objective in developing the Medicare and Medicaid programs? Was it a good decision as we look back today?...
1 answers
A triangle has angles of #78°#, #47°#, and #x+65°#. What is the value of #x#?
A triangle has angles of #78°#, #47°#, and #x+65°#. What is the value of #x#?...
1 answers
A solid insulating sphere of radius a = 3.1 cm is fixed at the origin of...
A solid insulating sphere of radius a = 3.1 cm is fixed at the origin of a co-ordinate system as shown. The sphere is uniformly charged with a charge density ρ = -350 μC/m3. Concentric with the sphere is an uncharged spherical conducting shell of inner radius b = 13.5 cm, and outer radius c =...
1 answers
II.6. The wave function of a particle in a 1D rigid box (infinite potential well) of...
II.6. The wave function of a particle in a 1D rigid box (infinite potential well) of length L is: v, 8, 1) = sin(x)e-En/5). n = 1,2,3... What is the probability density of finding the particle in its 2nd excited state?...
1 answers
Mercury, Inc., produces cell phones at its plant in Texas. In recent years, the company's market...
Mercury, Inc., produces cell phones at its plant in Texas. In recent years, the company's market share has been eroded by stiff competition from overseas. Price and product quality are the two key areas in which companies compete in this market. A year ago, the company's cell phones had been...
1 answers
U None of the above POPULATION PROPORTION 13. In order to estimate the population proportion of...
U None of the above POPULATION PROPORTION 13. In order to estimate the population proportion of Americans who support more international involvement to within 2% with 95% confidence, the sample size should be a. 16,577 6. 2,401 c. 1,691 d. None of the above n= (Zaz ) Ê (1-6) 14. In the crimina...
1 answers
A sinusoidal wave is described by the wave function, y = (0.20 m) sin(0.16x − 54t)...
A sinusoidal wave is described by the wave function, y = (0.20 m) sin(0.16x − 54t) where x and y are in meters and t is in seconds. Determine the following for this wave. (a) the amplitude ______________ m (b) the angular frequency _______________ rad/s (c) the angular wave number ____________...
1 answers
A) a beam of length L is attached to a string as shown in figure. the...
A) a beam of length L is attached to a string as shown in figure. the mass of the beam is M=20kg. determine the tension in the string and the force on the beam exerted by the pivot point. B) A 7m long beam that has a mass M=25kg is attached to the wall at point A by a hinge. the beam is also suppor...
1 answers
Problem 8-23 Schedule of Expected Cash Collectlons; Cash Budget [L08-2, LO8-8 The president of the retailer Prime P...
Problem 8-23 Schedule of Expected Cash Collectlons; Cash Budget [L08-2, LO8-8 The president of the retailer Prime Products has just approached the company's bank with a request for a $55,000, 90-day loan. The purpose of the loan is to assist the compay in acquiring inventories. Because the compa...
1 answers
16. In a noisy communication system transmitting binary digits (zeros and ones) the sender may send...
16. In a noisy communication system transmitting binary digits (zeros and ones) the sender may send a digit (for example, 1) and the receiver may receive the other digit (for example, 0). Let A be the event "a 1 is sent" and let B be the event "a 1 is received." Hence T is the event ...
1 answers
USA PIV.001. Plus 9. 8.) John Waits owns a small shop with four employees. For one...
USA PIV.001. Plus 9. 8.) John Waits owns a small shop with four employees. For one payroll period the total withholding tax for all employees was $1,506. The total employees' Social Security tax was $161 and the total employer's Social Security tax was $247. The total employees' Medicare...
1 answers
Clinical evidence has demonstrated an association between folic acid deficiency and the occurrence of neural tube...
Clinical evidence has demonstrated an association between folic acid deficiency and the occurrence of neural tube defects. What methods can be utilized in health promotion to make sure that women of childbearing age have adequate folic acid levels prior to pregnancy?...
1 answers
12.13 The two blocks shown we originally at rest Neglecting the masses of the pulleys and...
12.13 The two blocks shown we originally at rest Neglecting the masses of the pulleys and the effect of friction in the pulleys and between the blocks and the incline, determine (a) the corleon of each block, (b) the tension in the cable...

-- 0.016727--