Bloomex Basics
Transshipment & Supply Chain Strategy
Shipment Plan Analysis
Excel
Solver
100

Which location is being considered for opening as a new transshipment center?

a) Calgary
b) Miami/Florida
c) Winnipeg
d) Halifax

b) Miami/Florida

100

What is the demand at Calgary?
 

 a) 64
 b) 127
 c) 171
 d) 191

 c) 171

100

How many boxes are shipped from Florida/Miami* to Ottawa?
 

 a) 0
 b) 64
 c) 127
 d) 184

c) 127

100

What is the main purpose of using Excel Solver in the Bloomex logistics optimization?
A) Visualizing transportation routes
B) Minimizing transportation costs
C) Maximizing transportation costs
D) Averaging transportation costs

B) Minimizing transportation costs

200

How many major Canadian metro areas host Bloomex's warehouses and production facilities?

 a) 5
 b) 6
 c) 7
 d) 8

c) 7

200

What is the total demand shown in the analysis?

 a) 381
 b) 737
 c) 1,050
 d) 1,182

d) 1,182

200

How many boxes are shipped from South America to Toronto in the shipment plan?

 a) 0
 b) 345
 c) 705
 d) 1,050

b) 345

200

What Solver solving method is typically used for linear programming problems like Bloomex's logistics case?
A) Evolutionary
B) GRG Nonlinear
C) Simplex LP
D) Genetic Algorithm

C) Simplex LP

300

What is the weekly demand in boxes for Montreal?
 

a) 127
 b) 184
 c) 64
 d) 171

b) 184

300

What is the shipping cost per box from Florida (Miami) to Ottawa?

 a) 10
 b) 7.5
 c) 5
 d) 0

b) 7.5

300

What is the supply from Ontario (Toronto)* to Toronto*?
 a) 0
 b) 30
 c) 100
 d) 345

c) 100

300

2. What weekly transportation cost did Bloomex incur under the original supply chain setup?
A) CAD 14,375.50
B) CAD 23,095.50
C) CAD 23,059.50
D) CAD 18,760.00

 B) CAD 23,095.50

400

What is the primary role of transshipment centers in Bloomex's logistics network?

a) Locations where flowers are exclusively grown and harvested.
b) Final destinations for customer deliveries across Canada.
c) Intermediate facilities that receive flowers from sources and redistribute them to production sites.
d) Storage units only for excess inventory during peak seasons.

c) Intermediate facilities that receive flowers from sources and redistribute them to production sites.

400

What is the total cost shown in the analysis when Miami is opened as a transshipment center?
 a) $18,503.50
 b) $23,095.50
 c) $18,623.50
 d) $4,592.00

 a) $18,503.50

400

How many boxes are shipped from South America to Miami?
 a) 0
 b) 345
 c) 705
 d) 1,050

c) 705

400

What does a constraint in Solver represent in a linear programming model?
A) A rule that limits the values variables can take
B) A bonus value for extra supply
C) A cell format option
D) An automatic formula generator

A) A rule that limits the values variables can take

500

What is the core structure of Bloomex's operational business model?
 

a) A single centralized warehouse handling all orders
 b) A network of small-to-medium-scale warehouses and production facilities in major metro areas
 c) Outsourcing all logistics to third-party providers
 d) Operating solely as an online platform without physical facilities

b) A network of small-to-medium-scale warehouses and production facilities in major metro areas

500

What is the primary objective of optimizing Bloomex's logistics through transshipment centers?
 

a) To maximize flower production at each facility.
 b) To minimize overall transportation costs in the supply chain.
 c) To increase the variety of gift arrangements offered.
 d) To focus on direct customer interactions at warehouses.

b) To minimize overall transportation costs in the supply chain

500

What significant shift occurred in the shipment plan when Miami was added as a transshipment center?
A) All shipments bypassed Toronto
B) 100% of shipments came from domestic suppliers
C) 62% of total supplies were rerouted through Florida due to lower shipping costs
D) Shipment costs increased due to facility duplication

Answer: C) 62% of total supplies were rerouted through Florida due to lower shipping costs

500

In a 20% demand increase scenario, what percentage of total supplies was handled by Miami?
A) 62%
B) 75%
C) 50%
D) 93%

D) 93%