MegaPixel Allocation Management System (MPAMS)

Abstract

The project aims to solve the client’s need to calculate order allocations, as their current use of multiple spreadsheets typically requires more time and human intervention in doing so. These are generally due to two reasons, the use of ratio and proportion formulas and the specific needs of a client’s order. There are specific scenarios where their client may specify which variants they wish to have, which would require further thought by the user. The developed system allows standard users to manage the inventory of supported products, to allocate these inventories based on the needs of their clients, and to print related reports for review and for preparation in deliveries. For admin users, they have access to user management, client management and control for certain choice-based fields, in addition to the functionalities made available to standard users. This project was made with the following aims: to reduce the use of spreadsheets for the client, to provide a unified and easy to use platform for this aspect of the business, and to potentially reduce the amount of time and human intervention needed for order allocation. The developer was able to develop the system as specified by the client. The system allows for the order allocation process to be potentially faster, as it can calculate the units to be allocated automatically, allowing for less time and intervention needed. Future developments or attempts at the project could implement alternative input methods, performance-related improvements and additional features as seen fit by the client.