Joppy - Correct, we're continually getting various numbers of pallets of parts that have different amounts on them, all of which are worked down to 0 at different rates
Opalg - Thanks so much! I'll use this link and work that into my spreadsheet. This is exactly what I was looking for!
Hi,
I am working on building some excel spreadsheets, and need to know the terminology for a math process to help with building formulas. This is the situation I'm working on:
I am charged \$10/pallet of goods per month.
I order 10 pallets of material, of which 2 pallets every month are...