Please assist in meeting requirements A and B in the excel file.

(Transaction and Closing Entries) The City of Merlot operates a Central Garage through an Internal Service Fund to provide garage space and repairs for all city owned and operated vehicles. The Central Garage Fund was established by a contribution of $500,000 from the General Fund on July 1,20x7, at which time the building was acquired. The post closing trial balance at June 30, 20x9, was as follows: Debit Credit Cash 150,000 Due from General Fund 20,000 Inventory of Materials and Supplies 80,000 Land 60,000 Building 200,000 Accumulated Depreciation - Building 10,000 Machinery and Equipment 56,000 Accumulated Depreciation - Machinery and Equipment 12,000 Vouchers Payable 38,000 Net Position 506,000 566,000 566,000 The following information applies to the fiscal year ended june 30, 20y0: 1. Materials and supplies were purchased on account for $74,000. 2. The inventory of materials and supplies at June 30, 20y0, was $58,000, which agreed with the physical count taken. 3. Salaries and wages paid to employees totaled $230,00, including related cost. 4. A billing from the Enterprise Fund for utility charges totaling $30,000 was received and paid. 5. Depreciation of the building was recorded in the amount of $5,000. Depreciation of the machinery and equipment was $8,000.00 6. Billings to other departments for services rendered to them were as follows: General Fund $262,000 Water and Sewer Fund $84,000 Special Revenue Fund $32,000 7. Unpaid interfund receivable balances at June 30, 20Y0 were as follows: General Fund $6,000 Special Revenue Fund $16,000 8. Vouchers payable at June30, 20y0, were $14,000 Required A. For the period July 1, 20x9 through June 30, 20y0, prepare journal entries to record all of the transactions in the Central Garage Fund accounts. B. Prepare closing entries for the Central Garage Fund at June 30, 20y0. (AICPA adapted). pace and repairs for all city 000 from the General Fund 20x9, was as follows: hysical count taken. ery and equipment was nsactions in the Central