This project presents a comprehensive decision tree analysis conducted for Major Pharmaceutical Company (MPC) to determine the optimal drug line development strategy amidst market uncertainty and new competition. The analysis evaluates three strategic options: developing a new drug, modifying an existing drug, and maintaining the current approach. By quantifying potential outcomes, probabilities, and financial payoffs, this project provides a data-driven recommendation to maximize MPC's expected financial value.
This dataset was provided by Western Governors University (WGU) for academic and educational purposes as part of the Data-Driven Decision Making course. It is intended for internal use within the WGU academic environment and this portfolio piece demonstrates its utilization in a project.
Important Note: This dataset may contain simulated or anonymized data for learning purposes. It is not intended for commercial use or distribution beyond this academic portfolio.
- Dataset:
Drug Market Analysis.xlsm - Format: Microsoft Excel Workbook (.xlsx)
- Size: 32KB
- Number of Sheets: 4 sheets: Drug Line Values, Expected Earned Value, Decision Tree Analysis
- Key Columns/Variables: Profit (per unit), Favorable Demand (units/month), Favorable Probability, Favorable Payoffs, Favorable Expected Value, Unfavorable Demand (units/month), Unfavorable Probability, Unfavorable Payoffs, Unfavorable Expected Value, Final Expected Value