A Full Pack App for Inventory Analysis Forecasting and Customized Report
Use Cases and Deployment Scope
We have 80 SKUs to analyze, thus the app helped us to understand trends, be alarmed of soon to be out of stock products, so we could order in advance. we can also track POs of our replenishments, and even small products or spare part replacements. Forecasting helped us to manage our multi-store shop, and it addressed some of our problems such as mentioned - stockouts and overstocking.
Pros
- It gives us detailed metrics of product sales performance
- It gives us graph of sales forecast too
- It provides table with multiple customizable columns to activate for us to see important details
- It also gives a lot of filter options for us to be able to see priority items for attention
- It helped us create weekly and monthly reports that give us chance to plan ahead
Cons
- It still has some room for improvement, there's no option for custom formula
- We cannot also create a product barcode within the webapp
- Although PO label is possible, its just CSS and HTML, which is not friendly for team mates who usually manage it
Return on Investment
- It reduced our warehouse storage cost as we can now plan ahead more accurately only buying what is needed
- It helps us save time in organizing our datasets, thus our time is now revolving more on product sourcing rather than too much time in forecasting
- We can now have a 3D view of our historical records and future scales, thus we can now more atleast near accurately predict future sales giving us data driven decision making easier
Usability
Alternatives Considered
Prediko
Other Software Used
Prediko