From the information provided, prepare appropriations, encumbrances, expenditure and fund balance ledger for the year 2019 in excel sheet. (10 marks) Date 2019 April 1 April 10 May 4 June 15 July 22 July 28 OMR 1,250,000 650,000 240,000 450,000 August 25 August 28 September 10 September 15 September 20 150,000 Transactions Appropriations via budget Expected grant Order for supplies 1/4th supplies received with voucher OMR 58,000 Placed order for two machinery @ 25000 each 50% of the balance of the supplies received with voucher OMR 85,000 General operating expenditure One of the machinery ordered delivered with voucher Balance of the supplies ordered cancelled Expected grant reduced by The price of the second machinery increased by OMR 5000 and agreed upon The second machinery was delivered with voucher As the oil prices down in the international market, government decided to cut down the budget appropriation by 5% Additional municipality property tax Transferred to Debt Service Fund Account Payable for the services received from ISF Transferred to Fiduciary - pension fund Received share of profits from State Enterprises (SE) Contract signed to complete the computerization in the general office Salary and other employee benefits payable Oct. 12 Oct.20 Oct.25 Nov. 5 Nov. 10 Nov15 Dec. 12 Dec. 25 146,000 112,000 60,000 185,000 260,000 90,000 Dec. 28 148,000 From the information provided, prepare appropriations, encumbrances, expenditure and fund balance ledger for the year 2019 in excel sheet. (10 marks) Date 2019 April 1 April 10 May 4 June 15 July 22 July 28 OMR 1,250,000 650,000 240,000 450,000 August 25 August 28 September 10 September 15 September 20 150,000 Transactions Appropriations via budget Expected grant Order for supplies 1/4th supplies received with voucher OMR 58,000 Placed order for two machinery @ 25000 each 50% of the balance of the supplies received with voucher OMR 85,000 General operating expenditure One of the machinery ordered delivered with voucher Balance of the supplies ordered cancelled Expected grant reduced by The price of the second machinery increased by OMR 5000 and agreed upon The second machinery was delivered with voucher As the oil prices down in the international market, government decided to cut down the budget appropriation by 5% Additional municipality property tax Transferred to Debt Service Fund Account Payable for the services received from ISF Transferred to Fiduciary - pension fund Received share of profits from State Enterprises (SE) Contract signed to complete the computerization in the general office Salary and other employee benefits payable Oct. 12 Oct.20 Oct.25 Nov. 5 Nov. 10 Nov15 Dec. 12 Dec. 25 146,000 112,000 60,000 185,000 260,000 90,000 Dec. 28 148,000