A B C D E F G 1 Variance Analysis Practice Exercise 2 3 4 SeverCo manufactured 25,000 units, using 175,000 square feet of materials, purchased at $1.15 per square foot. This required 425 direct labor hours that cost $17.25 per hour. The standard for production is 8 square feet per unit, at a standard cost of $1.25 per square foot. The labor standard is currently set at 0.032 direct labor hours per unit, at a standard cost of $14.00 per hour. 5 Price Variance (aka Rate Variance or Spending Variance) 6 (AP-SP)*AQ 7 AP = Actual Price for one unit of input (e.g. one pound of material, one hour of labor, etc.) 8 SP=Standard Price for one unit of input (e.g. one pound of material, one hour of labor, etc.) AQ Actual quantity of those inputs (e.g. pounds of materials or hours of labor) needed to produce the 9 number of units that you have actually produced in total. 10 11 Quantity Variance (aka Efficiency Variance or Usage Variance) 12 (AQ-SQ)*SP AQ Actual quantity of those inputs (e.g. pounds of materials or hours of labor) needed to produce the 13 number of units that you have actually produced in total. SQ-Standard expected quantity of those inputs (eg. pounds of materials or hours of labor) needed to 14 produce the number of units that you have actually produced in total. 15 SP Standard Price for one unit of input (e.g. one pound of material, one hour of labor, etc.) 16 17 Materials 18 Actual Price per Sq. Foot 19 Standard Price Per Sq. Foot $1.15 $1.25 20 Actual quantity of sq. feet needed to produce your current actual level of production 175000 Standard quantity of sq. feet needed to produce your current actual level of 21 production 200000 22 23 Labor 24 Actual Price per Hour $17.25 25 Standard Price Per Hour $14.00 Variance Analysis +