Reference no: EM13587893

The following information relates to the City of Millersville for the fiscal year ending 12/31/13.

1. Total Fund Balance - Unassigned at 1/1/13 $82,900

2. Estimated revenues of $2,774,000 a. Taxes $1,943,000

b. Licenses and permits $372,000 c. Intergovernmental revenue $378,000 d. Other financing sources - sale of park land $81,000

3. Current year tax information a. Levy $2,005,000

b. Estimated uncollectible taxes $65,000 c. Collections from current year levy $1,459,000 d. All unpaid taxes at the end of the year are expected to be collected by 2/28/14

4. Revenues other than taxes - actual a. Licenses and permits $373,000 b. Intergovernmental revenue $381,000 c. Other financing sources - sale of park land $0

5. Appropriations of $2,693,000 for the following functions a. General government $557,000 b. Public safety $886,000 c. Public works $650,000

d. Parks and recreation $600,000

6. Total a. General government $422,100 b. Public safety $635,000 c. Public works $254,000 d. Parks and recreation $439,000 personnel costs of $1,750,100 charged to the following functions

7. Expenditure information a. Total purchase orders issued $931,000

i. General government $129,000 ii. Public safety $250,000

iii. Public works $392,000

iv. Parks and recreation $160,000 b. Actual amounts billed for purchase orders issued $850,500 (there were no differences in the amounts billed and the amounts ordered) i. General government $123,700

ii. Public safety $236,200 iii. Public works $360,000 iv. Parks and recreation $130,600

c. Total paid on bills/invoices received for purchase orders issued against current year non payroll appropriations $754,900

i. General government $104,599 ii. Public safety $202,712

iii. Public works $317,853

iv. Parks and recreation $129,736 d. The City Council passes a resolution at the end of every year to commit fund

balance in the amount of any unfilled and outstanding purchase orders as of year end. There were no outstanding purchase orders at the end of the prior year.

Questions:

1. What is the amount of "Tax Revenues" for the year?

2. What is the balance of "Current Taxes Receivable" at the end of the year?

3. What is the amount of total "Revenues" for the year?

4. Are total "Revenues" over or under the amount budgeted?

5. By how much are total "Revenues" over or under budgeted amounts?

6. Of the total amount appropriated for the year, how much was appropriated for nonpayroll expenditures?

7. Of the total nonpayroll expenditures appropriated for the year, how much relate to "General Government"?

8. Of the total nonpayroll expenditures appropriated for the current year, how much relate to "Public Safety"?

9. Of the total nonpayroll expenditures appropriated for the year, how much relate to "Public Works"?

10. Of the total nonpayroll expenditures appropriated for the year, how much relate to "Parks & Recreation"?

11. What is the amount of total outstanding purchase orders at the end of the year?

12. Of the total amount of purchase orders outstanding at the end of the year, what amount relates to "General Government"?

13. Of the total amount of purchase orders outstanding at the end of the year, what amount relates to "Public Safety"?

14. Of the total amount of purchase orders outstanding at the end of the year, what amount relates to "Public Works"?

15. Of the total amount of purchase orders outstanding at the end of the year, what amount relates to "Parks & Recreation"?

16. What is the amount of total Accounts Payable at the end of the year?

17. What is the amount of total expenditures for the current year?

18. Of the total expenditures for the year, how much relate to "General Government"?

19. Of the total expenditures for the year, how much relate to "Public Safety"?

20. Of the total expenditures for the year, how much relate to "Public Works"?

21. Of the total expenditures for the year, how much relate to "Parks & Recreation"?

22. For the current year, are total actual expenditures over or under the amounts appropriated?

23. For the current year, are total actual expenditures for "General Government" over or under the amounts appropriated?

24. For the current year, are total actual expenditures for "Public Safety" over or under the amounts appropriated?

25. For the current year, are total actual expenditures for "Public Works" over or under the amounts appropriated?

26. For the current year, are total actual expenditures for "Parks & Recreation" over or under amounts appropriated?

27. What is the balance in total Fund Balance at the end of the current year?

28. What is the amount of Unassigned Fund Balance at the end of the current year?