Extech Ltd's sales revenue budget for 2018 is $350,000. Extech Ltd manufactures tables and its production costs as a percentage of sales revenue are:
Raw materials 25%
Direct Labour 25%
Overheads 10%
Raw materials, which are added at the start of production, are carried in inventory for ten days and finished goods are held in inventory before sale for twenty days.
Work in progress is held at levels where products are assumed to be 50% complete in terms of labor and overheads.
The production cycle is five days and production takes place evenly through the year.
Extech Ltd receives 60 days credit from suppliers and grants 30 days credit to its customers.
Overheads are incurred evenly throughout the year.
(a) Determine Extech Ltd’s total working capital requirement
(b) Extech Ltd are owed $10,000 by a supplier who has just been declared bankrupt. The owner of Extech wants to sue the supplier’s auditors for the $10,000 as she had reviewed their audited accounts and understood that the business would continue for the foreseeable future. Discuss, with reference to the “performance gap” and the “expectations gap” what an auditor does and does not do, and whether the owner of Extech is correct in their understanding.
(a) Working Capital = Current Assets - Current Liabilities | ||||
% of Sales | Value | |||
Sales | $350,000 | |||
Raw Materials | 25% | $87,500 | ||
Direct Labor | 25% | $87,500 | ||
Overheads | 10% | $35,000 | ||
Raw Material Inventory is quantity for ten days of production | ||||
Given that production is even throughout the year | ||||
Computation of Raw Materials Inventory | ||||
Total value of Raw Materials consumed during the year | $87,500 | |||
Value of Raw materials consumed per day | $240 | |||
Value of Raw materials consumed in ten days | $2,400 | |||
Raw materials inventory levels | $2,400 | |||
Computation of Finished Goods Inventory | ||||
Total value of Finished Goods sold during the year | $350,000 | |||
Value of Finished goods sold per day | $959 | |||
Value of Finished goods sold for twenty days | $19,180 | |||
Finished goods inventory levels | $19,180 | |||
Computation of Work-in-progress Inventory | ||||
Since,production cycle is for five days, Work in progress includes | ||||
a. Five days of raw materials inventory | ||||
b. 50% of five days of direct labor cost | ||||
c. 50% of five days of overheads cost | ||||
Daily Cost | Days | % of Completion | Value | |
Inventory | $240 | 5 | 100% | $1,200 |
Direct Labor | $240 | 5 | 50% | $600 |
Overhead | $96 | 5 | 50% | $240 |
Work-in-progress inventory levels | $2,040 | |||
Computation of Accounts Receivables | ||||
Credit period allowed to customer(in days) | 30 | |||
Average daily sales | $959 | |||
Sales value for 30 days | $28,770 | |||
Average Accounts Receivables | $28,770 | |||
Computation of Accounts Payable | ||||
Credit period allowed by suppliers(in days) | 60 | |||
Average daily purchases | $246 | |||
Purchase value for 60 days | $14,760 | |||
Average Creditors | $14,760 | |||
Note - Purchase = Raw Materials Consumed + Raw Material Inventory | ||||
= $ 87,500 + $ 2,400 | ||||
= $ 89,900 | ||||
Average daily purchase = $ 89,900/365 | ||||
= $ 246 | ||||
Current Assets | ||||
Raw Material Inventory | $2,400 | |||
Work-in-progress Inventory | $2,040 | |||
Finished Goods Inventory | $19,180 | |||
Accounts Receivable | $28,770 | |||
Total Current Assets | $52,390 | |||
Current Liabilities | ||||
Accounts Payable | $14,760 | |||
Total Current Liabilities | $14,760 | |||
Working Capital = Current Assets - Current Liabilities | ||||
= $ 52,390 - $ 14,760 | ||||
Working capital requirement = $ 37,630 |
(b) | |||||
Expectation gap is the difference between the public perception of an auditor's | |||||
role and responsibilities regarding audits of financial statements and what the | |||||
auditor's legal responsibilities actually are. | |||||
Expectation gap may be categorized into | |||||
(i) Performance gap which signifies the difference between the level of work an | |||||
auditor is required to do by the auditing standards and what public believes they | |||||
ought to do. | |||||
(ii) Liability gap which signifies the mis-perception regarding the legal liability of the | |||||
auditor. | |||||
The auditing process has certain limitations.The auditor has to express his | |||||
opinion on the financial statements of the auditee on basis of the information he | |||||
gathers on the basis of the data made available to him.This data is collected in | |||||
form of samples ans these samples are a subset of transactions during the | |||||
financial year.The auditor does not tests the whole records and it is possible that | |||||
the sample tested does not truly represent the total financial data for the year. | |||||
Also,the evidences available to the auditor may not always be conclusive.The | |||||
auditor relies on his judgement if the evidence is persuasive. | |||||
It is for these reasons that the auditor expresses his opinions on the financial | |||||
statements and does not certify it. | |||||
Hence,the auditor would not be legally liable if the supplier is declared bankrupt | |||||
where he had expressed his opinion that the business of the supplier would | |||||
continue for forseable future,if he was satisfied with the evidence made available | |||||
to him and performed his audit tests with due diligence.This is irrespective of the | |||||
opinion of Extech Limited that it was the duty of the auditor to predict that the | |||||
said supplier would become bankrupt because the audit engagement does not | |||||
create any liability on the auditor to certify that the financial statements show the | |||||
exact and precise conditions of the company. |
Extech Ltd's sales revenue budget for 2018 is $350,000. Extech Ltd manufactures tables and its production...
XX Ltd is preparing its budget for 2019. The company has collected the following information from the managers, 1. Sales: Sales for November 2018 Sales for December 2018 Expected sales for January 2019 Expected sales for February 2019 Expected sales for March 2019 Expected sales for April 2019 Expected sales for May 2019 Selling price per unit 112,500 102,100 113,000 112,500 116,000 125,000 137,500 $12 units units units units units units units The company likes to keep 15% of next...
Grant Ltd Grant Ltd operates at capacity and makes glass-topped dining tables. At the end of 2018, Grant Ltd.’s management accountant gathered the following data to prepare budgets for the first six months 2019: Units sales per quarter and the selling price per unit are estimated as follows: Unit sales Price per unit January 2,500 $450 February 2,800 $450 March 2,750 $480 April 2,750 $480 May 2,800 $500 June 2,800 $500 July 3,000 $500 August 3,000 $500 Sales on November...
create the initial documents for the master budget:
• sales budget
• production budget
• direct materials purchases budget
• direct labor budget
• overhead budget
• selling and administrative expense budget
• cash budget include a schedule of cash collections and
payments
• finished goods inventory calculation
Then, Create the following schedules, financial statements, and
calculations
A) Pro forma cost of goods manufactured
B) Pro forma Cost of goods sold- both financial and variable
cost basis
C) Pro forma...
Master Budget Case: ToyWorks Ltd.
ToyWorks Ltd. is a company that manufactures and sells a single
product, which they call a toodle. For planning and control
purposes they utilize a quarterly master budget, which is
usually developed at least six months in advance of the budget
period. Their fiscal year end is December 31.
During the summer of 2018, Chris Leigh, the ToyWorks controller,
spent considerable time with Pat Frazer, the Manager of Marketing,
putting together a sales forecast for...
SECTION A (40 marks): Answer ALL Questions in this section. QUESTION ONE a) Aseda Ltd incurred the following cost in its manufacturing operations GH¢ Cost of material purchase 20,000 Import duties 400 Trade discount @10% of purchase cost Cash discount 500 Irrecoverable taxes 1,000 Salary of factory plant operator 2,500 Direct labour 5,000 Salary of factory supervisor 4,000 Cost of expected production losses 800 Administrative overhead (Note) 16,000 Cost of storage of raw material for further processing 2,000 Marketing cost...
Please show the formulas.
Unique Sinks Master Budget Unique Sinks is a family-owned manufacturing business specializing in sinks; it does not produce any of the faucets or plumbing needed for installation. The company focuses on the new housing market, which has been quite strong for over ten years. Unique Sinks' core competencies include a relatively low- cost but high-quality manufacturing process for sinks. During the last several years, demand for large houses with three to four bathrooms was strong. And...
LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with the following two risks: 1. The risk that that the client might be making duplicate payments to vendors. 2. The risk that the client's accounting clerk might be making unauthorized payments to himself. a. Assuming that the client has a manual accounting system, describe how the auditors can design a test to identify the duplicate payments and unauthorized payments. b. Assuming that the client...
Case Study Analysis: Fred Stern & Company, Inc. (Knapp): In the business world of the Roaring Twenties, the schemes and scams of flimflam artists and confidence men were legendary. The absence of a strong regulatory system at the federal level to police the securities markets—the Securities and Exchange Commission was not established until 1934—aided, if not encouraged, financial frauds of all types. In all likelihood, the majority of individuals involved in business during the 1920s were scrupulously honest. Nevertheless, the...