Formula Help

  • Thread starter Thread starter cempire5
  • Start date Start date
C

cempire5

I have a doc with numerous worksheets related to retail inventory, traffic,
each store's orders and a totals page. I want to total the quantity of a
particular item the store used during the month. Inventory and orders are
counted by lots (i.e., 50 per lot). I took last month's inventory + this
month's order - this month's inventory, (i.e.,
='invntry!c61+'ords09'!b156-'invntry'!c101), but I don't know if that's
right. I'm wondering if the amount of traffic the store had should be used
at all. Any help with the appropriate formula would be appreciated. Thanks!
 
If inventory and orders are by lots then your formula will give you the lots
used during the month...
If you want the quantity then use
=(invntry!c61 + ords09!b156 - invntry!c101) * 50

Orders should be orders delivered during the period...

Note: '' arond the sheetname are required only if sheetname has spaces...

What does traffic signify?
 
Hi Sheeloo,
Thanks for the " tip. Traffic signifies how many customers entered the
store that month. It doesn't mean that a sale occurred with every customer,
nor that every customer was given any or all of the inventory items we're
speaking of. Not sure if it's relevant; however, I find that many stores
order based on their traffic so that they are sure to have enough inventory.
Even a formula that gives the average of how many lots are used during the
month would be helpful. Thanks! ~M
 
=(invntry!c61 + ords09!b156 - invntry!c101) * 50
will give you the items used during the month
You may also track the traffic and see how it relates to the items sold when
you collect data for a few month...
 
Back
Top