In: Accounting
Calculate total sales mix variance, Direct Materials Variance Price, Direct Materials Variance Efficiency, Dircet Labor Variance Rate & Efficiency, Variable overhead variance spending, and Selling and General Admin Variance.
Scooter's Inc |
|||
Summary of Standard Costs |
Deluxe |
Beginner |
|
Assembly kit per scooter |
$ 400 |
$ 200 |
|
Direct labor hours per scooter |
3 |
1 |
|
Direct labor rate per hour |
$ 25 |
$ 15 |
|
Variable overhead rate per scooter |
$ 35 |
$ 35 |
|
Sales Price |
|||
2017 |
2018 |
||
Deluxe |
$ 900 |
$ 900 |
|
Beginner |
$ 350 |
$ 350 |
|
Sales Mix Percent |
|||
2017 |
2018 |
||
Deluxe |
80% |
50% |
|
Beginner |
20% |
50% |
|
Total Assembled & Sold |
6,800 |
6,800 |
|
Scooter's Inc |
|||
Summary of Actual Costs |
|||
Deluxe |
2017 |
2018 |
|
Assembly kits: |
Used |
5,440 |
3,425 |
Price per kit |
$ 400 |
$ 500 |
|
Direct labor hours |
16,320 |
10,275 |
|
Direct labor rate per hour |
$ 25 |
$ 27 |
|
Variable overhead per scooter |
$ 35 |
$ 38 |
|
Beginner |
2017 |
2018 |
|
Assembly kits: |
Used |
1,360 |
3,460 |
Price per kit |
$ 200 |
$ 175 |
|
Direct labor hours |
1,360 |
3,460 |
|
Direct labor rate per hour |
$ 15 |
$ 20 |
|
Variable overhead per scooter |
$ 35 |
$ 41 |
|
Director salaries |
$ 400,000 |
$ 275,000 |
SALES MIX VARIANCE | ||||||||||
SALES MIX VAIRANCE IS VARIANCE WHICH ARISES DUE TO CHANGE IN STANDARD MIX WITH RESPECT TO | ||||||||||
ACTUAL MIX | ||||||||||
PRODUCT DELUXE | 2017 | 2018 | VARIANCE | |||||||
SALES | 4896000 | 3060000 | -1836000 | |||||||
SALE PRICE x MIX PERCENTAGExRATE | ||||||||||
PRODUCT BEGINER | ||||||||||
SALES | ||||||||||
SALE PRICE x MIX PERCENTAGExRATE | 476000 | 1190000 | 714000 | |||||||
TOTAL SALES MIX VARIANCE | -1122000 | ADVERSE | ||||||||
DIRECT MATERIAL VARAINCE PRICE | ||||||||||
VARIANCE = ACTUAL COST OF MATERIAL - ACTUAL COST OF MATERIAL AT STANDARD PRICE | ||||||||||
2017 | 2018 | |||||||||
ACTUAL COST OF MATERIAL DELUXE | ||||||||||
ACTUAL CONSUMPTION x ACTUAL PRICE | 2176000 | 1712500 | ||||||||
ACTUAL CONSUMPTION x STANDARD PRICE | 2176000 | 1370000 | ||||||||
ACTUTAL COST OF BEGINER | ||||||||||
ACTUAL CONSUMPTION x ACTUAL PRICE | 272000 | 605500 | ||||||||
ACTUAL CONSUMPTION x STANDARD PRICE | 272000 | 692000 | ||||||||
TOTAL ACTUAL COST OF MATERIAL | 2448000 | 2318000 | ||||||||
TOTAL COST OF MATERIAL AT STANDARD RATE | 2448000 | 2062000 | ||||||||
VARIANCE | 256000 | ADVERSE | ||||||||
DIRECT MATERIAL VARIANCE EFFICIENCY | ||||||||||
VARIANCE = COST OF MATERIAL CONSUMED FOR ACTUAL OUTPUT AT STANDARD COST - COST OF MATERIAL CONSUMED AT STANDARD COST | ||||||||||
MATERIAL COST AT STANDARD RATE | 2017 | 2018 | ||||||||
TOTAL COST OF MATERIAL AT STANDARD RATE | 2448000 | 2318000 | ||||||||
STANDARD COST OF ACTUAL OUTPUT | ||||||||||
ACTUAL OUTPUT | 6800 | |||||||||
STANDARD COST DELUXE | 2176000 | 1360000 | ||||||||
STANDARD COST BEGINER | 272000 | 680000 | ||||||||
2448000 | 2040000 | |||||||||
278000 | ADVERSE | |||||||||
DIRECT LABOUR PRICE | ||||||||||
VARIANCE = ACTUAL COST OF LABOUR - ACTUAL COST OF LABOUR AT STANDARD PRICE | ||||||||||
2017 | 2018 | |||||||||
ACTUAL LABOUR COST DELUXE | 408000 | 277425 | ||||||||
ACTUAL LABOUR COST BEGINER | 20400 | 69200 | ||||||||
428400 | 346625 | |||||||||
ACTUAL LABOUR COST AT STANDARD RATE | ||||||||||
DELUXE | 408000 | 256875 | ||||||||
BEGINER | 20400 | 51900 | ||||||||
428400 | 308775 | |||||||||
VARIANCE | 37850 | ADVERSE | ||||||||
DIRECT LABOUR EFFICIENCY VARIANCE | ||||||||||
VARIANCE = ACTUAL COST OF LABOUR AT STANDARD PRICE - STANDARD COST OF LABOUR | ||||||||||
ACTUAL LABOUR COST AT STANDARD RATE | ||||||||||
DELUXE | 408000 | 256875 | ||||||||
BEGINER | 20400 | 51900 | ||||||||
428400 | 308775 | |||||||||
STANDARD COST OF LABOUR | ||||||||||
STANDARD COST OF DELUXE | 408000 | 255000 | ||||||||
STANDARD COST OF BEGINER | 20400 | 51000 | ||||||||
428400 | 306000 | |||||||||
VARIANCE | 2775 | ADVERSE | ||||||||
DIRECT VARIABLE OVERHEAD PRICE | ||||||||||
VARIANCE = ACTUAL COST OF VARIABLE OVERHEAD - ACTUAL COST OF VARIABLE OVERHEAD AT STANDARD PRICE | ||||||||||
2017 | 2018 | |||||||||
ACTUAL VARIABLE OVERHEAD COST DELUXE | 571200 | 390450 | ||||||||
ACTUAL VARIABLE OVERHEAD COST BEGINER | 47600 | 141860 | ||||||||
618800 | 532310 | |||||||||
ACTUAL VARIABLE OVERHEAD COST AT STANDARD RATE | ||||||||||
DELUXE | 571200 | 359625 | ||||||||
BEGINER | 47600 | 121100 | ||||||||
618800 | 480725 | |||||||||
VARIANCE | 51585 | ADVERSE | ||||||||
DIRECT VARIABLE OVERHEAD EFFICIENCY VARIANCE | ||||||||||
VARIANCE = ACTUAL COST OF VARIABLE OVERHEAD AT STANDARD PRICE - STANDARD COST OF VARIABLE OVERHEAD | ||||||||||
ACTUAL VARIABLE OVERHEAD COST AT STANDARD RATE | ||||||||||
DELUXE | 571200 | 359625 | ||||||||
BEGINER | 47600 | 121100 | ||||||||
618800 | 480725 | |||||||||
STANDARD COST OF VARIABLE OVERHEAD | ||||||||||
STANDARD COST OF DELUXE | 571200 | 357000 | ||||||||
STANDARD COST OF BEGINER | 47600 | 119000 | ||||||||
618800 | 476000 | |||||||||
VARIANCE | 4725 | ADVERSE | ||||||||
SINCE STANDARD FIXED SELLING AND ADMINSTRATION OVERHEADS ARE NOT GIVEN FINDING VARIANCE IS NOT POSSIBLE | ||||||||||
YEAR TO YEAR VARIANCE WILL BE $ 400000- $ 275000 = $125000 FAVOURABLE |