Question 1. Khan is running a flower shop since last five years successfully. He has five...

Question 1.

Khan 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 be 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 .

Cash in hand OMR 17,000 and balance at bank OMR 9,500.
Received commission by cheque OMR 5,000.

Issued cheque to XYZ LLC for cash purchase of furniture OMR 1,100.
Sold goods to M/S Muhammed for cash OMR 2,500.

8. Purchased a used office equipment OMR 1,200. Spent OMR 50 on its repair.

10. Received a purchase order for OMR. 250 from KM LLC.

11 Issued a cheque for OMR 6,500 to ABC Traders in full settlement of his account OMR 6,750.

12. Withdrew from bank OMR 1,000.

15. Received a cheque OMR 2,500 from CDC traders settled his account OMR2,800.

18. Withdrew for personal use OMR 1,000.

20. Purchased machinery from ABC LLC for OMR 5,000 and paid 40% by cash and balance paid by cheque.

24. Paid ROP fine OMR 200. (Online).

Received a cheque for commission OMR 500 from R. & Co. and deposited into bank.
Paid rent and wages OMR 800 and OMR 2,700 by bank respectively.
Received a cheque of OMR 18,900 from Ali in full settlement of his account OMR 19,000.

Paid Utility bills OMR 200 by cheque.

31. Paid carriage charges OMR. 50 by cash.

Required: -Prepare three columns cash book for the month using MS Excel.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Jason has participated in the flower auction for the last nine years as an agent for...

Jason has participated in the flower auction for the last nine years as an agent for Holt Ltd. (Holt). Every occasion Holt had been given clear direction to buy whatever kinds of flowers he felt the store would need and be able to sell. There always was a wide array of flowers available at the auction; there were exotic flowers like orchids, as well as greenery like vines, and potted plants like camellia bushes and rose bushes. On this, occasion,...

FOPPI BIKES Ltd, sell bicycles, and has been running successfully for a number of years. The...

FOPPI BIKES Ltd, sell bicycles, and has been running successfully for a number of years. The bank has requested a Cash-flow Statement for last month and Signor Foppi provides you with the following transactions / events, and asks for your assistance. You are required to identify for each cash flow the correct classification, selecting from the drop down list; Operating, Investing or Financing. You must also indicate whether the cash-flow is an inflow or outflow. Where you believe there is...

Case Study: The Flower Shop Anastasia owns a successful flower shop. She has been in business...

Case Study: The Flower Shop Anastasia owns a successful flower shop. She has been in business for four years and enjoys a good reputation in the community. She is a good marketer and good manager. The shop is in a prominent location with an ample parking lot which thus provides good foot traffic for the business. The shop is opened six days a week from 10am to 5pm. Recently, she has been thinking about extending the flower shop's hours an...

Case Study: The Flower Shop Anastasia owns a successful flower shop. She has been in business...

Colin Closer has been playing baseball since he was five years old and has always dreamed...

Colin Closer has been playing baseball since he was five years old and has always dreamed of playing in the big leagues. Last season, he was a starting pitcher for a double-A (AA)-level baseball team, the Moab Mountain Goats; last year, he was the first runner-up for the Minor League Player of the Year award. Using his 93 mph fastball, an impeccable curve ball and slider, and a reliable changeup pitch, he achieved a 15-2 win–loss record, an earned run...

The flower shop has ten different flower arrangements. How many different ways can the shop show...

The flower shop has ten different flower arrangements. How many different ways can the shop show flowers if their display case can hold three flower arrangements and no flower arrangement is repeated?

Question: Explicate the key reason that the US has been running deficits for the last close...

Question: Explicate the key reason that the US has been running deficits for the last close to 40 years, and presently, is the largest debt nation globally. The US net international Investment position is approximately $ 12 trillion.

A small grassroots organization has been running a food pantry for about five years. They are...

A small grassroots organization has been running a food pantry for about five years. They are located in the community center of a local church. The church is its only major partner. They typically open about two days per week and provide food for local families that stop in. The hours of operation are a bit inconsistent. Most of their donations, of late, have come from the church. Sometimes, they collect hats, scarves and gloves to distribute during winter months....

Question 1:- (15 marks) a) Assuming that you are running a printing shop. Identify 3 items...

Question 1:- a) Assuming that you are running a printing shop. Identify 3 items as fixed costs and 3 items as variable costs of your business. Hint: You also need to determine the level of activity in your business. b) What would be the implications if a business does not prepare a budget? Explain your views c) Choose one limitation of budgeting and write clearly on that point using your own words.

1. Select a company that has undergone an initial public offering within the last five years...

1. Select a company that has undergone an initial public offering within the last five years and obtain the prospectus (these are usually available on the company’s website, EDGAR for companies listed on the U. S. stock exchanges, or other information services). A. What is the business strategy and business model? B. Identify the strategic objectives. C. Identify the key critical risks. D. Discuss which of the critical risks identified in C. above the internal audit function should focus on...

Subjects