The Wilton Company manufactures and sells three products: X, Y and Z. In September, 20A the company budget department gathered the following forecast data for operations of the coming year.

Item Product x Product y Product z

Item Product x Product y Product z Product A Product B Product C

Item Product x Product y Product z

Projected sales for fourth quarter

Quantity Unit price 4500 12

2000 25

3000 20

Inventories in units

Beginning Desired ending 600 900

500 400

400 500

2000 2500 1500 2000 2500 2000

Material production requirement for each unit of product

Unit of material A 3

2 3

Unit of material B 2

2

3

Unit of material C 2

4

2

There is no beginning or ending inventory of work in process. Budgeted cost material A, B, C, are 0 1.50, 2 and 1 respectively.

Required

1. Prepare a sales budget that includes quantities and revenue for each of three products.

2. Prepare a production budget for all three products.

3. Prepare a material usage budget.

4. Prepare a material purchase budget.

Home Tools Cost Accounting POMKTG Final & 2 0 Question 3: The Wilton Company manufactures and sells three products: X, Y and Z. In September, 20A the company budget department gathered the following forecast data for operations of the coming year. Projected sales for fourth quarter Item Quantity Unit price Product 4500 12 2000 25 Product y 3000 20 Product z Inventories in units Item Products Product y Product Product A Product B Product Beginning 600 500 100 2000 1500 2.500 Desired ending 900 100 500 2500 2000 2000 Material production requirement for each unit of product Item Products Product y Product z Unit of material A 3 2 3 Unit of material B 2 2 3 Unit of material 2 1 2 There is no beginning or ending inventory of work in process. Budgeted cost material A, B, C, are 0 1.50. 2 and 1 respectively Required 10 marks 1. Prepare a sales budget that includes quantities and reveme for each of three products 2. Prepare a production budget for all three products, 3. Prepare a material usage budget. 4. Prepare a material purchase budget