From the information provided, prepare appropriations, encumbrances, expenditure and fund balance ledger for the year 2019 in excel sheet.(10 marks)

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