BEIHANG UNIVERSITY
北京航空航天大学
SCHOOL OF ECONOMICS
AND MANAGEMENT
经济管理学院
SUPPLY CHAIN MANAGEMENT
HOMEWORK5
“Mintendo Game Girl Case Study”
Professor:
ZHAO QUIHONG
Student:
NGUYEN THI THU HIEN - LS 1508257
VU THI THU HIEN
- LS 1508226
GANTA. MURALI
- LS 1508233
Supply Chain Managament - Homework5
MINTENDO GAME GIRL
Demand for Game Girls
Demand Forcast
Month
July
August
September
October
November
December
Total
Item
100,000
110,000
130,000
180,000
250,000
300,000
1,070,000
Costs for Mintendo/We "R" toys
Cost
Material cost/unit
$
12.00
Inventory holding cost/unit/month
Marginal cost of a
stockout/unit/month
Hiring and training costs/worker
Layoff cost/worker
Labor hour required/unit
$
4.00
$
$
$
10.00
3,000.00
5,000.00
0.25
Regular-time cost/hour
$
15.00
Overtime cost/hour
$
22.50
Cost of subcontracting/unit
$
18.00
Mintendo Game Girl Case Study
Page 1
Supply Chain Managament - Homework5
Basic Model
The decision variables are contained in Cells B4:I10 .
The constraints are as follows:
Workforce balance : Cells M5:M10
Capacity :
Cells N5:N10
Inventory balance: Cells O5:O10
Overtime limit : Cells P5:P10
The formula summary for determining constraints is:
Constraint
Cell
Cell Formula
Copied to
Workforce
M5
=(D5-D4-B5+C5)
M6:M10
Capacity
N5
=(I5-640*D5-4*E5)
N6:N10
Inventory
O5
=(F4-G4+I5+H5-J5-F5+G5)
O6:O10
Overtime
P5
=(40*D5-E5)
P6:P10
The detailed costs are calculated in Cells B15:I20 and the total cost is shown in Cell C22.
The net profit is shown in Cell C25.
Given that all demand is to be met, minimizing cost is equivalent to maximizing profit.
Mintendo Game Girl Case Study
Page 2
Supply Chain Managament - Homework5
Question1 : Which option delivers the maximum profit for the supply chain: Sandra’s plan,
Bill’s plan, or no promotion plan at all?...