A B E H J L K - M N o a ? ? ? Copy Formulas Data 4 Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price 6 Direct materials 3.0 pounds $4.00 per pound 7 Direct labar 0.60 hours $22.00 per hour 8 Variable manufacturing overhead 0.50 hours $8.00 per hour 9 10 Actual results: 11 Actual output 2,000 unis 12 Actual variable manufacturing overhead cost $7,140 13 AE : 4/ Di 1 ty Actualurico 14 Actual direct materials cost 8,500 pounds $3,80 per pound 15 Actual direct labor cost 1,050 hours $21.50 per hour 16 17 Enter a formule into each of the green cells marked with a ? below. Once complete use the "Copy Formula " button. 18 Main Example: Chapter 10 19 20 Exhibir 10-4: Standard Cost Variance Analysis - Direct Materials 21 Standard Quantity Aloned for the Actual Output at Standard Price 2 pounds 7 per pound 22 Actual Quantity of Input, at Standard Price ? pounds ? per pound - 23 Actual Quantity of Inout at Actual Price 7 pounds 7 per pound = 24 Direct materials variances Formula example 25 Materials quan ly variance for variances: ? 26 Materials price variance -AB5(F22-F211 27 Materials spending variance ? 28 29 Exhibit 10-6: Standard Cost Variance Analysis - Direct Labor 30 Standard Hours Alowed for the Actual Output, at Standard Rate 7 hours ? per hour - 31 Actual Hours of Input. at Standard Rate ? hours ? per hour Actual Hours of input, at Actual Rate ? hourg x ? per hour 33 Direct labor verlancas 34 Labor clancy variance ? 35 Laborrate variance 7 ? 36 labor spending variance 37 Exhibit 10-8: Standard Cost Variance Analysis - Variable Manufacturing Overhead 39 Standard Hours Alowed for the Actual Output. at Standard Ralu 7 hours 7 per hour 40 Actual Hours of input, at Standard Rale 7 hours ? per hour 41 Actual Hours of Input, at Actual Rale ? hours ? per hour 42 Variable overhead variances 43 Variable overhead eliciency variance ? 44 Variable overhead rale variance ? 45 Variable overhead spending variance ? 46 42 Formulas Req 1 Chlo A Req2 Ch10 + ? ? ? ? ? ? ? # AP + 10% B6 A C F G P 1 3 U Chapter 10: Applying to Hiirement Rec Enter 2.9 pounds for the direct materials, hours for direct labor, and hours to variable manufacturing overhead in the preences to the left If your formulasare correct, the materials spending varlance should now be $1,500 U, the labor spending variance $3,720 F, and the varbatie overhead spending varbancestor, if not, got the previnus sheet correct your formules, and is the copy formules button until your answers are correct De Exhibit 10-T: Star Cart Card inte 4 5 entham Stardo.widy 2 pound 9 hours 7 Direct labor Marul H 4 4 4 4 4 tra H'hew 522.00 per hour Super What is the material quantity variance? 10 Actuslaus. 11 A.0 12 Adoua variabk mufacturing and cost 12 14 Ada direct aterials oot 15 ALA direct ! 16 17 18 Main Example: Chapter 10 2.000 uts 57,140 Actual Quant 6.500 pounds 1,060 hours Aerul loc $3.30 per pound $21.50 per hour Explain the variance above 7 pounds ? pour de 7 pounds 7 per pound - ? per round- 7 per pound ? ? 7 What is the labor rote varlare? 20 Exiv 10-4 Standard Cost Variance Analysis Oleor Moserials 21 Standard Quarity Allowed for the Actual Otput st Standard Price Z2 Actual cantity of input st Standard Price 23 votuala.antity of input at Actual Price 2 w RNH Malatya 26 Mar PVNER Maling V ? ? ? Explain the vartance above ? hur 7 hom ? routs ? per hour - 7 per tour - ? PH tour - ? ? ? 28 Exhibit 10-6: Standard Cost Variance Analysis-irect Labor Stancard or Alowed for the Alus Dupu. Standard Rale 31 AHLIN de Palm 32 Allu A. Ral 33 Diwal labor van 34 LABO kay walance 35 LABOr mate van 35 LADO sending van 37 Exhibit 10-8. Starde Cast Vwiance Anywa-Varimbia wafuciuring Dard 39 Standard Hours Allowed for the actual Outpu., Standard Rate 40 Actual Hours of Inpu... Standard Rale 41 Actual Hours of Input Adal Rate L2 Varkable overhead vartences Varlack overhead elliciency variance 44 Variable overhead rale variance 5 Variable overhead pendir variance 7 hours 7 hours 7 hours 7 per hour 7 per hour 7 per hou ? 7 7 7 7 Formulas Reg 1 Ch10 Req 2 Chio + 90% B11 11 C 0 F 5 U A Chapter 10: Applying to Hirement I M N Reg. 2: Enter the stata for requirement in the green cells to the lettas given at the bottom of pace171 in the tratta What is the materials quantity varbance Siinta 94.00 pound Stand und 30 pound 0.50 0. 0.50 hora 56.00 per hour . 13 lunes What is the materials price vrie? Data 4 Why 10-1 Stanton Cat Cand 5 inte 6 Dieci mi 7 Direct labor 3 vaitle fan fatig irataai 9 10 A Actualpu 12 Actua variatik mufacturing overhead cost 12 14 Acoua direct material oost 15 Acta dret abr 0061 16 17 18 Main Example: Chapter 10 19 20 Exiv 10-4 Standard Cost Variance Analysis Oleor Moserials 21 Standard Quarity Allowed for the Actual Otput st Standard Price Actual antity of input at Standard Price 2 Actual antity of input at Actual Price 24 Del materials variances Materials and variance 26 Malas BAVNO 27 Maling VCH Actus Candy 7 pounds 7 ho.rs Actual prop ? per pound ? per hour What is the labor offklany variance? 7 pounds ? ponds rants ? per pour ? per pound 7 per pound - What is the labor rate variance? 7 3 > 28 Exhibit 10-6: Standard Cost Variance Analysis-irect Labor 30 SHH Hours Almelor i slud Dupu. Bit Pals 31 AH Ben Pin S2 Actual Hours of Input Antal Rate ? huru ? . ? . ? IF Par- 7 urhur 7 What is the variable cuerhend efficiency varbance ? 7 7 7 0.1 . What is the variable overler varlane 54 Laeir efeine 35 Lnut rats variaras| 35 LADO Andha van 37 Exhibit 10-8. Starre Card Vwiance Anwlywa-Variable wcfuring Oward 39 Stand Hours Allowed for it alud Dupu... Bi Rain 40 Actual Hours of Inpu... Standard Rale 41 Actual Hours of Input Adal Rate L2 Varkable overhead vakances Variak overtices eliciency valence 44 Variak overhead rale variance 5 Variable overhead spending variance ? ? per hour ? per hour 7 ho.rs 7 hours x ? ? 7 7 7 47 Formulas Reg 1 Ch10 Reg 2 Ch 10 + 90% A B E H J L K - M N o a ? ? ? Copy Formulas Data 4 Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price 6 Direct materials 3.0 pounds $4.00 per pound 7 Direct labar 0.60 hours $22.00 per hour 8 Variable manufacturing overhead 0.50 hours $8.00 per hour 9 10 Actual results: 11 Actual output 2,000 unis 12 Actual variable manufacturing overhead cost $7,140 13 AE : 4/ Di 1 ty Actualurico 14 Actual direct materials cost 8,500 pounds $3,80 per pound 15 Actual direct labor cost 1,050 hours $21.50 per hour 16 17 Enter a formule into each of the green cells marked with a ? below. Once complete use the "Copy Formula " button. 18 Main Example: Chapter 10 19 20 Exhibir 10-4: Standard Cost Variance Analysis - Direct Materials 21 Standard Quantity Aloned for the Actual Output at Standard Price 2 pounds 7 per pound 22 Actual Quantity of Input, at Standard Price ? pounds ? per pound - 23 Actual Quantity of Inout at Actual Price 7 pounds 7 per pound = 24 Direct materials variances Formula example 25 Materials quan ly variance for variances: ? 26 Materials price variance -AB5(F22-F211 27 Materials spending variance ? 28 29 Exhibit 10-6: Standard Cost Variance Analysis - Direct Labor 30 Standard Hours Alowed for the Actual Output, at Standard Rate 7 hours ? per hour - 31 Actual Hours of Input. at Standard Rate ? hours ? per hour Actual Hours of input, at Actual Rate ? hourg x ? per hour 33 Direct labor verlancas 34 Labor clancy variance ? 35 Laborrate variance 7 ? 36 labor spending variance 37 Exhibit 10-8: Standard Cost Variance Analysis - Variable Manufacturing Overhead 39 Standard Hours Alowed for the Actual Output. at Standard Ralu 7 hours 7 per hour 40 Actual Hours of input, at Standard Rale 7 hours ? per hour 41 Actual Hours of Input, at Actual Rale ? hours ? per hour 42 Variable overhead variances 43 Variable overhead eliciency variance ? 44 Variable overhead rale variance ? 45 Variable overhead spending variance ? 46 42 Formulas Req 1 Chlo A Req2 Ch10 + ? ? ? ? ? ? ? # AP + 10% B6 A C F G P 1 3 U Chapter 10: Applying to Hiirement Rec Enter 2.9 pounds for the direct materials, hours for direct labor, and hours to variable manufacturing overhead in the preences to the left If your formulasare correct, the materials spending varlance should now be $1,500 U, the labor spending variance $3,720 F, and the varbatie overhead spending varbancestor, if not, got the previnus sheet correct your formules, and is the copy formules button until your answers are correct De Exhibit 10-T: Star Cart Card inte 4 5 entham Stardo.widy 2 pound 9 hours 7 Direct labor Marul H 4 4 4 4 4 tra H'hew 522.00 per hour Super What is the material quantity variance? 10 Actuslaus. 11 A.0 12 Adoua variabk mufacturing and cost 12 14 Ada direct aterials oot 15 ALA direct ! 16 17 18 Main Example: Chapter 10 2.000 uts 57,140 Actual Quant 6.500 pounds 1,060 hours Aerul loc $3.30 per pound $21.50 per hour Explain the variance above 7 pounds ? pour de 7 pounds 7 per pound - ? per round- 7 per pound ? ? 7 What is the labor rote varlare? 20 Exiv 10-4 Standard Cost Variance Analysis Oleor Moserials 21 Standard Quarity Allowed for the Actual Otput st Standard Price Z2 Actual cantity of input st Standard Price 23 votuala.antity of input at Actual Price 2 w RNH Malatya 26 Mar PVNER Maling V ? ? ? Explain the vartance above ? hur 7 hom ? routs ? per hour - 7 per tour - ? PH tour - ? ? ? 28 Exhibit 10-6: Standard Cost Variance Analysis-irect Labor Stancard or Alowed for the Alus Dupu. Standard Rale 31 AHLIN de Palm 32 Allu A. Ral 33 Diwal labor van 34 LABO kay walance 35 LABOr mate van 35 LADO sending van 37 Exhibit 10-8. Starde Cast Vwiance Anywa-Varimbia wafuciuring Dard 39 Standard Hours Allowed for the actual Outpu., Standard Rate 40 Actual Hours of Inpu... Standard Rale 41 Actual Hours of Input Adal Rate L2 Varkable overhead vartences Varlack overhead elliciency variance 44 Variable overhead rale variance 5 Variable overhead pendir variance 7 hours 7 hours 7 hours 7 per hour 7 per hour 7 per hou ? 7 7 7 7 Formulas Reg 1 Ch10 Req 2 Chio + 90% B11 11 C 0 F 5 U A Chapter 10: Applying to Hirement I M N Reg. 2: Enter the stata for requirement in the green cells to the lettas given at the bottom of pace171 in the tratta What is the materials quantity varbance Siinta 94.00 pound Stand und 30 pound 0.50 0. 0.50 hora 56.00 per hour . 13 lunes What is the materials price vrie? Data 4 Why 10-1 Stanton Cat Cand 5 inte 6 Dieci mi 7 Direct labor 3 vaitle fan fatig irataai 9 10 A Actualpu 12 Actua variatik mufacturing overhead cost 12 14 Acoua direct material oost 15 Acta dret abr 0061 16 17 18 Main Example: Chapter 10 19 20 Exiv 10-4 Standard Cost Variance Analysis Oleor Moserials 21 Standard Quarity Allowed for the Actual Otput st Standard Price Actual antity of input at Standard Price 2 Actual antity of input at Actual Price 24 Del materials variances Materials and variance 26 Malas BAVNO 27 Maling VCH Actus Candy 7 pounds 7 ho.rs Actual prop ? per pound ? per hour What is the labor offklany variance? 7 pounds ? ponds rants ? per pour ? per pound 7 per pound - What is the labor rate variance? 7 3 > 28 Exhibit 10-6: Standard Cost Variance Analysis-irect Labor 30 SHH Hours Almelor i slud Dupu. Bit Pals 31 AH Ben Pin S2 Actual Hours of Input Antal Rate ? huru ? . ? . ? IF Par- 7 urhur 7 What is the variable cuerhend efficiency varbance ? 7 7 7 0.1 . What is the variable overler varlane 54 Laeir efeine 35 Lnut rats variaras| 35 LADO Andha van 37 Exhibit 10-8. Starre Card Vwiance Anwlywa-Variable wcfuring Oward 39 Stand Hours Allowed for it alud Dupu... Bi Rain 40 Actual Hours of Inpu... Standard Rale 41 Actual Hours of Input Adal Rate L2 Varkable overhead vakances Variak overtices eliciency valence 44 Variak overhead rale variance 5 Variable overhead spending variance ? ? per hour ? per hour 7 ho.rs 7 hours x ? ? 7 7 7 47 Formulas Reg 1 Ch10 Reg 2 Ch 10 + 90%