Question

The finance director of the City of Minnetonka is making estimates for the budget for the upcoming fiscal year ending June 30, 20XO. The attached information is available for the budget for the General Fund. The fund balances in the General Fund at the end of fiscal year 20W9 are expected to be $1,250,000. The city wants at least S1,600,000 at the end of fiscal year 20X0 to provide financing for fiscal year 20X1 operations. REQUIRED: (1) (2) (3) Prepare the revenues budget for fiscal year 20X0. Show all supporting computations Prepare an expenditures budget, excluding salaries and wages, for fiscal year 20X0. Show supporting computations. What amount can be spent for salaries and wages in the 20X0 budget based upon the information in the problem? Show computations. What percentage increase or decrease will this be assuming that any change would be across the board
CITY OF MINNETONKA INFORMATION FOR PREPARING REVENUES AND EXPENDITURES BUDGETS FOR FISCAL YEAR 20X0 Estimated Amount For Fiscal 209Expected Change For Fiscal 20XO Revenues: Property Taxes State Grants Federal Grants Other 2,500,00 850,000 600,000 S 325,000 S 3.0 % Increase 3.0% increase 60,000 decrease 25,000 increase Expenditures: 2,500,000 Salaries and Wages Utilities Maintenance Capital Purchases Debt Service Other 450,000 00,000S 00,000 200,000 S Dependent on money available 5.5% increase 25,000 increase 35,000 increase 25,000 increase 2.5% increase 50,000
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Revenue budget for the year 20x0

Particulars Budgeted amount

Revenues:-

property taxes (2,500,000+2,500,000*5%) 2,625,000

state grants ( 850,000+850,000*3%) 875,500

federal grants (600,000-60,000) 540,000

others (325,000+25,000)    350,000

total estimated revenue (a)   4,390,500

expenditures:-

salary and wages 2,329,500

utilities (450,000+450,000*5.5%) 474,750

maintenance (300,000+25,000) 325,000

debt services (200,000+25,000) 225,000

others (50,000+50,000*2.5%) 51,250

total budgeted expenditures (b)    3,405,500

  total revenue (a)- (b) 985,000

computation of estimated salary and wages exepenses

available cash balance at the begning of the year 1,250,000

estimated revenue collected in the year 4,390,500

total cash available 5,440,500

total exepnses other than salary and wages 1,076,000

capital purchase 435,000

total cash available at the end of the year 3,929,500

cash required at the end of the year 1,600,000

cash available for salary and wages 2,329,500

percentage decrease in amount of salary and wages 170,500/2500000*100=6.82%

  

expenditure budget for the year 20x0 (other than salary and wages)

particulars estimated amount

utilities ( 450,000+450,000*5.5%) 474,750

maintenance (300,000+25,000) 325,000

debt services ( 200,000+25,000) 225,000

capital purchases (400,000+35,000) 435,000

others (50,000+50,000*2.5%) 51,250

total estimated expenditure budget 1,511,000

Add a comment
Know the answer?
Add Answer to:
The finance director of the City of Minnetonka is making estimates for the budget for the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • excel file not actually provided 3-15. The City of Grafton's records reflected the following budget and...

    excel file not actually provided 3-15. The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2017. 1. Estimated revenues: Taxes (Property) $3,213,000 Licenses and permits 790,000 Intergovernmental revenues 310,000 Miscellaneous revenues 200,000 2. Revenues: Taxes (Property) $3,216,000 Licenses and permits 792,000 Intergovernmental revenues 299,000 Miscellaneous revenues 195,000 3. Appropriations: General government $ 920,000 Public safety 2,090,000 Health and welfare 1,400,000 4. Expenditures: General government $ 880,000...

  • The following transactions occurred during the 2020 fiscal year for the City of Evergreen. For budgetary...

    The following transactions occurred during the 2020 fiscal year for the City of Evergreen. For budgetary purposes, the city reports encumbrances in the Expenditures section of its budgetary comparison schedule for the General Fund but excludes expenditures chargeable to a prior year’s appropriation. The budget prepared for the fiscal year 2020 was as follows: Estimated Revenues: Taxes $ 1,943,000 Licenses and permits 372,000 Intergovernmental revenue 397,000 Miscellaneous revenues 62,000 Total estimated revenues 2,774,000 Appropriations: General government 471,000 Public safety 886,000...

  • Greenville has provided the following information from its General Fund Revenues and Appropriations/Expenditure/Encumbrances subsidiary ledgers for...

    Greenville has provided the following information from its General Fund Revenues and Appropriations/Expenditure/Encumbrances subsidiary ledgers for the fiscal year ended. Assume the beginning fund balances are $167 (in thousands) and that the budget was not amended during the year. Required Prepare a General Fund statement of revenues, expenditures, and changes in fund balance. Prepare a General Fund schedule of revenues, expenditures, and changes in fund balance—budget and actual (assume the budget is prepared on a GAAP basis). 514 308 367...

  • Greenville has provided the following information from its General Fund Revenues and Appropriations/Expenditure/Encumbrances subsidiary ledgers for...

    Greenville has provided the following information from its General Fund Revenues and Appropriations/Expenditure/Encumbrances subsidiary ledgers for the fiscal year ended. Assume the beginning fund balances are $156 (in thousands) and that the budget was not amended during the year. City of Greenville General Fund Subsidiary Ledger Account Balances (in thousands) For the Fiscal Year Debits Credits Estimated Revenue Taxes 6,048 Fines & Forfeits 303 Intergovernmental Revenue 504 Charges for Services 370 Revenues Taxes 6,056 Fines & Forfeits 308 Intergovernmental Revenue...

  • please explain this to me. I am thoroughly confused 3-15. The City of Grafton's records reflected...

    please explain this to me. I am thoroughly confused 3-15. The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2017. 1. Estimated revenues: Taxes (Property) $3,213,000 Licenses and permits 790,000 Intergovernmental revenues 310,000 Miscellaneous revenues 200,000 2. Revenues: Taxes (Property) $3,216,000 Licenses and permits 792,000 Intergovernmental revenues 299,000 Miscellaneous revenues 195,000 3. Appropriations: General government $ 920,000 Public safety 2,090,000 Health and welfare 1,400,000 4. Expenditures:...

  • The City of South River budget for the fiscal year ended June 30.2020. Included an appropriation...

    The City of South River budget for the fiscal year ended June 30.2020. Included an appropriation for the police department in the amount of $8.712.000. During the month of July 2020, the following transactions occurred in summary: Purchase orders were issued in the amount of $545.000 Of the $545,000 in purchase orders, $502,000 were filled with involces amounting to $492,000. Salaries, not encumbered, amounted to $308.000. A budget appropriations reduction in the amount of $64.000 was approved by the city...

  • $614,400 $614,400 Assigned fund balance consists of outstanding encumbrances. Required Prepare the budget entry th...

    $614,400 $614,400 Assigned fund balance consists of outstanding encumbrances. Required Prepare the budget entry that was made at January 1,2020. b. Calculate the balance in fund balance-unassigned on December 31, 2019. Prepare the required closing entries at year-end d. Prepare the general fund statement of revenues, expenditures, and changes in fund balances for 2020. Prepare the general fund balance sheet at December 31, 2020. C. e P10.12 General Fund-Entries and Financial Statements Below are the July 1, 2019 balances for...

  • The Edward City Council approved and adopted the budget for its general fund for the year just en...

    The Edward City Council approved and adopted the budget for its general fund for the year just ended. The budget contained the following amounts: Estimated revenues $4,900,000 Appropriations 4,780,000 Authorized interfund transfer to the sports and      recreation debt service fund 90,000 During the year, various transactions and events occurred that affected the general fund. Edward City levied property taxes of $4,000,000, of which it estimated that $25,000 would be uncollectible. During the discount period between the levy and the date...

  • In preparing its budget proposals, a city’s budget committee initially estimated that total revenues would be...

    In preparing its budget proposals, a city’s budget committee initially estimated that total revenues would be $120 million and total expenditures would be $123 million. In light of the balanced budget requirements that the city has to meet, the committee proposed several measures to either increase revenues or decrease expenditures. They included the following: 1. Delay the payment of $0.4 million of city bills from the last week of the fiscal year covered by the budget to the first week...

  • The following transactions occurred during the 2020 fiscal year for the City of Evergreen. For budgetary...

    The following transactions occurred during the 2020 fiscal year for the City of Evergreen. For budgetary purposes, the city reports encumbrances in the Expenditures section of its budgetary comparison schedule for the General Fund but excludes expenditures chargeable to a prior year’s appropriation. The budget prepared for the fiscal year 2020 was as follows: Estimated Revenues: Taxes $ 1,943,000 Licenses and permits 372,000 Intergovernmental revenue 397,000 Miscellaneous revenues 62,000 Total estimated revenues 2,774,000 Appropriations: General government 471,000 Public safety 886,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT