# supply chain management

## supply chain management

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?...