2010 scm logistics excel(1)
TRANSCRIPT
-
7/29/2019 2010 SCM Logistics Excel(1)
1/26
Question
Type the words "I AGREE" in the field to the right of this text if you
agree with the terms and conditions at this URL:
http://www.apqc.org/PDF/osbc/instructions_and_terms.pdf
First Name
Last Name
Title
Company
Address Line 1
Address Line 2
City
State
Zip/Postal Code
Country
Phone Number
Corporate email address
4 digit NAICS code
How did you hear about this survey?
If other, please describe.
191.0030 What is the total annual revenue of your entireorganization?
Please provide the following financial information about your
business entity.
191.0040 What is the total annual revenue for your business
entity?
191.0050 What is the total annual cost of continuing operations
incurred by your business entity?
LogiCLICK HERE TO READ DETAILED INSTR
This data collection instrument is only intended to be used to faciliindependent of existing APQC on-line data collection instruments.
You must agree to the terms and conditions of the APQC data col
This data collection instrument is copyright APQC 2010. Permissi
activities related to participation in an active APQC data collection
For more information including definitions of key terms and links thttp://www.apqc.org/OSBC, or call +1-713-681-4020 or (800) 776InstructionsFill in all cells highlighted in yellow. For "select only one" or "selecplacing an "X" in the appropriate cell.
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 1 of 26
Logistics
OSBC!SCM_LOG_v4
http://www.apqc.org/PDF/osbc/instructions_and_terms.pdfhttp://www.apqc.org/PDF/osbc/instructions_and_terms.pdf -
7/29/2019 2010 SCM Logistics Excel(1)
2/26
191.0060 What is your business entity's total annual cost of
goods sold?
Please provide the following information about your cash flow.
191.0070 Cash-to-cash cycle time
191.0080 Days sales outstanding
191.0090 What is the number of all employees (temporary, part-
time, and full-time) at your business entity?
191.0100 In how many countries, including your own, does your
business entity operate?
191.0110 What is your assessment of your business entity's
overall performance relative to industry peers?
Top quartile
Middle half
Bottom quartile
191.0120 Which of the following best describes your
organization's maturity with regards to information availability
and analysis capabilities? (Options are listed in increasing order of
maturity; select the option that best describes your organization's
maturity.)
We don't have regular access to data beyond basic transactions.
Data is stored in spreadsheets or system extracts. Analysis is not
performed on a regular basis and decisions are based on instinct
or anecdote.
Data is in department or line-of-business silos. Insight generation
is only performed on an ad hoc or periodic basis. Decisions maybe supported by data, but are primarily based on past experience.
Structured operational data is available and may include some
basic external data. Insights are generated at department or line-
of-business level. Decision making is focused on analyzing past
actions and consequences.
Traditional and unstructured data is integrated and available from
enterprise sources as well as some external data. While data is
available to many people based on their roles and needs, using it
might require some technical assistance. Decision making
involves historic analysis and predictive algorithms.
Real-time, internal and external data is readily accessible across
the enterprise based on need. Information is shared extensively
across the enterprise. The data is integrated real-time and users
can access, manipulate and visualize data on demand. Data-
driven decision making is part of the organization's culture.
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 2 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
3/26
191.0130 Which of the following best describes the maturity with
regards to information availability and analysis capabilities, that
you think your organization SHOULD have in order to be
competitive / on par with peers? (Options are listed in increasing
order of maturity. This question is intended as a subjective
measure of the level of analytics maturity required to competewithin the industry.)
We don't have regular access to data beyond basic transactions.
Data is stored in spreadsheets or system extracts. Analysis is not
performed on a regular basis and decisions are based on instinct
or anecdote.
Data is in department or line-of-business silos. Insight generation
is only performed on an ad hoc or periodic basis. Decisions may
be supported by data, but are primarily based on past experience.
Structured operational data is available and may include some
basic external data. Insights are generated at department or line-
of-business level. Decision making is focused on analyzing past
actions and consequences.
Traditional and unstructured data is integrated and available from
enterprise sources as well as some external data. While data is
available to many people based on their roles and needs, using it
might require some technical assistance. Decision making
involves historic analysis and predictive algorithms.
Real-time, internal and external data is readily accessible acrossthe enterprise based on need. Information is shared extensively
across the enterprise. The data is integrated real-time and users
can access, manipulate and visualize data on demand. Data-
driven decision making is part of the organization's culture.
191.0140 Does your organization use an enterprise resource
planning (ERP) system to coordinate key business information,
resources, and activities across the value chain?
Yes
No
191.0150 Which of the following best describes your business
entity's primary capability model? (Select only one.)
Build-to-Stock
Build-to-Order
Engineer-to-Order
Retail
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 3 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
4/26
191.0160 Which of the following best describes the structure of
the logistics operation with respect to your organization overall?
Centralized
Decentralized
Other (Specify)
If you selected other, please specify:
Which of the following best describes your business entity's role
for each of the following processes? (Select only one per process.)
191.0170 "Define logistics strategy"
Self-supporting-performs most aspects of this process
Relies on other business units for the process
Relies on shared services center for the process
Serves as a shared services center for the process
Outsources to third party
191.0180 "Plan and manage inbound material flow"
Self-supporting-performs most aspects of this process
Relies on other business units for the process
Relies on shared services center for the process
Serves as a shared services center for the process
Outsources to third party
191.0190 "Operate warehousing"
Self-supporting-performs most aspects of this process
Relies on other business units for the process
Relies on shared services center for the process
Serves as a shared services center for the process
Outsources to third party191.0200 "Operate outbound transportation"
Self-supporting-performs most aspects of this process
Relies on other business units for the process
Relies on shared services center for the process
Serves as a shared services center for the process
Outsources to third party
191.0210 What is your business entity's total logistics cost?
Please include personnel, systems, outsourced, freight, and
overhead/other costs, for inbound material flow and reverse
logistics, warehousing, outbound transportation, and logistics
strategy.
191.0220 What is your business entity's total logistics cost as a
percentage of sales?
191.0230 What is your business entity's cost of damaged product
as a percentage of sales? (Damaged product percentage is
calculated as total damaged value, divided by total sales value.
Appropriate values are in the range of 0 to 100.)(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 4 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
5/26
191.0240 What is the total number of FTEs employed to perform
each of the following processes?
"Define logistics strategy"
"Plan and manage inbound material flow"
"Operate warehousing"
"Operate outbound transportation"
191.0250 What is your business entity's total annual cost toperform the process "plan and manage inbound material flow,"
for each of the following cost categories?
a. Annual personnel cost (compensation and benefits) for those
classified as FTEs in question 191.0240
b. Annual systems cost (direct and/or allocated to the site)
c. Annual overhead cost (direct and/or allocated to the site)
d. Annual other cost
e. Annual outsourced cost
f. Total cost of the process "plan and manage inbound material
flow" (sum of a through e)
191.0260 What is your business entity's total annual cost to
perform the process "operate warehousing," for each of the
following cost categories?
a. Annual personnel cost (compensation and benefits) for those
classified as FTEs in question 191.0240
b. Annual systems cost (direct and/or allocated to the site)
c. Annual overhead cost (direct and/or allocated to the site)d. Annual other cost
e. Annual outsourced cost
f. Total cost of the process "Operate warehousing" (sum of a
through e)
191.0270 What is your business entity's total annual cost to
perform the process "operate outbound transportation," for each
of the following cost categories?
a. Annual personnel cost (compensation and benefits) for those
classified as FTEs in question 191.0240
b. Annual systems cost (direct and/or allocated to the site)
c. Annual overhead cost (direct and/or allocated to the site)
d. Annual other cost
e. Annual outsourced cost excluding freight
f. Annual freight cost
g. Total cost of the process "Operate outbound transportation"
(sum of a through f)(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 5 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
6/26
191.0280 To what extent have the following logistics practices
been implemented at your business entity? (Check one for each
question in each row.)
a. Formal distribution strategy (location, number, mission, mix)
No Implementation
Some ImplementationExtensive Implementation
b. Collaborative carrier management
No Implementation
Some Implementation
Extensive Implementation
c. Supply chain visibility for managing exceptions
No Implementation
Some Implementation
Extensive Implementation
d. Collaboration and integration among service providers
No Implementation
Some Implementation
Extensive Implementation
e. Differentiated logistics services for discrete customer segments
No Implementation
Some Implementation
Extensive Implementation
f. Formal returns management
No Implementation
Some ImplementationExtensive Implementation
g. Cross-docking, flow-through
No Implementation
Some Implementation
Extensive Implementation
h. Continuous-replenishment programs for customers
No Implementation
Some Implementation
Extensive Implementation
i. Management of inventory at customer site
No Implementation
Some Implementation
Extensive Implementation
j. Share real-time, electronic demand / inventory data
No Implementation
Some Implementation
Extensive Implementation
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 6 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
7/26
191.0290 For each of the logistics practices that have been
implemented (question 191.0280), how effective has each
practice been in reaching desired goals? (Check one for each
question in each row.)
a. Formal distribution strategy (location, number, mission, mix)
Not EffectiveSomewhat Effective
Extremely Effective
b. Collaborative carrier management
Not Effective
Somewhat Effective
Extremely Effective
c. Supply chain visibility for managing exceptions
Not Effective
Somewhat Effective
Extremely Effective
d. Collaboration and integration among service providers
Not Effective
Somewhat Effective
Extremely Effective
e. Differentiated logistics services for discrete customer segments
Not Effective
Somewhat Effective
Extremely Effective
f. Formal returns management
Not EffectiveSomewhat Effective
Extremely Effective
g. Cross-docking, flow-through
Not Effective
Somewhat Effective
Extremely Effective
h. Continuous-replenishment programs for customers
Not Effective
Somewhat Effective
Extremely Effective
i. Management of inventory at customer site
Not Effective
Somewhat Effective
Extremely Effective
j. Share real-time, electronic demand / inventory data
Not Effective
Somewhat Effective
Extremely Effective(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 7 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
8/26
191.0300 What is your average monthly forecast error measured
as an absolute percentage (mean absolute percentage error -
MAPE) at the following levels?
National
Shipping location
Product Family
191.0310 What is your business entity's percentage of supplier on-time delivery?
191.0320 What is your business entity's average dock-to-stock
cycle time for supplier deliveries in hours?
191.0330 What is your business entity's return processing cycle
time in days?
191.0340 What is your business entity's total annual value of
returned products as a percentage of sales?
191.0350 What percentage of your business entity's total annual
logistics costs is associated with the physical transportation of
returns, storage of returns, or handling of returned product?
191.0360 What percentage of your business entity's returned
product (by value) flows through the same logistics network as
primary products (as opposed to an independent returns
channel)?
191.0370 What is your business entity's average gross value of
inventory? Include all types of inventory, including raw, WIP, and
finished goods.
191.0380 Please provide your annual inventory turns.
Total annual inventory turns
Finished goods inventory turnsRaw material inventory turns
191.0390 What is your business entity's inventory carrying cost as
a percentage of average inventory value?
191.0400 What is your business entity's average inventory
accuracy? (Inventory accuracy is defined as the variance between
perpetual inventory counts and physical inventory counts; it is
expressed as a percentage.)
191.0410 What is your business entity's warehouse slot
utilization?
191.0420 What is the total annual number of sales orders that
your business entity fulfills?
Please provide the following average cycle times regarding orders
for primary products.
191.0430 For primary products, what is the average customer
order cycle time in days (including weekends)?
191.0440 Time to receive and prepare an order for selection (in
hours) (This includes time to allocate resources and determine
delivery dates and routing/shipping.)(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 8 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
9/26
191.0450 What is your business entity's average pick-to-ship cycle
time for customer orders in hours?
191.0460 What is your business entity's average customer
shipment to delivery cycle time (in hours)?
Please provide the following sales order metrics.
191.0470 What is your business entity's perfect order
performance?191.0480 What is your business entity's order fill rate?
191.0490 What is your business entity's unit fill rate?
191.0500 What percentage of the total annual number of sales
orders (question 191.0420) was delivered on time as scheduled
(on-time delivery rate)?
191.0510 What percentage of the total number of sales orders
(191.0420) was delivered in perfect condition (perfect condition
rate)?
191.0520 What percentage of the total number of sales orders
(191.0420) was delivered with accurate documentation (accurate
documentation rate)?
191.0530 What is the total annual value of sales order line items
not fulfilled by your business entity due to lack of production
capacity or stock outages as a percentage of revenue?
191.0540 What percentage of the total annual number of sales
orders (question 191.0420) is shipped as part of full-load
shipments?
191.0550 What is your business entity's average full trailer-load
or full container-load capacity utilization?
191.0560 What percentage of the total annual number of sales
orders (question 191.0420) is considered expedited?
191.0570 What are your business entity's expedited costs as a
percentage of total logistics costs?
191.0580 What were your business entity's premium freight
charges as a percentage of total freight for the most recent
calendar year?
191.0590 Which of the following technologies and technology-
based systems has your business entity implemented or is your
business entity planning to implement to support your Logistics
processes? (Select only one for each technology.)
a. Advanced Planning and Scheduling software (APS)
Do Not Plan to Implement
Plan to Implement
Implemented
b. Transportation Management System (TMS)
Do Not Plan to Implement
Plan to Implement(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 9 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
10/26
Implemented
c. Warehouse Management System (WMS)
Do Not Plan to Implement
Plan to Implement
Implemented
d. Bar coding
Do Not Plan to ImplementPlan to Implement
Implemented
e. Network planning/optimization tools
Do Not Plan to Implement
Plan to Implement
Implemented
f. Distribution Requirements Planning (DRP) Software
Do Not Plan to Implement
Plan to Implement
Implemented
191.0600 For each of the technologies and technology-based
systems that have been implemented (question 191.0590), how
effective has each been in reaching desired goals? (Select only
one for each technology.)
a. Advanced Planning and Scheduling software (APS)
Not Effective
Somewhat Effective
Extremely Effective
b. Transportation Management System (TMS)
Not Effective
Somewhat EffectiveExtremely Effective
c. Warehouse Management System (WMS)
Not Effective
Somewhat Effective
Extremely Effective
d. Bar coding
Not Effective
Somewhat Effective
Extremely Effective
e. Network planning/optimization tools
Not Effective
Somewhat Effective
Extremely Effective
f. Distribution Requirements Planning (DRP) Software
Not Effective
Somewhat Effective
Extremely Effective
191.0610 What is your business entity's RFID tagging strategy?(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 10 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
11/26
No RFID tagging strategy
Slap and ship for compliance
Tag all products in manufacturing
Maintain separate inventory of tagged and untagged items
Other (Please specify)
If you selected other, please specify:191.0620 If you have a strategy, what do you believe will be your
largest benefit from implementing RFID at your business entity?
(Check up to three)
Reduce DC/warehouse cost
Reduce inventory
Improve trading relationships
Improve distribution processes
Meet compliance requirements
Other (Please specify below.)
If you selected other, please specify:
191.0630 To what extent has each of the following business
functions been outsourced in your business entity's logistics
network? (Select only one for each function.)
a. Transportation (inbound and/or outbound)
No Outsourcing
Some Outsourcing
Extensive Outsourcing
b. Warehousing and/or distribution centers
No Outsourcing
Some OutsourcingExtensive Outsourcing
c. Facilities maintenance
No Outsourcing
Some Outsourcing
Extensive Outsourcing
d. Information technology
No Outsourcing
Some Outsourcing
Extensive Outsourcing
e. Audit and payment services for freight bills
No Outsourcing
Some Outsourcing
Extensive Outsourcing
f. Carrier management services (previously called "Transportation
management services")
No Outsourcing
Some Outsourcing
Extensive Outsourcing
g. Product returns transport/handling(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 11 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
12/26
No Outsourcing
Some Outsourcing
Extensive Outsourcing
h. Disposition decision-making for returned products
No Outsourcing
Some Outsourcing
Extensive Outsourcingi. Customs/export
No Outsourcing
Some Outsourcing
Extensive Outsourcing
191.0640 For each of the following business functions that have
been outsourced (question 191.0630) how effective has the
outsourced function been in reaching desired goals? (Select only
one for each function.)
a. Transportation (inbound and/or outbound)
Not Effective
Somewhat Effective
Extremely Effective
b. Warehousing and/or distribution centers
Not Effective
Somewhat Effective
Extremely Effective
c. Facilities maintenance
Not Effective
Somewhat Effective
Extremely Effective
d. Information technologyNot Effective
Somewhat Effective
Extremely Effective
e. Audit and payment services for freight bills
Not Effective
Somewhat Effective
Extremely Effective
f. Carrier management services (previously called "Transportation
management services")
Not Effective
Somewhat Effective
Extremely Effective
g. Product returns transport/handling
Not Effective
Somewhat Effective
Extremely Effective
h. Disposition decision-making for returned products
Not Effective
Somewhat Effective(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 12 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
13/26
Extremely Effective
i. Customs/export
Not Effective
Somewhat Effective
Extremely Effective
191.0650 To what extent are the following statements true
concerning your company's sustainability, or green supply chainstrategies and practices?
a. There is an ongoing program for low carbon design for
distribution (late customization, picking, packing, reusable and
recyclable packaging, reverse logistics).
To no extent
To little extent
To some extent
To a significant extent
To a very great extent
b. Contract with warehouse and distribution service providers
(e.g. fleet providers, haulers, buffer warehouses) favors those
with low direct and indirect CO2 emissions.
To no extent
To little extent
To some extent
To a significant extent
To a very great extent
c. Transportation companies are evaluated for carbon emissions,
energy consumption, and strategy or approach to carbon
management.To no extent
To little extent
To some extent
To a significant extent
To a very great extent
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 13 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
14/26
Answer
ticsCTIONS AND TERMS AND CONDITIONS
itate collection of data; it is not intended to be used.
lection effort in order to use this data collection instrument.
on is granted to make copies to facilitate data collection
effort. Any other use is prohibited.
submit data electronically, visit-9676.
t all that apply" questions, indicate your response by
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 14 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
15/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 15 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
16/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 16 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
17/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 17 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
18/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 18 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
19/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 19 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
20/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 20 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
21/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 21 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
22/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 22 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
23/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 23 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
24/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 24 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
25/26
(c) 2010 APQC
Last updated: 9/21/2010
Last printed: 9/20/2013 Page 25 of 26
Logistics
OSBC!SCM_LOG_v4
-
7/29/2019 2010 SCM Logistics Excel(1)
26/26
(c) 2010 APQC
L d d 9/21/2010 L i i