Questions are in attachment. Willing to offer more money if needed.

Problem I. (80 points possible). Below is selected information on the post-closing trial balance of the General Fund at March 31, 2016, the last day of the 2016 fiscal year (FY 2016) of the Town of Juno, NJ, a quiet town approximately 20 miles east of the Pennsylvania border. Cash Taxes receivable--current Estimated uncollectible current taxes Vouchers payable Encumbrances Outstanding--2016 Fund balance--Unassigned $ Debit 184,400 243,919 Credit $ 4,878 97,216 54,321 ? The town has three primary governmental functions: General Government, Public Safety, and Public Works. The Town's is about to begin the 2017 fiscal year (FY 2017) set to begin April 1, 2016 and ending March 31, 2017. Instructions: For each question below, provide the journal entry(ies), explanation, or calculation for each selected transaction below. Unless otherwise indicated, each journal entry(ies) should be for the Town of Juno's General Fund for fiscal year 2017 (FY 2017). No subsidiary journal entries will be required. 3/31/16. Calculate the unreserved fund balance in the General Fund. Show your computations to receive credit: 4/1/16 The Town of Juno's city council and mayor approved the fiscal year 2017 budget with estimated revenues of $383,840, unallotted appropriations of $801,300, estimated other financing uses of $38,500 and estimated other financing sources of $190,000. 1. Journalize the adoption of the fiscal year 2017 budget in the general fund: 2 2. Briefly explain if there exists sufficient fund balance to adopt this budget? Is this a deficit budget/surplus budget? (No less than three (3) sentences, supported by calculations): 3. On 4/2/16, the Town of Juno allotted approximately 15% of the annual appropriations to the various agencies for the beginning of the fiscal year. Journalize the entry in the general fund to record the allocation of the allotment: 4/20/16. $96,000 of the balance in vouchers payable were paid in cash; journalize the payment at the governmental activities (government-wide) level: 4/22/16. Goods ordered in FY 2016 that were outstanding at the end of that fiscal year were received on 4/22/16 in FY 2017. The estimated cost of the goods received on this date was $54,321. The invoice cost of the goods was $54,398. 1. Journalize the entry to record the receipt of the FY 2016 goods in the general fund: 2. Journalize the entry in the General Fund to record the invoice cost of the goods in FY 2017: 3 5/2/16. Revenues were received in cash totaling $112,200 (charges for services: $68,000 General Government, $12,500 Public Safety, and $31,700 Public Works): 1. Journalize the entry to the general fund: 2. Journalize the governmental activities (government-wide) entry: 6/12/16. Purchase orders were issued to acquire various goods for FY 2017 with estimated costs as follows: General Government Public Safety Public Works $ $ 149,200 54,318 29,374 232,892 Journalize the purchase orders in the general fund: 6/20/16. Collected 90% of the property taxes receivable that were assessed during the previous fiscal year (FY 2016) (round to the nearest dollar) (Hint: Look at the Trial Balance). Journalize the collection of the taxes in the general fund: 4 6/21/16. Assume the remaining balance of taxes receivable are delinquent. Journalize the delinquency in the general fund: 6/22/16. The delinquent taxes were immediately assessed interest and penalties totaling $2,900, of which $300 are estimated as uncollectible. Journalize the assessed interest and penalties in the general fund: 6/30/16. Annual property taxes for FY 2017 are levied at $260,000, with estimated uncollectible taxes at 3%. 1. Calculate the gross property tax levy (round to the nearest dollar): 2. Journalize the FY 2017 property tax levy in the governmental activities (government-wide level): 7/1/16. The Town of Juno, NJ borrowed $50,000 from First National Bank, N.A. in anticipation of property tax collections. Interest is 5% per annum on the note. The note is expected to be paid back within three months. Journalize the entry to record the receipt of the proceeds in the general fund: 5 7/5/16. Payroll is journalized in the amount of $280,100 with $58,400 in federal tax withholdings ($21,428 of this amount are the employee's share of FICA taxes) and $11,204 in NJ state tax withholdings. Journalize the payroll accrual in the general fund: 7/11/16. Journalize the payment of the vouchers for the employee's net pay in the general fund: 7/12/16. In the general fund, journalize the employer's required FICA tax match owed to the federal government from the 7/5/13 payroll (do not credit Vouchers Payable): 7/16/16. Received only part of the 6/12/16 order for General Government, while 100% of the orders for Public Safety and Public Works were received. Actual costs and estimated costs below of the order received: General Government Public Safety Public Works $ $ Actual Cost 126,940 54,274 28,950 210,164 Estimated Cost $ 126,820 54,318 29,374 $ 210,512 1. Journalize the receipt of the order in the general fund: 2. Journalize the actual expenditure and liability in the general fund: 6 3. Journalize the actual expenditure and liability in the governmental activities (governmentwide) journal: 8/1/16. The Town of Juno allotted approximately 40% of the remaining balance of annual appropriations to the various agencies. Journalize the entry in the general fund to record the allocation of this second allotment: 8/12/16. The Town of Juno issued a note with the proceeds used to finance the cost of acquiring two (2) emergency vehicle units costing $94,000 each. 1. Journalize the 8/12/16 issuance of the note in the general fund: 2. Journalize the 8/12/16 issuance of the note in the governmental activities (government-wide) journal: 7 8/14/16. Issued a purchase order for the two (2) emergency vehicle units. The estimated cost was $94,000 per vehicle. The vehicles are custom ordered and will not be received until the end of the fiscal year. Journalize the entry in the general fund to record the issuance of the purchase order: 10/1/16. The Town of Juno, NJ repaid the tax anticipation note (issued on July 1) in full, including interest. Prepare the journal entry in the governmental activities (government-wide) journal (round to the nearest dollar): 10/15/16. Approximately $4,192 of the delinquent taxes recorded on 6/21/16 from the previous fiscal year were deemed uncollectible by the Town of Juno Tax Assessor. Interest and penalties of $100 are attached to the delinquent taxes. These taxes and associated interest and penalties have been approved for a write-off. Journalize the write-off of these delinquent taxes and the interest and penalties in the general fund: 10/19/16. The Town of Juno realized that revenues are slowing due to economic conditions. While this might be only a short-run impact, the city council and mayor did not want to chance the possibility of lesser-than-expected revenues. Therefore, the Town reduced estimated revenues by $10,000. It also reduced unallotted appropriations by the same amount (ignore the impacted programs/functions). Journalize the entry in the general fund to record this budget adjustment: 8 11/8/16. The Town of Juno was pleased to hear that it received a $50,000 grant from the U.S. Department of Agriculture to study the \"dating\" habits of small town teens. A Special Revenues Fund was created (ignore budget adoption). The grant requires that Juno expend the monies for the grant prior to seeking reimbursement (eligibility requirement must be satisfied). 1. Assume Juno spends $50,000 on the study. Journalize the entry in the Special Revenues Fund to record the expenditure and liability (ignore encumbrances): 2. Juno then mails the U.S. Department of Agriculture the receipts spent on the grant; ten days later, the Town of Juno received a check for $50,000. Journalize the receipt of the grant proceeds in the Special Revenues Fund: 9 Problem II. (20 points possible). The City of Camden, NJ General Fund Pre-closing Trial Balance is provided below for fiscal year ending June 30, 2016 (FY 2016). The trial balance is listed in alphabetical order. Do not include encumbrances or encumbrances outstanding in either closing entry. Instructions: 1. Prepare the budgetary closing entry in the space provided on the next page. 2. Prepare the closing entry for the remaining nominal accounts in the space provided on the next page. City of Camden, NJ General Fund Pre-Closing Trial Balance June 30, 2016 Cash Allowance for Uncollectible Delinquent Taxes Allowance for Uncollectible Interest and Penalties Appropriations Budgetary Fund Balance Due from Other Funds Due to Federal Government Due to New Jersey State Government Due to Other Funds Encumbrances Outstanding--2016 Encumbrances--2016 Estimated Other Financing Sources Estimated Other Financing Uses Estimated Revenues Expenditures--2015 Expenditures--2016 Fund Balance--Committed Fund Balance--Unassigned Interest and Penalties Receivable on Taxes Inventory of Supplies Other Financing Sources Other Financing Uses Revenues Taxes Receivable--Delinquent Vouchers Payable Debits $ 2,348,221 Credits $ 309,735 8,442 7,750,000 560,000 8,709 16,246 74,983 1,229 12,350 12,350 2,000,000 180,000 6,490,000 74,800 7,640,000 218,300 1,051,141 90,775 261,655 2,000,000 182,000 6,879,000 766,816 813,900 $19,875,326 $ 19,875,326 10 Problem II (Continued). Prepare the budgetary closing entry at 6/30/16: Prepare the closing entry for all remaining nominal accounts at 6/30/16: 11 Problem III. (20 points possible). The City of Alton, MO has appropriations of $1,298,325 for fiscal year 2016 (FY 2016), which is on a calendar year. During FY 2016, Alton's budget manager was notified that the receiving department was not forwarding the receiving reports on a timely manner; the City of Alton did not pay on any invoices received since it needed the receiving reports for expenditure and disbursement. Below are the purchase orders, receiving report data, and invoices through March 31, 2016 (notice that the goods ordered were received, some with multiple shipments; some of the goods ordered are backlogged): 2/16/16 Encumbrances--2016 2/28/16 Encumbrances--2016 3/17/16 Encumbrances--2016 145,000 344,800 96,800 Receiving Reports Issued: 2/22/16 Goods Rec'd on 2/16 order 2/27/16 Goods Rec'd on 2/16 order 3/4/16 Goods Rec'd on 2/28 order 3/5/16 Goods Rec'd on 2/16 order 3/18/16 Goods Rec'd on 2/16 order 3/28/16 Goods Rec'd on 3/17 order 116,000 14,500 310,300 14,500 2,500 96,800 Purchase Invoices Received: 2/23/16 Goods Rec'd 2/22 3/1/16 Goods Rec'd 2/27 3/7/16 Goods Rec'd 3/4 3/7/16 Goods Rec'd 3/5 3/20/16 Goods Rec'd 3/18 3/31/16 Goods Rec'd 3/28 116,857 14,489 311,070 14,601 2,488 96,910 The City of Alton's budget manager is very concerned there might be potential over-expenditure of appropriations. She was expecting to have at least $800,000 in available appropriations at the end of March. Instructions: Using the information above, prepare a schedule of available appropriations at March 31, 2016 in good form with subtotals. Once you complete the schedule, briefly answer the following questions: Did the budget manager have at least $800,000 in available appropriations? Why or why not? If at least $800,000 is not available, should the budget manager be fired? You may write up your solution on the next page. 12 Problem III. (Continued). End of Exam 13