Required to normalise the data on the unnormalised worksheet

Assignment Help Financial Accounting
Reference no: EM132987228

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:

Problem 1: You are required to normalise the data on the unnormalised worksheet provided

Reference no: EM132987228

Questions Cloud

Compute the total value of the ninty-two bonds : Compute the total value of the 92 bonds. The Florida Investment Fund buys 92 bonds of the Gator Corporation through a broker.
Statistical process control in quality system : Discuss the integration of acceptance sampling with statistical process control in a quality system. What is meant by the term "statistically valid?"
What is return rate that bond investors are seeking : The United States treasury bond rate is 2.75% and Jones's beta is 0.90. Jones's tax rate is 25%. What is return rate that bond investors are seeking form Jones?
Explain the three general types of error : describe and explain the three general types of error that can occur in problem-solving. Give examples.
Required to normalise the data on the unnormalised worksheet : Good Fortune Restaurant Supplies (GFRS) is owned by Anna Vuong, Required to normalise the data on the unnormalised worksheet provided
Manufacturers and end-customers : Analyze the relationship between manufacturers and end-customers.
What would be the value of the zero-coupon rate bond : What would be the value of the zero-coupon rate bond? (Assume annual compounding. Do not round intermediate calculations and round your answer)
What is the effective yield to maturity : What is the effective yield to maturity? Assume a zero-coupon bond that sells for $383 and will mature in 20 years at $2,150. Use Appendix B
Establishing sustainable supply chain operation : Discuss the difficulty of establishing a sustainable supply chain operation while trying to maintain a balanced triple bottom line.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd