Use the range names in formulas to find the total for each month Fit in the tal for each month below (Simplify your anewars) D Expenses April May Cost of Goods $2.550 $2,860 Advertising Salaries Supplies August $2.040 $3.160 53.210 $2,500 $2.500 $2.500 $3.000 $18.750 518.750 $18.750 $30.000 $1,100 $1,160 $1.240 $1.350 $1.350 $1.300 Miscellaneous $16,000 $16,000 $16.400 $16.800 $17.500 $17,000 June July September October $3.000 32 MO J November December $2.630 $2.270 $3,000 $30,000 $2.500 $1.500 $1.500 $1.500 $30,000 $18.650 $18,650 $14.650 $1,250 $1.500 $1,100 $16.300 $16,000 $15.200 Total for Each 40.000 341.270 541.830 354,310 $50,000 54,700 340,500 303720 Month Use the range names in formulas to find the total for each type of expense. Fill in the total for each expense below (Simplify your answers) A 1 Expenses B C D E April May June July August G September October H 2 Cost of Goods $2,550 Advertising $2.500 $2,800 $2,940 $2.500 $2.500 $3,100 $3,000 Salari $18,750 $18.750 $18,750 $30,000 5 Supplies $1,100 $1,160 $1,240 $1,350 Miscellaneous $16,000 $16,000 $16.400 $16.800 $3.210 $3,000 $30,000 $1,350 $17,500 November December Total for Each Expense $3,000 $2,400 $2.630 $2.270 $2,500 $1,500 $1.500 $1.500 $16.300 $30,000 $18.650 $18.650 $18.650 $1,300 $1,250 $1,200 $1,100 $17,000 $16.000 $15.200