|
Operations and Logistics are essential functions within any organization. Organizations must maintain optimal inventory levels without negatively impacting their balance sheets.
We have implemented dashboards that generate reports on inventory levels, aging, returned items and implemented controls when any of the KPIs are not satisfactory.
Depending on the systems used by your organization, dashboards may be based on MS Excel, MS SQL Reporting Services or ASP.net web based.
See below an example of our system generated report. It is a drill down report on purchase items received.
Purchase Items Received (Y2019)
| | PurchaseItem | Quarter1 | Quarter2 | Quarter3 | Quarter4 |
 | Motherboard 2GHz | 6,790 | 8,990 | 9,990 | 6,954 |
| Vendor | | | | |
| A&M Supplies | $1,344,420 | $1,780,020 | $1,978,020 | $1,376,892 |
|
| SDRAM 8GB 1.5 GHz | 8,789 | 9,876 | 7,890 | 6,670 |
| Vendor | | | | |
| Alpha Enterprise | $922,845 | $1,036,980 | $828,450 | $700,350 |
|
| HDD 120GB | 3,890 | 4,567 | 4,367 | 4,678 |
| Vendor | | | | |
| Computer Inc | $175,050 | $205,515 | $196,515 | $210,510 |
|
| HDD 256GB | 987 | 678 | 567 | 234 |
| Vendor | | | | |
| Hardware S | $54,285 | $37,290 | $31,185 | $12,870 |
|
| Processor M 1.2 GHz | 4,876 | 3,985 | 1,234 | 2,789 |
| Vendor | | | | |
| Chain Store | $482,724 | $394,515 | $122,166 | $276,111 |
|
| CD Drive 52X | 98 | 34 | 55 | 61 |
| Vendor | | | | |
| Chain Store | $2,450 | $850 | $1,375 | $1,525 |
|
| DVD + 4.7GB | 63 | 62 | 45 | 89 |
| Vendor | | | | |
| Computer Inc | $1,827 | $1,798 | $1,305 | $2,581 |
|
| CPU Fan | 18 | 16 | 17 | 18 |
| Vendor | | | | |
| A&M Supplies | $630 | $560 | $595 | $630 |
|
|