Need answers of all parts using the format below which I have attached. Figure 9.3, 9.4, 9.5, 9.6, 9.7 is attached.

39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead. Sports Bars, Inc, produces energy bars and sells them by the case (1 unit = 1 case). Information to be used for the operating budget this coming year follows: - Average sales price for each case is estimated to be $25. Unit sales for this coming year, ending December 31, are expected to be as follows: First quarter 80,000 Second quarter 84,000 Third quarter 88,000 Fourth quarter 97,000 - Finished goods inventoryis maintained at a level equal to 15 percent of the next quarter's sales. Finished goods inventory at the end of the fourth quarter budget period is estimated to be 13,000 units. . Each unit of product requires 5 pounds of direct materials, at a cost of $3 per pound. Management prefers to maintain ending raw materials inventory equal to 10 percent of next quarter's materials needed in production. Raw materials inventory at the end of the f0urth quarter budget period is estimated to be 43,000 pounds. . Each unit of product requires 0.10 direct labor hours at a cost of $14 per hour. - Variable manufacturing overhead costs are Indirect materials $0.20 per unit Indirect labor $0.15 per unit Other $0.10 per unit - Fixed manufacturing overhead costs per quarter are Salaries $80,000 Other $70,000 Depreciation $55,625 Required: a. Prepare a sales budget using the format shown in Figure 9.3. b. Prepare a production budget using the format shown in Figure 9.4. c. Prepare a direct materials purchases budget using the format shown in Figure 9.5. d. Prepare a direct labor budget using the format shown in Figure 9.6. e. Prepare a manufacturing overhead budget using the format shown in Figure 9.7. Round to the nearest dollar. f. As the production manager, what concerns, if any, do you have about production requirements for each of the four quarters? PROBLEMS (continued) 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead (continued) I. The production budget shows the following trend in production from one quarter to the next: First Second Third Fourth Quarter Quarter Quarter Quarter 'ROBLEMS (continued) 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead (continued) 2. Manufacturing overhead budget Sports Bars, Inc. Manufacturing Overhead Budget Year Ending December 31 1 2 3 4 Year Units to be produced (from production budget) Variable overhead costs: Indirect materials ( per unit) Indirect labor ( per unit) Other ( per unit) Total variable overhead costs Fixed overhead costs: Salaries Other Depreciation Total fixed overhead costs Total overhead costs $248,578 Deduct depreciation Cash payments for overhead Manufacturing overhead per unit $2.80 PROBLEMS (continued) 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead (continued) :1. Direct labor budget Sports Bars, Inc. Direct Labor Budget Year Ending December 31 1 2 3 4 Year Units to be produced (from production budget) Direct labor hours per unit X X X X X Total direct labor hours needed in production Labor rate per hour X X X X X Total direct labor cost Direct labor cost per unit PROBLEMS (continued) 39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manuj'acturing Overhead (continued) e. Direct materials purchases budget Sports Bars, Inc. Direct Materials Purchases Budget Year Ending December 31 Units to be produced (from production budget) Materials required per unit (pounds) X X X x X Materials needed in production Add desired ending inventory Materials needed in inventory Deduct beginning inventory Direct materials to be purchased (pounds) Cost of materials per pound X X X X X Cost of materials to be purchased $1,417,575 Direct materials cost per unit $15 ROBLEMS ( continued ) 9 . Budgeting for Sales , Production , Direct Materials , Direct Labor , and Manufacturing Overhead a . Sales budget Sports Bars , Inc. Sales Budget Year Ending December 3 1 Quarter Year Projected sales in units Sales price per unit X Sales revenue b . Production budget Sports Bars , Inc . Production Budget Year Ending December 31 Quarter* 2 3 4 Year Sales in units ( from sales budget ) Add desired ending finished goods inventory* 13, 000 13, 000 Total finished goods inventory needed Deduct beginning finished goods inventory* Units to be produced 350, 000Figure 9. 3 Sales Budget for Jerry's Ice Cream Jerry's Ice Cream Sales Budget Year Ending December 31 Quarter 7 2 3 4 Year Sales in units ( 1 unit = 1 gallon) 40, 000 48, 000 60, 000 52, 000 200, 000 Sales price per unit X 56 X X 56 95 X X Sales revenue $240, 000 $288, 000 $360, 000 $372, 000 $7 , 200, 000Figure 9.4 Production Budget for Jen'y's Ice Cream *Infonnaiion from Figure 9.3. \"Desired ending inventory = 10 percent x Next quarter sales; for the rst quarter, 4,800 = 0.10 x 48,000. Fourth quarter desired ending inventory of 4,400 units is based on an estimate of sales in the rst quarter of next year. ***Beginning inventory = Inventory at end of previous quarter; for example, second quarter beginning inventory = First quarter ending inventory. First quarter beginning inventory = Previous year fourth quarter ending inventory (4,000 = 0.10 x 40,000). Figure 9.5 Direct Materials Purchases Budget for Jerry's Ice Cream * Information from Figure 9. 4 . * Desired ending inventory = 20 percent * Next quarter production needs ; for the first quarter , 19 , 680 = 0. 20 x 98 , 400 . Fourth quarter desired ending inventory of 20 , 000 pound ounds is based on an estimate of materials needed in production first quarter of next year . * * * Beginning inventory = Inventory at end of previous quarter ; for example , Second quarter beginning inventory = First quarter* ending inventory . * * * * $2 direct materials cost per unit = 2 pounds of materials required per unit x $ 1 per pound . Jerry's Ice Cream Direct Materials Purchases Budget Year Ending December 31 Quarter 7 2 3 4 Year Units to be produced* 40, 800 49, 200 59 , 200 51 , 200 200, 400 Materials required per unit ( pounds ) X 2 X 2 X 2 X 2 X 2 Materials needed in production 81 , 600 98 , 400 1 18 , 400 102, 400 400, 800 Add desired ending inventory* 19 , 680 23 , 680 20, 480 20, 000 20 , 000 Materials needed in inventory 101 , 280 122 , 080 138 , 880 122 , 400 420, 800 Deduct beginning inventory* ( 16 , 320 ) ( 19 , 680 ) ( 23, 680 ) ( 20, 480 ) ( 16, 320 )# Direct materials to be purchased ( pounds ) 84, 960 102, 400 1 15 , 200 101 , 920 404, 480 Cost of materials per pound ST $7 X $1 X X X Cost of materials to be purchased 584, 960 $ 102, 400 $1 15, 200 $101 , 920 5404, 480 Direct materials cost per unit* 2.00Figure 9. 7 Manufacturing Overhead Budget for Jerry's Ice Cream *From Figure 9. 4 . * * $1 . 20 = $240 , 480 total overhead cost : 200 , 400 units to be produced for the year . ' Deduct depreciation to get the actual cash payment for overhead . This information is needed for the cash budget presented in Fig ure 9. 11 . Jerry's Ice Cream Manufacturing Overhead Budget Year Ending December 31 Quarter 1 2 3 4 Year Units to be produced* 40. 800 49, 200 59, 200 51, 200 200, 400 Variable overhead costs Indirect materials ( 50 .15 per unit ) \\6 , 120 5 7 . 380 5 8, 8:80 5 7 , 580 5 30, 050 5 Indirect labor (50 . 10 per unit ) 4, 080 4, 920 5, 920 5 , 120 20, 040 Other ( 50. 25 per unit )| 10 , 200 12 , 300 14 , 800 12, 8:00 50, 100 Total variable overhead costs $ 20, 400 5 24, 600 $ 29 , 600 $ 25 , 600 $ 100 , 200 Fixed overhead costs Salaries 15, 000 15, 000 15, 000 15, 000 60, 000 Rent 10, 000 10, 000 10 , 000 10, 000 40, 000 Depreciation 10, 070 10, 070 10, 070 10, 070 40, 280 Total fixed overhead costs 5 35, 070 5 35, 070 5 35, 070 5 35, 070 5140, 280 Total overhead costs 55, 470 59, 670 64, 670 50, 570 240, 480 Deduct depreciation ( 10 , 070) ( 10, 070 ) ( 10, 070) ( 10, 070 ) ( 40, 280 ) Cash payments for overhead $ 45, 400 $ 49, 500 $54 , 600 $ 50, 500 $200, 200 Manufacturing overhead per unit* 1. 20Figure 9.6 Direct Labor Budget for Jerry's Ice Cream *From Figure 9.4. \"$1.30 direct labor cost per unit = 0.10 direct labor hours per unit x $13 per hour