need help with the budget for 2022, thank you.
Swifty Furniture builds high end hand made dining tables. Attacus Simmons, the company's owner, has developed the following sales forecast for 2022. 1st Quarter 2,700 2nd Quarter 3,200 3rd Quarter 2,800 4th Quarter 1,700 Forecasted sales (tables) R Because of the time needed to create each table, Swifty maintains an ending Finished Goods Inventory of 20% of the following quarter's budgeted sales. Swifty has been following this inventory policy for several years. The company ended 2021 with 400 tables on hand. The standard cost card for a table is as follows: Total Standard Cost $80 32 American cherry wood American cherry turning square (legs) Direct labor Variable overhead Fixed overhead Standard Quantity 20 board feet 4 squares 8 DLH 8 DLH 8 DLH Standard Price $4/board foot $8/square $15/DLH $45/DLH $12/DLH 120 360 96 $688 Prepare Swifty's production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables. Production Budget 2nd Quarter 1st Quarter 3rd Quarter Budgeted unit sales 2700 3200 2800 Budgeted ending inventory 640 560 340 Total units required 3340 3760 3140 Beginning inventory 400 i 640 560 i Budgeted Production 2940 3120 2580 e Textbook and Media - Swifty maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31, 2021, Swifty'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 Swifty's 2022 direct materials purchases budget for American cherry wood. Direct Materials Purchases Budget 2nd Quarter 3rd Quarter 1st Quarter Budgeted production 2940 3120 25 Standard board feet 20 20 58800 Production needs 62400 5161 6240 5160 Budgeted ending inventory 3720 553 Total DM required 65040 67560 4800 6240 5160 Beginning inventory 60240 61320 501 Budgeted purchases Prepare Swifty's direct labor budget for 2022. Direct Labor Budget 2nd Quarter 3rd Quarter Quarter 4th Quarter Annual $ $ $