what is the favorable unfavorable if statement that should be used for this excel spreadsheet

What is the favorable unfavorable if statement that should be used for this excel spreadsheet

KLM TO DE FONT Leonardo Paint Manufacturer Company Direct Material and Labor Variance Analysis For Period Ended December 31, 2020 STANDARD $3,000 3.000 ACTUAL $3,600 2,500 1.44 1.00 5 Input Area 6 Direct Materials: 7 Total Purchase Price 3 Quantity Placed in Production 9 Cost per unit T1 Direct Labor 2 Direct Labor Costs 3 Direct Labor Hours Rate Per Hour 10 $30,000 6,000 $5.00 $27,830 6,050 4.60 GA) Calculated Direct Materials Price Variance 7 8 B) Calculated Direct Materials Usage Variance LL 9 OC) Calculate Direct Labor Rate Variance Cells with purple highlights should be if statements. 2D) Calculate Direct Labor Efficiency Variance Impact Area: Standard BA) I $ 1.00 - S Actual 1.44 ) 2,500 = ($1,100) Unfavorab 3B) 3,000 - 2,500) $1.00 = $500 Favorable C) $5.00 4.60) 6,050 = $2.420 Favorable 3D) 6,000 6,050) . $5.00 = ($250) Unfavora Direct Materials Consumed T actual quantity 2.500 Purchased actual quantity 2,500 standard quantity 3,000 2,500 standard price actual price 1$ 1.44 standard price $ 1.00 $ 1.00 1.00 1$ 3,600 $ 2,500 $ 2,500 3,000 Total Variance s $ 600 Unfavorable e Variance $ $ 1,100 Unfavorable Pricel | 500 Unfavorable i nfavorable Usage Direct Labor standard quantity 6,000 actual quantity 6.050 actual quantity 6,050 actual rate 4.60 standard rate $ 5.00 standard rate $ 5.00 $ 27.830 30.250 $ 30,000 Total Variance 2.170 $ Unfavorable $ $ Unfavorable 2.420 Favorable Ratel 250 Efficiency