Bebidas Don Erico produces fine tequilas made with exceptional organic ingredients. Two distinct varieties are produced: High-0 Silver Tequila and Solid gold Tequila. Please use the information on this and the next page to complete the departmental income statement below. Departments SG&A High-0 Silver Solid Gold Total Sales COGS Gross Margin 2,328,4po 1,218,100 1,110,300 3,492,600 1,755,300 1,737,300 5,821,000 2,973,400 2,847,600 Payroll Depreciation Supplies Total Direct Expense 141,200 24,800 9,100 175,100 279,500 35,200 15,090 329,790 252,100 45,420 20,000 317,520 672,800 105,420 44,190 822,410 Rent Utilities Advertising Total Allocated Expense Total Expense Allocated SG&A Expense Total Expense Operating Income $54,000 of Rent should be allocated based on square footage (next page) $190,000 of Utilities should be allocated based on square footage as well $176,000 of advertising should be allocated to departments in proportion to sales Total SG&A expense should be allocated to the two other departments in proportion to sales Rent square feet percentage allocated amount 5,400 Administration High-0 Silver Solid Gold rent expense 54,000 54,000 54,000 9,450 12,150 27,000 100.0% square feet percentage 5,400 Utilities Administration High-0 Silver Solid Gold utilities expense allocated amount 190,000 190,000 9,450 190,000 12,150 27,000 100.0% sales percent of sales I Administration High- Silver Solid Gold 2,328,400 3,492,600 5,821,000 100.0% percent of sales allocated amount Advertising Administration High-0 Silver Solid Gold advert expense 176,000 176,000 176,000 100.0% SG&A percent of sales G&A expense allocated amount Administration High- Silver Solid Gold 100.0%