Prepare a budgetary comparisons schedule for the city

Assignment Help Financial Accounting
Reference no: EM131195181

The City of Grafton's records reflected the following budget and actual data for the General Fund for the fiscal year ended June 30, 2012.
Estimated revenues:

Taxes (Property)

$3,000,000

Licenses and permits

800,000

Intergovernmental revenues

300,000

Miscellaneous revenues

200,000

Revenues:

Taxes (Property)

$3,000,000

Licenses and permits

801,320

Intergovernmental revenues

293,000

Miscellaneous revenues

198,000

Appropriations:

General government

$ 900,000

Public safety

2,000,000

Health and welfare

1,400,000


Expenditures of 2012 appropriations:

General government

$ 880,000

Public safety

1,949,000

Health and welfare

1,398,000

5. Encumbrances of 2012 appropriations, outstanding as of June 30, 2012.
General government $18,000
Public safety 50,000

6. Transfer to debt service fund:
Budget $600,000
Actual 600,000

7. Budget revisions approved by the city council:
Estimated revenues:

Decrease intergovernmental revenues $10,000

Decrease miscellaneous revenues 3,000

Appropriations:
Decrease general government 2,000

8. Total fund balance at July 1, 2011, was $1,038,000.

Required:

Use the Excel file provided to prepare a budgetary comparisons schedule for the City of Grafton for the fiscal year ended June 30, 2012.

Include outstanding encumbrances with expenditures. Use the formula feature (e.g., sum, =, etc.) of Excel to calculate the amounts in cells.

Reference no: EM131195181

Questions Cloud

How would religion interpret the nature of georges malady : What sorts of values and considerations would each religion focus on in deliberating about whether or not George should opt for euthanasia - Given the above, what options would be morally justified under each religion for George and why?
Types according to task taxonomy : Assess the value to an interface designer, of being familiar with the seven basic tasks and create an argument for which three of the seven basic tasks are the most important to incorporate in a designparagraph and references.
Developing a problem statement : Throughout the DIT program, you may have been thinking about areas of research interest for your doctoral study. Your problem is something you want to address or for which you want to find a solution.
Effects of catastrophic events on transportation system : The Effects of Catastrophic Events on Transportation System Management and Operationsis the case study for this week. Please read and provide analysis in the form of an executive summary. Please feel free to search for other information that perta..
Prepare a budgetary comparisons schedule for the city : Use the Excel file provided to prepare a budgetary comparisons schedule for the City of Grafton for the fiscal year ended June 30, 2012.
What types of health care this facility will provide : Describe what types of health care this facility will provide. Summarize their purpose and services provided, such as the type of health care, number of staff, type of staff, size, departments, and so forth.
Design an innovative system for transporting : Design an innovative system for transporting refuse from the kitchen to the curb. Cost should not be a major consideration. Imaginative ideas that just might work are required.
Develop an efficient route for refuse collection : On a map of your campus (or any other convenient map), develop an efficient route for refuse collection, assuming that each blockface must be collected.
Identify family from a culture other than the united states : Identify a family from a culture other than the United States. Interview family members in terms of a range of issues, including family values, norms, customs, and rituals relative to marriage, childbearing, and childrearing. Compare your findings..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd