Optimizing pharmacy sales and inventory through business analytics tools

Simple item page
creativework.keywordsinventory optimization, pharmacy, sales forecasting
dc.contributor.advisorTorres, Doreen A.
dc.contributor.authorCabradilla, Noligen C.
dc.contributor.authorCanapit, Desiree Jane B.
dc.contributor.authorCasison, John Kyle M.
dc.contributor.authorOrdanza, Loren Marie O.
dc.contributor.authorSese Jr., Emmanuel T.
dc.contributor.chairRodriguez, Marylen D.
dc.contributor.committeememberEstira, Marydel C.
dc.contributor.committeememberJubinal, Rosalia S.
dc.date.accessioned2026-04-23T03:12:22Z
dc.date.available2026-04-23T03:12:22Z
dc.date.issued2025-11
dc.descriptionFull text
dc.description.abstractThis study presented the development and implementation of a web-based business analytics system designed to optimize pharmacy sales and inventory management. Utilizing a Seasonal Autoregressive Integrated Moving Average (SARIMA) model, the system forecasted pharmaceutical product demand by analyzing three years of historical sales. The forecasting model achieved a high accuracy with a Mean Absolute Percentage Error (MAPE) of 2.32, enabling precise stock level recommendations and reorder point determination. The system provided role-based dashboards for administrators, pharmacists, and clerks, facilitating data-driven decision-making, real-time inventory updates, and proactive stock management to minimize stockouts and inventory losses due to expiry. Evaluation through the System Usability Scale (SUS) yielded an excellent score of 79.17, indicating effective usability for pharmacy personnel. The study demonstrated that integrating predictive analytics in pharmacy operations enhanced inventory control, reduced financial risks, and supported continuous availability of essential medicines. This research contributed to improved pharmacy management practices by advocating for the adoption of advanced analytics tools in inventory optimization.
dc.format.extentxi, 75 p.: ill. (col.).
dc.identifier.citationCabradilla, N. C., Canapit, D. J. B., Casison, J. K. M., Ordanza, L. M. O., & Sese Jr., E. T. (2025). Optimizing pharmacy sales and inventory through business analytics tools. [Unpublished Undergraduate Thesis]. Don Mariano Marcos Memorial State University - Mid La Union Campus, City of San Fernando, La Union. Lakasa ti Sirib, DMMMSU Institutional Repository.
dc.identifier.urihttps://lakasa.dmmmsu.edu.ph/handle/123456789/1377
dc.language.isoEnglish
dc.publisherDon Mariano Marcos Memorial State University - Mid La Union Campus
dc.rights.licenseCC BY 4.0
dc.subjectInventory control--Mathematical models
dc.subjectPharmacy
dc.subjectPharmacy management
dc.subjectPharmacy--Study and teaching
dc.subjectHospital pharmacies
dc.subjectSales forecasting
dc.subjectSales forecasting--Mathematical models
dc.subjectSales forecasting--Management
dc.subjectSales forecasting--Data processing
dc.subjectSales forecasting--Econometric models
dc.titleOptimizing pharmacy sales and inventory through business analytics tools
dc.typeThesis
dcterms.accessRightsOpen access
thesis.degree.disciplineCollege of Information Technology
thesis.degree.levelUndergraduate
thesis.degree.nameBachelor of Science in Information Technology
Files
Original bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
UT-MLUC-2025-CIT-BSIT-CabradillaNC-FT.pdf
Size:
42.36 MB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.71 KB
Format:
Item-specific license agreed to upon submission
Description:
Download
Collections
Undergraduate Theses