Information is king – and real-time data regarding material stock movements is essential for effective inventory management. Here, Mostafa Eissa from Cairo University demonstrates the use of statistical processing control techniques for monitoring material mobility and how this could benefit the pharma industry.
Introduction
Inventory management in the industrial field is crucial for the control of goods in warehouses. Monitoring the patterns and trends of material flow and traffic is useful to assess the dynamic weight of the item’s stock. Observation of the process behaviour in a timely manner could be rendered fast and effective in the modern healthcare field, notably the pharmaceutical industry, using network communication between different processing sectors in organisations’ facilities.1 This would enable the material mobility database to be updated regularly. The final step is the statistical processing of the dataset through Statistical Processing Control (SPC) techniques using a statistical software platform.2 The following case study illustrates the dynamicity of medicinal material between point of delivery at a quarantine area in a warehouse and final disposition. From this study, an inventory shipment dynamicity index was adopted. The investigation will integrate the combined analysis of commercial statistical software platforms including GraphPad Prism v 6.01 for Windows and Minitab® v 17.1.0.3 Inventory control is an important and integral part of the total quality management (TQM) for any successful organisation in the world of competitive industry.
Are you looking to explore how lipid formulations in softgels can enhance drug absorption and bioavailability. Register for our upcoming webinar to find out!
3 September 2025 | 3:00 PM BST | FREE Webinar
This webinar will delve into the different types of lipid formulations, such as solutions, suspensions, emulsions, and self-(micro)emulsifying systems. Applications span diverse therapeutic areas including HIV therapy, oncology, immunosuppressants, and emerging treatments like medicinal cannabis (eg, CBD).
What You’ll Learn:
Lipid formulation development and screening tools for optimisation
Key steps in scale-up and industrialisation to ensure consistency and efficiency
Impact of lipid-based softgels on drug delivery and patient outcomes.
Can’t attend live? No worries – register to receive the recording post-event.
Segmental analysis of Immunosuppressive Disease‑Modifying Antirheumatic Drug (DMARD): a worked case investigation
Preliminary statistical analysis and data visualisation
Immunosuppressive Disease-Modifying Antirheumatic Drugs (DMARD) are a group of unrelated drugs that are used to slow down rheumatoid arthritis (RA) progression, in addition to other conditions such as inflammatory arthritides, including ankylosing spondylitis (AS) and psoriatic arthritis (PsA).4 These drugs include methotrexate, hydroxychloroquine and auranofin (Gold salt). Data concerning this group of drugs were arranged chronologically and examined preliminarily using a statistical programme to yield column statistics; as seen in Table 1. Results showed apparent skewness of the dispersion involving truncation pattern. Thus, the dataset failed to show evidence of a Gaussian distribution shape. The maximum exceptional amount of shipped material was identified as a single batch using robust regression and outlier removal methodology (ROUT) (Q = 1.000 percent) due to additional demand for the material. The average amount of received item was 17.11kg ± 17.10 which ties in container units at r(Spearman) = 0.6293 with a 95 percent confidence interval between 0.1981 and 0.8564 and P (two‑tailed) of 0.0095. Most deliveries are small quantities with an amount of 10kg or less per reservoir in almost half of the shipments. The contour plot in Figure 1 demonstrates the zone pattern as the number of reservoir units in relation to time and amount of the material, showing a solitary point of the high delivery amount. On the other hand, the Pie chart in Figure 2 illustrates the rate of conformance and non-conformity based on the inspection and analysis of the material.
Figure 1: Contour diagram showing shipment arrival, amount (in Kg) and reservoir count relationship.
Process-behaviour charts and the monitoring of inventory mobility
Figure 2: Pie chart showing acceptance (A) and rejection rates (R) from the total deliveries.
A process-behaviour chart indicates when the process is out-of-control and helps to identify the presence of assignable cause variation. When special cause variation is present, the process is not stable and corrective action should be taken. Trending charts are figures that plot process data in a time-ordered sequence. Most control charts include a centreline (CL), an upper control limit (UCL) and a lower control limit (LCL). The centreline represents the process mean. The control limits represent the process variation. By default, the control limits are drawn at distances of three standard deviations (σ) above and below the centreline.5 Two types of trending charts were used – rare event and ordinary control charts – to draw both time interval between delivery and release of the warehouse item, and chronological monitoring of the delivery amount of the material under inspection. Reception and release of the material occurred at almost the same rate and the means and the upper control limits (UCLs) are almost identical with the same probability of occurrence as could be seen in Figure 3. Complementarily, the implementation of the classical type of control chart that shows the amount of material per delivery demonstrated a single excursion on the item demand per shipment (indicated by number 1 alarm dot in the diagram) in Figure 4. Since the dataset failed to follow any of the presumed distributions for control charts, Laney’s approach to modifying limits was applied to correct for data dispersion that impacts control limits and hence alarm signalling.6 Nevertheless, if the data are not following the expected distribution patterns (ie, normal or Poisson distributions) and the Laney modification was not applied, an increased number of false alarms might be considered. However, because fewer than two points are beyond the threshold limits on the Shewhart chart, the dispersion fitness test is not needed.7 In quantity demand terms, the process mean is expected to be unstable. One (5.9 percent) data point is ‘out of control’ on the Shewhart chart, bearing in mind that 0.7 percent of out-of-control points might be seen by chance, even when the process is stable.
Figure 3: Process-behaviour chart: the average amount of the raw material per shipment (μ bar), upper control limit (UCL) and lower control limit (LCL).
Figure 4: Rare event control chart showing incidences intervals, probability of occurrence, control limit (CL), upper control limit (UCL) and lower control limit (LCL).
Control chart-based material weight index
A metric was developed to take into account the rate of failure of material combined with its amount and the probability of the daily arrival to the facility, in such a way that the metric will increase with high risk and decrease with low-risk goods. The developed equation could be summarised as follows:
Wi= (1/(1-R)) ×P×A (1)
Where:
Wi = Weight index of the item delivered
R = Rejection fraction or 1 – R term could be substituted by Acceptance rate (A)
P = Probability of reception or release
A = Amount of the received good (in Kg), which could be expressed from mean value and UCL.
For example, in the previous case, the range of Wi could be estimated during the study period to be between 0.07 and 0.21. When a database is subjected to a continuous update, these values may change up and down depending on the amount and frequency of delivered shipments, in addition to the rate of acceptance or rejection of the goods.8 As an example, a comparison could be performed with another drug that showed 0.35 – 0.85 which is higher in the index value due to higher frequency and amount despite the absence of rejection factor. A third material showed even higher values of 0.36 – 1.07. A fourth product showed an even higher index value due to the impact of the combined factors, 6.96 – 14.51. When applying the Pareto principle, the major influential items could be spotted in the warehouse traffic. Thus, this index shows the preferential difference between inventory items in terms of the impact on the inventory load and burden.
Conclusion
Application of SPC methodologies has been adopted herein to assess the inventory item weight and impact using quantitative metrics. Moreover, monitoring and control of material mobility will provide useful support in the decision‑making procedures for planning actions and when comparing different materials with respect to inventory weight impact.
About the author
Mostafa Eissa Independent PhD Researcher, Cairo University
Mostafa has a master’s degree in pharmaceutical sciences and has worked as a research specialist in biotechnology at a pharmaceutical company. With microbiology and raw material quality analysis experience, Mostafa has written several cultural and scientific articles in magazines and published 104 scientific papers as well as a book. His research interest focuses on microbiology quality control and statistical process control. He is also Inspector at the central administration of pharmaceutical affairs.
References
Ei̇ssa M, Rashed E. APPLICATION OF STATISTICAL PROCESS OPTIMIZATION TOOLS IN INVENTORY MANAGEMENT OF GOODS QUALITY: SUPPLIERS EVALUATION IN HEALTHCARE FACILITY. Journal of Turkish Operations Management. 2020; 4(1): 388-408.
Eissa ME. Trichinosis Outbreak Risk Analysis in USA from Food Sources and New Prospective Analysis Using Statistical Process Control Tools. International Journal of Research in Pharmacy and Biosciences. 2019; 6(7): 4-13.
Benjamin O, Bansal P, Goyal A, Lappin S. Disease Modifying Anti-Rheumatic Drugs (DMARD) [Internet]. Ncbi.nlm.nih.gov. 2021 [cited 16 January 2021]. Available from: https://www.ncbi.nlm.nih.gov/books/NBK507863/
Ei̇ssa M, Rashed E. INVENTORY DIGITAL MANAGEMENT USING STATISTICAL PROCESS CONTROL ANALYSIS IN HEALTHCARE INDUSTRY. Journal of Business in The Digital Age. 2020; 3(2): 123-128.
This website uses cookies to enable, optimise and analyse site operations, as well as to provide personalised content and allow you to connect to social media. By clicking "I agree" you consent to the use of cookies for non-essential functions and the related processing of personal data. You can adjust your cookie and associated data processing preferences at any time via our "Cookie Settings". Please view our Cookie Policy to learn more about the use of cookies on our website.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorised as ”Necessary” are stored on your browser as they are as essential for the working of basic functionalities of the website. For our other types of cookies “Advertising & Targeting”, “Analytics” and “Performance”, these help us analyse and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these different types of cookies. But opting out of some of these cookies may have an effect on your browsing experience. You can adjust the available sliders to ‘Enabled’ or ‘Disabled’, then click ‘Save and Accept’. View our Cookie Policy page.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Cookie
Description
cookielawinfo-checkbox-advertising-targeting
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Advertising & Targeting".
cookielawinfo-checkbox-analytics
This cookie is set by GDPR Cookie Consent WordPress Plugin. The cookie is used to remember the user consent for the cookies under the category "Analytics".
cookielawinfo-checkbox-necessary
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance
This cookie is set by GDPR Cookie Consent WordPress Plugin. The cookie is used to remember the user consent for the cookies under the category "Performance".
PHPSESSID
This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed.
viewed_cookie_policy
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
zmember_logged
This session cookie is served by our membership/subscription system and controls whether you are able to see content which is only available to logged in users.
Performance cookies are includes cookies that deliver enhanced functionalities of the website, such as caching. These cookies do not store any personal information.
Cookie
Description
cf_ob_info
This cookie is set by Cloudflare content delivery network and, in conjunction with the cookie 'cf_use_ob', is used to determine whether it should continue serving “Always Online” until the cookie expires.
cf_use_ob
This cookie is set by Cloudflare content delivery network and is used to determine whether it should continue serving “Always Online” until the cookie expires.
free_subscription_only
This session cookie is served by our membership/subscription system and controls which types of content you are able to access.
ls_smartpush
This cookie is set by Litespeed Server and allows the server to store settings to help improve performance of the site.
one_signal_sdk_db
This cookie is set by OneSignal push notifications and is used for storing user preferences in connection with their notification permission status.
YSC
This cookie is set by Youtube and is used to track the views of embedded videos.
Analytics cookies collect information about your use of the content, and in combination with previously collected information, are used to measure, understand, and report on your usage of this website.
Cookie
Description
bcookie
This cookie is set by LinkedIn. The purpose of the cookie is to enable LinkedIn functionalities on the page.
GPS
This cookie is set by YouTube and registers a unique ID for tracking users based on their geographical location
lang
This cookie is set by LinkedIn and is used to store the language preferences of a user to serve up content in that stored language the next time user visit the website.
lidc
This cookie is set by LinkedIn and used for routing.
lissc
This cookie is set by LinkedIn share Buttons and ad tags.
vuid
We embed videos from our official Vimeo channel. When you press play, Vimeo will drop third party cookies to enable the video to play and to see how long a viewer has watched the video. This cookie does not track individuals.
wow.anonymousId
This cookie is set by Spotler and tracks an anonymous visitor ID.
wow.schedule
This cookie is set by Spotler and enables it to track the Load Balance Session Queue.
wow.session
This cookie is set by Spotler to track the Internet Information Services (IIS) session state.
wow.utmvalues
This cookie is set by Spotler and stores the UTM values for the session. UTM values are specific text strings that are appended to URLs that allow Communigator to track the URLs and the UTM values when they get clicked on.
_ga
This cookie is set by Google Analytics and is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. It stores information anonymously and assign a randomly generated number to identify unique visitors.
_gat
This cookies is set by Google Universal Analytics to throttle the request rate to limit the collection of data on high traffic sites.
_gid
This cookie is set by Google Analytics and is used to store information of how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
Advertising and targeting cookies help us provide our visitors with relevant ads and marketing campaigns.
Cookie
Description
advanced_ads_browser_width
This cookie is set by Advanced Ads and measures the browser width.
advanced_ads_page_impressions
This cookie is set by Advanced Ads and measures the number of previous page impressions.
advanced_ads_pro_server_info
This cookie is set by Advanced Ads and sets geo-location, user role and user capabilities. It is used by cache busting in Advanced Ads Pro when the appropriate visitor conditions are used.
advanced_ads_pro_visitor_referrer
This cookie is set by Advanced Ads and sets the referrer URL.
bscookie
This cookie is a browser ID cookie set by LinkedIn share Buttons and ad tags.
IDE
This cookie is set by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
li_sugr
This cookie is set by LinkedIn and is used for tracking.
UserMatchHistory
This cookie is set by Linkedin and is used to track visitors on multiple websites, in order to present relevant advertisement based on the visitor's preferences.
VISITOR_INFO1_LIVE
This cookie is set by YouTube. Used to track the information of the embedded YouTube videos on a website.