Question 2. Ali is running a flower shop since last five years successfully. He has five employees like two salesmen, one cleaner, one shop manager and one accountant. Business growing continuously and expending, so he has opened some more shops in other cities. Due to too much load in accountant department, he decided to do some task himself like to maintaining cash book, bank dealing and other cash related issues. Ali is commerce graduate but he is not good in Ms. Excel, being a friend you decided to teach him how to maintain three column cash books in Ms. Excel The records for the month of March 2020 transactions are as mentioned below 2020 March 1. Cash in hand OMR. 20,000 and balance at bank OMR. 18,500 (0/0) 2. Paid into bank OMR. 10,000. 3. Bought goods from M/S. Ali for OMR. 200 for cash. 4. Bought goods for OMR. 2,000 paid cheque for them, discount received 1% 5. Received a cheque from Irfan to whom goods were sold for OMR. 800. Discount allowed 12.5 % and deposited cheque into the bank. 8. Purchased a used computer for OMR. 200. Spent OMR. 50 on its repair. 9. Bank notified that Irfan's cheque has been returned dishonoured and debited to the account In respect of charges OMR. 10. 10. Received a purchase order for OMR. 250 from KM LLC. 11. Irfan settled his account by means of a cheque for OMR. 820, OMR. 20 being for interest charged. 12. Withdrew from bank OMR. 1,000 20. Received commission by cheque OMR 5,000. 22. Withdrew for personal use OMR. 1,000. 25. Paid Utility expenses OMR. 500 by cheque. 26. Purchased machinery from ABC LLC for OMR. 5,000 and paid 50% by cheque and balance paid within three months. 27. Issued cheque to XYZ LLC for cash purchase of furniture OMR. 1,575. 28. Received OMR 8,000 cash from XYZ LLC against goods supplied in last month, after allowing OMR 50 discount on bill amount 29. Paid municipality taxes OMR 1,000 through company bank account 30. Company Paid OMR 3,000 bonus to employees through online bank transfer. 31. Paid rent to landlord "Salim' by a cheque of OMR. 500 Required:- Prepare three columns cash book for the month using MS Excel. (10 Marks)