Hi there,
I have no idea what function I need for this but I am hoping there is a quick way to do the calculation without creating a table...
I am trying to estimate the cost of warehousing stock for a set period. To simplify what I am trying to calculate:
If we use 10 items per week for 5 weeks and each item costs £1 per week to store then the total cost for storage over the period would be:
Order Stock Storage
Start - 50 -
week1 10 40 £40
week 2 10 30 £30
week 3 10 20 £20
week 4 10 10 £10
week 5 10 0 £0
TOTAL 50 100 £100
Can his be done in a single formula without having to create a table?
Thanks
Bookmarks