Good Fortune Restaurant Supplies (GFRS) is owned by Anna Vuong, a graduate of UWS. GFRS has grown rapidly and has found that managing its Sales function is essential to providing excellent customer service and operating profitably. GFRS has asked you to design a database that will help it control its sale and cash collection operation. GFRS sells ingredients and supplies to several different restaurants, food and drink outlets, and processed food factory. Donna Hay is the account manager who looks after all sale-related activities. Paul Murray is the creditor manager who is responsible for assessing and approving customer credit applications. Anna Vuong is the accounts receivable manager who is responsible for cash collection and accounting function. All orders from customers are processed by account officer/manager, and approved by credit officer/manager. The cash payments are received by the accounts receivable officer/manager. Sale orders from customers are confirmed with a printed customer purchase order signed by customer’s purchasing agent. Normally, GFRS delivers shortly after orders are received and approved. A partial delivery of a sale order to a customer is acceptable.

When a delivery/shipment to customer is made, an invoice is prepared by one of the four account officers/manager and sent to the customer. A remittance advice is attached to the bottom of the invoice. Customers are required to tear off the remittance advice and sent it back with their payments. Anna has made an arrangement with each customer that a direct bank transfer is made by the customer per month to FRS’s bank account to cover all invoices issued for the previous month. This arrangement has reduced the chance of bad debt and internal control issues in relation to cash collection.

The business stores its sale and cash collection transactions on a worksheet. Anna claims that she has done her best to make sure the data on the worksheet is correct.

Required:

You are required to normalise the data on the unnormalised worksheet provided.