Build_a_Spreadsheet_10_46

Build_a_Spreadsheet_10_46 - Rate in Rates Hours Variance...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
DATA INPUT Standard Standard Direct-Labor Direct-Labor Hours Rate per Hour Allowed, Given April Output Labor Class III $16.00 500 Labor Class II 14.00 500 Labor Class I 10.00 500 Actual Actual Direct-Labor Direct-Labor Rate per Hour Hours Labor Class III $17.20 550 Labor Class II 15.00 650 Labor Class I 10.80 375 SOLUTION 1) Variances (U denotes unfavorable; F denotes favorable): a) Direct-labor rate variance for each labor class: Actual Standard Difference Actual Rate Labor Class Rate
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Rate in Rates Hours Variance III $17.20 $16.00 $1.20 550 $660 U II 15.00 14.00 1.00 650 $650 U I 10.80 10.00 0.80 375 $300 U Total $1,610 U b) Direct-labor efficiency variance for each labor class: Actual Standard Difference Standard Efficiency Labor Class Hours Hours * in Hours Rate Variance III 550 500 50 $16.00 $800 U II 650 500 150 14.00 $2,100 U I 375 500 (125) 10.00 $(1,250) F Total $1,650 U * Given April's output of production....
View Full Document

Ask a homework question - tutors are online