Question
he 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
he 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 functions7.
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started