Question: 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

 Please give me formula on excel Thanks Information for Abbott HealthCompany who makes vaccines. Average Selling Price Per Vial Total Direct Materials

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!