000			03023nam a2200301 i 4500
003			CSPC
005			20251016161416.0
008			251016s2024 ph a b 000 0 eng d
040			_aCSPC _beng _cCSPC _erda
090			_aUTH BSIS G643i 2024
100	1		_aTalagtag, Ma. Gabrielle S. _eauthor.
245	1	0	_aInteractive 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
300			_a133 leaves.
336			_2rdacontent _atext
337			_2rdamedia _aunmediated
338			_2rdacarrier _avolume
502			_aUndergraduate Thesis (BSIS) - Information System. _cCamarines Sur Polytechnic Colleges, 2024.
504			_aIncludes bibliographical references.
520	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.
700	1		_aPino, Eric F. _eauthor.
700	1		_aTalagtag, Jehan R. _eauthor.
720			_aRamizares, Maricris L. _eadviser.
720			_aManlapaz, Shiela Dona S. _echair, panelist.
720			_aColle, Jonuel Rey _epanelist.
720			_aLlagas, Josefina H. _epanelist.
942			_2ddc _n0 _cUM _hG643i _iBSIS _kUTH _m2024
999			_c30742 _d30742