In: Accounting
Standard cost information:
Standard Quantity / Unit | Standard Price | Standard Cost / Unit | |
Direct Material | 2 | $0.75 | $1.50 |
Direct Labor | 5 | $0.35 | $1.75 |
Variable Overhead | 3 | $1.20 | $3.60 |
Actual cost information:
Total Actual Used | Total Actual Cost | |
Direct Material | 19,500 | $19,500 |
Direct Labor | 34,500 | $15,750 |
Variable Overhead | 18,000 | $22,000 |
Do not enter dollar signs or commas in the input boxes.
Round all Unit values to 2 decimal places. Round all other answers
to the nearest whole number.
Enter all variances as positive values.
a) Complete Direct Materials variance analysis.
Actual Results / Unit | Total Actual Results | Price Variance | AQ x SP | Quantity Variance | Total Standard Allowed | Standard Allowed / Unit | ||||
Units Produced | 1.00 | 7,500 | 7,500.00 | 7,500 | 1.00 | |||||
Materials / Unit Produced | Answer | Answer | Answer | Answer | Answer | |||||
Price/Unit | Answer | Answer | Answer | |||||||
Total Cost | Answer | Answer | Answer | AnswerFU | Answer | Answer | AnswerFU | Answer | Answer | |
Total DM Variance | Answer | AnswerFU |
b) Complete Direct Labor variance analysis.
Actual Results / Unit | Total Actual Results | Labor rate variance | AQ x SP | DL efficiency variance | Total Standard Allowed | Standard Allowed / Unit | ||||
Units Produced | 1.00 | 7,500 | 7,500.00 | 7,500 | 1.00 | |||||
DLH / Unit Produced | Answer | Answer | Answer | Answer | Answer | |||||
DL Price/Unit | Answer | Answer | Answer | |||||||
Total Cost | Answer | Answer | Answer | AnswerFU | Answer | Answer | AnswerFU | Answer | Answer | |
Total DL Variance | Answer | AnswerFU |
c) Complete Variable Overhead variance analysis.
Actual Results / Unit | Total Actual Results | VOH spending variance | AQ x SP | VOH efficiency variance | Total Standard Allowed | Standard Allowed / Unit | ||||
Units Produced | 1.00 | 7,500 | 7,500.00 | 7,500 | 1.00 | |||||
VOH / Unit Produced | Answer | Answer | Answer | Answer | Answer | |||||
VOH Price/Unit | Answer | Answer | Answer | |||||||
Total Cost | Answer | Answer | Answer | AnswerFU | Answer | Answer | AnswerFU | Answer | Answer | |
Total VOH Variance | Answer | AnswerFU |
DATA FOR MATERIAL VARIANCE | ||||
SQ | Standard Hours for Actual Output [AO x SQ p.u.] | [7,500 Units x 2 ] | 15,000 | |
AQ | Actual Hours for Actual Output [AO x AQ p.u.] | [Given] | 19,500 | |
SR | Standard Rate per unit [TSC / TSQ] | [Given] | $0.75 | |
AR | Actual Rate per unit [TAC / TAQ] | [$19,500 / 19,500] | $1.00 | |
a) | 1) | Material Price/Spending Variance | [SR - AR] x AQ | |
[$ 0.75- $ 1.00] x 19,500 | ||||
$ 4,875 [Unfavourable] | ||||
2) | Material Usage/Efficency Variance | [SQ - AQ] x SR | ||
[15,000 - 19,500] x $ 0.75 | ||||
$ 3,375 [Unfavourable] | ||||
3) | Total Material Cost Variance | [SQ x SR] - [AQ x AR] | ||
[15,000 x $ 0.75] - [19,500 x $ 1.00] | ||||
[$ 11,250 - $ 19,500] | ||||
$ 8,250 [Unfavourable] | ||||
DATA FOR LABOUR VARIANCE | ||||
SH | Standard Hours for Actual Output [AQ x SH p.u.] | [7,500 Units x 5 hrs] | 37,500 | |
AH | Actual Hours for Actual Output [AQ x AH p.u.] | [Given] | 34,500 | |
SR | Standard Rate per Hour [TSC / TSH] | [Given] | $0.3500 | |
AR | Actual Rate per Hour [TAC / TAH] | [$15,750 / 34,500] | $0.4565 | |
b) | 1) | Labour Rate/Spending Variance | [SR - AR] x AH | |
[$ 0.35 - $ 0.4565] x 34,500 | ||||
$ 3,675 [Unfavourable] | ||||
2) | Labour Efficency Variance | [SH - AH] x SR | ||
[37,500 - 34,500] x $ 0.35 | ||||
$ 1,050 [Favourable] | ||||
3) | Total Labour Cost Variance | [SH x SR] - [AH x AR] | ||
[37,500 x $ 0.35] - [34,500 x $ 0.4565] | ||||
[$ 13,125 - $ 15,750] | ||||
$ 2,625 [Unfavourable] | ||||
DATA FOR VARIABLE OVERHEAD VARIANCE | ||||
SH | Standard Hours for Actual Output [AQ x SH p.u.] | [7,500 Units x 3 hrs] | 22,500 | |
AH | Actual Hours for Actual Output [AQ x AH p.u.] | [Given] | 18,000 | |
SR | Standard Rate per Hour [TSC / TSH] | [Given] | $1.2000 | |
AR | Actual Rate per Hour [TAC / TAH] | [$22,000 / 18,000] | $1.2222 | |
c) | 1) | Variable OH Rate/Spending Variance | [SR - AR] x AH | |
[$ 1.20 - $ 1.2222] x 18,000 | ||||
$ 400 [Unfavourable] | ||||
2) | Variable OH Efficency Variance | [SH - AH] x SR | ||
[22,500 - 18,000] x $ 1.20 | ||||
$ 5,400 [Favourable] | ||||
3) | Total Variable OH Cost Variance | [SH x SR] - [AH x AR] | ||
[22,500 x $ 1.20] - [18,000 x $ 1.2222] | ||||
[$ 27,000 - $ 22,000] | ||||
$ 5,000 [Favourable] | ||||