Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Wrong Total

Safety Stock =
VAR MaxWeeklyDemand = [Max]
VAR LeadTimeWeeks = [Max Lead Time in Weeks]
VAR AvgWeeklyDemand = [Avg]
VAR AvgLeadTimeWeeks = [Average Lead Time In Weeks]
VAR DesiredServiceLevel = [Desired service level]

RETURN
((MaxWeeklyDemand * LeadTimeWeeks) - (AvgWeeklyDemand * AvgLeadTimeWeeks)) * DesiredServiceLevel

((16355*17) -(3661*17))*3.09

Given values:
MaxWeeklyDemand = 16355
LeadTimeWeeks = 17
AvgWeeklyDemand = 3661
AvgLeadTimeWeeks = 17
DesiredServiceLevel = 3.09

Getting a total of 666800 which is incorrect. The actual total is 666815.82.
Can anyone help with this?

Test 1 = [Max]*[Max Lead Time in Weeks]
              16355*17
             =278035(Expected total)

 

2 Replies