MARC details
| 000 -LEADER |
|---|
| fixed length control field |
03023nam a2200301 i 4500 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
CSPC |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20251016161416.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
251016s2024 ph a b 000 0 eng d |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
CSPC |
| Language of cataloging |
eng |
| Transcribing agency |
CSPC |
| Description conventions |
rda |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN) |
|---|
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) |
UTH BSIS G643i 2024 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Talagtag, Ma. Gabrielle S. |
| Relator term |
author. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Interactive data visualization of the CSPC supply and property inventory management system using business intelligence / |
| Statement of responsibility, etc. |
Ma. Gabrielle S. Gonzales, Eric F. Pino, and Jehan R. Talagtag |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
133 leaves. |
| 336 ## - CONTENT TYPE |
|---|
| Source |
rdacontent |
| Content type term |
text |
| 337 ## - MEDIA TYPE |
|---|
| Source |
rdamedia |
| Media type term |
unmediated |
| 338 ## - CARRIER TYPE |
|---|
| Source |
rdacarrier |
| Carrier type term |
volume |
| 502 ## - DISSERTATION NOTE |
|---|
| Dissertation note |
Undergraduate Thesis (BSIS) - Information System. |
| Name of granting institution |
Camarines Sur Polytechnic Colleges, 2024. |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc. note |
Includes bibliographical references. |
| 520 3# - SUMMARY, ETC. |
|---|
| Summary, etc. |
The 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# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Pino, Eric F. |
| Relator term |
author. |
| 700 1# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Talagtag, Jehan R. |
| Relator term |
author. |
| 720 ## - ADDED ENTRY--UNCONTROLLED NAME |
|---|
| Name |
Ramizares, Maricris L. |
| Relator term |
adviser. |
| 720 ## - ADDED ENTRY--UNCONTROLLED NAME |
|---|
| Name |
Manlapaz, Shiela Dona S. |
| Relator term |
chair, panelist. |
| 720 ## - ADDED ENTRY--UNCONTROLLED NAME |
|---|
| Name |
Colle, Jonuel Rey |
| Relator term |
panelist. |
| 720 ## - ADDED ENTRY--UNCONTROLLED NAME |
|---|
| Name |
Llagas, Josefina H. |
| Relator term |
panelist. |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Suppress in OPAC |
No |
| Koha item type |
Unpublished Materials |
| Classification part |
G643i |
| Item part |
BSIS |
| Call number prefix |
UTH |
| Call number suffix |
2024 |