need help with last picture
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 Standard Quantity 20 board feet 4 squares BDLH B DLH American cherry wood American cherry turning square (legs) Direct labor Variable overhead Fixed overhead Standard Price $4/board foot $8/square $15/DLH $45/DLH $12/DLH 120 360 BDLH 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 Budgeted ending inventory 372 6240 5160 65040 Total DM required 67560 553: 4800 6240 5160 Beginning inventory 60240 61320 5012 Budgeted purchases Prepare Swifty's direct labor budget for 2022. Direct Labor Budget 2nd Quarter 3rd Quarter Quarter 4th Quarter Annual $ $ $ $ Assume that because of the skill level required to make the tables, Swifty cannot easily hire additional workers to handle peaks in demand. Consequently, the company maintains a steady workforce of 40 employees and guarantees each worker 500 hours per quarter. For any additional time required to complete the scheduled production, these same workers earn 1.5 times their normal hourly rate. Prepare Swifty's direct labor budget for 2022. (Round overtime rate to 2 decimal place, es, 5275 and all other answers to decimal places, es 5,275) 1st Quarter Direct Labor Budget 2nd Quarter 3rd Quarter th Quarter Budgeted DL cost Regular hours cost Overtime rate DLH available DLH needed Overtime cost Overtime hours $ $ $ $ $ $ $ $ $ $ 3 S
