Hi
Trying to think of a formula that will tell me the number weeks stock I have,would like to put the formula in h6 and copy across giving me the weeks stock
Green line is sales, yellow balance stock
EX1.JPG
Any help would be good, need job and its driving me insane!
Hi and welcome to the forumIt moght help if you provided some extra data? You have no sales, no consumption/sale etc?
Also, I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi
Sorry panic mode disengaged!
Ok, the green line is the forecast/consumption, the yellow line is the stock moving through the months less the forecast/consumption.
I need a formula that works out how many weeks cover I have every month.
Thanks
Gary
The WB you provided is really no different to the pic you provided. Unless Im missing something, what consitutes a week's consumption/usage? If you have that value, then it should be a simple matter of =stock-for-that-month/(4*weekly consumption)??
Hi
Sorry, I need a formula to calculate forward the number of weeks cover based on the stock level for that month less the on going forecasts. Simplest way I can put it is if I have 1000 units in March, based on the forecast april may etc, how many weeks stock would I have in March
Month F M A M J J A S
Sales 10 10 10 10 10 10 10 10
Stock 100) 90 80 70 60 150 140 130 120
Replenish 100
Weeks Cover ?
Last edited by dreamer1963; 03-13-2014 at 04:19 PM.
OK maybe this?
=I4/I2/4
I am really struggling to write what I needA formula that will give me how many weeks stock I have based against a monthly forecast and current stock level, It has to take in to account the rest of the monthly forecast to give me a weeks cover figure.Trying to maintain 8 weeks cover through the year, so need something that will highlight when stock cover drops below 8 weeks
jan feb mar apr may
A1 Forecast 10 10 10 10 10
A2 Stock 100 90 80 70 60 50
A3 Coverage wk ? (need to know based on stock of 90 and forecast when I will drop below 8 weeks of stock )
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks