ricafonyat
New Member
- Joined
- May 1, 2017
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Dear all,
My goal is to distribute the inventory of items in the months from the start date according to the velocity (From column Jun.24 to column Nov.24).
For example:
If I have 60 items in stock and their sales velocity is 3 and the start sales date is Sep.24, the formula should allocate 20 items in the months from Sep to Nov.
If the start sales date is less than or equal to the item, it can be allocated in the month.
Which excel formula will work in this case?
Base Month= jun/2024
Any help will be appreciated
My goal is to distribute the inventory of items in the months from the start date according to the velocity (From column Jun.24 to column Nov.24).
For example:
If I have 60 items in stock and their sales velocity is 3 and the start sales date is Sep.24, the formula should allocate 20 items in the months from Sep to Nov.
If the start sales date is less than or equal to the item, it can be allocated in the month.
Which excel formula will work in this case?
Base Month= jun/2024
Any help will be appreciated
Item | Price | Stock | Start Date | Velocity | jun/2024 | jul/2024 | ago/2024 | sep/2024 | oct/2024 | nov/24 |
Pen | 2,25 | 10 | jan/2024 | 1 | 10 | |||||
Pencil | 1,80 | 20 | mar/2024 | 2 | 10 | 10 | ||||
Eraser | 0,85 | 30 | jun/2024 | 2 | 15 | 15 | ||||
Notebook | 4,30 | 60 | sep/2024 | 3 | 20 | 20 | 20 |