|
Customer Market Bucket Overview
The Customer Market Bucket Overview screen lists all Customer Market Buckets. A “Customer Market Bucket” is what you get if you add a customer’s stock of a certain product (or Product Variant), and their customers’ stock, and so on until the end customer.
Fill Rate – the fill rate is a percentage that shows how well the supply chain ahead of the customer is meeting the demand for the product.
· If the fill rate is 0% the quantity of goods in the supply chain is enough to last for the Safety Time + the Lead Time.
· If the fill rate is below 0%, the quantity of goods in the supply chain is not enough to last for the Safety Time + the Lead Time.
· If the fill rate is 100%, the quantity of goods in the supply chain is at a desirable level.
· If the fill rate is above 200%, the quantity of goods in the supply chain is enough to last for more than the maximum time + the Lead Time.
The Fill Rate field is
· red when the quantity of goods in the supply chain is not enough to last for the Lead Time.
· yellow when the fill rate is less than 0%, but the quantity of goods in the supply chain is enough to last for more than the Lead Time.
· green when the fill rate is between 0% and 200%.
· blue when the fill rate is above 200%.
Fill Rate (Time) – the accumulated run-out time relative to the preferred time (see No. 7 below). This value tells you how critical the situation is with this product and helps you prioritize. It is negative if the fill rate (No. 1) is below 100%.
Fill Rate (Balance) – the total stock balance relative to the preferred balance (see No. 7 below). This value tells you how much of this product you need to produce or order. It is negative if the fill rate (No. 1) is below 100%.
Duration – the total duration of the stock of the product that the customer and all customers ahead in the supply chain have. Duration is inventory level expressed in run-out time (“we have enough of the product for so and so many days”).
Lead Time – the Lead Time of the customer’s Market Bucket is the sum of the Lead Times set in all the delivery agreements for this product by the customer and all customers ahead in the supply chain.
Example If there are 9 customers ahead of this customer in the supply chain, and they all have a Lead Time of 1 day each, then the Lead Time of the customer’s Market Bucket is 10 days.
Safety Time– the Safety Time of the Market Bucket is the sum of the Safety Times set in delivery agreements for this product by the customer and all customers ahead in the supply chain.
Example If there are 9 customers ahead of this customer in the supply chain, and you and they all have a Safety Time of 2 days each, then the Safety Time of the customer’s Market Bucket is 20 days.
Pref Time – this is what the duration (see No. 4 above) of the customer’s Market Bucket should be, according to PipeChain Supply. The preferred time is based on the Safety Time, the Max Time and the Lead Time.
Max Time – the Max Time of the Market Bucket is the sum of the Max Times set in delivery agreements for this product by the customer and all customers ahead in the supply chain.
Example If there are 9 customers ahead of this customer in the supply chain, and they all have a Max Time of 10 days each, then the Max Time of the Market Bucket is 100 days.
Outflow – the total outflow (sales or use) per day of this product and customer plus all the customers ahead in the supply chain.
If you right-click on a row in the list of Own Market Buckets, you open a menu where you can choose the following commands:
Sort By - Opens a submenu where you can choose how to sort the list items.
View - Opens a submenu where you can choose how to manage the view/columns and show all columns.
Export - Export the view to Htm or to Excel.
Update – if you choose this command, the all Customer Market Bucket data are recalculated immediately. (Normally, the data are updated whenever a data exchange takes place with a customer).
If you double-click on a row you will enter Customer Bucket Detail screen for more information about this product.