Question

In: Accounting

Question 3 - Week 6 (11 marks) A new company, is being established to manufacture and...

Question 3 - Week 6
A new company, is being established to manufacture and sell an electronic tracking device: the Trackit. The owners are excited about the future profits that the business will generate. They have forecast that sales will grow to 2,600 Trackits per month within five months and will be at that level for the remainder of the first year.
The owners will invest a total of $250,000 in cash on the first day of operations (that is the first day of July). They will also transfer non-current assets into the company.
Extracts from the company’s business plan are shown below.
Sales
The forecast sales for the first five months are:
Month Trackits (units)
July 1,000
August 1,500
September 2,000
October 2,400
November 2,600
The selling price has been set at $140 per Trackit.
Sales receipts
Sales will be mainly through large retail outlets. The pattern for the receipt of payment is expected to be as follows:
Time of payment % of sales value
Immediately 15 *
One month later 25
Two months later 40
Three months later 15
The balance represents anticipated bad debts.
* A 4% discount will be given for immediate payment
Production
The budget production volumes in units are:
July August September October
1,450 1,650 2,120 2,460
5
Variable production cost
The budgeted variable production cost is $90 per unit, comprising:
$
Direct materials 60
Direct labour 10
Variable production overheads 20
Total variable cost 90
Direct materials: Payment for purchases will be made in the month following receipt of materials. There will be no opening inventory of materials in July. It will be company policy to hold inventory at the end of each month equal to 20% of the following month’s production requirements.
Direct labour will be paid in the month in which the production occurs.
Variable production overheads: 65% will be paid in the month in which production occurs and the remainder will be paid one month later.
Fixed overhead costs
Fixed overheads are estimated at $840,000 per annum and are expected to be incurred in equal amounts each month. 60% of the fixed overhead costs will be paid in the month in which they are incurred and 15% in the following month. The balance represents depreciation of noncurrent assets.
Required:
a) Prepare a cash receipts budget schedule for each of the first three months
(July – September), including the total receipts per month.
b) Prepare a material purchases budget schedule for each of the first three
months (July – September), including the total purchases per month.
c) Prepare a cash budget for the month of July. Include the owners’ cash
contributions

Solutions

Expert Solution


Related Solutions

Question 3 - Week 6 (11 marks) A new company, is being established to manufacture and...
Question 3 - Week 6 A new company, is being established to manufacture and sell an electronic tracking device: the Trackit. The owners are excited about the future profits that the business will generate. They have forecast that sales will grow to 2,600 Trackits per month within five months and will be at that level for the remainder of the first year. The owners will invest a total of $250,000 in cash on the first day of operations (that is...
Question 6 (11 marks) (Note this question is from the Week 11 Tutorial) There are four...
Question 6 (Note this question is from the Week 11 Tutorial) There are four (4) main transmission channels that can be used as monetary policy to target the official interest rate. Identify each of the four (4) transmission channels and explain, within the context of monetary policy, the impact each channel has on economic activity. (11 marks. Word limit Maximum 500 words)
Question 6 (11 marks) (Note this question is from the Week 11 Tutorial) Required: A. Identify...
Question 6 (Note this question is from the Week 11 Tutorial) Required: A. Identify the four (4) key terms in Insurance Law. B. Briefly explain what indemnity means in Insurance Law. C. Briefly explain what the ‘doctrine of subrogation’ means and discuss its effect on the parties to an insurance contract. (Word limit: Minimum of 200 words. Maximum of 300 words)
Question 2 (11 marks) (This question is from the Week 3 and Week 4 Tutorials) Sally...
Question 2 (This question is from the Week 3 and Week 4 Tutorials) Sally has $50 000. She wants to save $120 000 to deposit for her first home loan. She decided to put that $50 000 in an investment fund that pays an interest rate of 11% per annum (per year), compounding annually. Required: a. How long does she need to wait until she has saved $120 000? b. If Sally wishes to have that $120 000 in five...
A new company is being established to manufacture and sell an electronic tracking device: the Trackit....
A new company is being established to manufacture and sell an electronic tracking device: the Trackit. The owners are excited about the future profits that the business will generate. They have forecast that sales will grow to 2,600 Trackits per month within five months and will be at that level for the remainder of the first year. The owners will invest a total of $250,000 in cash on the first day of operations (that is the first day of July)....
A new company, is being established to manufacture and sell an electronic tracking device: the Trackit....
A new company, is being established to manufacture and sell an electronic tracking device: the Trackit. The owners are excited about the future profits that the business will generate. They have forecast that sales will grow to 2,600 Trackits per month within five months and will be at that level for the remainder of the first year. The owners will invest a total of $250,000 in cash on the first day of operations (that is the first day of July)....
Question 6 (7 marks) (This question is from the Week 11 Tutorial) The following data available...
Question 6 (This question is from the Week 11 Tutorial) The following data available for ABC company. Account Beginning balance Ending Balance Use/source of cash Accounts payable 20,300 24,400 Inventory 60,600 67,200 Long term debts 127,500 125,800 Common stock 200,400 215,900 Required: a) Calculate and identify the source of cash or the use of cash for each account change by filling into the column next to the ending balance. b) Assume that beginning balance of accounts receivable is $23 400...
Question 6 (7 marks) [Note this question is from the Week 11 Tutorial] Mr Peter is...
Question 6 [Note this question is from the Week 11 Tutorial] Mr Peter is working as a Purchases Journal clerk in a small firm located on the Gold Coast. David is his friend, who works as an Accounts Payable Ledger clerk in the same firm. Peter periodically enters fictitious acquisitions. After creating a fictitious purchase, Peter notifies his Accounts Payable Ledger clerk. David enters these transactions in his ledger. When the payables are processed, the payment is mailed to the...
Question 6 (11 marks) (Note this question is from the Week 12 Tutorial) The following information...
Question 6 (Note this question is from the Week 12 Tutorial) The following information relates to Moon Light Ltd. (a) At the beginning of the accounting period the company has a salary payable liability of $200 and at the reporting date a salary payable of $360. During the year the salary expense shown in the income statement was $400. (b) At the beginning of the accounting period the company has property, plant and equipment (PPE) with a carrying amount of...
Question 6 - Week 11 (11 marks) Consider each of the following independent situations which have...
Question 6 - Week 11 Consider each of the following independent situations which have come to your attention. In each of the following independent and material situations assume that the client is a reporting entity and that a general-purpose financial report has been prepared and audited: Event 1: Part of Steel Limited's operations are in South America. Recent changes of government have made it impossible for you to verify the key accounts of inventory, fixed assets and cash and related...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT