What is the percentage over standard by company and by variance? Untitled - Paint File Home View

What is the percentage over standard by company and by variance?

Transcribed Image Text:

Untitled - Paint File Home View Jx A B C D E F G K9 1 Carrylt Inc AutoSave Off E Tejada_ACT460_mod6 opt 1 - Excel Sign in File Home Insert Page Layout Formulas Data Review View Help O Tell me X fx A B C D E F G H 2 Unit Variable Cost Item Star Goldbag PromoTotes Industry Carrylt 30 3. Price and Efficiency variance 3 Company Corporation LLC Data Inc Efficiency Variance 31 4 Labor Hours 5 Labor Rate ($ per hour) 0.35 0.20 0.30 0.30 0.25 Star Goldbag Company Corporation LLC PromoTotes Carrylt Inc 11.25 11.95 12.50 11.65 11.75 32 Labor 6 Materials Input (yards) 0.45 0.68 0.50 0.55 0.50 33 Actual 0.35 0.20 0.30 0.25 7 Materials Price ($ per yard) 1.65 1.35 1.55 1.50 1.50 34 Standard 0.30 0.30 0.30 0.30 Variable Overhead (OH) rate (per direct 6.00 5.25 4.70 5.45 5.00 35 Standard Rate 11.65 11.65 11.65 11.65 8 labor hour) 36 Variance (actual-standard)*rate 0.5825 -1.165 0 -0.5825 37 Material 9 38 Actual 0.45 0.68 0.50 0.50 10 39 Standard 0.55 0.55 0.55 0.55 11 1. Total variable cost per unit Star Goldbag PromoTotes Industry 40 Standard Rate 1.50 1.50 1.50 1.50 12 13 Labor Hours 14 Labor Rate (cost/hour) Company Corporation LLC Data Carrylt Inc 41 Variance (actual-standard)*rate -0.15 0.1875 -0.075 -0.075 42 Variable Overhead 0.35 0.20 0.30 0.30 0.25 43 Actual 11.25 11.95 12.50 11.65 11.75 15 Labor cost per unit (a) 44 Standard 3.94 2.39 3.75 3.50 2.94 16 Material Input 45 Standard Rate 0.45 0.68 0.50 0.55 0.50 17 Materials Price (cost/yard) 1.65 1.35 1.55 1.50 1.50 46 Variance (actual-standard)*rate 0.35 0.20 0.30 0.25 0.30 0.30 0.30 0.30 5.45 5.45 5.45 5.45 0.2725 -0.545 0 -0.2725 47 18 Materials cost per unit (b) 0.74 0.91 0.78 0.83 0.75 **Negative Variance is favorable, doing better then average 48 19 Labor Hour 0.35 0.20 0.30 0.30 0.25 20 Variable OH per labor hour 6.00 5.25 4.70 5.45 5.00 Price Variance 21 Variable OH per unit (c) 49 2.10 1.05 1.41 1.64 1.25 Star Goldbag PromoTotes Company Corporation LLC Carrylt Inc 22 Variable cost (a+b+c) (d) 50 Labor 6.78 4.35 5.94 5.96 4.94 51 Actual Cost 11.25 11.95 12.50 11.75 23 52 Standard Cost 11.65 11.65 11.65 11.65 24 2. Percentage of total for each component Star Goldbag PromoTotes 25 Company Corporation LLC Industry Data Carrylt Inc 53 Actual Hours 0.35 0.20 0.30 0.25 54 Variance (actual-standard)* actual hrs -0.14 0.06 0.255 0.025 26 Labor cost per unit (a/d) 58.08% 54.93% 27 Materials cost per unit (b/d) 10.95% 20.94% 28 Variable OH per unit (c/d) 30.97% 24.13% 63.18% 58.69% 59.49% 13.06% 13.85% 15.19% 27.46% 23.76% 25.32% 55 Material 56 Actual Cost 1.65 1.35 1.55 1.50 57 Standard Cost 1.50 1.50 1.50 1.50 29 58 Actual Quantity 0.45 0.68 0.50 0.50 30 3. Price and Efficiency variance Sheet1 Select destination and press ENTER or choose Paste < 59 Variance (actual-standard)* actual qty 60 Variable Overhead 0.0675 -0.10125 0.025 0 Sheet1 (+ Ready + E 1920 x 1080px S X Share + 100% Display Settings 100% 2:02 PM 88 11/21/2018 (+ Untitled - Paint File Home View Jx A B C D E F G K9 1 Carrylt Inc AutoSave Off E Tejada_ACT460_mod6 opt 1 - Excel Sign in File Home Insert Page Layout Formulas Data Review View Help O Tell me X fx A B C D E F G H 2 Unit Variable Cost Item Star Goldbag PromoTotes Industry Carrylt 30 3. Price and Efficiency variance 3 Company Corporation LLC Data Inc Efficiency Variance 31 4 Labor Hours 5 Labor Rate ($ per hour) 0.35 0.20 0.30 0.30 0.25 Star Goldbag Company Corporation LLC PromoTotes Carrylt Inc 11.25 11.95 12.50 11.65 11.75 32 Labor 6 Materials Input (yards) 0.45 0.68 0.50 0.55 0.50 33 Actual 0.35 0.20 0.30 0.25 7 Materials Price ($ per yard) 1.65 1.35 1.55 1.50 1.50 34 Standard 0.30 0.30 0.30 0.30 Variable Overhead (OH) rate (per direct 6.00 5.25 4.70 5.45 5.00 35 Standard Rate 11.65 11.65 11.65 11.65 8 labor hour) 36 Variance (actual-standard)*rate 0.5825 -1.165 0 -0.5825 37 Material 9 38 Actual 0.45 0.68 0.50 0.50 10 39 Standard 0.55 0.55 0.55 0.55 11 1. Total variable cost per unit Star Goldbag PromoTotes Industry 40 Standard Rate 1.50 1.50 1.50 1.50 12 13 Labor Hours 14 Labor Rate (cost/hour) Company Corporation LLC Data Carrylt Inc 41 Variance (actual-standard)*rate -0.15 0.1875 -0.075 -0.075 42 Variable Overhead 0.35 0.20 0.30 0.30 0.25 43 Actual 11.25 11.95 12.50 11.65 11.75 15 Labor cost per unit (a) 44 Standard 3.94 2.39 3.75 3.50 2.94 16 Material Input 45 Standard Rate 0.45 0.68 0.50 0.55 0.50 17 Materials Price (cost/yard) 1.65 1.35 1.55 1.50 1.50 46 Variance (actual-standard)*rate 0.35 0.20 0.30 0.25 0.30 0.30 0.30 0.30 5.45 5.45 5.45 5.45 0.2725 -0.545 0 -0.2725 47 18 Materials cost per unit (b) 0.74 0.91 0.78 0.83 0.75 **Negative Variance is favorable, doing better then average 48 19 Labor Hour 0.35 0.20 0.30 0.30 0.25 20 Variable OH per labor hour 6.00 5.25 4.70 5.45 5.00 Price Variance 21 Variable OH per unit (c) 49 2.10 1.05 1.41 1.64 1.25 Star Goldbag PromoTotes Company Corporation LLC Carrylt Inc 22 Variable cost (a+b+c) (d) 50 Labor 6.78 4.35 5.94 5.96 4.94 51 Actual Cost 11.25 11.95 12.50 11.75 23 52 Standard Cost 11.65 11.65 11.65 11.65 24 2. Percentage of total for each component Star Goldbag PromoTotes 25 Company Corporation LLC Industry Data Carrylt Inc 53 Actual Hours 0.35 0.20 0.30 0.25 54 Variance (actual-standard)* actual hrs -0.14 0.06 0.255 0.025 26 Labor cost per unit (a/d) 58.08% 54.93% 27 Materials cost per unit (b/d) 10.95% 20.94% 28 Variable OH per unit (c/d) 30.97% 24.13% 63.18% 58.69% 59.49% 13.06% 13.85% 15.19% 27.46% 23.76% 25.32% 55 Material 56 Actual Cost 1.65 1.35 1.55 1.50 57 Standard Cost 1.50 1.50 1.50 1.50 29 58 Actual Quantity 0.45 0.68 0.50 0.50 30 3. Price and Efficiency variance Sheet1 Select destination and press ENTER or choose Paste < 59 Variance (actual-standard)* actual qty 60 Variable Overhead 0.0675 -0.10125 0.025 0 Sheet1 (+ Ready + E 1920 x 1080px S X Share + 100% Display Settings 100% 2:02 PM 88 11/21/2018 (+