Question

Ellis Animal Health, Inc. produces a generic medication used to treat cats with feline diabetes. The liquid medication is sold in 100 ml vials. The term that Ellis uses for the product sold is a “dose”. Ellis employs a team of sales representatives who are paid varying amounts of commission.

Given the narrow margins in the generic veterinary 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:

                  Budgeted sales for April                                                                                                           700,000 doses

Average selling price per dose                                                                          $8.30 per dose

                  Medicine – 105 ml/dose @ $0.030 / ml                                                                         $3.15 per dose

                  Vials – 1 vial per dose @ $0.45 / vial                                                             $0.45 per dose

                  Direct manufacturing labor cost per hour                                                 $15.00 / hour

                  Average labor productivity rate (doses per hour)                                                      100

                  Sales commission is paid on all sales – average commission     $0.72 per dose

                  Fixed administrative and manufacturing overhead                           $990,000             

Actual results

Because of an accident in the factory, actual results were much different than planned

                  Dose sales and production were 90% of plan.

                  Actual average selling price increased to $8.40 per dose

                  Productivity dropped to 90 doses per hour

Raw material

Medicine – the company used 72,128,483 milliliters of medicine. They paid $0.029 per milliliter

Vials – the company used 702, 450 vials. They paid a total of $365,274 for the vials used

Actual direct manufacturing labor cost was $14.75 per hour

Sales commission – The average commission was $0.70 per dose

Fixed overhead costs were $40,000 above budget

Required

                  3.a Calculate Sales volume and sales rate variances (identify as F or U)

                  3.b Calculate volume, usage and rate variances (identify as F or U) for

                                    3.b1 Direct materials medicine

                                    3.b2 Direct materials vials

                                    3.b3 Direct Labor

                                    3.b4 Sales commissions

Answer 1

As per policy, only four part of a question is allowed to answer at a time, so answering :

Variance	Calculation
Sales volume variance	$8.30 (700000 - 630000) = $581000 (U)
Sales rate variance	(8.30 - 8.40) * 630000 = $63000 (F)
Direct material (medicine) rate variance	(0.030 - 0.029)72128483 = $73128(F)
Direc Material (medicine) usage variance	(630000*105 - 72128483)*0.030= $179354 (F)
Direct Material (medicine)Volume variance	(73500000 - 72128483)* 0.030 = $41145 (U)
Direct material (vials) rate variance	(0.45 - 365274/702450) 702450 = $49171 (U)
Direc Material (vials) usage variance	(702450*1 - 702450)* 0.45 = $0
Direct Material (vials)Volume variance	(630000*1 - 702450)*0.45= $32602 (F)
Direct labor rate variance	(15 - 14.750)630000/90 = $1750 (F)
Direc labor usage variance	630000/100 - 7000)15 = $10500 (U)
Direct Labor Volume variance	(630000/90 - 700000/100 )*15 = $0