Sandoval Furniture builds high-end hand-made dining tables. Mackenzie Sandoval, the companys owner, has developed the following sales forecast for 2015. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Forecasted sales (tables) 2,551 2,796 2,981 2,200 Because of the time needed to create each table, Sandoval maintains an ending Finished Goods Inventory of 20 percent of the following quarters budgeted sales. Sandoval has been following this inventory policy for several years. The company ended 2014 with 510 tables on hand. The standard cost card for a table is as follows: Standard Quantity Standard Price Total Standard Cost American cherry wood 25 board feet $5/board foot $125 American cherry turning square (legs) 3 squares $10/square 30 Direct labor 12 DLH $15/DLH 180 Variable overhead 12 DLH $51/DLH 612 Fixed overhead 12 DLH $8/DLH 96 $1,043 Collapse question part (a) Prepare Sandovals production budget for 2015. Assume that the desired ending inventory for 2015 is 500 tables. (Round answers to 0 decimal places, e.g. 5,250.)

Production Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Beginning inventoryBudgeted unit salesTotal units requiredBudgeted ending inventoryBudgeted production Budgeted unit salesBudgeted ending inventoryBeginning inventoryTotal units requiredBudgeted production Budgeted unit salesBeginning inventoryTotal units requiredBudgeted ending inventoryBudgeted Production Total units requiredBudgeted productionBudgeted unit salesBeginning inventoryBudgeted ending inventory Beginning inventoryBudgeted unit salesBudgeted ending inventoryTotal units requiredBudgeted Production