Good morning,

Please assist me in completing this question or show me the steps to complete this table

Required information The following information applies to the questions displayed below.] Mango & Associates expects the below departments to make the following income for the upcoming year. Dept. M $66,000 Dept. N 38,000 Dept. O $59,000 Dept. T 31,000 Total Dept. P $45,000 Sales $239,000 Expenses Avoidable Unavoidable Total expenses $128,800 $115,000 23,300 4,500 15,500 40,500 11,300 53,000 38,200 14,400 31,200 11,900 52,400 64,300 52,600 27,800 46,700 243,800 (4,800) $(14,600) $(1,700) (21,400) Net income (loss) $31,200 1,700 Recompute & prepare departmental income statements (which should include a combined total column) for Mango & Associates taking each of the following separate scenarios into consideration. (1) Mango & Associates' management decided to get rid of departments with expected net losses. DEPARTMENTS WITH EXPECTED NET LOSSES ELIMINATED Dept. N Dept. O Dept. T Dept. M Dept. P Total Sales 0 Expenses: Avoidable Unavoidable Total expenses Net income (loss) 0 0 0 $ 0