Please  make the production budget in units and materials purchases budget

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Please  make the production budget in units and materials purchases budget 

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:
Raw materials:
Finished goods:
10% of the next month's usage
10% of the next month's sales.
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.
Insurance of £12,500 is due to be paid in April.
Capital Expenditure
April:
May:
June:
Computer
Delivery van
Additional Delivery van
£148,000
£280,000
£230,000
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:
Transcribed Image Text: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: Raw materials: Finished goods: 10% of the next month's usage 10% of the next month's sales. 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. Insurance of £12,500 is due to be paid in April. Capital Expenditure April: May: June: Computer Delivery van Additional Delivery van £148,000 £280,000 £230,000 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:
3. 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)
Аpril
May
3,000
5,500
3,500
June
July
4,000
Budgeted selling price per unit:
£80
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:
Mode
Material X (kilogrammes)
3 kg
Material planner has provided the following information:
Material X Mode
1,000 kg
Opening inventory
(April)
Closing inventory
(June)
Purchase price (per £2.50
kilogramme)
1,200 units
1,800 kg
Transcribed Image Text:3. 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) Аpril May 3,000 5,500 3,500 June July 4,000 Budgeted selling price per unit: £80 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: Mode Material X (kilogrammes) 3 kg Material planner has provided the following information: Material X Mode 1,000 kg Opening inventory (April) Closing inventory (June) Purchase price (per £2.50 kilogramme) 1,200 units 1,800 kg
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education