03114nam a2200301 i 4500003000500000005001700005008004100022040002500063090002400088100004000112245019000152300001600342336002100358337002500379338002300404502009700427504004100524520185500565700002702420700003202447720003702479720004702516720003302563720003502596942003902631952012502670999001702795CSPC20251016161416.0251016s2024    ph a     b    000 0 eng d  aCSPCbengcCSPCerda  aUTH BSIS G643i 20241 aTalagtag, Ma. Gabrielle S.eauthor.10aInteractive data visualization of the CSPC supply and property inventory management system using business intelligence / cMa. Gabrielle S. Gonzales, Eric F. Pino, and Jehan R. Talagtag  a133 leaves.  2rdacontentatext  2rdamediaaunmediated  2rdacarrieravolume  aUndergraduate Thesis (BSIS) - Information System.cCamarines Sur Polytechnic Colleges, 2024.  aIncludes bibliographical references.3 aThe increasing reliance on technology has transformed inventory management through business intelligence (BI) tools. This study integrates Power BI into the Supply and Property Inventory Management System (SPIMS) of Camarines Sur Polytechnic Colleges (CSPC) to optimize inventory tracking, demand forecasting, and cost efficiency. The study employs descriptive analysis and statistical models to analyze inventory levels, stock fluctuations, and procurement patterns. Findings indicate inefficiencies in inventory control, with overstocking of disinfectant bleach (430 excess units per month) and stockout risks for high-demand items like accountable forms. Demand forecasting analysis showed stable demand projections, but poor inventory monitoring led to excessive holding costs, particularly for the T8 LED Tube, which incurred a holding cost of P17,068. Safety stock analysis identified critical items requiring buffer stock management, such as batteries and bleach, which faced demand fluctuations. The cost analysis revealed that office supplies contributed to P69,578 in total inventory expenses, highlighting procurement inefficiencies. To enhance inventory operations, the study recommends expanding data collection to include supplier performance metrics, implementing predictive analytics for real-time inventory monitoring, and conducting regular staff training on Bl tools. Additionally, optimizing stock levels through improved procurement strategies can reduce unnecessary expenses. The study concludes that Power BI significantly enhances CSPC's inventory management, but further refinement in data accuracy, system integration, and strategic stock planning is necessary for long-term efficiency. Future research should explore the integration of machine learning for more accurate forecasting and automation of procurement workflows.1 aPino, Eric F.eauthor.1 aTalagtag, Jehan R.eauthor.  aRamizares, Maricris L.eadviser.  aManlapaz, Shiela Dona S.echair, panelist.  aColle, Jonuel Reyepanelist.  aLlagas, Josefina H.epanelist.  2ddcn0cUMhG643iiBSISkUTHm2024  00102ddc4070aCSPCbCSPCcUTHd2025-10-16l0oUTH BSIS G643i 2024p006928UMr2025-10-16 16:16:20t1-1w2025-10-16yUM  c30742d30742