Question: In the EMC Excel example, what is the function in Excel that can be used to formulate the objective function (total cost)? SOLVER function SUMPRODUCT
In the EMC Excel example, what is the function in Excel that can be used to formulate the objective function (total cost)?
SOLVER function
SUMPRODUCT function
VLOOKUP function
NORMSINV function
Question 2
0 / 8 pts
In the Thomas transshipment formulation, inflow into Node 3 is given by
X13 + X23
X35 + X36 + X37
X14 + X24
X35 + X45
Question 3
8 / 8 pts
In a transportation model, when total demand is greater than total supply
All constraints are equality type
All constraints are "less than equal to" type
Demand constraints are "less than equal to" and supply constraints are "equal to
Demand constraints are "equal to" and supply constraints are "less than equal to
Question 4
0 / 8 pts
In a transshipment model, what are flow balancing constraints?
Supply constraints
Demand constraints
Constraints associated with inflow and outflow for intermediate nodes
None of these
Question 5
0 / 8 pts
CCR DEA model allows for all these, except
Differentiates between efficient and inefficient units
Provides improvements needed for inefficient units to become efficient
Differentiates between the efficient units
None of these
Question 6
8 / 8 pts
In the supply chain network design model, how many additional variables will be needed to have the option of selecting suppliers if fixed costs are given?
2
1
3
5
InQuestion 7
0 / 8 pts
CCR DEA model assumes
Constant returns to scale
Variable returns to scale
Both constant and variable returns to scale
All of these
Question 8
8 / 8 pts
Network design decisions include
Facility location
Capacity allocation
Market and supply allocation
All of these
Question 9
8 / 8 pts
In the supply chain network design model, flow balancing constraints are required for
Suppliers and plants
Suppliers and warehouses
Plants and warehouses
Warehouses and customer locations
Question 10
8 / 8 pts
If there are 5 inputs and 4 outputs in the DEA model, how many DMUs will you select from the following options to effectively discriminate between efficient and inefficient DMUs?
10
19
15
25
Question 11
8 / 8 pts
The key difference between transportation and transshipment models is that
Transportation model minimizes cost and transshipment model maximizes profit
Transportation model involves indirect shipments and transshipment model involves direct shipments
Transportation model has no intermediate nodes, but the transshipment model has intermediate nodes
They are the same and no differences exist
tQuestion 12
0 / 8 pts
What would be a possible input is evaluating supplier performance in a DEA model
Production capacity used by the supplier
Quality of products generated by the supplier
Delivery performance
None of these
Question 13
0 / 8 pts
In the Thomas transshipment model, revise the flow balancing constraint for Node 3 if the capacity at Node 1 is increased to 100 units and inventory at Node 3 must be at least 20 units.
(X14 + X24) - (X35 + X36 + X37) > 20
(X13 + X23) - (X35 + X36 + X37) > 20
(X13 + X23) - (X35 + X36 + X37) < 20
(X13 + X23) + (X35 + X36 + X37) > 20
Question 14
8 / 8 pts
In the supply chain network design model, plant selection variables are
Continuous
Positive
Binary
None of these
Question 15
8 / 8 pts
Efficiency in DEA is defined as the
Ratio of weighted sum of inputs to weighted sum of outputs
Ratio of weighted sum of outputs to weighted sum of inputs
Weighted outputs minus the weighted inputs
Weighted inputs minus the weighted outputs
IncorrectQuestion 16
0 / 8 pts
In the Thomas transshipment model, why is the total cost of the revised policy more than the total cost of the original model?
It is not optimized correctly
The changes in shipment costs
Because of maintaining excess inventory at warehouses
It has missing constraints
Question 17
8 / 8 pts
The traditional transportation model involves
Indirect shipments
Direct shipments
Transshipment nodes
Only demand locations
IncorrectQuestion 18
0 / 8 pts
A unit is considered to be inefficient in DEA if it has score of less than 1
True
False
IncorrectQuestion 19
0 / 8 pts
In the supply chain network design model Excel solution, which nodes are selected?
Plant 1, Warehouse 1, and Warehouse 2
Plant 2, Warehouse 1, and Warehouse 2
Plant 1, Plant 2, Warehouse 3
Plant 1, Plant 2, Warehouse 2
IncorrectQuestion 20
0 / 8 pts
The EMC transportation model is balanced.
True
False
Question 21
8 / 8 pts
Network optimization models allow us to optimize costs in deciding which nodes to establish and how to configure the network.
True
False
IncorrectQuestion 22
0 / 8 pts
DEA is primarily a diagnostic tool
True
False
Question 23
8 / 8 pts
In the EMC transportation example, if no shipments are allowed between Evansville to Boston, how do we refine the model?
The problem will be infeasible
We have to remove constraints that include XEB
Add an extra constraint: XEB = 0
None of these are true
IncorrectQuestion 24
0 / 8 pts
In a transportation model, when total demand is equal to total supply
All constraints are equality type
All constraints are "less than equal to"
No constraints are needed
All of these
Question 25
8 / 8 pts
When would someone use a BCC DEA model?
When inputs are more than the outputs
When outputs are more than the inputs
When outputs increase proportionally as inputs increase
When outputs do not increase proportionally as inputs increase
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
