In: Accounting
The following is information related to X Company, a company that uses a standard cost system:
Standard cost card for 1 unit of Product A:
Direct materials – Raw Material A (1 kilogram @ $ 20/kg.) $ 20
Direct materials – Raw Material B (1 kilogram @$ 10/kg.) $ 10
Direct labour (1 hour @ $15/hr.) $ 15
Variable overhead (1 hour @ $ 5/hr.) $ 5
Fixed overhead (1 hour @ $ 10/hr.) $ 10
Total budgeted fixed overhead: $ 1,000
Budget total units of production: 100 units
Actual units produced 88 units
Actual costs incurred: Total
Direct materials – Raw Material A (130 kilograms $ 2,860
Direct materials – Raw Material B ( 60 kilograms) $ 660
Direct labour (100 hours) $ 1,600
Variable overhead (100 hours) $ 480
Fixed overhead $ 1,120
Required:
Prepare a 5-column analysis, with the columns as follows: Actual, Cost Variances, Flexible Budget, Volume Variance, Master Budget
Calculate the direct labour variances.
Calculate the two variable overhead variances.
Calculate the direct material variances..
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||||||||||
Actual | Cost Variance | Flexible | Volume Variance | Master | |||||||||
$ | Result | $ | Result | ||||||||||
Units | 88 | 88 | 100 | ||||||||||
Raw Material A | $ 2,860 | $ 1,100 | U | $ 1,760 | $ 240 | F | $ 2,000 | ||||||
Raw Material B | $ 660 | $ 220 | F | $ 880 | $ 120 | F | $ 1,000 | ||||||
Direct Labor | $ 1,600 | $ 280 | U | $ 1,320 | $ 180 | F | $ 1,500 | ||||||
Variable Overhead | $ 480 | $ 40 | U | $ 440 | $ 60 | F | $ 500 | ||||||
Fixed Overhead | $ 1,120 | $ 240 | U | $ 880 | $ 120 | F | $ 1,000 | ||||||
Total | $ 6,720 | $ 1,440 | U | $ 5,280 | $ 720 | F | $ 6,000 | ||||||
Material A | Material B | ||||||||||||
Standard Material Price | $ 20.00 | Standard Material Price | $ 10.00 | ||||||||||
Standard Quantity | 88*1 | 88 | Standard Quantity | 88*1 | 88 | ||||||||
Actual Quantity Purchased | 130 | Actual Quantity Purchased | 60 | ||||||||||
Actual Quantity used | 130 | Actual Quantity used | 60 | ||||||||||
Actual Matrial Price | 2860/130 | $ 22.00 | Actual Matrial Price | 660/60 | $ 11.00 | ||||||||
Material Price Variance | AQ(AP-SP) | Material Price Variance | AQ(AP-SP) | ||||||||||
(Actual Price | - | Standard Price) | * | Actual Quantity | (Actual Price | - | Standard Price) | * | Actual Quantity | ||||
$ 22.00 | - | $ 20.00 | * | 130 | $ 11.00 | - | $ 10.00 | * | 60 | ||||
$ 260 | Unfavorable | $ 60 | Unfavorable | ||||||||||
Material Quantity Variance | SP(AQ-SQ) | Material Quantity Variance | SP(AQ-SQ) | ||||||||||
(Actual Quantity | - | Standard Qty) | * | Standard Price | (Actual Quantity | - | Standard Qty) | * | Standard Price | ||||
130 | - | 88 | * | $ 20.00 | 60 | - | 88 | * | $ 10.00 | ||||
$ 840.00 | Unfavorable | $ -280.00 | Favorable | ||||||||||
Direct Labor | |||||||||||||
Standard Hour Rate | $ 15.00 | ||||||||||||
Standard Hour | 88*1 | 88 | |||||||||||
Actual Hours | 100 | ||||||||||||
Actual Hour Rate | 1600/100 | $ 16.00 | |||||||||||
Labor Rate Variance | AH(AR-SR) | ||||||||||||
(Actual Rate | - | Standard Rate) | * | Actual Hours | |||||||||
$ 16.00 | - | $ 15.00 | * | 100 | |||||||||
$ 100 | Unfavorable | ||||||||||||
Labor Efficiency Variance | SR(AH-SH) | ||||||||||||
(Actual Quantity | - | Standard Qty) | * | Standard Price | |||||||||
100 | - | 88 | * | $ 15.00 | |||||||||
$ 180 | Unfavorable | ||||||||||||
Variable Overhead | |||||||||||||
Standard Hour Rate | $ 5.00 | ||||||||||||
Standard Hour | 88*1 | 88 | |||||||||||
Actual Hours | 100 | ||||||||||||
Actual Hour Rate | 480/100 | $ 4.80 | |||||||||||
Labor Rate Variance | AH(AR-SR) | ||||||||||||
(Actual Rate | - | Standard Rate) | * | Actual Hours | |||||||||
$ 4.80 | - | $ 5.00 | * | 100 | |||||||||
$ -20 | Favorable | ||||||||||||
Labor Efficiency Variance | SR(AH-SH) | ||||||||||||
(Actual Quantity | - | Standard Qty) | * | Standard Price | |||||||||
100 | - | 88 | * | $ 5.00 | |||||||||
$ 60 | Unfavorable |