Need to do page 2 before you can complete page 1

Bebidas Don Erico produces fine tequilas made with exceptional organic ingredient distinct varieties are produced: High-0 Silver Tequila and Solid gold Tequila. Please information on this and the next page to complete the departmental income stater Departments SG&A High- Silver Solid Gold Total Sales - 2,619,450 3,201,550 5,821,000 COGS - 1,118,500 1,637,000 2,755,500 Gross Margin - 1,500,950 1,564,550 3,065,500 Payroll 141,200 279,500 252,100 672,800 Deepreciation 24,800 35,200 45,420 105,420 Supplies 9,100 15,090 20,000 44,190 Total Direct Expense 175,100 329,790 317,520 822,410 Rent Utilities Advertising Total Indirect Expense Total Expense Allocated 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 proporti percentage allocated amount Rent Administration High-O Silver Solid Gold rent expense 54,000 54,000 54,000 square feet 5,400 9,450 12,150 27,000 square feet 5,400 9,450 12,150 27,000 sales 100.0% percentage Utilities Administration High- Silver Solid Gold utilities expense allocated amount 190,000 190,000 190,000 100.0% percentage Administration High- Silver Solid Gold percent of sales Advertising Administration High- Silver Solid Gold 100.0% advert expense allocated amount 176,000 176,000 176,000 100.0% percent of sales allocated amount SG&A Administration High-O Silver Solid Gold G&A expense 223,900 223,900 223,900 100.0%