Microsoft Power Apps + Inventory Management
Budget: $3,000 – $5,000 USD
Skills: Microsoft Power Apps + Inventory Management
Budget: Thinking of around $5K USD but will fluctuate based on discussion and hours
Project: Will start with Number 1 project and review. Then potentially award Number 2 project.
Project Description
Utilizes Microsoft environment
1) Order Management
* an interactive page to manage package orders
*Users will create new orders, use the PO, Product, Quantity, and cost information and submit orders
* (Optional) Track order status
* Receive quantity in system once physically received
* Document overages and shortages of virtual to physical inventory
* Flexibility to add in additional features, such as barcode scanning, etc to improve automation
* Capability to split out csv file
2) Inventory Management
* Enter snapshot inventory qty currently carrying
* Adjusts inventory quantity and cost up and down based on FIFO
* (from previous) adjust quantity according to a csv data dump or user enters quantity used
* Inventory reconciliation function (Quarterly inventory check to adjust inventory level to match physical inventory
* Capability to export csv data or connect via Power BI to daily inventory level (qty and cost) by each SKU
* Flexibility to for the app to be adjusted in future
Budget: Thinking of around $5K USD but will fluctuate based on discussion and hours
Project: Will start with Number 1 project and review. Then potentially award Number 2 project.
Project Description
Utilizes Microsoft environment
1) Order Management
* an interactive page to manage package orders
*Users will create new orders, use the PO, Product, Quantity, and cost information and submit orders
* (Optional) Track order status
* Receive quantity in system once physically received
* Document overages and shortages of virtual to physical inventory
* Flexibility to add in additional features, such as barcode scanning, etc to improve automation
* Capability to split out csv file
2) Inventory Management
* Enter snapshot inventory qty currently carrying
* Adjusts inventory quantity and cost up and down based on FIFO
* (from previous) adjust quantity according to a csv data dump or user enters quantity used
* Inventory reconciliation function (Quarterly inventory check to adjust inventory level to match physical inventory
* Capability to export csv data or connect via Power BI to daily inventory level (qty and cost) by each SKU
* Flexibility to for the app to be adjusted in future