Welcome to the MERN Warehouse Planning Tool dashboard! The dashboard provides a visual representation of key metrics and insights to streamline your warehouse planning process. Here's an overview of the six main components:
-
Order Demand History Area Chart
The first component is a dynamic area chart that displays the historical trend of ordered demand and corresponding pallets picked. Use this chart to identify upcoming spikes in demand and plan accordingly. You can apply filters and settings to focus on specific data points. Refer to the "Chart Filters" section for more details.
-
Demand vs. Picked Pallets Line Chart
The second component features two line charts that compare demand and pallet stacking. Detect anomalies and changes in stacking patterns that may require investigation. Applying filters and date ranges helps you analyze data effectively. In usual circumstances, the two lines will maintain parallel, indicating a consistent stacking efficiency. However, when a significant gap occurs between the two lines, this suggests an anomaly. Anomalies could signify issues such as partial picking or inefficient consolidation, leading to increased delivery costs.
-
Average Cases per Pallet Bar Chart
Number 3 showcases a bar chart illustrating the average number of cases per pallet for a specific product within the selected date range. Just like other charts, you can modify settings to tailor the view to your needs.
- Trailers Board
The Trailers Board is a virtual whiteboard displaying loaded trailers. It includes essential information such as shipment date, delivery date, and border crossing time. Stay organized and track trailer movements with ease.
- Red: Indicates the presence of alcohol in the trailer.
- Green: Indicates certified products in the trailer.
- White: Indicates no certification or alcohol in the trailer.
Double-click to open the trailer row to open the Trailer Details.
- Category Distribution Pie Chart
Component 5 presents a pie chart depicting the distribution of total cases sent by category as a percentage for the selected year. Gain insights into category-wise shipment proportions.
- Monthly Trailer Statistics
Lastly, component 6 offers a summary box presenting statistics for the selected month. Find the total trailer count, overall cost, additional charges, and average case delivery cost conveniently.
The chart settings allow you to customize the data displayed on the charts for a more focused analysis. You can adjust the following settings:
- Date Range: By default, the charts show data for the last 30 days. You can change this date range to view historical data over a different period.
To change the date range, locate the date range selector on the chart interface and select your desired start and end dates. Product Selection:
-
Select Products: Choose specific products to be displayed on the chart. You can do this by clicking on the product names.
-
Select Category: Alternatively, you can choose to display all products within a specific category. When selecting a category, all products in that category will be automatically selected for display on the chart.
-
Show All: If neither specific products nor a category is selected, the chart will display data for all available products.
These settings provide flexibility in customizing your analysis, allowing you to focus on the data that is most relevant to your planning needs.
1 Trailer Number:
- Enter the unique identifier for the trailer. Avoid using spaces or special characters.
2 Load Type:
- Select the load type from the dropdown list. The load type represents the temperature requirements for the trailer's cargo.
3 Contractor Name:
- Choose the contractor's name from the dropdown list. This indicates the company responsible for the trailer.
4 Load Date:
- Select the date when the trailer was loaded or sent from the warehouse.
5 Arrival Date:
- Choose the date when the trailer should arrive at its destination.
6 Reference Number:
- If you've selected "JCARRION" as the contractor, this field becomes disabled, and a reference number is automatically generated. For other contractors, manually add a reference number related to this trailer. Freight Type:
7 Freight-Type
- Select the freight type from the dropdown list. Choose from options such as road, air, or sea to specify the mode of transportation for the trailer.
8 Contains Alcohol:
- Check this box if the trailer contains alcohol products.
9 Requires EHC Certificate:
- Check this box if the trailer contains products that require an EHC (Export Health Certificate) certificate.
10 Exit from the UK:
- Select from the dropdown how the trailer will leave the UK, for example, through the tunnel or ferry.
11 Comments:
- Add any comments or notes related to the trailer. For instance, you can mention specific details like the location of certain customer orders.
12 Product Selection:
- Select a product from the dropdown list that you want to add to the trailer.
13 Pallets Loaded:
- Specify the number of pallets of that product loaded onto the trailer. This field can be left empty if not applicable.
14 Cases Loaded:
- Enter the number of cases of this product loaded onto the trailer. This field cannot be left empty. Add Product:
Click the "+" icon to add the selected product with the specified pallets and cases to the product list.
After adding all the necessary products and details, click this button to create the trailer record.
1 Trailer Number:
- Red: Indicates the presence of alcohol in the trailer.
- Green: Indicates certified products in the trailer.
- White: Indicates no certification or alcohol in the trailer.
2 Reference Number:
- Composed of the delivery date plus four digits of the trailer number.
3 Send Date:
- Shows when the trailer was loaded and sent.
4 Delivery Date:
- Displays the expected arrival date of the trailer.
5 Clearance:
- Shows the date and time when the trailer was cleared by customs.
- Remains empty if not cleared yet.
6 Received:
- Shows the date the trailer was actually received by the store.
- Remains empty if not received yet.
7 Freight Type:
- Indicates the mode of transportation (e.g., road, air, sea).
8 Certified:
- Indicates whether the trailer contains certified stock.
- Options: Yes or No.
9 Alcohol:
- Indicates whether the trailer contains alcohol.
- Options: Yes or No.
10 Extra Cost:
- Displays the total extra cost associated with the trailer.
11 Extra Cost Reasons:
- Displays reasons for the extra cost, including price details.
- Multiple lines may be added for different reasons.
12 Comments:
- Allows users to add comments related to the trailer.
13 Action Buttons:
- Edit: Allows users to edit trailer details.
- Delete: Deletes the trailer, with a confirmation prompt.
14 Pie Chart:
- Displays a pie chart showing the percentage of pallets for each product in the trailer.
15 Total:
- Shows the total number of pallets and cases loaded into the trailer.
16 Pallet Breakdown:
- Provides a breakdown of cases and pallets for each product separately.
17 User Information:
- Displays the name of the user who created the trailer.
- Also shows the name of the user who made any changes to the trailer.
- If no changes have been made, this field remains empty.
You can use the "Edit Trailer" page to update important timestamps related to clearance and when the trailer is received by the store. Here's how you can do it:
-
Clearance: Shows the date and time when the trailer was cleared by customs. This field remains empty if the trailer has not been cleared yet. You can update this field with the clearance date and time once customs clearance is obtained.
-
Received: Indicates the date the trailer was actually received by the store. This field remains empty until the trailer is received. You can update this field with the date and time when the store receives the trailer.
In addition to these timestamps, you can also make other necessary edits on this page to keep the trailer record accurate and up-to-date, ensuring that all relevant information is reflected in the system.
-
Freight-Type Defines freight transportation modes (e.g., Road, Sea, Air). Used when creating or editing trailer details.
-
Contractors Specifies service provider (e.g., Eddie Stobart, J Carrion). Selected when managing trailer details.
-
Crossed Records the trailer's entry or exit route (e.g., Port, Ferry). Chosen during trailer management.
-
Load-Type Indicates trailer temperature requirements (e.g., Ambient, Frozen). Assigned when managing trailer details.
-
Products Adds new products and assigns categories. Impacts charts, filters, and Day details.
- To add a new option, add the name in to the input and click the "+" icon next to the respective box.
- Remember to click "Save Changes" after adding new options or removing existed.