F G . H 1 J L M M N o Q R B38 Xfx A B D E 1 Standard Costing 2 3 Bob is looking to scale up his business creating custom bonsal trees out of twisted metal wire 4 He would like for you to evaluate the effectiveness of the four months of production. 5 Write a single sentence analysis of the DM variance and the DL variance, 6 7 8 9 Standard Costs 10 DM Cost per foot wire $2 11 DM Feet used per sculpture 10 ft 12 DL Cost per hour $20 13 DL Hours per sculpture 4 hours 14 Standard Cost 15 16 January February March April 17 Units Produced 100 200 150 100 18 19 Direct Materials 20 Per Unit 21 DM wire per unit ift) 10 10 11 11 22 DM price per unit (dollars) $2.00 $2.50 S2.00 $1.50 23 Total 24 Total wire Used (ft) 1,000 2.000 1,650 1.100 25 Total cost of wire (dollars) $10,000.00 $20,000.00 $18,150.00 $12,100.00 26 27 Direct Labor 28 Per Unit 29 DL hours per unit (hours) 4 3 2 2 30 DL salary per hour (dollars $20.00 $20.00 $30.00 $45.00 31 Total 32 Total hours used hours 400 600 300 200 33 Total salary (dollars) $40,000.00 $120,000.00 $45,000.00 $20,000.00 34 35 Total Variance 36 Per Unit 37 Standard Cost $50,000.00 $140,000.00 $63,150.00 $32,100.00 38 Actual Cost 39 Variance 40 Total 41 Variance 42 43 Variance Analysis - Direct Materials 44 Per unit 45 Actual Q Actual Price 46 Actual Standard Price 47 Standard Standard Price 48 DM Price Variance 49 DM Quantity Variance 50 DM Total Variance posu, negaf) 51 52 Total 53 DM Price Variance 54 DM Quantity Var. 55 Total 56 57 Variance Analysis - Direct Labor 58 Per unit 59 Actual Q* Actual Price 60 Actual Standard Price 61 Standard Standard Price 62 DM Price Variance 63 DM Quantity Variance 64 DM Total Variance pos=, neg=f) (=F) 65 66 Total 67 DL Price Variance Standard Cost Quy DRY Band rica U Quanti Vrance Hours RE . EL Dober Baterie 10.30 Diber Time varie . Total Laborare I.EU File Home Insert Page Layout Formulas Data Review View Help Acrobat V F G H 1 K L L M N o Standard Price Price Quay Price PriceVara Quantity Variance Tapet Materials wie U Standard Actu Hours Actu Mate Actual Hours 30 Standard and Standard More 16.10 08.00 15.00 Direct Labor Rate Variant Time Variance 00 Total Direct Labor Variance 51.100 B38 EX fx B D D E 34 35 Total Variance 36 Per Unit 37 Standard Cost $50,000.00 $140,000.00 $63,150.00 $32,100.00 38 | Actual Cost 39 Variance 40 Total 41 Variance 42 43 Variance Analysis - Direct Materials 44 Per unit 45 Actual Q * Actual Price 46 Actual Standard Price 47 Standard Q * Standard Price 48 DM Price Variance 49 DM Quantity Variance 50 DM Total Variance (pos=U, neg=F) 51 52 Total 53 DM Price Variance 54 DM Quantity Var. 55 Total 56 57 Variance Analysis - Direct Labor 58 Per unit 59 Actual Q* Actual Price 60 Actualq standard Price 61 Standard Standard Price 62 DM Price Variance 63 DM Quantity Variance 64 DM Total Variance (pos=U, neg=F) ( 65 66 Total 67 DL Price Variance 68 DL Quantity Var. 69 Total 70 71 Total Variance 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 F G . H 1 J L M M N o Q R B38 Xfx A B D E 1 Standard Costing 2 3 Bob is looking to scale up his business creating custom bonsal trees out of twisted metal wire 4 He would like for you to evaluate the effectiveness of the four months of production. 5 Write a single sentence analysis of the DM variance and the DL variance, 6 7 8 9 Standard Costs 10 DM Cost per foot wire $2 11 DM Feet used per sculpture 10 ft 12 DL Cost per hour $20 13 DL Hours per sculpture 4 hours 14 Standard Cost 15 16 January February March April 17 Units Produced 100 200 150 100 18 19 Direct Materials 20 Per Unit 21 DM wire per unit ift) 10 10 11 11 22 DM price per unit (dollars) $2.00 $2.50 S2.00 $1.50 23 Total 24 Total wire Used (ft) 1,000 2.000 1,650 1.100 25 Total cost of wire (dollars) $10,000.00 $20,000.00 $18,150.00 $12,100.00 26 27 Direct Labor 28 Per Unit 29 DL hours per unit (hours) 4 3 2 2 30 DL salary per hour (dollars $20.00 $20.00 $30.00 $45.00 31 Total 32 Total hours used hours 400 600 300 200 33 Total salary (dollars) $40,000.00 $120,000.00 $45,000.00 $20,000.00 34 35 Total Variance 36 Per Unit 37 Standard Cost $50,000.00 $140,000.00 $63,150.00 $32,100.00 38 Actual Cost 39 Variance 40 Total 41 Variance 42 43 Variance Analysis - Direct Materials 44 Per unit 45 Actual Q Actual Price 46 Actual Standard Price 47 Standard Standard Price 48 DM Price Variance 49 DM Quantity Variance 50 DM Total Variance posu, negaf) 51 52 Total 53 DM Price Variance 54 DM Quantity Var. 55 Total 56 57 Variance Analysis - Direct Labor 58 Per unit 59 Actual Q* Actual Price 60 Actual Standard Price 61 Standard Standard Price 62 DM Price Variance 63 DM Quantity Variance 64 DM Total Variance pos=, neg=f) (=F) 65 66 Total 67 DL Price Variance Standard Cost Quy DRY Band rica U Quanti Vrance Hours RE . EL Dober Baterie 10.30 Diber Time varie . Total Laborare I.EU File Home Insert Page Layout Formulas Data Review View Help Acrobat V F G H 1 K L L M N o Standard Price Price Quay Price PriceVara Quantity Variance Tapet Materials wie U Standard Actu Hours Actu Mate Actual Hours 30 Standard and Standard More 16.10 08.00 15.00 Direct Labor Rate Variant Time Variance 00 Total Direct Labor Variance 51.100 B38 EX fx B D D E 34 35 Total Variance 36 Per Unit 37 Standard Cost $50,000.00 $140,000.00 $63,150.00 $32,100.00 38 | Actual Cost 39 Variance 40 Total 41 Variance 42 43 Variance Analysis - Direct Materials 44 Per unit 45 Actual Q * Actual Price 46 Actual Standard Price 47 Standard Q * Standard Price 48 DM Price Variance 49 DM Quantity Variance 50 DM Total Variance (pos=U, neg=F) 51 52 Total 53 DM Price Variance 54 DM Quantity Var. 55 Total 56 57 Variance Analysis - Direct Labor 58 Per unit 59 Actual Q* Actual Price 60 Actualq standard Price 61 Standard Standard Price 62 DM Price Variance 63 DM Quantity Variance 64 DM Total Variance (pos=U, neg=F) ( 65 66 Total 67 DL Price Variance 68 DL Quantity Var. 69 Total 70 71 Total Variance 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100