Question: How does the Inventory Status Report months history calculation match the display in the Product History Inquiry window?
Answer: If you want to calculate five months of supply as of today and today’s date is July 21, The program takes five prior months (Feb through June) plus this month - July (month to date). It prorates the current month by multiplying 30 (hard coded in the program) by the number of days so far (21/30 = 0.70 months). It takes total units sold and divides by 5.7 (five previous months and 0.7 for July to date) to obtain the monthly average. It then takes available inventory and divides it by the monthly average figure to get the number of months supply.