Formula Help

[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!

 

[Sheeloo]

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?

 

[cempire5]

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

 

[Sheeloo]

=(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...