hi please help with:

Problem 5-32 (Part Level Submission) 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,733	2,964	2,250

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	$8/square	24
Direct labor	12 DLH	$16/DLH	192
Variable overhead	12 DLH	$52/DLH	624
Fixed overhead	12 DLH	$9/DLH	108
$1,073

Warning

Don't show me this message again for the assignment

Ok Cancel

(a) Prepare Sandovals production budget for 2015. Assume that the desired ending inventory for 2015 is 557 tables. (Round answers to 0 decimal places, e.g. 5,250.)

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