Normalise a spreadsheet of data into tables

Assignment Help Financial Accounting

Reference no: EM133000658

Normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Introduction

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.

Attachment:- SID.rar

Reference no: EM133000658

Questions Cloud

How much was Celtics net cash flow from investing activities : Cash payments to banks for repayment of money borrowed totaled $9,700. How much was Celtics' net cash flow from investing activities

How much of the expenses is allocated : Under the IRS method, how much of the $16,000 in Tier 3 expenses (depreciation) is allocated above the line

How do calculate the minimum number of units of silpol : What is the expected operating income? Calculate the minimum number of units of SilPol that would have to be sold in order to justify further processing of GR37

What the company ending equity is : What the company's ending equity is? Darden has beginning equity of 277000 total revenues of 63000 and total expenses of 25000.

Normalise a spreadsheet of data into tables : Normalise a spreadsheet of data into tables in the third normal form in order to eliminate data anomalies.

Discuss whether the classification of a financial instrument : Discuss whether the classification of a financial instrument as a debt or equity under IAS 32 is relevant to investors in making economic decisions

Which the two ratios most commonly used by mortgage lender : Which the two ratios most commonly used by mortgage lenders to evaluate the ability to pay mortgage loan are the? Current ratio and mortgage debt service ratio.

Which will be the increase in the price of bond a : The price of the bond will fall by $0.42. If the yield goes down by 1 basis point, which of the following will be the increase in the price of Bond A

What amount of gain or loss should be recognized in loss : What is the interest expense for the year ended December 31, 2021? CHIA-SEED Company issued 7,000 of 15% ?1,000 bonds at 95.

User Account

All Pages