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...
I would want an example file that included at least 10 rows of data, so as to test any formulas, and the data should be such that it produces different results to test whether or not the conditions are being set appropriately. You are very familiar with the reality that this is supposed to represent, so minimal data may suffice in your mind; but folks from the outside need a more complete picture. Help us help you by painting a fuller picture of the kinds of situations that will arise in the real world, situations in which some of the data requires a replenishment reminder, some is just fine, etc.
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.