Please help, current examples in Chegg are not helpful. Please show formula and explain in detail.

A B C D E G Profit Center Analysis of Indirect Expenses 18 Planned Indirect Expenses \begin{tabular}{l|ll} 19 & Administrative & $72,500.00 \\ 20 & Depreciation & $61,250.00 \\ 21 & Energy & $46,000.00 \\ 22 & Insurance & $12,500.00 \\ 23 & Maintenance & $26,000.00 \\ 24 & Marketing & $52,250.00 \\ \hline \end{tabular} Name: ClarkMarquelda II I IIII IIIIIII Instructions Use the Planned Indirect Expenses provided in the cells B19:B24 to calculate the following indirect expenses: a. Spa Administrative (B8) = Administrative Expenses * Spa Total Net Revenue / Resort Total Net Revenue b. Spa Depreciation (B9) = Depreciation Expenses * Spa Square Footage / Total Square Footage c. Spa Energy (B10) = Energy Expenses * Spa Total Net Revenue/ Resort Total Net Revenue d. Spa Insurance (B11)= Insurance Expenses * Spa Square Footage / Total Square Footage e. Spa Maintenance (B12) = Maintenance Expenses * Spa Square Footage / Total Square Footage f. Spa Marketing (B13) = Marketing Expenses * Spa Total Net Revenue/ Resort Total Net Revenue g. Spa Total Indirect Expenses (B14) = SUM(B8:B13) h. Spa Net Income (B15) = Revenue - (Cost of Sales + Direct Expenses + Total Indirect Expenses) i. Use the concept of absolute reference we learn in chapter 3 to modify some cell references in column B, then use the fill handle to copy the range B8:B15 to the range C8:I15 j. AutoSum the totals for Column J, where appropriate k. Format the number as it deems appropriate (i.e., any appropriate formats will be accepted)