Question

In: Accounting

Ellis Animal Health, Inc. produces a generic medication used to treat cats with feline diabetes. The...

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

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

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

Solutions

Expert Solution

BUDGETED CONTRIBUTION MARGIN INCOME STATEMENT
AMOUNT $
Sales revenue (700,000 doses @$ 8.30) 5810000
Less: Variable cost
Medicine (73500,000 ml @0.03 per ml) 2205000
Vials (700,000 vials @$ 0.45) 315000
Direct labour cost (7000 hours@$15 per hour) 105000
Sales commission (700,000 doses @$0.72 per dose) 504000
Contribution margin 2681000
Less: Fixed cost
Admin and selling expense 990,000
Net Budgeted Income 1,691,000
ACTUAL CONTRIBUTION MARGIN INCOME STATEMENT
AMOUNT $
Sales revenue (630,000 doses @$ 8.40) 5292000
Less: Variable cost
Medicine (72,128,483 ml @0.029 per ml) 2091726
Vials (702,450 vials @$ 0.52) 365274
Direct labour cost (7000 hours@$14.75 per hour) 103250
Sales commission (630,000 doses @$0.70 per dose) 441000
Contribution margin 2290750
Less: Fixed cost
Admin and selling expense 1,030,000
Net Actual Income 1,260,750

Related Solutions

Ellis Animal Health, Inc., produces a generic medication used to treat cats with feline diabetes. The...
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: Average selling price per vial $ 8.30 Total...
Ellis Animal Health, Inc. produces a generic medication used to treat cats with feline diabetes. The...
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...
Comprehensive variance analysis review. Ellis Animal Health, Inc., produces a generic medication used to treat cats...
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: Average selling price per...
Please solve it the easy way. Several drugs are used to treat diabetes. A sales specialist...
Please solve it the easy way. Several drugs are used to treat diabetes. A sales specialist for a leading pharmaceutical company needs an estimate of the number of new prescriptions that were written during a particular month for his company’s new diabetes drug. The numbers of new prescriptions in a random sample of 25 sales districts are as follows: 210 240 190 275 290 185 223 190 185 192 265 312 284 261 243 168 240 170 187 190 215...
1.) Oxytocin is the 1st line uterotonic medication used to prevent and treat PP hemorrhage. What...
1.) Oxytocin is the 1st line uterotonic medication used to prevent and treat PP hemorrhage. What are the 2 routes used to administer oxytocin? 2.) Oxytocini is a HI-RISK medication! Name 3 ways to safeguard errors. 3.) What is active management of the third stage of labor? 4.) Name other uterotonics that may be used in PP hemorrhage. Give their route, dosage and nursing considerations.
Which is NOT a medication used to treat HIV? protease inhibitors antibiotics fusion inhibitors integrase inhibitors...
Which is NOT a medication used to treat HIV? protease inhibitors antibiotics fusion inhibitors integrase inhibitors antibodies that bind CD4 on T-helper cells
Complete three 3 different drugs used to treat a patient diagnosed with angina, each medication including...
Complete three 3 different drugs used to treat a patient diagnosed with angina, each medication including their generic /brand name , category class, expected Pharmacological Action, Complications, Contraindications/Precautions, Interactions, Medication Administration, Evaluation of Medication Effectiveness, Therapeutic Use, Nursing Interventions, and Client Education.
Generic Mills Inc., in the interest of reducing health insurance costs, is investing in a wellness...
Generic Mills Inc., in the interest of reducing health insurance costs, is investing in a wellness program for employees. They plan to survey a sample of employees to determine what type of program would be of most interest. Several different plans for selecting the sample are under consideration. Identify the type of sample that is described in each of the following. a. There are 5 categories of employees (administration, clerical, operations, engineering, facility). Randomly select ten individuals from each category....
Many psychoactive drugs are used "off-label" to treat mental health disorders by some practitioners. Can PMHNPs...
Many psychoactive drugs are used "off-label" to treat mental health disorders by some practitioners. Can PMHNPs legally prescribe psychoactive drugs off-label?
In what way(s) can medications used to treat chronic health conditions negatively impact nutritional status? Check...
In what way(s) can medications used to treat chronic health conditions negatively impact nutritional status? Check all that apply. Check All That Apply Some medications decrease appetite Some medications cause gastrointestinal bleeding. Some medications reduce saliva production. Some medications reduce acid production in the stomach.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT