please answer this question

Production and Purchases Budget EX 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. Use the attached spreadsheet to prepare the budgets or use the editor to type your budgets. E Purchases Budget January February March Units to be produced X X X Sq ft. of material needed for production Total sq. ft. needed Multiplied by: Cost of raw material purchases X X