Build_a_Spreadsheet_10_28

Build_a_Spreadsheet_10_28 - Direct-material quantity...

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

View Full Document Right Arrow Icon
DATA INPUT Standard Direct labor: Standard Direct material: Quantity 0.25 hour Quantity 4 kilograms Rate $16.00 per hour Price $0.80 per kilogram Actual data: Material purchases 240,000 kilograms Price $0.81 per kilogram Actual costs incurred in the production of: 50,000 units were as follows: Direct labor: $211,900 for 13,000 hours Direct material: $170,100 for 210,000 kilograms SOLUTION 1. Direct-material price variance = PQ x (AP - SP) = 240,000 x $0.81 - $0.80 = $2,400 Unfavorable
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Direct-material quantity variance = SP x (AQ - SQ*) = $0.80 x 210,000 -200,000 = $8,000 Unfavorable * SQ = 200,000 kgs = 50,000 units x 4 kgs per unit Direct-labor rate variance = AH x (AR*-SR) = 13,000 x $16.30 -$16.00 = $3,900 Unfavorable * AR = $211,900 / $13,000 = $16.30 Direct-labor rate variance = SR x (AH - SH*) = $16.00 x 13,000 -12,500 = $8,000 Unfavorable * SH = 12,500 hrs. = 50,000 units x 0.25 hrs per unit...
View Full Document

This note was uploaded on 02/29/2012 for the course E 101 taught by Professor Sfere during the Spring '12 term at Abilene Christian University.

Ask a homework question - tutors are online