Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead. Sports Bars, Inc, produces energy bars and sells them...

NEED F part only by following the format which is under:

• Attachment 1
• Attachment 2

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 thiscoming year follows: - Average sales price for each case is estimated to be $25. Unit sales for this coming year, ending December 31, areexpected to be as follows: First quarter 80,000Second quarter 84,000Third 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 goodsinventory 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 maintainending raw materials inventory equal to 10 percent of next quarter’s materials needed in production. Raw materialsinventory 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 areIndirect materials $0.20 per unit Indirect labor $0.15 per unitOther $0.10 per unit - Fixed manufacturing overhead costs per quarter areSalaries $80,000 Other $70,000Depreciation $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 fourquarters?