Question

In: Accounting

Variance Analysis Question The Glass Vessel Company has established the following budget for producing one of...

Variance Analysis Question The Glass Vessel Company has established the following budget for producing one of its handblown vases: Materials (silica) 2 pounds @ 1.25 per pound Labor 1.5 hours @ $15.00 per hour In March of the most recent year, Glass Vessel produced 300 vases using 650 pounds of materials. Glass Vessel purchased the 650 pounds of materials for $845. Actual total labor costs for March were $7,200, which entailed 480 hours of labor. Please answer both of the following questions:


Materials (silica) 2 pounds @ 1.25 per pound
Labor 1.5 hours @ $15.00 per hour

1. What was Glass Vessel’s flexible budget variance for materials in March? (As part of your answer, please indicate whether this variance was favorable or unfavorable.)

2. What was Glass Vessel’s labor efficiency/usage variance for March? (As part of your answer, indicate whether this variance was favorable or unfavorable.)

Must show work

Solutions

Expert Solution

  1. Material variance:

Material cost variance is the difference between standard cost for actual output produced and the actual cost of materials.

Material cost variance = (SQ*SP) – (AQ*AP)

Where SQ = Standard quantity for actual output, AQ = Actual quantity, SP = Standard Price and AP = Actual price.

This material cost variance can be subdivided into material price variance and material usage variance.

Material price variance = AQ*(SP – AP)

Material usage variance = SP (SQ-AQ)

In the problem, it is given that materials 2 pounds @ 1.25 per pound.

Therefore, SP = $1.25 and SQ per unit = 2 pounds.

It is given that Glass vessel produced 300 vases using 650 pounds of material.

Therefore, AQ = 650 pounds and actual output = 300 vases.

Therefore SQ for actual output = (SQ per unit)*(Actual output) = (2 pounds)*(300 vases) = 600 pounds.

It is given that Glass vessel purchased 650 pounds of material for $845.

Therefore Actual price = $845/650 pounds = $ 1.3

SP = $1.25 and AP = $1.3

SQ = 600 pounds and AQ = 650 pounds.

Material cost variance = (SQ*SP) – (AQ*AP)

Material price variance = AQ*(SP – AP)

Material usage variance = SP (SQ-AQ)

Material cost variance (MCV) = (600*1.25) – (650*1.3) = -95 (Unfavorable)

Material price variance (MPV) = 650*(1.25 – 1.3) = -32.5 (Unfavorable)

Material usage variance (MUV) = 1.25 (600-650) = -62.5 (Unfavorable).

Verification:

MCV = MPV + MUV = (-32.5) + (-62.5) = -95.

  1. Labor variances:

Labor cost variance is the difference between standard labor cost and the actual cost.

Labor cost variance = (SH*SR) – (AH*AR)

Where SH = Standard hours for actual output, AH = Actual hours, SR = Standard rate and AR = Actual rate.

Labor cost variance can be subdivided into Labor rate variance and Labor efficiency variance.

Labor rate variance = AH*(SR-AR)

Labor efficiency variance = SR*(SH – AH)

It is given that Labor 1.5 hours @ $15 per hour is the standard.

Therefore, SR = $15 and SH per unit = 1.5 hours.

SH for actual output = SH per unit * actual output = 1.5 * 300 = 450 hours.

It is given that the actual total labor costs for March were $7200, which entailed 480 hours of labor.

Therefore, AH = 480 hours. AR = Labor cost / labor hours = 7200/480 = $15.

SH = 450 hours, AH = 480 hours, SR = $15 and AR = $15.

Here, standard rate and actual rate are same. Therefore the labor rate variance is NIL. So the entire labor variance will come under labor efficiency variance.

Labor cost variance = (SH*SR) – (AH*AR)

Labor rate variance = AH*(SR-AR)

Labor efficiency variance = SR*(SH – AH)

Labor cost variance = (450*15) – (480*15) = -450 (Unfavorable)

Labor rate variance = 480*(15-15) = 0

Labor efficiency variance = 15*(450 – 480) = -450 (Unfavorable).


Related Solutions

QUESTION 27 Company R has produced the following variance analysis report. If Company R has a...
QUESTION 27 Company R has produced the following variance analysis report. If Company R has a policy to investigate variances over 10% of the flexible budget, which variances should be investigated? Actual Flexible budget Budget Variance Price Variance Quantity Variance DM $78,580 $88,000 ($9,420) F $1,200 U ($10,620) F DL $123580 $145,000 ($21,420) F ($2,650) F ($18,770) F VOH $126,860 $119,000 $7,860 U ($5,560) F $2,300 U The direct materials quantity variance and the direct labor efficiency variance. The direct...
Glass CC is a supplier of glass containers and has the following sales budget for the...
Glass CC is a supplier of glass containers and has the following sales budget for the coming year: Month Sales Value (Rands) January 300 000 February 315 000 March 345 000 April 367 500 The sales price per unit is R15; the cost of sales is 60% of sales. Glass CC keeps inventory equal to the coming month's budgeted sales requirements. It pays for purchases 55% in the month of purchase and 45% in the month after purchase. Inventory at...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for March 2018. Master Budget for March 2018 Sales volume………………………...……………….2,100 diskettes Average selling price per diskette……………………$5.00/diskette DM costs per diskette………………………………..$0.85/diskette DM cost per lb……………………………….$17.00/lb DM per diskette……………………………..0.05 lb/diskette Direct Labor: Direct labor cost per hour……………………..$15.00/hr # of diskettes produced per labor hour……….. 30 diskettes Direct Marketing costs………………………………$0.30 /diskette Fixed overhead costs………………………………..$850/month Actual for March 2018 Sales volume ………………………………………..1,800 diskettes Average selling price………………………………..$4,80/diskette DM costs per...
Question : Variance Analysis The following standard cost data relate to the operation of Dragon Company...
Question : Variance Analysis The following standard cost data relate to the operation of Dragon Company for 2016. The standard cost per unit is based on the normal annual production of 15,000 units. Standard cost per unit Direct materials 4kg @ $5.00 per kg $   20.00 Direct labour 2hrs @ $12.50 per hr $   25.00 Variable overhead 2hrs @ $3.00 per hr $   6.00 Fixed overhead 2 labour hrs @ $5.00 per hr $   10.00 Total $   61.00 Actual production...
XYZ Ltd has established the following standard mix for producing 9 gallons of A       ...
XYZ Ltd has established the following standard mix for producing 9 gallons of A                            GH 5 gallons –material X at GHc 7 per gallon        35 3 gallons –Material Y at GHc 5 per gallon        14 2 gallons- Material Z at GHc 2 per gallon        4 A standard loss of 10% of input is expected to occur. Actual input was: Material X-53,000 gallons at Ghc 7 per gallon...
Variance Analysis Peter Enterprises has collected the following data on one of its products. During the...
Variance Analysis Peter Enterprises has collected the following data on one of its products. During the period the company produced生产了(件) 25,000 units. The direct materials quantity variance 直接原材料数量差异is: Direct materials standard (7 kg. @ $2.05/kg) $14.35 per finished unit Actual cost of materials purchased $332,150 Actual direct materials purchased and used 151,000 kg Multiple Choice $22,600 favorable. $26,600 unfavorable. $49,200 favorable. $49,200 unfavorable. $22,600 unfavorable.
17. A manufacturing company that has only one product has established the following standards for its...
17. A manufacturing company that has only one product has established the following standards for its variable manufacturing overhead. Variable manufacturing overhead standards are based on machine-hours.   Standard hours per unit of output 4.40 machine-hours   Standard variable overhead rate $11.55 per machine-hour The following data pertain to operations for the last month:   Actual hours 8,800 machine-hours   Actual total variable manufacturing overhead cost $95,910   Actual output 1,900 units What is the variable overhead efficiency variance for the month? $2,832 U $7,293...
Gandolph Game Company has established the following standards for the prime costs of one unit of...
Gandolph Game Company has established the following standards for the prime costs of one unit of its chief product, dartboards. Standard Cost Standard Quantity Standard Price or Rate Direct material $ 5.00 5.00 kilograms $ 1.00 per kilogram Direct labor 1.00 0.20 hour $ 5.00 per hour Total $ 6.00 During September, Gandolph purchased 195,000 kilograms of direct material at a total cost of $214,500. The total wages for September were $40,404, 75 percent of which were for direct labor....
Reflector Glass Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6 comma...
Reflector Glass Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6 comma 0006,000 Per Unit Sales Revenue $ 5.00$5.00 $ 30 comma 000$30,000 Variable Costs 1.501.50 9 comma 0009,000 Contribution Margin 21 comma 00021,000 Fixed Costs 4 comma 0004,000 Operating​ Income/(Loss) $ 17 comma 000$17,000 If a flexible budget is prepared at a volume of 8 comma 9008,900 ​units, calculate the amount of operating income. The production level is within the relevant range. A. $ 4...
Discuss the purpose of a budget and cost variance analysis. Why is it important for companies...
Discuss the purpose of a budget and cost variance analysis. Why is it important for companies to create a budget then determine if they met budgeted costs? For example, is it always a negative variance if a company exceeds budgets? Give me an example of why a cost falling below expectations (actual cost below budgeted cost) may still be a problem even if it appears to increase profit.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT