Manage Your Inventory in Excel - James H. Byrd
Jan 05, 2012 · I'll show you how to calculate a safety quantity later in the article. Estimating a Sales Forecast. In order to figure out your lead time sales and a safety quantity, you first have to estimate your maximum and average sales. These figures will let you calculate a sales variation, which is one component of your safety quantity formula.