A B D E $ $ $ 1 Information for Abbott Health Company who makes vaccines. 2 Budgeted 3 Average Selling Price Per Vial $ 8.30 4 Total Direct Materials Cost Per Vial $ 3.60 5 Direct Manufacturing Labor Cost Per Hour $ 15.00 6 Average labor productivity rate (vials per hour) 100.00 7 Sales commission cost per vial $ 0.72 8 Fixed administrative and manufacturing overhead $ 990,000 9 Sales in Units $ 700,000 10 Actual 8.20 3.90 15.20 90.00 0.70 1,100,000 630,000 $ $ $ 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Data Template + A B C D E F G H T J Static Budget 1 Part 1: Develop a Flexible Budget Performance Report for Abbott Health Company 2 Actual Flexible F/U Flexible Budget Sales F/U Budget Volume 3 Variance Variance 4 5 6 7 8 Total Variable Costs 9 Contribution Margin 10 11 Net Operating Income 12 13 Part 2: Calculate Total Static Budget Variance, Flexible Budget Variance, and Sales Volume Variance. 14 15 16 17 Total Static Budget Variance 18 19 20 21 Total Flexible Budget Variance Total Sales Volume Variance 22 23 24 Part 3: Calculate Direct Materials Price and Efficiency Variances Actual Input Qt X Budgeted Price Flexible Budget 25 Actual Costs Incurred 26 27 28 Direct Materials 29 30 31 32 Price Variance Efficiency Variance Data Template + A B E F G H I J 20 21 Total Flexible Budget Variance Total Sales Volume Variance 22 23 24 Part 3: Calculate Direct Materials Price and Efficiency Variances Flexible Budget Flexible Budget 25 Actual Costs Incurred Actual Input Qt X Budgeted Price 26 27 28 Direct Materials 29 30 Price Variance Efficiency Variance 31 32 33 Flexible Budget Variance 34 35 Part 3: Calculate Direct Manufacturing Labor Price and Efficiency Variances 36 37 38 Actual Costs Incurred Actual Input Qt X Budgeted Price 39 40 41 Direct Manufacturing Labor 42 43 Price Variance Efficiency Variance 44 45 46 Flexible Budget Variance 47 48 49 50 51 52 53 54 Data Template +