Chapter 14 Michaels Hardware
The goal of this case is to get students to understand that the value of using aggregation
through milk runs and intermediate facilities when designing transportation networks. The case
also gets students to see that as demand
Input Data
Number of suppliers =
Number of retail stores =
Demand per store from each supplier =
Cost per large trailer =
Cost per small truck =
Large trailer capacity =
Small truck capacity =
Holding cost per unit per year =
Cost / large truck stop =
Cos
Value of Aggregation (Problem 12.15)
Popular variant at Large dealer
Demand per period (weekly) per location, Di =
Standard deviation of demand, sD =
Ave replenishment lead time, L (weeks)=
Standard deviation over L, sL =
Desired cycle service level, CSL
Specialty Packaging Corporation
To optimize the aggregate plan, click on the Solver button. The optimal aggregate plan, shown in Cells
B5:N16, provides the best use of available resources and subcontracting to meet demand over the next
three years. The to
Chapter 12 Postponement
The goal of this case is to get students to understand that the value of postponement is affected
by the value of the product, coefficient of variation as well as the correlation of demand. High
value products with high coefficient
Black
Clear
Aggregate
2010
2010
2010
2010
2011
2011
2011
2011
2012
2012
2012
2012
Quarter I
Quarter II
Quarter III
Quarter IV
Quarter I
Quarter II
Quarter III
Quarter IV
Quarter I
Quarter II
Quarter III
Quarter IV
Total
6,650
4,576
6,293
13,777
7,509
5,14
CoolWipes
1) The total cost to serve the entire nation from Chicago is $32,661.40 as illustrated below:
2) Based upon a reduction in total costs to $29,189, we would recommend building a plant
Princeton, Atlanta and LA. All plants would offer both the Wip
Should Packaging be Postponed to the DC?
Holding cost =
CSL =
Lead time =
Correlation coefficient
Increase in cost/unit on postponement
Unit Cost
Weekly Demand
Target
Best Buy
Office Max
Staples
Aggregate
Demand
30%
0.95
9 weeks
0
$2.00
Q1: the answer is
CHAPTER 5
Case Questions
Location
Seattle
Denver
St. Louis
Atlanta
Philadelphia
Small Warehouse
Fixed Cost
Variable Cost
$300,000
0.2
$250,000
0.2
$220,000
0.2
$220,000
0.2
$240,000
0.2
Seattle
Denver
St. Louis
Atlanta
Philadelphia
Northwest
$2.00
$2.50
$
Chapter 6 - Forever Young Solution
The decision tree for Forever young is as follows:
D = 1,210
E= 7.16625
0.5 0.5
0.5 0.5
0.5 0.5
0.5 0.5
D = 1,100
E= 6.825
D = 1,000
E= 6.50
0.5 0.5
D = 1,100
E= 6.175
D = 900
E= 6.825
0.5 0.5
0.5 0.5
0.5 0.5
0.5 0.5
D =
SPC
Year
2005
2006
2007
2008
2009
Quarter
I
II
III
IV
I
II
III
IV
I
II
III
IV
I
II
III
IV
I
II
III
IV
Black Plastic Demand Clear Plastic Demand
('000 lbs)
('000 lbs)
2250
3200
1737
7658
2412
4420
7269
2384
3514
3654
2143
8680
3459
5695
7056
1953
4120
4742
Exercise 13.11: DoorRed Pharmacy
Daily demand for Aspirin at DoorRed Pharmacy is normally distributed with a mean of 40
bottles and a standard deviation of 5. The replenishment lead time from the supplier is 1 day.
The current inventory policy at DoorRed
Chopra/Meindl 5/e
CHAPTER 5
Case Questions (see corresponding Chapter 5 case Excel spreadsheet)
1. What is the cost SportStuff.com incurs if all warehouses leased are in St. Louis?
Demand in 2007 is as shown in Table 5-15
Demand 2007
Northwest
320,000
Sou
Chapter 14: Transportation in a Supply Chain
Exercise Solutions
1.
Coal:
We evaluate the total cost per day for each of the options and select the one with the lowest cost.
For the carload option the calculations are shown below:
Safety inventory held = 2
Chopra 5e Chapter 8 case discussion
What actions do you think influence the actions and decisions? For example, do you
think that the price the subcontractor charges have any relationship to the amount
of private warehousing space to be leased?
Public war
Benetton has entered into a quantity flexibility contract for a seasonal product with its retailer. If the retailer orders O units,
Benetton is willing to provide up to another 35 percent if needed. Benettons production cost is $20 and they charge the ret
Exercise 13-5 Snoblo
Snoblo, a manufacturer of snow blowers, currently sells four models. The base model, Reguplo, has demand that is normally
distributed with a mean of 10,000 and a standard deviation of 1,000. The three other models have additional feat
Evaluating the Onshoring option
Starting demand
Variable cost / unit =
Sale Price =
Starting Yuan / $
1000
10 dollars
20 dollars
6.5
Expected profit over 2 periods from on-shore source
is given in Cell Q10.
Period 2 Analysis
Period 1 Analysis
E (Yuan Exch
Excersise 12-1: Best Buy
Weekly demand for Motorola cell phones at a Best Buy store is normally distributed with a mean of
300 and a standard deviation of 200. Motorola takes two weeks to supply a Best Buy order. Best Buy
is targeting a cycle service leve
Chapter 9: Sales and Operations Planning
We define a comprehensive set of decision variables that are utilized in problems 9-1 to
9-3 depending on the problem context.
Decision Variables:
Ht = # of workers hired in month t (t = 1,.,12)
Lt = # of workers l
Exercise 13-3: Goodstone Tires
The manager at Goodstone Tires, a distributor of tires in Illinois, uses a
continuous review policy to manage their inventory. The manager currently
orders 10,000 tires when the inventory of tires drops to 6,000. Weekly
dema
Case Study - MoonChem
Questions
1. What is the current annual cost of MoonChem's strategy of sending full truck loads to each customer in the Peoria region to replenish
consignment inventory?
2. Consider different delivery options and evaluate the cost of
Chapter 16: Pricing and Revenue Management in a Supply Chain
Exercise Solutions
1.
The amount of production capacity to reserve is:
Q* = F-1 (p*, , ) = NORMINV(p*, , )
p* = 1-(5/10) = 0.5
NORMINV(0.5, 250, 100) = 250 units
Worksheet 16-1 presents this sol
1. What is the annual cost of MoonChems strategy of sending full truckloads to
each customer in the Peoria region to replenish consignment inventory?
MoonChems customer profile appears in Table 10-4 and is reproduced below:
Customer
Type
Small
Medium
Larg
Chapter 9 Mintendo Game Girl
The results for this case are obtained using the accompanying spreadsheet Mintendo Case
Study.
Basic Model
The decision variables are contained in Cells B4:I10 in worksheet pricing. The constraints are
as follows:
Workforce ba
Chopra/Meindl 5/e
CHAPTER SIX
BioPharma Case Questions
1. How should BioPharma have used its production network in 2009? Should any of
the plants have been idled? What is the annual cost of your proposal, including
import duties?
This solution was obtaine