excel inputs that didnt work for incorrect attempts:

=C10*C12

=H14-H13

=+IF(H15>0,"Favourable", IF(H15=0,"NIL","Unfavorable"))

AutoSave OFF OF A BETA Gradable Excel_Brief Exercise 11.6 IF, Subtract, Multiply, Cell Referencing_1_evalresponse (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 12 v 2 Wraa Text Custom Insert X [G Liberation Sans BIU 24-O 4 BE Conditional Format Cell Furmalingas Teule Styles DX Delete Psstc A - Merge & Center S-% Sort & Filler Farmat Find & Select Analyze Cale Sensitivity y Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. + xfx 124 B F G K L M N R 5 U Student Work Are Required: Provide input into cells shaded in yelow in this template. Use cel references to the Problem srea with mathematical formulas n the input cells. In the last nput Mald, Inout an IF function with cel references to your work area. 9 Compute the amount of the stal overhand variance and designato it the varianon is favorable or unfavarable using Excel's IF function. 11 $ Actual overhead Overhead applied Total overhead verlance 110.000 120,000 WOOD $ Nature of variance Fouble D : Function: IF: Formula: Subtract, Multiply: Call Referencing ; , 2 3 Using Excel to Determine Overhead Varlances 4 4 PROBLEM 5 In October, Pine Company was determining 13 overhead varience. Its opredetermined overhead rate is based on direct labor hours. The following 7 Information was provided * 4 Marisachuring overhead costs incurred S 118.00 10 Actual direct labor hours 21.00 Standard hours alowed for work donn 20.600 12 Predatormired overhead ratr S G.00 13 14 15 10 17 18 19 20 21 22 22 24 25 25 27 28 29 30 32 32 33 34 35 36 37 79 40 41 41 44 Summary Enter Answer + Ready C - - - + 90%