Coreflex™
New Customer Worksheet Questionnaire
Private Warehouse
Revision 3
Instructions:
1) Coreflex
Client Name and Address. (Your Company)
2) Contact
Person/ First and Last Name, Title, Phone, e-mail (1 individual).
(This
is the single point of contact for making decisions and scheduling your
company’s staff, time and resources during implementation of Coreflex™.)
3) How many
warehouses will be managed?
4) How are you
currently managing your inventory? (indicate all that apply)
a)
___ Excel spreadsheets
b)
___ Manually (card file, etc…)
c)
___ Software Package… Specify Name: _____________________________
d)
___ New startup, inventory not being managed
at the moment.
e)
___ Other... Describe:
____________________________________________
5) What is the
main objective you are trying to achieve or main issue you are trying to solve?
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
6) Are there
any time critical business objectives you wish to be considered when planning
the startup schedule? (physical
inventory date, live date, etc…)
___ Yes
___ No
If yes, please provide details:
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
7) Approximate
total number of SKUs / Unique Product Numbers managed?
a)
___ 1 – 100
b)
___ 101 – 500
c)
___ 501 – 1000
d)
___ 1000 – 5000
e)
___ 5000 – 10,000
f)
___ 10,001 +
g)
___ Other …
Specify ___________________________
8) Do you track
any of the following: (check all that
apply)
a)
___
b)
___ Expiation Date
c)
___ Serial Number
9) Do you make
Kits, Assemblies or Finished Goods from Inventory?
___ Yes
___ No
10) Do you
manage multiple units of measure (UOMs) for a single product Id?
(For
example Product ABC stored in CASE of 12, PACK of 2 or EACH of 1)
___ Yes
___ No
11) What Units
of Measure do you currently handle?
(indicate all that apply)
a)
___ Case
b)
___ Packs
c)
___ Each
d)
___ Pallet
e)
___ Other… Specify: _________________________
f)
___ Other… Specify: _________________________
12) What type of
Products do you currently handle? (indicate all that apply)
____ Refrigerated ____ Frozen ____ Dry Goods
____ Food ____ House wares ____ Clothing
____ Perishable ____ Non Perishable ____ Resin
____ Paper ____ Steel ____ Lumber
____ Garment on Hanger
____ Other… Specify __________________________
____ Other… Specify __________________________
____ Other… Specify __________________________
13) 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
14) What is the
inventory unit? This is the unit that
will use to count the product inventory: ( Indicate all that apply)
____ Case ____ Each ____ Piece
____ Pallet ____ Cases on Pallet ____ Pounds
____ Rolls ____ Drums ____ Gaylord
____ Other Specify __________________________
____ Other Specify __________________________
15) How is the
product stored physically? (Indicate all that apply)
____ Pallet ____ Bundles ____ Bins
____ Rolls ____ Drums ____ Gaylord
____ Pieces ____ Each
____ Other Specify __________________________
____ Other Specify __________________________
16) What
Electronic imports and exports are to be used?
a)
Initial Data
Load:
i)
___ None (Manual data entry to be used)
ii)
___ EDI… Specify
Document Numbers _______________
iii)
___ Product Master
iv)
___ Scan Codes (for Barcoding)
v)
___ Inventory Master
vi)
___ Bin / Location Master.
vii)
___ Quick Books
b)
Import To
Coreflex:
i)
___ None (Manual data entry to be used)
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 ___________________________
17) Database
Server Activation - Is the PC that will be used to house the Coreflex Database:
a)
Installed and
connected to the internet?
___ Yes
___ No
b)
If No, when do
you expect it to be installed and accessible via the internet? (provide date or
explain in detail)
c)
What is the PC name?
(If the actual PC name is not known indicate who’s PC it is. For example Receiving, Shipping, John’s Sue’s
etc.)
___________________________________
d)
What is the
operating system?
Operating
System:
___ Server 2003 * ___ Server 2000 * ___ MS
Small Business Server *
___ XP ___ XP Pro __
___ Other… Specify
__________________
* Terminal server type operating system.
e)
If using terminal
server type operating system, indicate the number of Coreflex™ licenses
purchased that are to be concurrent licenses activated on the Server?
18) Workstation
PCs Activation: Are the PC’s that will run the remaining Coreflex™ licenses:
a)
Installed and
connected to the internet?
___ Yes
___ No
b)
If No, when do
you expect it to be installed and accessible via the internet? (provide date or
explain in detail)
c)
What are the PC
names and operating systems on which you want Coreflex to be activated? (If the
actual PC name is not known indicate who’s PC it is. For example Receiving, Shipping, John’s Sue’s
etc.)
i)
Name: ___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
ii)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
iii)
Name: ___________________ __ XP __
XP Pro __
__ Other… Specify: _______________________
iv)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
v)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
vi)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
vii)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
viii) Name: ___________________ __ XP __ XP
Pro __
__ Other… Specify: _______________________
ix)
Name:
___________________ __ XP __ XP Pro __
__ Other… Specify: _______________________
x)
Name:
___________________ __ XP __ XP Pro __
__
Other… Specify: _______________________
19) Mobile RF
Server PC Activation – If you have purchased the Mobile RF Scanning Module, is the RF PC that will have the
antenna connected to it:
a)
Installed and
connected to the internet?
___ Yes
___ No
b)
If No, when do
you expect it to be installed and accessible via the internet? (provide date or
explain in detail)
c)
What is the PC
name and operating systems? (If the actual PC name is not known indicate who’s
PC is. For example Receiving, Shipping,
John’s Sue’s etc.) Note the PC must have
a DB 9 Communications port.
i)
Name:
___________________ __ XP __ XP Pro __
__
Other… Specify: ______________________
d)
Note a serial
port is required for antenna connection (9 pin).
20) Mobile Batch
Scanner PC Activation – If you have purchased the Mobile Batch Scanning Module, is the PC that will have the
antenna connected to it:
a)
Installed and
connected to the internet?
___ Yes
___ No
b)
If No, when do
you expect it to be installed and accessible via the internet? (provide date or
explain in detail)
c)
What is the PC
name and operating systems? (If the actual PC name is not known indicate who’s
PC is. For example Receiving, Shipping,
John’s Sue’s etc.) Note the PC must have
a DB 9 Communications port.
i)
Name:
___________________ __ XP __ XP Pro __
__
Other… Specify: ______________________
d)
Note a USB port
is required for uploading files from the Batch Hand Held to the PC for import
into Coreflex™.
21) 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 are to be completed by Coreflex:
22) BIA Notes /
Comments: (To be completed by Coreflex
Analyst upon completion of BIA)
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
23) Operational
Flow (Receiving, Storage, Shipping, Billing)
(To be completed by Coreflex Analyst upon completion of BIA)
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
24) Configuration
/ Programming Changes needed to support Operational Flow: (To be completed by Coreflex Analyst upon
completion of BIA)
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________