Open Always
Email: Call Now! +1-315 515-4588
Open Always
Email: Call Now! +1-315 515-4588

Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study

This sample paper on(Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study) was uploaded by one our contributors and does not necessarily reflect how our professionals write our papers. If you would like this paper removed from our website, please contact us via our Contact Us Page.

A Database of over Million Scholarly Resources. Start your Search Now

Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study


Western Pharmaceutical is a drug company that has an extended company- Western Pharmaceutical B. It is located in Los Angles and headedby GeorgeCastro, who in this case has rooted for a merger between WesternPharmaceutical andrenowned over the counter pharmaceutical company, AtlanticMedical. The main aim of the merger is to help Atlantic Medicine’s cough syrup and WesternPharmaceuticalStomachUpset to penetrate the coast-to-coast drug market. The two companies have merged to form the United Pharmaceuticals. Notably, with both companies enjoying initial success in their previous markets, the merger promises valuable market success in the west and coast region.

However, the merger poses new inventory challenges whereGeorge has to determine the company’s inventorycapability regardingthe refined supply chain. The merger requires the companies to modify its inventory management system to accommodate the two distinct entities systems. In this regard, the company wants to conduct a comprehensive inventory analysis but has limited information because of the subsequent shift to the Enterprise Resource Planning system and the merger on the whole.The followinganalysis will be conducted based on Bowersox et al. (2013) spreadsheet.

The Issues Addressed
The Fill rate of each Product

The fill rate is best calculated by multiplying servicelevel and demand quantity to project the merger’s sales rather than the demand. The technique will be used to calculate a weighted service level.  First, the weighted sales for every DC product combination are represented by the AM, AO, and AM columns. Secondly, the AQ column representsthe DC sales total quantity,while the AR column represents DC demand. Finally, the column AR and AQ represent the average service percentage.The columns AW, AV, and AU are adopted in computing the comparable service analysis, which will give the variance valuefor astandard cost and unit regarding the effect it has on the outcomes across the DCs and products. Basing on the standard cost, the AX column stands for the existing inventory.  Using the given methodology, the calculated value and units for the fill rates percentages are 96.31 and 96.1.  Taking into considerations the individualproducts, it can be assumed that a portion of the observed substances are under stocked while the others are marginally overstocked.

Average Inventory Levels and Safety Stock

The second question is best answered using the columns between AZ and BK. The columns BA, BB, and AZ, are used to find the f (k) value for every DC product combination as illustrated by the order quantity and the calculated 95% fill rate.  Columns BE, BD, and BF are used to calculate the required base for the required safety stock. Similarly, the columns BI, BJ, and BH are used to calculate the DC inventoryproduct average which is essentialfor providing a service level of 95%.  Adopting a standard cost formulae, column BK is used to calculatethe average inventory dollars by converting the aggregate units. Notably, it is important to note that the analyticalinventorytechnique needs $7.5 million to get a 95% fill rate, yet the available situation provides a yield of 96 plus percentservice only using twice the current inventory.

The Inventory Carrying Cost

The columns BX and BM is used in developing the solution to this answer where one has to undergo a similar process as the safety and average inventory, however, in this case, it is at a level of 99% fill rate.  The charts indicate that the merger has eight distribution centers, which would narrow downto sevencenters when we incorporatethe AtlantaDistribution Centre.Column BX and BK are used to calculate the needed inventory to increase the company’s service.  The columns BZ through to CD are used to conduct marginanalysis, by comparing the excess inventory cost and the additional sales marginal distribution.  At ninety-nine percent level, the CA column forms the comparable sales service, while the CB column is considered the incremental margin between CA and BZ level of service that is required to boost the service to a 99% level from the initial 95%. The required inventoryincrementto achieve this level is found in column CC, also referred to as the carrying cost. Similarly, the contribution increment is represented by column CD.According to this approach,   a positive value justifies the need for an additional inventory; while on the other hand, a negative value does not justify the need for additional inventory. On this case, the general result is positive which calls for an increase in the service level for a majority of the inventory items.

Conducting the cost Analysis

The process requires a general analysis of the spreadsheet to ascertain if the merge would be profitable in the long term. The columns   CF to CU provide the needed data for consolidation.  Each product review cycleis represented by column CF while CI and CG demonstrate the two to four weeks product reviewing for the usedyearly sales.  The average inventory value for the second and fourth weeks review are represented by columns CJ and CH respectively,which have unique review cycle.  Therefore, to calculatethe N analysis square root, one has to separatethe two columns.  First, the standarddeviation combinationfor C is calculated to combine the distribution centers. Column CLand CM representsthe demandstandarddeviation ofD and the combined deviation respectively.Likewise, Column CN represents the replenishment order quantity that is also the cumulative value of each order.  According to the service objective, the 95% fill rate is the standard deviation of C and the combined order quantity.Furthermore, columnCG represent result inventory calculated from the safety stock and replenishment order quantity.  The calculated safety stock based on the SD of C andvalue of K is represented by column CR.  The column CT showsthe corresponding inventory valuesum the distribution centers.  Therefore, the aggregate inventory values are closely related based on the comparison results of the three and single distribution centers.


Based on the inventory analysis, the merger between the Atlantic Medical and Western Pharmaceutical is profitable if done in a concise manner.  Moreover, even if the management closes or merges some of its distributioncenters, it still stands to make significant cost savings. Despite the inevitable service load increase, mergingWestern Pharmaceutical and Atlantic Medicalis profitable in the long term. The projected inventory analysis shows that combining the two unique distribution centers guarantees the coast to coast market penetration.










Bowersox, D. J., et al. (2013). Western Pharmaceuticals (A &B). Integrated Logistics for Supply Chain Management, 453-457: New York, N.Y: Mc Graw-Hill.

Sharing is: CARING

Are you looking for homework writing help? Click on Order Now button below to Submit your assignment details.

Homework Writing Help
We Can Help you with this Assignment right now!
Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study

Are you looking for homework writing help on(Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study)?Well, you can either use the sample paper provided to write your paper or you could contact us today for an original paper. If you are looking for an assignment to submit, then click on ORDER NOW button or contact us today. Our Professional Writers will be glad to write your paper from scratch.



We ensure that assignment instructions are followed, the paper is written from scratch. If you are not satisfied by our service, you can either request for refund or unlimited revisions for your order at absolutely no extra pay. Once the writer has completed your paper, the editors check your paper for any grammar/formatting/plagiarism mistakes, then the final paper is sent to your email.

Writing Features

Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study

Privacy| Confidentiality

Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study

We do not share your personal information with any company or person. We have also ensured that the ordering process is secure; you can check the security feature in the browser. For confidentiality purposes, all papers are sent to your personal email. If you have any questions, contact us any time via email, live chat or our phone number.

Our Clients Testimonials

  • I appreciate help on the assignment. It was hard for me but am good to go now

    Impact of pollution on Environment
  • Am happy now having completed the very difficult assignment

    Creative Message Strategies
  • Your writer did a fine job on the revisions. The paper is now ok

    Ethics: Theory and Practice
  • The paper was so involving but am happy it is done. Will reach you with more assignments

    Title: Privatization in or of America
  • I expected perfection in terms of grammar and I am happy. Lecturer is always on our head but was pleased with my paper. Once again, thanks a lot

    Title: Bundaberg Inquiry
  • The paper looks perfect now, thank to the writer

    Health Care Systems
  • You helped me complete several other tasks as you handled paper. wonna thank you

    Critique Paper on Political Change

Related Articles

Sample Case Study Paper on Western Pharmaceutical Merger Inventory Case Study

Analyze the Nursing Roles in providing Comprehensive care in a Variety of Community Health Settings

Community Settings This week’s graded topics relate to the following Course Outcomes (COs). CO3: Plan prevention and population-focused interventions for vulnerable populations using professional clinical judgment and evidence-based practice. (POs...
Read More

Case Study Assignment on Ethical Issues in Asia-Pacific business

Case study assignment on Ethical Issues in Asia-Pacific business For this assignment, students will write a case study report in 2,000 words based on a case identified with circumstance or...
Read More

Sample Report Paper on The proposed reward system and strategy for the big city university

A good reward system should motivate workers. It should also attract and retain the same workers. On the contrary, a bad reward system does not do either of these things....
Read More

Management of PCOS through Homoeopathy-A case report

Introduction PCOS is the acronym for Polycystic Ovarian Syndrome. It is the most common endocrine disorder of women in their reproductive period manifested by irregular menstrual cycles and polycystic ovaries,...
Read More

Get more from us…

Would you like this sample paper to be sent to your email or would you like to receive weekly articles on how to write your assignments? You can simply send us your request on how to write your paper and we will email you a free guide within 24-36 hours. Kindly subscribe below!

Email Address: