Spreadsheet: 859147d1707608606-calculate-ship-date-based-on-lead-time-and-day-of-the-week-book2
Sheet: CS WIP

Customer | Five Star Gourmet Foods |  |  |  |  | Customer Notes
PO# | 12345678 |  | PO Date | 2024-02-21 00:00:00
Cust Code |  |  | Delivery Address
Lead Time
Ship Via
Carrier
ORDER DETAILS
SRF Order # |  |  |  |  | Override Ship Date |  |  | Via
Req'd Del Date | 2024-03-06 00:00:00 | Req'd Ship |  | Within Lead Time? |  |  | Lead-Compliant Ship Date |  |  |  |  | [NAME] |  | DtD After P/U
 | Product # | Qty | Description |  |  |  | GTIN | Cat | Cat Freight Multiplier | Flagged |  | Pallet Cube | TiHi | GCW | GIW
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
 | Order Notes
Customer Freight Structure
1 Pallet:
2 Pallets:
3 Pallets:
FREIGHT/SHIPPING DETAILS
Full Pallet Req? |  |  | Delivered Pricing
Pallet(s) Cube |  |  | Enter in Freight Tracking -> | Freight |  | Fuel |  | Total
Pallet Count |  |  | FOB Pricing | Freight |  | Fuel |  | SRF
Weight |  |  |  |  |  |  |  | Total
Ship-To Zip
Ship Week
 | New Order Entry Processes |  |  |  | Ship Prep Processes
 | [NAME] |  |  |  | P/U appt scheduled by carrier & added to All Shipping & Outlook calendars
 | Enter order in FDS |  |  |  | Lots assigned from Pick Sheet
 | Flags reported to Sales@ |  |  |  | Driver paperwork generated
 | Rate Quote/BOL sent to carrier (CC: Shipping@) |  |  |  | [NAME]
 | Carrier confirmed |  |  |  | Print Invoice
 | Freight Tracking entered (unless a P/U) |  |  |  | Enter Invoice # in Freight Tracking (unless a P/U)
 | Added to All Shipping calendar |  |  |  | [NAME] to customer through FDS unless an SPS/EDI customer*
 | FDS prices match PO prices (usually minus [NAME]) |  |  |  | SPS/EDI: create shipment & print
 | Order confirmed to customer |  |  |  | SPS/EDI: create invoice & print
Product # | GTIN Verification | Item Desc |  |  | PO Qty | GCW | GIW | CPFP | Class | TiHi
Sauces
31-1020 | 00812177011839 | ABC Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1030 | 00812177011778 | General [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1040 | 00812177011747 | Orange Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1050 | 00812177011723 | Sweet & Sour Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1061 | 00812177011815 | White Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1070 | 00812177011822 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1080 | 00812177011921 | Hunan II Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1090 | 00812177011884 | Pad Thai Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-1180 | 00812177012508 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2000 | 00812177011877 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2001 | 00812177012416 | Savory Brown Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
31-2010 | 00812177011754 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-1100 | 00812177011808 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-9045 | 00812177011860 | Red Pepper Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
34-9060 | 00812177011853 | Hot & Sour Solution |  |  |  | 25.5 |  | 77 | S | 11 x 7
35-9065 | 00812177011846 | Stir-Fry Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1525 | 00812177012027 | Jump General Tso Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1875 | 00812177011983 | [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
36-1940 | 00812177011730 | [NAME] [NAME] |  |  |  | 25.5 |  | 77 | S | 11 x 7
59-0005 | 00812177011785 | RS: Teriyaki with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
59-2065 | 00812177011891 | RS: General Tso with Flaxseed Sauce |  |  |  | 25.5 |  | 77 | S | 11 x 7
Proteins
35-1928 | 00812177012249 | HT Chicken Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10
35-1938 | 00812177012256 | HT Pork Nuggets |  |  |  | 11.5 |  | 110 | P | 11 x 10
35-1948 | 00812177012263 | HT Dark Chicken Chunk |  |  |  | 11.5 |  | 110 | P | 11 x 10
45-1950 | 00812177012546 | FC Sliced Beef |  |  | 110 | 11.5 |  | 110 | P | 11 x 10
45-1965 | 00812177012539 | FC [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10
45-2050 | 00812177012584 | [NAME] |  |  |  | 11.5 |  | 110 | P | 11 x 10
60-1950 |  | 20 OZ/SRF FC-Beef Slice |  |  |  | 1.3125 |  | 800 | P | 800 x 1
60-1965 |  | 20 OZ/SRF FC-Chicken Slice |  |  |  | 1.3125 |  | 800 | P | 800 x 1
Kits
37-1070 | 00856460001305 | Teriyaki Beef |  |  |  | 17.75 |  | 70 | K | 7 x 10
37-1090 | 00856460001138 | Beef with Broccoli |  |  |  | 17.75 |  | 70 | K | 7 x 10
37-1180 | 00812177011129 | [NAME] |  |  |  | 17.25 |  | 70 | K | 7 x 10
37-1200 | 00812177012423 | Thai Chili Chicken |  |  |  | 10.5 |  | 110 | K | 11 x 10
37-1210 | 00812177012966 | Breakfast Fried Rice w/ Turkey |  |  |  | 16 |  | 110 | R | 11 x 10
68-5010 | 00812177012577 | Fried Rice |  |  |  | 16.5 |  | 110 | R | 11 x 10
68-5020 | 00812177012911 | White Rice |  |  |  | 16.5 |  | 110 | R | 11 x 10
78-0010 | 00812177012867 | Orange [NAME]P&S ONLY* |  |  |  | 9.5 |  | 110 | K | 11 x 10
78-0020 | 00812177012874 | General [NAME] veg* |  |  |  | 11 |  | 110 | K | 11 x 10
78-0030 | 00812177012881 | Beef with Broccoli *w/ veg* |  |  |  | 11 |  | 110 | K | 11 x 10
78-0050 | 00812177012898 | Veg [NAME] veg* |  |  |  | 14 |  | 110 | K | 11 x 10
78-0060 | 00812177012935 | [NAME] veg* |  |  |  | 11 |  | 110 | K | 11 x 10
[NAME].
30-8030 | 00043431003011 | Pre-Cooked Lo Mein Noodles |  |  |  | 32 |  | 60 | M | 15 x 4
33-7005 | 00812177012188 | 3 oz Pork & Shrimp Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10
33-7122 | 05265118261001 | 1 oz Spring Roll |  |  |  | 27 |  | 48 | SR | 12 x 4
33-7100 | 00812177012171 | 3 oz Southwestern Chicken Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10
34-1667 | 00812177012195 | 3 oz Vegetable Egg Roll |  |  |  | 18.75 |  | 70 | ER | 7 x 10