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

Project Sales for Fourth Quarter

Item Quantity Unit Price

Product X 4,500 $12

Product Y 2,000 25

Product Z 3,000 20

Inventories in Units

Item Beginning Desired Ending

Product X 600 900

Product Y 500 400

Product Z 400 500

Product A 2,000 2,500

Product B 1,500 2,000

Product C 2,500 2,000

Materials Production Requirements for Each Unit of Product

Item Units of Units Units of

Material B Material B Material C

Product X 3 1 2

Product Y 2 2 4

Product Z 1 3 2

There is no beginning or ending inventory of work in process. Budgeted unit costs for materials A, B, and C are $0.50, $2.00, and $1.50, respectively.

Required:

1. Prepare a sales budget that includes quantities and revenue for each of the three products.
2. Prepare a production budget for all three products.
3. Prepare a materials usage budget.
4. Prepare a materials purchases budget.