Question

In: Accounting

Value Products Ltd manufactures a single product. You are the management accountant responsible for preparing the...

Value Products Ltd manufactures a single product. You are the management accountant
responsible for preparing the quarterly budgets of the next quarter from July to September 2020.
Your colleague, the financial accountant, has provided you the following extracted data from
the balance sheet as at 30 June 2020:
Assets Liabilities
Accounts Receivable $250,000 Bank Overdraft $90,000
Plant and Machinery $800,000 (Cost) Dividend Payable $10,000
Long-term Loan 15% $400,000
The following transactions are expected during the next three months:
Sales Purchases Expenses
January $1,500,000 $1,000,000 $200,000
February 2,000,000 1,500,000 250,000
March 3,000,000 2,800,000 300,000
All sales are on credit and the collections have the following pattern:
During the month of sale: 80% (early payment discount of 4% is given)
In the subsequent month: 20% (no discount)
Payments for purchase are made in the month of purchase enjoying a 10% early payment
discount.
Expenses shown above include depreciation of machinery which is calculated at a rate of 12%
per annum on cost. Expenses are paid for in the month in which they are incurred.
The dividend payable will be paid in July.
Loan interest for the three months will be paid in September.
Required:
(a) Prepare a Cash Budget for each of the three months from July to September 2020.

(b) Prepare a Budgeted Income Statement for the period from July to September 2020.

Solutions

Expert Solution


Related Solutions

As a cost accountant of a company that manufactures a single product, would you advise your...
As a cost accountant of a company that manufactures a single product, would you advise your company to adopt an ABC system? Why or why not? Explain. .
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018. Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment. The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018.  Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment.  The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
Cintra is the Management Accountant of Fine pens Ltd. The company manufactures various types of pens...
Cintra is the Management Accountant of Fine pens Ltd. The company manufactures various types of pens ranging from cheap disposable units to expensive units which are intended to be reusable. Both ball point pens and fountain pens are produced. The current cost allocation system in use is Absorption costing.and Cintra is very comfortable with the use and application of this costing method. Ram has recently joined the company in a senior capacity. Both Cintra and Ram were recently discussing the...
ToyWorks Ltd. is a company that manufactures and sells a single product, which they call a...
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 monthly master budget, which is usually developed at least six months in advance of the budget year. Their fiscal year end is June 30. During the summer of 2019, Chris Leigh, the ToyWorks controller, spent considerable time with Pat Frazer, the Manager of Marketing, putting together a sales forecast for the next budget year (July...
Question 1 Kearsley Ltd manufactures a single product, a laminated product used in kitchen surfaces. The...
Question 1 Kearsley Ltd manufactures a single product, a laminated product used in kitchen surfaces. The standard cost is £118 and is made up as follows:                                                                                                      £ Direct materials             8 sq. metres at £5 per square metre       40.00 Direct labour                 6 hours at £5 per hour                           30.00 Variable overheads       6 hours at £3 per hour                           18.00 Fixed overheads           6 hours at £5 per hour                           30.00                                                                                                 118.00 The standard selling price of the product is £150....
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning...
Empire Ltd. is a company that manufactures and sells a single product called WarStars. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is March 31. The sales forecast consisted of these few lines: • For the year ended March 31, 2020: 620,000 units at $15.00 each* • For the year ended March 31, 2021: 640,000 units at $16.50 each • For the year ended...
Suppose that you are working for Amenia Ltd. as a junior management accountant. The previous accounting...
Suppose that you are working for Amenia Ltd. as a junior management accountant. The previous accounting staff has collected the following data for the company’s last year of operations: Sales volume (units) 150,000 Sales revenue: $2,400,000 Direct materials: $578,000 Direct labour: $415,000 Manufacturing overhead*: $540,000 Selling expenses**: $360,000 Administrative expenses***: $420,000 Note that: *70 variable and 30% fixed **40% variable and 60% fixed ***20% variable and 80% fixed The managing director has asked that you undertake a cost-volume-profit (CVP) analysis...
Banksy Ltd manufactures two products, the first product is a bag with a specific print on...
Banksy Ltd manufactures two products, the first product is a bag with a specific print on them and the second product is a series of postcards (sold in a pack of 10) with the same print on them. Information regarding the costs associated with both the bags and postcards is below: Bags: has a selling price of $30, and variable costs of $12 per unit. The bags need to be put through the printing machine once sewn and require 1.5...
Please assist with the question below. Teddy Ltd manufactures and sells a single product. The organisation...
Please assist with the question below. Teddy Ltd manufactures and sells a single product. The organisation uses a fully integrated absorption costing system for both internal and external reporting purposes. The comparative monthly results for the most recent two months (February and March 2019) have just been tabled at a meeting. The sales director says, our break-even point is 15 128 units. In February, we sold above our break-even point and made loss, and in March we sold below break-even...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT