Account Setup Worksheet

Coreflex™

New 3PL Account Setup Worksheet Questionnaire

Revision 4

Instructions:

Click here to download the form
Complete Electronically in Microsoft Word..
Completed one worksheet for each company for which you are managing inventory.
Save the worksheet file with a name of Your Company – Account Name.
E-mail completed form to your account manager.
Fax examples of all required / existing printed output for the Account to 201 808 2700.

1) Coreflex Client: _____________________ (Your company Name)

2) Account Name (The Company for which you are managing inventory.)

3) Account Bill To Address:

4) Are there any time critical business objectives to be considered when planning the startup schedule? (physical inventory date, live date, etc…)

___ Yes ___ No

If yes, please provide details:

_______________________________________________________________

5) Which best describes the type of Account? (indicate all that apply)

a) ___ Case In / Case Out.

b) ___ Split Case Pick

c) ___ Pallet In / Pallet Out (full)

d) ___ Pallet In / Pallet Out (full and split)

e) ___ Pallet In / Case Out

f) ___ Case In / Split Case Pick Out

g) ___ B2B Business to Business

h) ___ B2C Business to Consumer

i) ___ Other… Specify: _________________________

6) Type of Products: (indicate all that apply)

____ Refrigerated ____ Frozen ____ Dry Goods

____ Food ____ House wares ____ Clothing

____ Perishable ____ Non Perishable ____ Resin

____ Paper ____ Steel ____ Lumber

____ Garment on Hanger

____ Other… Specify __________________________

7) Product numbers and Barcodes:

a) Does each product have a unique product number / identifier?

____ Yes ____ No

b) Does each product have a barcode label?

____ Yes ____ No

c) If yes, does the data in the barcode match the product identifier?

____ Yes ____ No

8) What is the inventory unit? This is the unit that the account will use to count the inventory:

____ Case ____ Each ____ Piece

____ Pallet ____ Cases on Pallet ____ Pounds

____ Rolls ____ Drums ____ Gaylord

____ Drums on Pallet

____ Other Specify __________________________

9) How is the product physically stored?

____ Pallet ____ Bundles ____ Bins

____ Rolls ____ Drums ____ Gaylord

____ Pieces ____ Each

____ Other Specify __________________________

10) If physically stored on Pallets:

a) Will a physical pallet contain mixed SKUs (products)?

____ Yes ____ No

11) What Accounting Package are you using for Accounts receivable?

a) ___ None

b) ___ Quick Books

c) ___ Other Specify __________________________

12) What Electronic imports and exports are to be used?

a) Initial Data Load:

i) ___ None

ii) ___ EDI… Specify Document Numbers _______________

iii) ___ Product Master

iv) ___ Scan Codes (for Barcoding)

v) ___ Inventory Master

vi) ___ Bin / Location Master.

vii) ___ Quick Books

viii) ___ Other Specify ___________________________

b) Import To Coreflex:

i) ___ None

ii) ___ EDI… Specify Document Numbers _______________

iii) ___ Advanced Shipping Notice (ASN for receiving)

iv) ___ Sales Order / Warehouse Release (for shipping)

v) ___ Quick Books

vi) ___ Other Specify ___________________________

c) Export From Coreflex:

i) ___ None

ii) ___ EDI… Specify Document Numbers _______________

iii) ___ Receiving Report.

iv) ___ Shipping Confirmation

v) ___ UPS World ship

vi) ___ Federal Express

vii) ___ Quick Books

viii) ___ Other Specify ___________________________

13) Data Collected with Inventory Items:

a) What information must be recorded for items being received?

Indicate P if it is available prior to receiving.

Indicate R if it is available during receiving.

____ Cube ____ Dimensions (length, width, height)

____ Manufacture’s Lot ____ Manufacture’s Expiration Date

____ Receiving Lot ____ Date Code

____ Origin ____ Ship Method

____ ASN Number ____ PO Number

____ Weight ____ 100 Weight

____ Account Pallet Number

____ Other __________________________

_________________________

b) What information must be tracked with the specific inventory’s life cycle and show on outbound documents or be used to during the shipping process?

Indicate PT if it is to show on Pick Ticket.

Indicate PL if it is to show on Packing List.

Indicate B if it is to show on BOL.

____ Cube ____ Dimensions (length, width, height)

____ Manufacture’s Lot ____ Manufacture’s Expiration Date

____ Receiving Lot ____ Date Code

____ Origin ____ Ship Method

____ ASN Number ____ PO Number

____ Weight ____ 100 Weight

____ Account Pallet Number

____ Other __________________________

_________________________

14) When the product is to be released / shipped, how will the account indicate what they want shipped?

____ Product Id ____ Receiving Lot ____ Manufacture’s Lot

____ ASN ____ PO Number ____ Ship Method

____ Account’s Pallet Number

____ Other __________________________

_________________________

15) What allocation method will be used to select the specific inventory?

a) ____ FIFO by receiving date

b) ____ FIFO by expiration date

c) ____ FIFO by date code

d) ____ Specified by Customer / Account.

e) ____ Manually chosen at time of Order Entry

f) ____ Manually chosen by warehouse pickers

g) ____ Walking Sequence

h) ____ Reference Number / Data recorded at time of receiving.

i) ____ Other : Specify __________________________

16) Samples:

a) Will samples of product be shipped?

____ Yes ____ No

b) If yes, is the unit of measure shipped different than the products inventorying unit? (i.e. is the inventory by the case and the samples shipped by the each?)

____ Yes ____ No

17) Labeling:

a) Does the account require any specific labels and or data to be generated for receiving or shipping labels?

____ Receiving ____ Yes ____ No

____ Shipping ____ Yes ____ No

b) If yes, specify the label and the data to be printed?

Label ____________________ Label: ___________________

Data: ____________________ Data: ____________________

Label ____________________ Label: ___________________

Data: ____________________ Data: ____________________

18) Printed Output – Fax examples of all printed output for the account to 201 808 2700. Check all that currently are used in operation.

a) ___ Warehouse Receipt

b) ___ Storage Invoice

c) ___ Fulfillment / Shipping / Accessorial Invoice.

d) ___ Sales Order

e) ___ Pick ticket

f) ___ Packing List

g) ___ Bill of Lading

h) ___ Inventory Reports

i) ___ Reports sent to Account / Customer.

j) ___ Receiving Labels

k) ___ Shipping Labels

l) ___ Product Labels

m) ___ Other Specify _____________________

n) ___ Other Specify _____________________

o) ___ Other Specify _____________________

p) ___ Other Specify _____________________

******************** Billing Setup *******************

19) Billing General:

a) Is reduced rate or split month rate used for initial storage?

____ Yes ____ No

b) Is initial storage billed upon receipt?

____ Yes ____ No

c) Is storage billing by:

____ Day ___ Week ___ Month

____ Anniversary Date ___ None

d) Is the account given free days of inventory?

____ Yes ____ No

e) Billing Product Types:

A billing product type is a grouping of products that bill in the same manner. For example if all refrigerated products bill one way and all frozen products bill another way there are two billing product type. Or if all non hazardous materials bill one way and all hazardous materials bill another way these are two billing product types.

i) Are all products for this account billed the same way?

____ Yes ____ No

ii) If No, list the different names and indicate them as a type or product:

______________________ ____ Type ____ Specific Product Id

20) Receiving - What amount do you charge upon receipt of the inventory?

Instructions:

Complete the following for each product type. If all inventory is billed the same complete one product type and indicate “All Products”.

If there are different amounts charged within a specific product type complete additional Amount sections within the specific product type (i.e. complete Amount 1, Amount 2, Amount 3, etc…).

Product Type 1:

____ All Products Product Type: ____________ Product Id ____________

Amount 1: ________

For:

____ In & Out ___ In Only ____ Initial Storage

___ Other Specify: ________________________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

Comment / Detailed Explanation if needed:

__________________________________________________________

Amount 2: ________

For:

____ In & Out ___ In Only ____ Initial Storage

___ Other Specify: ________________________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

Comment / Detailed Explanation if needed:

__________________________________________________________

Product Type 2:

____ All Products Product Type: ____________ Product Id ____________

Amount 1: ________

For:

____ In & Out ___ In Only ____ Initial Storage

___ Other Specify: ________________________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

Comment / Detailed Explanation if needed:

__________________________________________________________

Amount 2: ________

For:

____ In & Out ___ In Only ____ Initial Storage

___ Other Specify: ________________________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

Comment / Detailed Explanation if needed:

__________________________________________________________

21) Storage – What amount do you charge for storage?

Product Type1:

____ All Product Type: _________________ Product Id ________________

Amount 1: ________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____ Day

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

For:

____ Month ___ Week ____ Day

___ Other Specify: ______________________

Is there free time?

____ No ____ Yes… Free Days ______________

Comment / Detailed Explanation if needed:

__________________________________________________________

Product Type 2:

____ All Product Type: _________________ Product Id ________________

Amount 1: ________

Per:

____ Cube ____ Carton ____ Each / Piece

____ Pallet ____ Weight ____ 100 Weight

____ Month ____ ½ Month ____ Day

____ Other… Specify __________________________

If Cube, which is used for Billing?

___ Actual cube ___ Rounded cube

If Rounded Cube, Round up to:

___ 1 Cube ____ Other... Specify ____________

For:

____ Month ___ Week ____ Day

___ Other Specify: ______________________

Is there free time?

____ No ____ Yes… Free Days ______________

Comment / Detailed Explanation if needed:

__________________________________________________________

22) Fulfillment – What amounts are charged for fulfillment?

a) Product Type1:

____ All Product Type: _________________ Product Id ________________

Amount: _________ For each: Order

Amount: _________ For each: Piece / Each

Amount: _________ For each: Case

Amount: _________ For each: Pallet

Amount: _________ For each: Case Split off of Pallet

Amount: _________ For each: Cube

Amount: _________ For each: Label

Amount: _________ For each: __________________________

b) Product Type 2:

____ All Product Type: _________________ Product Id ________________

Amount: _________ For each: Order

Amount: _________ For each: Piece / Each

Amount: _________ For each: Case

Amount: _________ For each: Pallet

Amount: _________ For each: Case Split off of Pallet

Amount: _________ For each: Cube

Amount: _________ For each: Label

Amount: _________ For each: __________________________

23) Ancillary Charges:

a) Receiving:

Amount: _________ For: Segregation

Amount: _________ For: Palletizing

Amount: _________ For: Shrink Wrapping

Amount: _________ For: Container Off Load

Amount: _________ For: Labeling

Amount: _________ For: __________________________

b) Fulfillment:

Amount: _________ For: Bill of Lading

Amount: _________ For: Shrink Wrapping

Amount: _________ For: Labeling

Amount: _________ For: __________________________

c) Shipping:

Amount: _________ For: Bill of Lading

Amount: _________ For: Shrink Wrapping

Amount: _________ For: Labeling

Amount: _________ For: __________________________

d) Miscellaneous / Other:

Amount: _________ For: __________________________

24) Notes / Comments: (Include any additional information deemed relevant to your operation or relevant to the install of Coreflex that is not otherwise noted in this worksheet.)

_______________________________________________________________

The Following is to be completed by Coreflex:

25) BIA Notes / Comments: (To be completed by Coreflex Analyst upon completion of BIA)

_______________________________________________________________

26) Operational Flow (Receiving, Storage, Shipping, Billing) (To be completed by Coreflex Analyst upon completion of BIA)

_______________________________________________________________

27) Configuration / Programming Changes needed to support Operational Flow: (To be completed by Coreflex Analyst upon completion of BIA)

_______________________________________________________________