20162_ACG2071_M10_DIRVAR_Worksheet (2).xls - DIRVAR Student...

Kayla Battle
Section Number => ___________________
------ -------------------------------------------------------------------- -------------- ----------------- --------------
A B C D E
------ -------------------------------------------------------------------- -------------- ----------------- --------------
6 Data Section:
7
8 Materials price variance input
9 Actual cost of material per pound (ounce, etc.) $15.90
10 Standard cost of mat. per pound (ounce, etc.) $16.00
11
12 Materials quantity variance input
13 Actual quantity of materials used 39,500
14 Standard quantity of mat. used for actual output 38,000
15
16 Labor rate variance input
17 Actual cost of labor per hour $8.05
18 Standard cost of labor per hour $8.00
19
20 Labor efficiency variance input
21 Actual quantity of hours incurred 44,000
22 Standard quantity of hours for actual output