pls help. use the table format provided in the pics along with all the items shown is the drop down menu. part a is already done and shown. i need part b. thanks.

Bramble Furniture builds high-end hand-made dining tables. Attacus Simmons, the company's owner, has developed the following sales forecast for 2022 . Because of the time needed to create each table, Bramble maintains an ending Finished Goods Inventory of 20% of the following quarter's budgeted sales. Bramble has been following this inventory policy for several years. The comparny ended 2021 with 400 tables on hand. The standard cost card for a table is as follows: Prepare Bramble's production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables. Bramble maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31, 2021, Bramble's physical inventory count showed 4,800 board feet of American cherry. Due to an anticipated price increase in 2023, managers want to have 5,000 board feet of American cherry wood in inventory on December 31, 2022. Prepare Bramble's 2022 direct materials purchases budget for American cherry wood. Bramble maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31. 2021. Bramble's physical inventory count showed 4.800 board feet of American cherry. Due to an anticipated price increase in 2023, managers want to have 5,000 board feet of American cherry wood in inventory on December 31, 2022. Prepare Bramble's 2022 direct materials purchases budget for American cherry wood. Budgeted ending inventory Budgeted production Standard board feet Budgeted purchases cost Standard price per board foot Beginning inventory Budgeted purchases Total DM required Production needs