Question: Comprehensive variance analysis review. Ellis Animal Health, Inc., produces a generic medication used to treat cats with feline diabetes. The liquid medication is sold in 100 ml vials. Ellis employs a team of sales representatives who are paid varying amounts of commission. Given the narrow margins in the generic veterinary drugs industry, Ellis relies on tight standards and cost controls to manage its operations. Ellis has the following budgeted standards for the month of April 2017:
Ellis budgeted sales of 700,000 vials for April. At the end of the month, the controller revealed that actual results for April had deviated from the budget in several ways:
- Unit sales and production were 90% of plan.
- Actual average selling price decreased to $8.20.
- Productivity dropped to 90 vials per hour.
- Actual direct manufacturing labor cost was $15.20 per hour.
- Actual total direct material cost per unit increased to $3.90.
- Actual sales commissions were $0.70 per vial.
- Fixed overhead costs were $110,000 above budget. Calculate the following amounts for Ellis for April 2017:
1. Static-budget and actual operating income
2. Static-budget variance for operating income
3. Flexible-budget operating income
4. Flexible-budget variance for operating income
5. Sales-volume variance for operating income
6. Price and efficiency variances for direct manufacturing labor
7. Flexible-budget variance for direct manufacturing labor