Calculating "Weeks of Supply" in Excel

In retail there is an important measure called "Weeks of Supply", which essentially determines how long the current inventory will last based on a future sales forecast. Calculating Weeks of Supply in Excel is difficult since you have to determine how many cells (weeks) would be added up from the sales forecast before you exceed the current inventory....

Continue Reading Add comment June 30th, 2006