The Export Planning Tool is a powerful and user-friendly MERN stack application designed to assist warehouse managers in streamlining the process of estimating the required number of trailers at the time of receiving an order. With the increasing demand for faster deliveries, it is crucial for warehouses to accurately predict the number of trailers needed to distribute their stock efficiently. However, predicting the number of trailers before the warehouse order has been fully picked and the number of pallets available can be challenging.
Our app utilizes historical data to provide accurate estimates based on the average of the five previous weeks, or specific days of the week. With the app's intuitive charts and graphs, you can easily identify seasonal order spikes and be prepared for the growing demand. The application is designed to be simple and easy to use, allowing warehouse managers to make better-informed decisions and improve overall efficiency.
- React: A JavaScript library for building user interfaces
- Nodejs: A JavaScript runtime built on Chrome's V8 JavaScript engine
- Material-UI: A popular UI library for React
- MongoDB: A NoSQL document-oriented database
- Chart.js: A JavaScript library for creating charts and graphs
- Heroku: A cloud platform to deploy and run web applications
- Moment.js: A JavaScript library for working with dates and times
- react-countup: A React component for animating numbers
This App is deployed on free heroku hosting, please allow some time when opening application for the first time.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
- As a warehouse manager, I want to input the number of cases ordered for each product category on a specific day, so that I can keep track of the inventory.
- As a warehouse manager, I want to retrieve the number of cases ordered for each product category on a specific day, so that I can check the progress of the order.
- As a warehouse manager, I want to see the total number of cases, pallets, and trailers for all product categories of the day or week, so that I can have an overview of the inventory.
- As a warehouse manager, I want to amend the number of cases ordered for each product category on a specific day, so that I can make adjustments if needed.
- As a warehouse manager, I want to see the expected value or number of trailers for each product category on a specific day, based on the average of the last five weeks, so that I can prepare for the demand.
- As a warehouse manager, I want to see the expected number of pallets and trailers based on the actual number of cases once known from the received order, so that I can ensure efficient distribution.
- As a warehouse manager, I want to compare the expected values versus the actual values of each product category for any weekday on a bar chart, so that I can identify any discrepancies.
- As a warehouse manager, I want to see the cases, pallets, and trailers of the last five weeks of the same weekday on a line chart, so that I can identify any patterns or trends.
- As a warehouse manager, I want to see the total cases, pallets, and trailers for each day of a selected week on a line chart, so that I can plan for the demand.
- As a warehouse manager, I want to be able to filter the charts by product category, so that I can focus on specific products.
