Pharmaceutical Sales and Inventory Monitoring

Introduction:

 

Pharmaceutical companies, wholesalers, and pharmacies need to track drug sales and inventory to avoid shortages or excess stock. Poor inventory management can lead to Expired drugs due to overstocking, Lost sales due to stockouts and Inefficiencies in distribution across different locations.

 

 

 

Requirement:

 

Using the attach calculation excel perform the respective calculations in pharmaceutical_sales table and display the calculated fields.

 

 

 

Unity catalog information: purgo_playground.pharmaceutical_sales