SUBJECT: ACCOUNTING INFORMATION SYSTEM

I NEED YOU TO PREPARE AS SMAE AS THE EXAMPLE AND DO IT IN WORD FILE, I ONLY HAVE 1 DAY TO PREPARE PLEASE HELP.

Sales Order

To understand this procedure, your team first met with Azlina, the sales officer. She first explained the nature of SESB sales operation. The sales are made to the resellers that have registered with SESB. Each reseller receives a pre-numbered purchase order booklet from SESB office upon its registration. Periodically, the reseller completes the purchase order form for reordering purpose. The reseller specifies the description of the ordered products and the quantity, respectively. The purchase order form is faxed/e-mailed to SESBs head office for processing. The reseller may also bring the purchase order form directly to the head office for ordering purpose.

Your team further asked about the process of handling the customers order. The following description was provided by Azlina:

As a sales officer, she is responsible to review and to approve the order made by a reseller. Upon receiving the pre-printed purchase order copy from the reseller, she then checks the resellers account status by referring to the customers weekly report file. The accounts unit prepares the customer accounts summary report weekly for the sales officer reference. Based on the customers account record, she approves the resellers order and transfers the order details into

the sales order form (prepared in duplicate carbon copies). She then forwards the original sales order copy to a store executive. Meanwhile, the second sales order copy is filed together with the pre-printed purchase order by the resellers name. In case of the customer exceeds its credit limit, Azlina remarks the customers order as on hold and files the customers purchase order copy into Pending Customers Order file. She then notifies the customer to clear the pending payment before the order being processed.

Your team then met Selamat, the store executive who is responsible for managing inventory and delivery related tasks. As he mentioned, he has two operation employees to help him in his unit. As your team observed, the storeroom area is securely locked and only accessible by the authorised employees. You also noticed that the 2,000 square feet storage area is also equipped with the fire extinguishers and smoke detectors.

When requested to elaborate further on his responsibilities, he described as follows:

Upon receiving the resellers sales order details, he first checks the inventory card for the current inventory balances. If all the ordered products are available, he then requests the operation employee to pick up the ordered goods from the store shelves based on the verified sales order copy. He then instructs the operation employee to complete a duplicate copy of the delivery note by specifying the sales order details and the delivery agent. The employee also attaches the sales order copy to the packaging. The packed order is kept in the collection area while waiting for the delivery.

Selamats description of the existing delivery procedures are summarised as below: The appointed delivery agent comes to the head office three times a week to collect the packed goods and deliver to the respective reseller. The agent picks up the packed inventories from the operation employee and signs on the delivery note prepared earlier. While the delivery agent retains the second copy of the delivery notes, the operation employee provides the original copy of an annotated delivery note to Selamat for recording purpose. He is responsible to update the respective inventory cards based on the number of units delivered. He then signs the completed delivery note and forwards it to the account officer.

REQUIRED: Question (a) refers to (i) Sales Order and (ii) Cash Receipt procedures (a) Using suitable software, prepare the following documentation for of SESB Sdn Bhd:

1. (i) a table of entities and activities,

2. (ii) a context diagram,

3. 

USE THIS AS EXAMPLE OF ENTITIES AND ACTIVITIES KAS2013 Accounting Information Systems (A192) (a) Table of entities and activities Pro Entity Secretary (Internal) Secretary Secretary Secretary Secretary Cashier (internal) Xtut 6-13 Cashier Cashier Bank (External) Cashier Cashier Cashier paragraph Activities 1 1 Receives mail containing cheque and remittance advice from customer 1 2) Compares the amount stated on the cheque and the remittance advice 1 3) Completes a cheque receipt listing in duplicate copies 1 4) Sends the first copy of the cheque receipt listing and cheques (in batch) to cashier 1 5) Sends copy of the cheque receipt listing together with the remittance advices (in batch) to the accounts receivable department 2 6) Calculates to ensure total of the cheque Prore amount agrees with cheque receipt listing 2 7) " Prepares duplicate copies of deposit slips 2 8) Send the cheques and deposit slips to bank for deposit 3 9) Returns validated slip to Cashier 3 P10) Update cash receipt journal 3 "11) Prepares a cash receipt summary 3 12) Files validated deposit slip and cheque a receipt listing (chronological order) 3 13) Forwards the cash receipt summary to general ledger department 4 14) Updates accounts receivable subsidiary ledger a ways flow), 3 arrows lways 4 15) Prepares accounts receivable summary v 16) Forwards accounts receivable summary to general ledger department process 4 17) Files cheque receipt listing and fiving som Isbb 18 adal remittance advice by customer number delay 5 18) Prepares a customer's monthly statemen on time and accounts receivable aging report 5 19) Mails monthly statement to the respective customer 5 20) Forwards aging report to financial controller Cashier Accounts Receivable (internal) vt - 26 Accounts Receivable Accounts Receivable a seperates & Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable external Bank GL dept, customer, fin.Controllen secretary, cashier, Acc Receivable DFD not showing & filing parts just storage interno doin 1 no 1.317 USE THIS AS EXAMPLE OF ENTITIES AND ACTIVITIES KAS2013 Accounting Information Systems (A192) (a) Table of entities and activities Pro Entity Secretary (Internal) Secretary Secretary Secretary Secretary Cashier (internal) Xtut 6-13 Cashier Cashier Bank (External) Cashier Cashier Cashier paragraph Activities 1 1 Receives mail containing cheque and remittance advice from customer 1 2) Compares the amount stated on the cheque and the remittance advice 1 3) Completes a cheque receipt listing in duplicate copies 1 4) Sends the first copy of the cheque receipt listing and cheques (in batch) to cashier 1 5) Sends copy of the cheque receipt listing together with the remittance advices (in batch) to the accounts receivable department 2 6) Calculates to ensure total of the cheque Prore amount agrees with cheque receipt listing 2 7) " Prepares duplicate copies of deposit slips 2 8) Send the cheques and deposit slips to bank for deposit 3 9) Returns validated slip to Cashier 3 P10) Update cash receipt journal 3 "11) Prepares a cash receipt summary 3 12) Files validated deposit slip and cheque a receipt listing (chronological order) 3 13) Forwards the cash receipt summary to general ledger department 4 14) Updates accounts receivable subsidiary ledger a ways flow), 3 arrows lways 4 15) Prepares accounts receivable summary v 16) Forwards accounts receivable summary to general ledger department process 4 17) Files cheque receipt listing and fiving som Isbb 18 adal remittance advice by customer number delay 5 18) Prepares a customer's monthly statemen on time and accounts receivable aging report 5 19) Mails monthly statement to the respective customer 5 20) Forwards aging report to financial controller Cashier Accounts Receivable (internal) vt - 26 Accounts Receivable Accounts Receivable a seperates & Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable external Bank GL dept, customer, fin.Controllen secretary, cashier, Acc Receivable DFD not showing & filing parts just storage interno doin 1 no 1.317