Production and Purchases Budget The Good as Old Company manufactures antique-looking oak rocking chairs. Budgeted sales for the first five months of the year are as follows: Budgeted Sales (Units) January 200 February 240 March 180 April 160 May 240 Each rocking chair requires 10 square feet of oak, at a cost of $20 per square foot. The company wants to maintain an inventory of chairs equal to 25% of the following month's sales. At the beginning of the year, 40 chairs are on hand Assume the company maintains an inventory of oak equal to 10% of the next month's needs. At the beginning of the year, 240 square feet of oak are on hand. Inventory of oak at March 31 is estimated to be 180 square feet. Required: (use the spreadsheet below for both) Each worth 20 points. Prepare a production budget, in units, for each of the first four months. Prepare a purchases budget, in dollars, for each of the first three months. Required: Prepare a production budget, in units, for each of the first four months. Production Budget in Units January February March Budgeted Total production needs Units to be produced Prepare a purchases budget, in dollars, for each of the first three months Purchases Budget January February March Units to be produced Sq ft. of material needed for production Total sq ft needed Multiplied by Cost of raw material purchases