Please help to solve this excel spreadsheet - DIRVAR

DIRVAR Student Name => ___________________ Section Number => ___________________ ------ -------------------------------------------------------------------- --------------- ---------------A B C D ------ -------------------------------------------------------------------- --------------- ---------------6 Data Section: 7 8 Materials price variance input 9 Actual cost of material per pound (ounce, etc.) 10 Standard cost of mat. per pound (ounce, etc.) 11 12 Materials quantity variance input 13 Actual quantity of materials used 14 Standard quantity of mat. used for actual output 15 16 Labor rate variance input 17 Actual cost of labor per hour 18 Standard cost of labor per hour 19 20 Labor efficiency variance input 21 Actual quantity of hours incurred 22 Standard quantity of hours for actual output 23 24 -------------------------------------------------------------------- --------------- ---------------25 Answer Section: 26 27 28 Material price variance FORMULA1 29 Material quantity variance FORMULA2 30 ------31 Total materials variance FORMULA3 32 33 Labor rate variance FORMULA4 34 Labor efficiency variance FORMULA5 35 ------36 Total labor variance FORMULA6 37 ------38 Total materials and labor variances FORMULA7 39 ======= 40 -------------------------------------------------------------------- --------------- ---------------- --------------E --------------- $15.90 $16.00 39,500 38,000 $8.05 $8.00 44,000 45,600 --------------Indicate F or U only --------------FORMULA8 FORMULA9 FORMULA10 FORMULA11 FORMULA12 FORMULA13 --------------- F or U only FORMULA8 FORMULA9 FORMULA10 FORMULA11 FORMULA12 FORMULA13 Current 12 10 8 6 4 2 0 Page 3 2 Current 0 Page 4 ORIGINAL 12 10 8 6 4 2 0 Page 5 2 ORIGINAL 0 Page 6