Problem 5-32 (Part Level Submission) Sandoval Furniture builds high-end hand-made dining tables. Mackenzie Sandoval, the company?s owner, has developed the following sales forecast for 2015.

1st Quarter	2nd Quarter	3rd Quarter	4th Quarter
Forecasted sales (tables)	2,527	2,749	2,984	2,300

Because of the time needed to create each table, Sandoval maintains an ending Finished Goods Inventory of 20 percent of the following quarter?s budgeted sales. Sandoval has been following this inventory policy for several years. The company ended 2014 with 505 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)	4 squares	$10/square	40
Direct labor	12 DLH	$18/DLH	216
Variable overhead	12 DLH	$51/DLH	612
Fixed overhead	12 DLH	$8/DLH	96
$1,089

(a) Prepare Sandoval?s production budget for 2015. Assume that the desired ending inventory for 2015 is 575 tables.(Round answers to 0 decimal places, e.g. 5,275.)

Production Budget
1stQuarter	2ndQuarter	3rdQuarter	4thQuarter	Annual
Budgeted productionBudgeted unit salesTotal units requiredBudgeted ending inventoryBeginning inventory
Total units requiredBudgeted unit salesBudgeted ending inventoryBeginning inventoryBudgeted production
Budgeted ending inventoryBudgeted ProductionTotal units requiredBeginning inventoryBudgeted unit sales
Budgeted unit salesBudgeted ending inventoryBeginning inventoryBudgeted productionTotal units required
Beginning inventoryBudgeted ProductionBudgeted unit salesBudgeted ending inventoryTotal units required

LINK TO TEXT

Attempts: 0 of 1 used

SAVE FOR LATER

SUBMIT ANSWER

(b) The parts of this question must be completed in order. This part will be available when you complete the part above.

(c) The parts of this question must be completed in order. This part will be available when you complete the part above.

(d) The parts of this question must be completed in order. This part will be available when you complete the part above

i will ask for the additional parts in the comments once the first part is completed. this is a part level submission. Print by: Maria Malik GB519: Measurement and Decision Making - 1604D-02 / Unit 3 Graded Quiz *Problem 5-32 (Part Level Submission) Sandoval Furniture builds high-end hand-made dining tables. Mackenzie Sandoval, the company's owner, has developed the following sales forecast for 2015. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2,527 2,749 2,984 2,300 Forecasted sales (tables) Because of the time needed to create each table, Sandoval maintains an ending Finished Goods Inventory of 20 percent of the following quarter's budgeted sales. Sandoval has been following this inventory policy for several years. The company ended 2014 with 505 tables on hand. The standard cost card for a table is as follows: American cherry wood Standard Quantity Standard Price Total Standard Cost 25 board feet $5/board foot $125 American cherry turning square (legs) 4 squares $10/square 40 Direct labor 12 DLH $18/DLH 216 Variable overhead 12 DLH $51/DLH 612 Fixed overhead 12 DLH $8/DLH 96 $1,089 Warning Don't show me this message again for the assignment Ok Cancel *(a) Prepare Sandoval's production budget for 2015. Assume that the desired ending inventory for 2015 is 575 tables. (Round answers to 0 decimal places, e.g. 5,275.) Production Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Warning Don't show me this message again for the assignment Ok Cancel Attempts: 0 of 1 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. *(c) The parts of this question must be completed in order. This part will be available when you complete the part above. *(d) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved