Question 9 1 pts On the Income & Expenses Sheet, the first month that bonuses are awarded is February March August None are awarded Question 10 1 pts On the Income & Expenses sheet, the function used to calculate the bonuses for February(C13) is =IF(C6 is greater then B20, Then Bonuses, no bonus) =IF(C6>-B20, B21"C6,0) =IF(C6>$B$21, $B$22"C6, 0) $15.890 M N Projected Income and Expenses January 1, 2017 to December 31, 2017 March $1.000 April SH.000 May $1,546,000 June $1,517,000 July $1,529,000 August $1,576,500 September $1,616,000 October $1,655,500 November $1.095,000 December $785,000 Total $16.811,000 S.950 $175.000 5275,000 $11.790 561340 349450 5197,000 $197,500 0 S445.050 $77,300 $309,200 $100,200 $15,460 $711,160 $22,350 5309,400 5109,000 515,290 $71140 57,450 $305,300 $305,00 $15,290 $703, M40 $78,825 $315,100 $315,300 $15.705 $725,190 $80,00 $123.200 $32.1,200 $16, 160 $743,360 $32.775 $131.100 5331100 $16,555 $761,530 $1,750 $339,000 339.000 $16,950 $779,700 $19,450 3157,00 3157,800 55.40.550 $3,362,200 51,162,200 $141,150 57.706,100 OS $155,050 . Real Estate Sales January inventory Income & Expenses Payment Calculator Employee Sale Type here to search o PR g a DS 72" FA Question 9 1 pts On the Income & Expenses Sheet, the first month that bonuses are awarded is February March August None are awarded Question 10 1 pts On the Income & Expenses sheet, the function used to calculate the bonuses for February(C13) is =IF(C6 is greater then B20, Then Bonuses, no bonus) =IF(C6>-B20, B21"C6,0) =IF(C6>$B$21, $B$22"C6, 0) $15.890 M N Projected Income and Expenses January 1, 2017 to December 31, 2017 March $1.000 April SH.000 May $1,546,000 June $1,517,000 July $1,529,000 August $1,576,500 September $1,616,000 October $1,655,500 November $1.095,000 December $785,000 Total $16.811,000 S.950 $175.000 5275,000 $11.790 561340 349450 5197,000 $197,500 0 S445.050 $77,300 $309,200 $100,200 $15,460 $711,160 $22,350 5309,400 5109,000 515,290 $71140 57,450 $305,300 $305,00 $15,290 $703, M40 $78,825 $315,100 $315,300 $15.705 $725,190 $80,00 $123.200 $32.1,200 $16, 160 $743,360 $32.775 $131.100 5331100 $16,555 $761,530 $1,750 $339,000 339.000 $16,950 $779,700 $19,450 3157,00 3157,800 55.40.550 $3,362,200 51,162,200 $141,150 57.706,100 OS $155,050 . Real Estate Sales January inventory Income & Expenses Payment Calculator Employee Sale Type here to search o PR g a DS 72" FA