The Customer Flows Comparison template
The "Customer Flow Comparison" sheet is a template designed to compare two different customer flows scenarios selected by the modeler. You can duplicate and modify this template according to your needs.
If the visualizations are not automatically populated, make sure the model inputs and outputs align with the columns specified in each visualization. To ensure that the Site Production Throughput maps are accurately populated, make sure all the Sites and Customers in the model are properly geocoded.
See Customizing templates for customization suggestions.
Customer Flows Comparison Dashboard
| Visualization | Description |
|---|---|
| Scenario A and Scenario B filters |
The Customer Flow Comparison sheet compares two user-selected scenarios. The scenarios can be filtered by the following elements:
As you make selections, the visualizations in the sheet update to reflect your choices. You can close the filters to free up space on your dashboard. Click the red X to the left of the filters to close them. To reopen the filters, click |
| Total Cost | The total cost of the customer flows for the scenario. |
| Total Flow Units | The total customer flow units for the scenario. |
| Flow Cost and Units by Source for Scenario A graph | For Scenario A, this graph displays the amount product flowing through each site (bars) and the cost of the customer flows (line) for each site. |
| Flow Cost and Units by Source for Scenario B graph | For Scenario B, this graph displays the amount product flowing through each site (bars) and the cost of the customer flows (line) for each site. |
| Customer Flows Details table | This table displays the customer flow details, comparing Scenario A and Scenario B in different columns. |
| Customer Flow Map for Scenario A map | This map displays the flow of products to customer sites for Scenario A. |
| Customer Flow Map for Scenario B map | This map displays the flow of products to customer sites for Scenario B. |
.Last modified: Tuesday March 25, 2025