Please use below excel format to answer. Thanks.

40. Selling and Administrative Budget and Budgeted Income Statement. The previous problem must be completed before working this problem.) Sports Bars, Inc., produces energy bars. Management estimates all selling and administrative costs are fixed. Quarterly selling and administrative cost estimates for the coming year follow. Salaries $170,000 Rent $ 65,000 Advertising $120,000 Depreciation $ 75,000 Other $ 36,000 Required: a. Use the information presented previously to prepare a selling and administrative budget. Refer to the format shown in Figure 9.8. b. Use the information from the previous problem and from requirement a of this problem to prepare a budgeted income statement. Refer to the format shown in Figure 9.9. c. How will management use the information presented in the budgeted income statement? Figure 9.8 Selling and Administrative Budget for Jerry's Ice Cream *Deduct depreciation to get the actual cash payment for selling and administrative costs. **This information is needed for the cash budget presented in Figure 9.11. Jerry's Ice Cream Selling and Administrative Budget Year Ending December 31 Quarter 1 2 3 4 Year Salaries Rent Advertising Depreciation Other Total selling administrative costs Deduct depreciation Cash payments for selling and administrative $ 40,000 8,000 5,000 3,000 2.000 5 58,000 (3.000) $ 55.000 S 40,000 8,000 5,000 3,000 2.000 $ 58,000 (3.000) $ 55,000 $ 40,000 8,000 5,000 3,000 2,000 $ 58,000 (3.000) $ 55,000 $ 40,000 8,000 5,000 3,000 2,000 $ 58,000 (3,000) $ 55,000 $ 160,000 32,000 20,000 12,000 8,000 $ 232,000 (12,000) 5220,000 Figure 9.9 Budgeted Income Statement for Jerry's Ice Cream *Cost of goods sold = Per unit cost of $4.50 (see above)