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 Sales COGS Gross Margin Payroll Deepreciation Supplies Total Direct Expense Rent Utilities Advertising Total Indirect Expense Subtotal Expense Allocated Expense Total Expense Operating Income - $84,000 of Rent should be allocated based on square footage 568:}! 141,200 24,300 8,700 174,700 High-0 Silver 2,529,000 1,218,100 1,310,900 279,500 35.200 15.090 329.790 Solid Gold 3,091,000 1,755,300 1,335,700 252,100 45,420 20,000 317,520 - $210,000 of Utilities should be allocated based on square footage as well - $228,000 of advertising should be allocated to departments in proportion to sales Total 5,620,000 2,973,400 2,646,600 672,300 105,420 43,790 822,010 - Total SG&A expense (direct plus indirect) should be allocated to the two other departments in proportion to sales Rent square feet percentage rent expense allocated amount Administration 6,750 84,000 High-O Silver 9,450 84,000 Solid Gold 10,800 84,000 27,000 100.0% Utilities square feet percentage utilities expense allocated amount Administration 6,750 210,000 High-O Silver 9,450 210,000 Solid Gold 10,800 210,000 27,000 100.0% sales percentage Administration High-O Silver 2,529,000 Solid Gold 3,091,000 5,620,000 100.0% Advertising percent of sales advert expense allocated amount Administration 228,000 High-O Silver 228,000 Solid Gold 228,000 100.0% SG&A percent of sales G&A expense allocated amount Administration 248,200 High-O Silver 248,200 Solid Gold 248,200 100.0%