Furniture Island manufactures customised dining tables and is in the process of preparing its budgets for the
Question:
Furniture Island manufactures customised dining tables and is in the process of preparing its budgets for the next quarter (April, May and June). To date the following budgeted information has been compiled for one of its popular products 'Mode: Mode Budgeted sales (units) April May June July 3,000 5,500 3,500 4,000 Budgeted selling price per unit: 180 80% of sales are on credit. Credit terms are strictly 30 days. 1% of all sales will result in bad debt. Trade receivables outstanding at 31 March were £65,000 (which are all collectable in April) The standard material usage for one unit of Mode is as follows: Material X (kilogrammes) Mode 3 kg Material planner has provided the following information: Material X Mode 1.000 kg 1,200 units 1.800 kg x Opening inventory April) Closing inventory June Purchase price (per kilogramme) 2.50 x [Page 8 of 10 All purchases are paid in the same month to the supplier Management have decided closing stock at the end of each month should be as follows: d) Critically explain the benefits and limitations of traditional budgeting systems. Suggested word count permitted is 400. Where appropriate include the bibliography at the end of this question, bibliography is not included in the word count. (10 marks) Raw materials: Finished goods: 10% of the next month's usage 10% of the next month's sales. (Total marks = 35 marks) Overheads Fixed overheads are estimated at £5,000 per month and are paid in the month they were incurred. £1,500 of this amount relates to depreciation END OF EXAM PAPER Insurance of £12,500 is due to be paid in April. Capital Expenditure April: Computer May Delivery van Additional Delivery van £148,000 £200,000 £230,000 June Corporation Tax of £35,900 is due to be paid in May The opening bank balance is £43,500 overdrawn.
Required:
a) Prepare the following budgets for April, May and June: () Sales Budget (3 marks) ()Production Budget in units (3 marks) (ii) Materials Purchases Budget (6 marks)
b) Prepare the Cash Budget for the 3 months period. (9 marks)
c) Recommend to the management of Furniture Island at least three ways of improving their cash position.
Using Financial Accounting Information The Alternative to Debits and Credits
ISBN: 978-1133161646
7th Edition
Authors: Gary A. Porter, Curtis L. Norton