Yes, I'm sure you're already accounting for OTIF, but are you factoring in everything?
OTIF calculates the percentage of deliveries made on time and in full versus the total number of deliveries. To report OTIF, several types of data are necessary:
1. Delivery Dates: The scheduled and actual delivery dates are crucial to determine if a delivery was made on time.
2. Order Details: Information about the quantity of product ordered and delivered is needed to assess if the delivery was made in full.
3. Sales Orders: The total number of sales orders and the number of orders delivered on time and in full are used to calculate the OTIF percentage.
4. Product Information: Details about the products ordered and delivered are necessary to ensure the correct items were delivered.
5. Location Information: The delivery location is important to ensure the products were delivered to the correct place.
6. Inventory Data: Information about stock levels and availability can help identify potential issues that might affect OTIF performance, such as stockouts.
7. Shipping Dates: In some cases, companies base their OTIF metric on the customer’s desired ship date and compare that to the order’s actual ship date.
8. Carrier Data: Accurate capturing, collecting, and consolidating data from within your carrier base is crucial for reliably calculating your OTIF score.
Remember, the way OTIF is calculated can vary between companies and even between different retailers. It's important to understand the specific requirements of your customers or partners when collecting data for OTIF reporting
