50.1K

Verified Solution

Link Copied!

Please give me formula on excel Thanks

Information for Abbott Health Company who makes vaccines. Average Selling Price Per Vial Total Direct Materials Cost Per Vial Direct Manufacturing Labor Cost Per Hour Average labor productivity rate (vials per hour) Sales commission cost per vial Fixed administrative and manufacturing overhead Sales in Units Budgeted $ 8.30 $ $ 3.60 $ $ 15.00 $ 100.00 $ 0.72 $ $ 990,000 $ $ 700,000 $ Actual 8.20 3.90 15.20 90.00 0.70 1,100,000 630,000 Part 1: Develop a Flexible Budget Performance Report for Abbott Health Company Actual F/U Flexible Budget F/U Static Budget Flexible Budget Variance Sales Volume Variance Total Variable Costs Contribution Margin Net Operating Income Part 2: Calculate Total Static Budget Variance, Flexible Budget Variance, and Sales Volume Variance. Total Static Budget Variance Total Flexible Budget Variance Total Sales Volume Variance Part 3: Calculate Direct Materials Price and Efficiency Variances Actual Costs Incurred Actual Input Qt X Budgeted Price Flexible Budget Direct Materials Price Variance Efficiency Variance Flexible Budget Variance Part 3: Calculate Direct Manufacturing Labor Price and Efficiency Variances Actual Costs Incurred Actual Input Qt X Budgeted Price Flexible Budget Direct Manufacturing Labor Price Variance Efficiency Variance Flexible Budget Variance

Answer & Explanation Solved by verified expert

See Answer