Current Attempt in Progress Coronado Furniture builds high-end hand made dining tables. Attacus Simmons, the company's owner, has developed the following sales forecast for 2022 2nd Quarter 3rd Quarter 1st Quarter 2600 4th Quarter 1.900 3,000 2.800 Forecasted sales (tables) Because of the time needed to create each table, Coronado maintains an ending Finished Goods Inventory of 20% of the following quarter's budgeted sales. Coronado has been following this inventory policy for several years. The company ended 2021 with 450 tables on hand. The standard cost card for a table is as follows: Standard Quantity Standard Price Total Standard Cost $80 20 board feet 4 squares 32 American cherry wood American cherry turning square (legs) Direct labor Variable overhead Fixed overhead 54/board foot $8/square $15/DUH $45/DUH 120 8 DLH 8 DLH 360 96 8 DLH $12/DLH $688 Prepare Coronado'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 2600 3000 2800 Budgeted ending inventory 600 560 380 Total units required 3200 3560 3180 Beginning inventory Budgeted Production e Textbook and Media Your answer is partially correct. Prepare Coronado's production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables. Production Budget 2nd Quarter 3rd Quarter 4th Quarter Annual er 2600 3000 2800 10300 1900 600 560 380 3200 3560 3180 e Textbook and Media