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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!