Reference no: EM132548971

Question - The following information pertains to the XYZ Manufacturing Company for the months April through July of 2012.

Planned sales in units for April, May, June, and July are 1,200, 1,500, 1,650, and 1,750 units respectively.

Unit sales price for April, May, June, and July is respectively Birr 120, 135, 140, and 130.

Desired ending inventory is 10 percent of the next month's sales.

Beginning inventory is the same as the previous month's ending inventory.

Ending inventory of March 31,2012 is 160 units

Material needs per unit are 6 pounds in each month.

Desired ending inventory of materials is 10 percent of the next month's units needed for production.

Beginning inventory of materials is the same as the prior month's ending inventory.

Ending inventory of materials of March 31, 2012 is 400 units

Unit price of materials is Birr 25 in each month.

Direct labor hours per unit are 8 in each month.

Direct labor cost per hour is Birr 30 in each month.

Required - Based on the above information, PREPARE the following budgets for the quarter ending June 30, 2012:

a) Sales budget

b) Production Budget

c) Direct material budget

d) Direct labor budget