Question

In: Accounting

Masters Ltd has just realised that it has a problem with sales data as its sales...

Masters Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. a) What decisions made during the revenue cycle would be affected by this data problem? How can the problem be corrected? __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ b) How would this data problem affect the performance of the revenue cycle? __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ Question 3 continued next page Practice Questions Accounting Systems and Information Assurance - ACCT20072 Page 5 of 7 Question 3 continued Griffith Ltd has just realised that it has a timeliness problem with its general ledger data. It updates daily transactional data from subsidiary systems to the general ledger weekly; however, general ledger reports are available on an unrestricted basis. The CFO recently realised that some users do not know that they need to wait until after the Sunday night update to run their month-end reports. c) What decisions made during the general ledger and financial reporting cycle would potentially be affected by this data problem? ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ ________________________________________________________________ d) How would this data problem affect the reported results of the organisation?

Solutions

Expert Solution

A) Credit sales should be approved before the order is processed any further.

This problem can be corrected by :-

- Automatic checking of credit limits and balances by improving the IT system.

- Emails to credit manager for accounts needing specific authorization.

B)The revenue cycle will get disturb because without having checks on the credit limits, the management will not be able to find the persons who have inability to pay.

C) Griffith needs to determine which time zone they are operating in and gear their posting and reporting cycles globally around that time zone only. If the mismatch takes place in the management reports then internal decision making could be flawed.

If the timing mismatch occured in financial reports then Griffith may find that they are in breach of corporate reporting requirements with potentially serious implications.

D) Other process may not be directly affected in terms of their operational activities however decision making relating to budgets and foercasts may be on inaccurate data which would flow through to create issues for other processes.


Related Solutions

After being in business for 3 years, Franco Ltd. realised that its warehouse facility was inadequate....
After being in business for 3 years, Franco Ltd. realised that its warehouse facility was inadequate. The company decided to construct a new building to expand its warehouse capabilities. To finance this venture, Franco Ltd. acquired a loan of $2,000,000 on January 1, 2018, with an interest rate of 10% payable annually. Construction on the new building started on January 1, 2018 with a projected completion date of December 31, 2018. During the year, the company’s expenditure schedule for the...
SPU, Ltd., has just received its sales expense report for January, which follows. Item Amount Sales...
SPU, Ltd., has just received its sales expense report for January, which follows. Item Amount Sales commissions $ 440,500 Sales staff salaries 88,400 Telephone and mailing 49,000 Building lease payment 60,000 Utilities 22,100 Packaging and delivery 83,000 Depreciation 37,750 Marketing consultants 60,190 You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional...
ABC Ltd., has been facing cash shortage problem for many years. You have just joined the...
ABC Ltd., has been facing cash shortage problem for many years. You have just joined the company and made the proposal to prepare cash budget for controlling of cash shortage problem. Management has given you the green signal to prepare the cash budget and made the projection for requirement of cash through commercial bank channel in the coming period. The following information were gathered for preparing the cash budget. Sales budgets November, 2019…………………………. Rs.200,000 December, 2019……………………………    300,000 January, 2020……………………………..     400,000...
Part A: Ranier Ltd. has just completed its first year of operations on December 31, 20X1....
Part A: Ranier Ltd. has just completed its first year of operations on December 31, 20X1. Net income for the year was $570. During the year, equipment costing $800 was purchased when the company paid cash of $640 and issued common shares worth $160. Near the end of the year, equipment costing $60 with accumulated depreciation of $16 was sold for $54. At the end of the year, accounts receivable was $250, accounts payable was $36 and accumulated depreciation was...
Part A: Ranier Ltd. has just completed its first year of operations on December 31, 20X1....
Part A: Ranier Ltd. has just completed its first year of operations on December 31, 20X1. Net income for the year was $570. During the year, equipment costing $800 was purchased when the company paid cash of $640 and issued common shares worth $160. Near the end of the year, equipment costing $60 with accumulated depreciation of $16 was sold for $54. At the end of the year, accounts receivable was $250, accounts payable was $36 and accumulated depreciation was...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows:Sales in Units  April72,000  May85,000  June112,000  July91,000The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s sales. The inventory at the end of March was 14,400 units.Required:Prepare a production budget for the second quarter; in your budget, show the number of units to be...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Sales in Units   April 64,000   May 80,000   June 104,000   July 87,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 15% of the following month’s sales. The inventory at the end of March was 9,600 units. Required: Prepare a production budget for the...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next...
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 78,000 May 85,000 June 118,000 July 94,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s unit sales. The inventory at the end of March was 15,600 units. Required: Prepare a production budget by month...
1. Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the...
1. Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 60,000 May 80,000 June 100,000 July 85,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s unit sales. The inventory at the end of March was 12,000 units. Required: Prepare a production budget by...
Bello Plc has just released its financial results for 2018. It achieved sales of £200m, and...
Bello Plc has just released its financial results for 2018. It achieved sales of £200m, and forecast that these were expected to grow at 8% per year. Bello Plc currently has cash on deposit of £32m, debt of £12m and has issued 15m shares. It is taxed at a rate of 25%. You are provided with the following estimates: EBIT is 7% of sales Increases in both net investment and in net working capital will be 8% of any increase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT