I have read (and hopefully understood, but that's why I'm here...) all the support documentation on this and several forum threads and am stuck for an answer. Hopefully this hasn't already been discussed, but any help is appreciated.
I cannot make heads or tails of the auto calculation logic. I've made a calculator in Excel using the same assumptions as documented by NS, but we always come up with different figures.
Assumptions
Item X, has sales history > 6 months and consistently
Preferred Stock Level: Autocalc checked, set for 90 days
Reorder Point: Autocalc checked
Lead Time: Autocalc checked
Safety Stock Level Days: 14
No seasonality
Inv Management Preferences: 6 months analysis, 0% demand change, based on actual sales,
Given that actual sales is driven of invoices/cash sales/assembly builds, I've written a search to get this figure. I even specified in the criteria that this is the last 6 months, not the last 182.5 days.
Search shows 194 units demand in the last 6 months. (and yes, the negative value on assembly builds has been corrected).
Calculated outside of NS
194 units / 182.5 to get daily demand = 1.06 units per day. (dunno how to get 6 months vs. 182.5 done in Excel)
This item should have 90 days preferred stock, so 1.06*90 = 96 units PSL
Reorder point should be ( lead time + safety stock ) * daily demand, which is 93 days + 14 days *1.06 = 114 units ROP
I manually trigger a recalculation to see what NS produces...
NS Calculations
PSL 103 units
ROP 103 units
I do understand why ROP and PSL are equal. I do not understand where 103 units comes from - if all my assumptions are correct (are they?) it should be 114.
I want to have faith in these figures, but I need to understand where they come from and be able to reproduce them on my own before I trust NS to handle this.