PLEASE help me solve this. Thank you so much

AA D M N R W 2 AB Pete's Store Dept A Dept B Dept C Total Peter Profit is the owner and general manager of Pete's Store which has three departments, A, B and C. Allocation Amounts: Total costs to be | Dept Dept Dept Total Part 1: allocated A C |Allocated Expense Costs Sales 400,000 240,000 160,000 $ 800,000 Sales and direct costs are accumulated by department but indirect costs are not. Pete has asked you to make an income statement for the year showing the profitability of each department as well as for the COGS 312,000 167,400 100,600 $ 580,000 total store. 50,000 50,000 Salaries You have analyzed these direct costs and determined the best approach is to allocate the indirect costs Gross Margin 88,000 72,600 59,400 $ 220,000 as follows: Other Revenue S 1. Salaries, other - gross profit margin 3,000 3,000 Advertising Total Revenue 88,000 72,600 59,400 220,000 2. Advertising - direct advertising Direct Expenses S 3. Building rent - value of floor space; A.50% B.30% C.20% 19.000 19,000 Building Rent Salaries, Sale: 38,400 34,600 23,000 S 96,000 4. Payroll taxes - total direct and indirect salaries Advertising 2,400 1,200 7,200 5. Insurance - value of equipment and inventory; A.28.7% B.34.5% C.36.8% 5,840 5,840 Payroll Taxes Supplies 1,500 1,600 1,240 4,340 6. Utilities - floor space, equal 33.33% each Misc 600 400 360 1,360 7. Amortization - value of equipment; A.28% B.30% C.42% 1,800 1,800 Insurance 44,100 39,000 25,800 $ 108,900 8. Miscellaneous - sales Allocate the indirect costs to each department and make a departmentalized income statement showing operating income for each of the three departments and total for Pete's Store. 3.360 3,360 Utilities Indirect Expenses Salaries, Othe 20,000 16,500 13,500 $ 50,000 Advertising 1,500 990 510 $ 3,000 Allocation Breakdown: 3,250 3,250 Amortization 13 Building Rent $ 19,000 Allocation Base (driver) Dept A Total Expense 18 PR Taxes 5,840 Gross Profit Margin 100% Salaries 2,000 2,000 Miscellaneous Insurance S 1,800 Direct Advertising 100% Advertising 20 Utilities 3,360 Value of floor space 100% Building Rent 21 Amortization 3,250 22 Misc 2,000 Total salaries 100% Payroll Taxes 23 21,500 17,490 14,010 $ 88,250 24 Value of equip & inv 100% Insurance 25 PART 1 Net Income $ 7,017 $ 5,040 $ 10,793 $ 22,850 Floor space 100% Utilities 26 27 PART 2 Net Income $ 30,000 $ (8,237) $ 540 $ 22,303 Value of Equip 100% Amortization 28 Sales 100% Miscellaneous 29 30 31