Max Alejandro Molina
Member
Hello Excel Ninjas,
I have been trying for so long to try to come up with a formula to calculate the "cycle time" specifically now for 4 months, unfurtunately with 0 succes....
The manual formula is: FR(Revision Frequency) + DT (Delivery Time) = CT (Cycle Time)
FR: If a store generates purchase orders in Tuesday and Friday, that would be a FR of 4 because you need to compare how many days are in between from one generation day to another and get bigger number. (Sometimes there will be stores that generate in 3 days per week). In this cases from Tue to Fri there are 3 days and from Fri to Tue there are 4 days which is longer (or bigger number).
At this point we have: FR(4) + DT (Delivery Time) = CT (Cycle Time)
In order to get the DT the procedure that needs to be done is:
The store Delivery days are: Monday and Thursday and generates purchase orders in Tuesday and Friday as previously said, so now we compare the days from purchase order generation days and delivery days; from TUE(generation) to THU (Delivery) there are 2 days and from FRI (generation) to MON (delivery) there are 3 days which is the bigger number (This is our Delivery time number).
Now we have FR(4) + DT(3)= CT(7 days!!!!!!)
Unfortunately I cannot do this with excel -_-
Can anybody help me????
Please look at the file with the results done manually.
I have been trying for so long to try to come up with a formula to calculate the "cycle time" specifically now for 4 months, unfurtunately with 0 succes....
The manual formula is: FR(Revision Frequency) + DT (Delivery Time) = CT (Cycle Time)
FR: If a store generates purchase orders in Tuesday and Friday, that would be a FR of 4 because you need to compare how many days are in between from one generation day to another and get bigger number. (Sometimes there will be stores that generate in 3 days per week). In this cases from Tue to Fri there are 3 days and from Fri to Tue there are 4 days which is longer (or bigger number).
At this point we have: FR(4) + DT (Delivery Time) = CT (Cycle Time)
In order to get the DT the procedure that needs to be done is:
The store Delivery days are: Monday and Thursday and generates purchase orders in Tuesday and Friday as previously said, so now we compare the days from purchase order generation days and delivery days; from TUE(generation) to THU (Delivery) there are 2 days and from FRI (generation) to MON (delivery) there are 3 days which is the bigger number (This is our Delivery time number).
Now we have FR(4) + DT(3)= CT(7 days!!!!!!)
Unfortunately I cannot do this with excel -_-
Can anybody help me????
Please look at the file with the results done manually.