My assumptions are: I receive 100 bins on day 1 of each month. I issue the bins equally each week and there are four weeks in a month. The cost to store 1 bin is $10 per day. I am looking to insert 1 formula that calculates the monthly cost. I have attached a sample file.
Thanks in advance
In J12 cell
Formula:
Please Login or Register to view this content.
Or
In J12 cell
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for your reply but both those formulas give the wrong answer. Stock days should be a variable.
In your example, which is the expected result?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The answer is 17 500 based on 7 days stock holding but I would like the number of days to be a variable field.
Just an idea...
In J2 and copy down to J5.
=COUNTA($A$2:$A$100)/4
Then in J12, this one
=I6*10*J2
Ηι
I'm just curious. Did you found the solution ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks