Forum Discussion
Set a Low Inventory Reminder/Alert in Excel?
Our operations team has a very complex inventory report which pulls information from several platforms to help plan inventory for our regular customers. Unfortunately, we do not have an automated syst...
ALM I am not entirely sure if this is the kind of thing you're looking for. Again, you are familiar with your data, your situation. So I was doing my best to guess from the spreadsheet and your earlier description. The formula shown below is in column R, and gets the total of the allocated quantities from the inventory sheet for each item number shown in column B of the forecast sheet. You can then compare those totals with your quarterly projections---I"m assuming you can do that part.