can not get formulas right pls help Basic Veriance Analyse and the Impact of Var

Question

can not get formulas right pls
help

Basic Veriance Analyse and the Impact of Variances on Unt Casts e HOME | INSERT PAGE LAYOUT FORMULAS DATA REV?EW VIEW BIUB.A Aignment Namber Condtional Format as Cell Cels Edtia Formatting Table Styles oard Styles tandards far one of Patterson, Inc.'s products is shown below, along with actual cost data for the month: rect materials: andard ctual irect labor: tandard ctual riable overhead: tandard ctual 2.4 yards @ $6,60 $%2.75 per yard $2.7D per yard 3 yards e $8.10 0.6 hours @ 0.5 hours é $18.00 per hour $22.00 per hour 10.80 0.6 hours 0.5 hours g $7.00 per hour $7.10 per hour 4.20 3.55 tal cost per unit $21.00 $2265 xcess of actual cost over standard cost per unit $1.05 ctual production for the month ariable overhead is assigned to products based on direct abor haurs There as no beginning ar ending imentory of materials far the manth 13,500 units ing formulas, compute the foilowng. Input all numbers as positive amounts dicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use cell ferences (formulas] for cells D53 -D60. Enter an F or U to indicate the correct varlance in cells Sheetl. ptis) eterenceseBook & Resources box 11) dracsla

Explanation / Answer

1 Actual rate 2.7 Per yard Direct material price variance = (Standard rate - Actual rate) * Actual quantity Direct material price variance = (2.75-2.70) * 13500*3 Direct material price variance = 2025 Favorable 2 Standard Material for actual production 13500*2.4 32,400 Yards Direct material quantity variance=   ( Actual material - Standard material for acual production) *Standard rate Direct material quantity variance=   (13500*3-32400)* 2.75 22275 UnFavorable 3 Actual rate 22.00 per hour Labor rate variance = (Actual rate -Standard rate) * Actual hours Labor rate variance = (22 - 18) * 13500*.5 27000 unFavorable 4 Standard labor hours for actual production 13500*.6 8,100 Hours Labor Effeciency variance= (Standard hours for acual production -Actual hours) *Standard rate Labor Effeciency variance= (8100 - 13500*.5)* 18 24300 Favorable 5 Actual rate 7.10 per hour (145600/55800) Variable overhead rate variance = (Actual rate -Standard rate) * Actual hours Variable overhead rate variance = (7.10 - 7) * 13500*.5 675 UnFavorable 6 Standard labor hours for actual production 13500*.6 8,100 Hours Variable OH Effeciency variance=   (Standard hours for acual production -Actual hours) *Standard rate Variable OH Effeciency variance=   (8100-13500*.5)* 7 9450 Favorable

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.