1 Explain how u found sales 2 Explain how u found percent of sale of op expenses...
Fantastic news! We've Found the answer you've been seeking!
Question:
- 1 Explain how u found sales
- 2 Explain how u found percent of sale of op expenses (weight of each product)
- 3 Explain how much each product produces (most to least profitable)
- 4 Explain where money is allocated (which departments)
Guidance on calculations:
- Start off with Net Product Sales of REGN Products. Your objective pertains to 2019 expenses, so you should be reviewing 2019 total revenue per product (ignore US and ROW sales). Itemize out total product revenue for Eylea, Dupixent, Praulent, and Kevzara and then divide each product's revenue by total 2019 revenue. This will give you the % portion that each product contributes to total sales. For example - Eylea contributed around 70%. Since you are only concerned with 4 out of the 8 products, you should group the combined revenue of all the remaining products into an Other and calculate the proportionate percentage of that - approximately 3%.
- Take a look at the numbers you were given in the table - Total 2019 Annual Operating Expense for each of the 5 departments. Consider what the third column "time spent supporting Commercial products" represents - 4 out of the 5 departments did not spend 100% of their time supporting Commercial products, so it wouldn't be appropriate to allocate all Operating Expense for 2019 to the four products. Instead you should adjust 2019 Operating Expense for Time Spent (so: Column 2 x Column 3) and calculate what you would call Adjusted 2019 Annual Operating Expense. This Adjusted Operating Expense is what's appropriate to allocate across all four products per your objective.
- Review the current data you have: the % share of each product's contribution to total sales revenue in 2019 and the Adjusted Operating Expense for 2019 per department. With the data we have, the best assumption we can make is that if a product is contributing more revenue to the company. If one product pulls in more revenue from sales than others, it must mean more of those products are being sold. If a certain product has more being sold, it also means the company manufactures more of those products than the ones that sold less. Manufacturing more of some products than others means they must have accrued more of the 2019 expenses.
- Considering all of that above - you should multiply the Adjusted 2019 Annual Operating Expense by the respective percentages of Eylea, Dupixent, Praluent, Kevzara, and Other. Show in a table what that allocation of expense per product looks like.
Product Sales:
Product | 2019 Net Sales (millions) | % of Sales |
EYLEA | ||
Dupixent | ||
Praluent | ||
Kevzara | ||
Other | ||
Total |
Final Allocation of Adjusted Operating Expense:
Department | Adjusted Annual Op. Expense | EYLEA | Dupixent | Praluent | Kevzara |
Commercial | 200,000,000 | ||||
IT | 25,000,000 | ||||
Facilities | 0 | ||||
Finance | 5,000,000 | ||||
Human Resources | 7,500,000 | ||||
Total | 237,500,000 |
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date: