Sandip Roy
New Member
Dear friends,
Till now I have been using a spreadsheet where safety stock is calculated on sales demand, inventory optimisation & procurement optimisation also calculated on virtual incoming of material based on lead time.
Now system is asking little different. Safety stock will be lead time demand + min Stock maintain. Procurement planning would be based on sales demand but in case sales does not reach or crosses the demand or material does not arrive in time, then immediately it will reflect on next procedures but never it will cross max inventory. Max inv will also be calculated automatically. That means inventory & procurement optimisation both will be done at the same time. Little confused to generate the formula.
Am attaching my existing spreadsheet, there I have highlighted yellow the new system, rst are existing.
Kindly help.
Regards
Sanndip
Till now I have been using a spreadsheet where safety stock is calculated on sales demand, inventory optimisation & procurement optimisation also calculated on virtual incoming of material based on lead time.
Now system is asking little different. Safety stock will be lead time demand + min Stock maintain. Procurement planning would be based on sales demand but in case sales does not reach or crosses the demand or material does not arrive in time, then immediately it will reflect on next procedures but never it will cross max inventory. Max inv will also be calculated automatically. That means inventory & procurement optimisation both will be done at the same time. Little confused to generate the formula.
Am attaching my existing spreadsheet, there I have highlighted yellow the new system, rst are existing.
Kindly help.
Regards
Sanndip