Thomas Kuriakose
Active Member
Respected Sirs,
We have a monitoring workbook to capture issuance and receipts for PPE.
There are 16 types of PPE and 4 categories of employees to whom these PPEs are issued based on entitlement (Entitlement sheet).
For a new employee, the complete set is issued based on the category of employee and entitlement and for an existing employee, replacement of damaged or missing PPE is carried out.(Issuance Sheet)
The lead-time for replenishment from the vendor for the PPEs is 14 days. We need to carry out replenishment once a month or once in two months. The issuance cycle and dates are staggered.
There is a replenishment sheet in which we monitor Opening stock and Closing stock based on the issuance and receipts.
We need to know the week in which the order is to be placed to ensure safety stocks are replenished as well as Economic Order Quantity is generated.
Kindly check and let me know how to arrive at this.
Thank you very much,
with regards,
thomas
We have a monitoring workbook to capture issuance and receipts for PPE.
There are 16 types of PPE and 4 categories of employees to whom these PPEs are issued based on entitlement (Entitlement sheet).
For a new employee, the complete set is issued based on the category of employee and entitlement and for an existing employee, replacement of damaged or missing PPE is carried out.(Issuance Sheet)
The lead-time for replenishment from the vendor for the PPEs is 14 days. We need to carry out replenishment once a month or once in two months. The issuance cycle and dates are staggered.
There is a replenishment sheet in which we monitor Opening stock and Closing stock based on the issuance and receipts.
We need to know the week in which the order is to be placed to ensure safety stocks are replenished as well as Economic Order Quantity is generated.
Kindly check and let me know how to arrive at this.
Thank you very much,
with regards,
thomas