supply chain management

BEIHANG UNIVERSITY
???????SCHOOL OF ECONOMICS
AND MANAGEMENT
?????
SUPPLY CHAIN MANAGEMENT
HOMEWORK5“Mintendo Game Girl Case Study”Professor:ZHAO QUIHONGStudent:
NGUYEN THI THU HIEN – LS 1508257
VU THI THU HIEN
– LS 1508226
GANTA. MURALI
– LS 1508233 Supply Chain Managament – Homework5MINTENDO GAME GIRL
Demand for Game Girls
Demand ForcastMonth
July
August
September
October
November
December
TotalItem100,000
110,000
130,000
180,000
250,000
300,000
1,070,000
Costs for Mintendo/We “R” toys
CostMaterial cost/unit$12.00Inventory 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.25Regular-time cost/hour$15.00Overtime cost/hour$22.50Cost of subcontracting/unit$18.00Mintendo Game Girl Case StudyPage 1 Supply Chain Managament – Homework5Basic ModelThe 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:
ConstraintCellCell FormulaCopied toWorkforceM5=(D5-D4-B5+C5)M6:M10CapacityN5=(I5-640*D5-4*E5)N6:N10InventoryO5=(F4-G4+I5+H5-J5-F5+G5)O6:O10OvertimeP5=(40*D5-E5)P6:P10The 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 StudyPage 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?…