Production and purchases budgets
Brian Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units which
are sold to public school systems throughout the Midwest. The controller of the company’s
School Desk Division is currently preparing a budget for the second quarter of 2015. The
following sales forecast has been developed by the division’s sales manager:
April 6,500 desk and chair sets
May 7,500 desk and chair sets
June 9,000 desk and chair sets
July 8,700 desk and chair sets
August 8,800 desk and chair sets
The inventory of finished desk and chair sets at the end of each month must be equal to
30% of the budgeted sales for the next month. On April 1, there will be 1,950 units of desk
and chair sets on hand.
Work-in-process inventories are negligible and can be safely ignored.
Each desk and chair set requires 10 board feet of pine planks. Pine planks cost $0.75 per
board foot, and the division ends each month with enough pine to cover 20% of the next
month’s production requirements. This requirement will be met on April 1 of 2015.
Required. Prepare a production budget and a materials purchases budget for April, May,
and June and in total for the three-month period.