Question

In: Accounting

QUESTION 1 (60 MARKS) Feast E-Mart Sdn. Bhd. is an online grocery store that offers home...

QUESTION 1

Feast E-Mart Sdn. Bhd. is an online grocery store that offers home delivery of groceries to customers around Changlun, Jitra, and Alor Setar. Feast E-Mart purchases their supplies of grocery products from suppliers in Kedah, Perlis and Penang. The shop is located at the new Kedah SME Industrial area beside the Kedah River. Installation of surveillance camera at entrance area is expected to be completed in two months. Due to a limited building space, a warehouse is built in a separate area behind the store. This warehouse consists of two large room with one main entrance. One room is rented by Feast E-mart, while another room is rented by other business selling electrical parts. Each room has a modern touch surrounded with glass windows and installed with glass door and air conditioner. There are two security guards hired to scout the area. Each of them work individually on a 12-hour shift basis.

The following paragraphs present the purchasing procedures of Feast E-Mart. Currently, the business adopts basic technology in its purchasing system with an independent system maintain in each department.

Inventory Control Procedures

Inventory status are retrieved from the Sales Management System. The inventory records include a quantity on hand and a desired quantity on hand for all grocery types in the inventory database. Each day, the inventory control clerk monitors the balance of inventories in the database, showing those items that have reached their reorder points. Then, the clerk prints a purchase requisition (PR) from the system and approves the reordering of inventory by signing the PR. Then, the clerk forwards the approved PR to the Purchasing Department.

Purchasing Procedures

Upon receiving the approved PR, the purchasing clerk keys in purchasing data to prepare purchase order (PO), selects a supplier from the registered supplier file in the purchase database, update the PO file and creates a purchase order on the purchasing system. Once the purchase order is saved, the completed purchase order is printed in four copies. PO1 is sent to the supplier, PO2 is sent to the Inventory Control Department, PO3 (blind copy) is sent to the Receiving Department and PO4 is sent to the Accounts Payable Department. The approved PR is filed. In certain situation, if the chosen supplier is unable to fulfill the order, urgent order request will be made to any other supplier available in Alor Setar area. No purchase requisition is issued in this situation.

Receiving Procedures

When the inventory arrives at the Receiving Department from the supplier, the receiving employees are expected to check and count the inventory, and compares the actual quantity to the quantity stated in the attached packing slip and PO3. This process is, however, unmonitored and based on trust to the employees. Then, the employee keys in the PO number and records the actual quantity of inventory received in the receiving database to create a receiving report (RR). Four copies of RR are printed from the database. The receiving clerk keeps PO3 and PS in a file. RR1 is sent to the Inventory Control department to update the inventory balances in the inventory database. RR1 is then filed in the Inventory Control Department. RR2 is sent to the Purchasing Department to be filed. RR3 is sent together with the inventory to the Warehouse. Finally, RR4 is sent to the Accounts Payable Department.

Accounts Payable Procedures

Earlier on, Accounts Payable Department received PO4 and RR4. Both documents are filed temporarily. When invoice arrived from the supplier, Accounts Payable clerk performs three-way match of PO4, RR4 and Supplier Invoice. After verifying the accuracy of invoice, the clerk keys in the invoice data into the Accounts Payable (AP) database to update purchase journal and AP subsidiary ledger. The three documents of PO4, RR4 and Supplier Invoice are filed. A journal voucher is printed and sent to the General Ledger Department.

REQUIRED:

  1. Prepare the following diagrams to represent the purchasing process at Feast E-Mart Sdn. Bhd.
  1. A context diagram.

  1. A logical data flow diagram.

(14.5 Marks)

  1. A system flowchart.

(32.5 Marks)

Solutions

Expert Solution


Related Solutions

QUESTION 1 (60 MARKS) Feast E-Mart Sdn. Bhd. is an online grocery store that offers home...
QUESTION 1 Feast E-Mart Sdn. Bhd. is an online grocery store that offers home delivery of groceries to customers around Changlun, Jitra, and Alor Setar. Feast E-Mart purchases their supplies of grocery products from suppliers in Kedah, Perlis and Penang. The shop is located at the new Kedah SME Industrial area beside the Kedah River. Installation of surveillance camera at entrance area is expected to be completed in two months. Due to a limited building space, a warehouse is built...
Question 2 Balances of accounts for GoodLuck Sdn Bhd on 1 June 2019 are as follows:...
Question 2 Balances of accounts for GoodLuck Sdn Bhd on 1 June 2019 are as follows: RM Cash in hand 36,800 Cash at bank 100,000 Inventory 24,500 Mortgage on premises 800,000 Van 125,000 Lucky Sdn Bhd 72,000 Buildling 900,000 Rainbow Berhad 61,670 Sunshine Supplies 24,700 Happy Trading 95,270 Capital 400,000 The following transactions took place in the month of June: Date Transactions 1 The business decided to add additional cash to the bank accounts amounted to RM300,000. 3 Purchased goods...
Question 1 Tap Sdn Bhd bought an asset on 5 April 2017 at a cost of...
Question 1 Tap Sdn Bhd bought an asset on 5 April 2017 at a cost of RM180,000. The asset had an expected useful life of 10 years and an expected residual value of RM20,000. The company applies straight-line depreciation to this category of non-current assets. It also charges a full year depreciation in the year of acquisition and no depreciation in the year of disposal. Its financial year ends on 31 December. At 31 December 2018, the company revalued the...
Question 3 (6 marks) On 21 June 20x1, the Large Mart store in Armidale ordered a...
Question 3 On 21 June 20x1, the Large Mart store in Armidale ordered a new company car for its customer service department (called the “Nerd Herd”) from a car dealer in Brisbane for $30,000. The car was delivered to Large Mart in Armidale on 28 June 20x1, and the delivery company left a delivery invoice of $500 when delivering the car. The invoices for the car and the delivery of the car were paid via bank transfer on 29 June...
Question 1 James Bond Sdn Bhd produces a type of toy which is sold for RM110...
Question 1 James Bond Sdn Bhd produces a type of toy which is sold for RM110 per unit. The normal annual production and sales for the toys are 1,600 units, although the company has the capacity to produce up to 2,000 units. The following data consist of costs incurred during the year ended 2016: RM Material (100% variable) 40,000 Labour (60% variable) 40,000 Variable selling expenses 12,800 Fixed selling expenses 25,000 Fixed administrative expenses 20,000 The management accountant of the...
Question 1 James Bond Sdn Bhd produces a type of toy which is sold for RM110...
Question 1 James Bond Sdn Bhd produces a type of toy which is sold for RM110 per unit. The normal annual production and sales for the toys are 1,600 units, although the company has the capacity to produce up to 2,000 units. The following data consist of costs incurred during the year ended 2016: RM Material (100% variable) 40,000 Labour (60% variable) 40,000 Variable selling expenses 12,800 Fixed selling expenses 25,000 Fixed administrative expenses 20,000 The management accountant of the...
Revision Qs Question 1 The following shows the unadjusted Trial Balance of Shahanom Logistics Sdn Bhd...
Revision Qs Question 1 The following shows the unadjusted Trial Balance of Shahanom Logistics Sdn Bhd during May 2018: Shahanom Logistics Sdn Bhd Unadjusted Trial Balance for month ended May 31, 2018 Account Title Balance Debit (RM) Credit (RM) Service Revenue        69,000 Salaries Expenses          30,000 Petrol Expenses            5,000 Rent Expenses          32,000 Cash in bank        451,000 Accounts Receivable          26,000 Office Supplies          14,000 Prepaid Electricity          15,000 Motor van        400,000 Accumulated Depreciation—Motor van           5,000 Accounts Payable           8,000 Unearned Revenue         64,000 Shahanom, Capital       867,000...
Question 4 (6 marks) On 1 July 20x1, Large Mart purchases a new building (and the...
Question 4 On 1 July 20x1, Large Mart purchases a new building (and the associated land) in Sydney. Large Mart paid $1,000,000 for the land and $800,000 for the building. Large Mart will use the building for 30 years, after which time the building will have a residual value of 50,000. Large Mart will depreciate this building, using the declining balance depreciation method, with a yearly depreciation percentage of 6.67%. On 1 July 20x3, Large Mart decides to revalue the...
QUESTION 1 (20 MARKS) Advance Energy Bhd (AEB) acquired a piece of land and a building...
QUESTION 1 Advance Energy Bhd (AEB) acquired a piece of land and a building on 1 January 2017 at the cost of RM6,000,000 and RM8,000,000 respectively. AEB decided that the acquisition of land is for long term capital appreciation. As for the building, it was planned to be rented out to its wholly subsidiary, Imperial Bhd. The fair value of land and building on 31 December 2017 was RM9,000,000 and RM6,000,000 respectively. On 31 August 2018, due to insufficient working...
Activity: Visit 2 physical and 1 online store(s) that have personal hygiene departments (e.g. grocery stores,...
Activity: Visit 2 physical and 1 online store(s) that have personal hygiene departments (e.g. grocery stores, pharmacies, and big box retailers, one online allowed). Compare the selections of incontinence products and the costs (regular and sale/coupon pricing). Bring your findings to class. Address both female and male products. Directions: Answer the following questions in paragraph form using APA formatting: If you were incontinent, which products would you use? Which stores did you research and where can you get the products...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT