M
Marcy
Please see following scenario. My issue is I would like to make this a bit more user friendly (for the"head-honchos!) So, if I were to change the start date from 10-17-03 t0 12-12-03, for example and change the leadtimes from 26 to 0 for the first event, all the subsequent dates will change. So far, so good. But, the end of the scenario is where I can't figure out how to manipulate. As you can see, I have it set up to subtract 49 days from the ship to customer date as that is only date that CANNOT change. So, if I were to make the cahnges as above, I would want the final step (REQUIRED X-factory) to reflect 49 days from the ship to customer date OR the earlier date of the ACTUAL x-factory (whichever would be the earlier of the two) BUT it must fall on a Saturday (or Tuesday; if you wouldn't mind including both scenarios
Note: This s/s runs from JUne 2004 through January 2005, using weeks 1-4 or weeks 1-5 as the case may be
I hope I made this understandable. If you need me to clarify, please advise
As always, thanks so much! I couldn't have gotten this far without you guys
LEAD JUNE
TIME WK1
CAD ARTWORK/color standards TO SUPPLIER 10/17
LAB DIP --1st SUBMITS w/comments (21+5) 26 11/12
LAB DIP --2nd SUBMITS w/comments (10+4) 14 11/26
LAB DIP --final deadline--must be approved (10+4) 14 12/11
BUY DETAILS COMPLETE (weekday): 5 12/16
PO ISSUED TO FACTORY (weekday) 3 12/19
BULK PG WEAVING/KNITTING BEGINS (From time of issue of PO) 5 12/24
**ADAR SAMPLE (From time of issue of buy details) 10 12/26
PG/COMPONENTS DELIVERED TO FTY/CUTTER (from time of fabric begins) 40 2/2
FABRIC DUE TO ITS FOR ISACO TESTING (2days from receipt of fabric) 2 2/4
FINAL DEADLINE FOR ITS TEST RESULTS (5 working days for COMPLETION) 7 2/11
TRIM CARD APPROVALS deadline 7 2/18
PRE-PRODUCTION SAMPLES APPROVAL deadline 7 2/25
SPREADING/CUTTING BEGINS 1 2/26
ASSEMBLY BEGINS 3 3/1
TOP'S (start ship) 4 3/5
PRODUCTION COMPLETED (from time of ASSEMBLY BEGINS) 30 3/31
FINAL INSPECTION 1 (b22) 4/1 (cells C22 & B22 are added as follows
X-FACTORY (SATURDAY) 1 4/3
=WORKDAY(C22+$B23-1,1,HOLIDAYS)-WEEKDAY(WORKDAY(C22+$B23-1,1,HOLIDAYS)-7)+
SHIP TO CUSTOMER DATE >>> 6/4 (cell C24 remains constant
REQUIRED x-FTY(SATURDAY)(sail date=Tuesday) based on minimum 49 days
(water [32] + customs [3] + whse [14] days from x-fty to ship to customer 4/10 current formula: =C24-49-WEEKDAY(C24-49
Note: This s/s runs from JUne 2004 through January 2005, using weeks 1-4 or weeks 1-5 as the case may be
I hope I made this understandable. If you need me to clarify, please advise
As always, thanks so much! I couldn't have gotten this far without you guys
LEAD JUNE
TIME WK1
CAD ARTWORK/color standards TO SUPPLIER 10/17
LAB DIP --1st SUBMITS w/comments (21+5) 26 11/12
LAB DIP --2nd SUBMITS w/comments (10+4) 14 11/26
LAB DIP --final deadline--must be approved (10+4) 14 12/11
BUY DETAILS COMPLETE (weekday): 5 12/16
PO ISSUED TO FACTORY (weekday) 3 12/19
BULK PG WEAVING/KNITTING BEGINS (From time of issue of PO) 5 12/24
**ADAR SAMPLE (From time of issue of buy details) 10 12/26
PG/COMPONENTS DELIVERED TO FTY/CUTTER (from time of fabric begins) 40 2/2
FABRIC DUE TO ITS FOR ISACO TESTING (2days from receipt of fabric) 2 2/4
FINAL DEADLINE FOR ITS TEST RESULTS (5 working days for COMPLETION) 7 2/11
TRIM CARD APPROVALS deadline 7 2/18
PRE-PRODUCTION SAMPLES APPROVAL deadline 7 2/25
SPREADING/CUTTING BEGINS 1 2/26
ASSEMBLY BEGINS 3 3/1
TOP'S (start ship) 4 3/5
PRODUCTION COMPLETED (from time of ASSEMBLY BEGINS) 30 3/31
FINAL INSPECTION 1 (b22) 4/1 (cells C22 & B22 are added as follows
X-FACTORY (SATURDAY) 1 4/3
=WORKDAY(C22+$B23-1,1,HOLIDAYS)-WEEKDAY(WORKDAY(C22+$B23-1,1,HOLIDAYS)-7)+
SHIP TO CUSTOMER DATE >>> 6/4 (cell C24 remains constant
REQUIRED x-FTY(SATURDAY)(sail date=Tuesday) based on minimum 49 days
(water [32] + customs [3] + whse [14] days from x-fty to ship to customer 4/10 current formula: =C24-49-WEEKDAY(C24-49