Question

In: Finance

P3-3 (Budgetary Comparison Statement) This problem is based on the information about the Murphy County General...

P3-3 (Budgetary Comparison Statement) This problem is based on the information about the Murphy County General Fund budgeted and actual transactions and events described in Problem 3-2.

P3-2 (Budgetary and Other Entries—General and Subsidiary Ledgers) The Murphy County Commissioners adopted the following General Fund budget for the 20X8 fiscal year:

Murphy County General FundBudget—20X8

Estimated Revenues:

  Taxes

$  8,000,000

  Licenses and permits

800,000

  Intergovernmental

2,000,000

  Charges for services

200,000

  Fines and forfeits

400,000

  Other

600,000

12,000,000

Appropriations:

  General government

1,000,000

  Public safety

4,000,000

  Highways and streets

5,000,000

  Health and sanitation

900,000

  Culture and recreation

400,000

  Other

600,000

11,900,000

Excess of Estimated Revenues over Appropriations

100,000

Fund Balance—Beginning

1,400,000

Fund Balance—Ending (Anticipated)

$ 1,500,000

The following events occurred during 20X8:

  1. Purchase orders issued and contracts let were expected to cost:

General government

$  300,000

Public safety

1,200,000

Highways and streets

2,500,000

Health and sanitation

500,000

Culture and recreation

300,000

Other

200,000

$  5,000,000

  1. The commissioners reviewed the budget during the year and (a) revised the estimate of Intergovernmental Revenues to $1,500,000 and reduced the Public safety and Highways and streets appropriations by $225,000 each to partially compensate for the anticipated decline in intergovernmental revenues, and (b) increased the Health and sanitation appropriation by $70,000 because of costs incurred in connection with an unusual outbreak of Tasmanian flu.
  2. Revenues (actual) for 20X8 were:

Taxes

$ 8,150,000

Licenses and permits

785,000

Intergovernmental

1,520,000

Charges for services

210,000

Fines and forfeits

395,000

Other

500,000

$11,560,000

  1. Goods and services under purchase orders and contracts were received:

Estimated Cost

Actual Cost

General government

$ 280,000

$ 278,000

Public safety

900,000

910,000

Highways and streets

2,500,000

2,500,000

Health and sanitation

440,000

440,000

Culture and recreation

300,000

295,000

Other

180,000

181,000

$4,600,000

$4,604,000

  1. The remaining orders are still outstanding.
  2. Other expenditures incurred were:

General government

$ 700,000

Public safety

2,560,000

Highways and streets

2,271,000

Health and sanitation

485,000

Culture and recreation

45,000

Other

391,000

$6,452,000

Required

  1. Set up general ledger T-accounts like those in Illustration 3-1 and also revenues and expenditures subsidiary ledgers like those in Illustrations 3-2 and 3-3.
  2. Record the Murphy County 20X8 General Fund budget in the general ledger and subsidiary ledger accounts, keying these entries “B” (for budget). Then record the numbered transactions and events, keying these entries by those numbers.

Required

  1. Prepare a budgetary comparison statement for the General Fund of Murphy County for the 20X8 fiscal year. The statement should present revenues (by source category), expenditures and encumbrances (by function), and the excess of revenues over (under) expenditures and encumbrances. Use these column headings:
    •       Original Budget
    •       Revised Budget
    •       Actual
    •       Variance—Over (Under)

Assume that no encumbrances were outstanding at the beginning of 20X8.

  1. Because encumbrances do not constitute expenditures, some governmental fund budgetary comparison statements omit data on encumbrances. (a) If no encumbrances were outstanding at the beginning of 20X8, what effects would omission of encumbrances data have on the Murphy County General Fund budgetary comparison statement for the 20X8 fiscal year? (b) In what circumstances would including or excluding encumbrances data mislead users of a governmental fund budgetary comparison statement?

Solutions

Expert Solution

Solution :-

As per the given data,

Step -1:-  Preparation of budgetary comaparision statement :-

A budgetary Comparision statement is a financial statement of general Govt Fund which shows the budgeted and actual revenue and expenditure and encumbrance in the form of variance.

Step - 2:- Prepare the statement of revenue , expenditures,and changes in fund balances on budgetary basis :-

Budgetary comparision statement for the fiscal year of 2018

Step :-3  Calculation of the revised budget for publc safety expenditure :-

The estimated personal service appropriation for the fiscal year was $4,000,000.

The city Council has decreased the budget by $225,000.

Revised budget for pubilc safety

= $4,000,000 - $225,000

= $3,775,000

Step :- 4  Calculation the revised budget for highway and street :-

Highway and street appropriation for the fiscal year was $5,000,000.

The city council has decreased the budget budget by $225,000.

Revised budget for highway & Street = $5,000,000 - $225,000

      = $4,750,000

Step :-5  Calculation of the revised budget for the health and sanitization

Health and Sanitization appropriation for the fiscal year was $ 900,000

The city council was increased budget by $70,000

= $900,000 + $70,000

= $970,000


Related Solutions

P3-3 (Budgetary Comparison Statement) This problem is based on the information about the Murphy County General...
P3-3 (Budgetary Comparison Statement) This problem is based on the information about the Murphy County General Fund budgeted and actual transactions and events described in Problem 3-2. P3-2 (Budgetary and Other Entries—General and Subsidiary Ledgers) The Murphy County Commissioners adopted the following General Fund budget for the 20X8 fiscal year: Murphy County General Fund Budget—20X8 Estimated Revenues:   Taxes $  8,000,000   Licenses and permits 800,000   Intergovernmental 2,000,000   Charges for services 200,000   Fines and forfeits 400,000   Other 600,000 12,000,000 Appropriations:   General government...
CITY OF VIENNA Budgetary Comparison Schedule General Fund For the Year Ended December 31, 2017 Budgeted...
CITY OF VIENNA Budgetary Comparison Schedule General Fund For the Year Ended December 31, 2017 Budgeted Actual Amounts (Budgetary Basis) Variance with Final Budget Original Final Revenues: Taxes $6,500,000 $6,465,000 $6,480,000 $ 15,000 Licenses 230,000 ? 225,000 (8,000) Intergovernmental 1,200,000 1,200,000 1,200,000 0 Miscellaneous 120,000 104,000 ? 2,000 Total Revenues 8,050,000 ? ? 9,000 Expenditures and Encumbrances: General Government 2,700,000 2,602,000 ? 98,500 Public Safety 4,050,000 4,200,000 4,215,000 (15,000) Health and Welfare ? ? 1,198,000 22,000 Total Expenditures and Encumbrances...
1.A county uses the legal budgetary basis to report encumbrances. Information for its latest fiscal year...
1.A county uses the legal budgetary basis to report encumbrances. Information for its latest fiscal year is as follows: Encumbrances outstanding at the beginning of the year $50,000 Encumbrances outstanding at the end of the year 75,000 Excess of revenues and other financing sources over expenditures and other financing uses, legal budgetary basis 860,000 What is the excess of revenues and other financing sources over expenditures and other financing uses, using the GAAP budgetary basis? A.$810,000 B.$835,000 C.$885,000 D.$935,000 2.A...
3 Required information Serial Problem Business Solutions LO P1, P2, P3, P4 [The following information applies...
3 Required information Serial Problem Business Solutions LO P1, P2, P3, P4 [The following information applies to the questions displayed below.] Santana Rey created Business Solutions on October 1, 2019. The company has been successful, and its list of customers has grown. To accommodate the growth, the accounting system is modified to set up separate accounts for each customer. The following chart of accounts includes the account number used for each account and any balance as of December 31, 2019....
a.) What are the tight lowerbound of the comparison based sorting problem and searching problem respectively....
a.) What are the tight lowerbound of the comparison based sorting problem and searching problem respectively. b.) True or False: A P problem is one that can be solved in polynomial time. while a NP problem is one that cannot be solved in polynomial time.Tell the relationship between P and NP problems
Problem 17-3A Applying activity-based costing LO P1, P3, A1, A2, C3 [The following information applies to...
Problem 17-3A Applying activity-based costing LO P1, P3, A1, A2, C3 [The following information applies to the questions displayed below.] Craft Pro Machining produces machine tools for the construction industry. The following details about overhead costs were taken from its company records. Production Activity Indirect Labor Indirect Materials Other Overhead Grinding $ 380,000 Polishing $ 145,000 Product modification 450,000 Providing power $ 205,000 System calibration 470,000 Additional information on the drivers for its production activities follows. Grinding 19,000 machine hours...
Comparison of absortion costing and activity based costing systems Through an optimization problem.
Comparison of absortion costing and activity based costing systems Through an optimization problem.
1 2 3 4 This problem is based on information taken from The Merck Manual (a...
1 2 3 4 This problem is based on information taken from The Merck Manual (a reference manual used in most medical and nursing schools). Hypertension is defined as a blood pressure reading over 140 mm Hg systolic and/or over 90 mm Hg diastolic. Hypertension, if not corrected, can cause long-term health problems. In the college-age population (18–24 years), about 9.2% have hypertension. Suppose that a blood donor program is taking place in a college dormitory this week (final exams...
Required information Problem 6-5A Preparing a bank reconciliation and recording adjustments LO P3 [The following information...
Required information Problem 6-5A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.] Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,090 and No. 5893 for $499. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement PREVIOUS...
Required information Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information...
Required information Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017. On July 31, the company’s Cash account has a $27,497 debit balance, but its July bank statement shows a $27,233 cash balance. Check No. 3031 for $1,482 and Check No. 3040 for $558 were...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT