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 iindustry , 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 dose

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 productvity rate ( doses per hour ) 100

sales commission is paid on sales ---- average commission $ 0.72 per dose

Fixed administrative and manufacturing overhead $ 1,100,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 $15.10 per hour

sales commission -- the average commission was $0.75 per dose

Fixed overhead costs were $ 40,000 below budget

Required

1. calculate the budget using the contribution margin income statement approach showing the volume, use and rate components ( when appropriate)

1b. calculate the actual results using the contribution margin statement approach showing the volume , use and rate components ( when appropriate)

2. Prepare a report showing the complete budget varaince ( i.e, variance calculated on each contribution margin income statement line ) and identify the variance as favorable (F) OR unfavorable (U).

3. calculate sales volume and sales rate variances ( identify as F or U ) .

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

i Direct materials medicine

ii Direct materials vials

iii. Direct Labour

iv. sales commission

Write a brief ( no longer than 2 paragrahps ) summary of the results analyzed identifying specific areas that should be focused on in upcoming months .

NOTE: The assignment should be completed using EXCEL ( except for the written analysis which can be a separate word file) so that the sources of information and the calculations can be easily determined.