Kubota Fill Rate Calculations
How to calculate Kubota Fill Rate in RIMSS
To view the Fill Rate for Kubota Parts go to Reports > Inventory Items > Item Metrics Report. Make sure to add the column Past 12 Months Fill Rate.
Select KUB in the Price Book Drop down and click on Fetch. The average will be the weighted average of based on the formula below.
How to calculate Fill Rate
| Actual Sales QTY | 20,000.00 |
| Plus Lost Sales QTY | 100.00 |
| Equals Total Potential Sales | 20,100.00 |
| Actual Sales Qty | 20,100.00 |
| Less Drop Ships | (100.00) |
| Less Back Orders | (5,000.00) |
| Equals Sold From Stock | 15,000.00 |
| Sold from Stock | 15,000.00 |
| Divided by Total Potential | 20,100.00 |
| Equals Fill Rate | 74.63% |