Read through page 1, the complete the allocations on page 2. se complete the pro-forma Income Statement on page 1 When you've done that, please complete the pro-forma Income Statement on page 1. With page1 completed, you can answer the following questions. Do not use dollar signs or decimal places (hint: no need for rounding). Make sure to properly use commas. 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- Silver Solid Gold Total Sales 5,821,000 COGS 2,328,400 1,218,100 1,110,300 3,492,600 1,755,300 1,737,300 Gross Margin 2,973,400 2,847,600 Payroll Depreciation Supplies Total Direct Expense 141,200 24,800 9,100 279,500 35,200 252,100 45,420 20,000 317,520 15,090 329,790 672,800 105,420 44,190 822,410 175,100 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 allocated amount Rent square feet percentage Administration High-0 Silver Solid Gold 5,400 9,450 12,150 27,000 rent expense 54,000 54,000 54,000 100.0% Utilities square feet percentage Administration High- Silver Solid Gold 5,400 9,450 utilities expense allocated amount 190,000 190,000 190,000 12,150 27,000 100.0% sales percent of sales Administration High- Silver 2,328,400 Solid Gold 3,492,600 5,821,000 100.0% percent of sales advert expense allocated amount Advertising Administration 176,000 High- Silver 176,000 Solid Gold 176,000 100.0% SG&A percent of sales G&A expense allocated amount Administration High-0 Silver Solid Gold 100.0%