Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Core Concepts Of Accounting

Authors: Leslie Breitner, Robert Anthony

11th Edition

0133125947, 9780133125948

More Books

Students also viewed these Accounting questions

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago