Manufacturing
Extended Game
© Copyright 2004-2017, Léger et al., HEC Montréal.
All rights reserved.
Last Update: December 19th 2017
$1 to $9
User:
Password: ERPSIM
FORECAST SALES
CALCULATE REQUIREMENTS
PURCHASING
RELEASE PRODUCTION
MARKETING EXPENSE
CHANGE PRICE
Create Planned Indep. Req. (MD61)
MRP Run (MD01)
Automatic Gen. of POs (ME59N)
Coll. Conversion of Pld Orders (CO41)
Marketing Expense Planning (ZADS)
Condition Maintenance: Change (VK32)
Product group,
1 Select
then enter : $$-F
2
forecasted quantities
3 Enter
in the 2nd date column
4
quantity corresponds to
? The
the replenishment level
1
1
2 Click once again on Enter
2 Purchase orders are created
3
?
In the pop-up window, click
If no open requisitions :
No suitable requisitions found.
1
order: Planned
? Iforderno planned
could not be selected
2 Select orders
on Convert. Message
3 Click
confirms the conversion.
fails,
? Ifclickconversion
on
to see log
1
2
Enter the daily amount of
marketing for each product
and each area.
To apply your
marketing expense plan
prices folder and
1 Open
double click on Price list
In Distribution channel, enter
2 10,
12 or 14
3
4 Enter your prices
5
FINANCIAL STATEMENT
STOCK LEVELS
PO TRACKING
PRODUCTION SCHEDULE
PRODUCTION COST
SALES AND MARKET DATA
Financial Statements (F.01)
Inventory Report (ZMB52)
Purchase Order Tracking (ZME2N)
Production Schedule (ZCOOIS)
Product Cost Analysis (ZCK11)
Sales Order Report (ZVA05)
For each product, it shows
variable and fixed costs.
Shows sales transactions:
time, sales revenues, boxes
sold and price per box.
company code, enter your
1 Incompany
code ($$)
ALV Tree control
2 Select
(optional)
3
Shows for each purchase
order, the issue , arrival and
payment dates.
Shows all stock levels
Shows released production
orders, past and future. For each
order the time released, started
and finished (or to start and finish
if incomplete).
Target Qty > Conf. Qty
means still pending.
Vendor Pricing (ZME13)
Shows material prices for
each vendor.
Liquidity Planning (ZFF7B)
Displays an estimate of your cashflow
for the coming weeks.
Summary Sales Report (ZVC2)
Aggregates the daily sales
orders by product.
Price Market Report (ZMARKET)
Shows market sales for
lagging 5 days - revenues,
units, and average price.
CHANGE PRODUCT DESIGN
LOAN REPAYMENT
SETUP TIME REDUCTION
INCREASE CAPACITY
Modify BOM (ZCS02)
Enter G/L Account (FB50)
Enter G/L Account (FB50)
Enter G/L Account (FB50)
enter the product
1 Into Material,
redesign : $$-F##
2
3 Change quantities
4
current date (F4) in
1 Enter
Document Date
1 Line
2
2
Account
113300
113101
D/C
Credit
???
prompted the “incorrect recipe“
? Ifmessage,
click on
to modify it
3
4
st
Amount
nd
Line
current date (F4) in
1 Enter
Document Date
1 Line
2
2
st
nd
Line
st
nd
Line
Account
113300
11000
Debit
D/C
Credit
Debit
???
Amount
???
???
Account
113300
478000
Debit
D/C
Credit
???
Amount
???
3
4
current date (F4) in
1 Enter
Document Date
1 Line
2
2
3
4
Product Design
Blueberry
Nut
$$-F01
$$-F11
© Copyright 2004-2017, Léger et al., HEC Montréal.
All rights reserved.
Last Update: December 19th 2017
500g
1kg
$$-F02
$$-F12
Strawberry
500g
1kg
20% wheat*
30% oat*
20% blueberry*
1 box / 1 bag*
20% wheat*
30% oat*
20% nut*
1 box / 1 bag*
500g
1kg
20% wheat*
30% oat*
20% raisins*
1 box / 1 bag*
*minimum
CUSTOMER S
Original
$$-F04
$$-F14
500g
1kg
20% wheat*
30% oat*
20% strawberry*
1 box / 1 bag*
*minimum
*minimum
$$-F03
$$-F13
Raisin
*minimum
STOR AGE CAPACIT Y AND COSTS
DC10
DC 10: Hypermarkets
Payment Time : 20
Approximate Market Size
€90 000 per team per week
DC12
DC 12: Grocery Chains
Payment Time : 10-20
Approximate Market Size
€220 000 per team per week
DC14
DC 14: Independant Grocers
Payment Time : 1-20
Approximate Market Size
€130 000 per team per week
$$-F05
$$-F15
500g
1kg
20% wheat*
30% oat*
1 box / 1 bag*
$$-F06
$$-F16
500g
1kg
20% wheat*
30% oat*
30% fruits & nuts**
1 box / 1 bag*
*minimum
*minimum
**At least some of all fruits/nut
PRODUCTION CAPACIT Y
Product type
Current space
Cost per
additional
50,000 units*
Finished product
250,000 boxes
€500/day
Raw materials
250,000 kg
€1 000/day
**Investing in additional capacity will increase equipment depreciation costs
Packaging
(bags and boxes)
750,000 units
€100/day
SETUP TIME
*Billed automatically
SUPPLIER S
Mixed
FIXED COSTS (€ paid each 5 days)*
Capacity (units/day)
24,000
Additional Capacity
(€ per 1,000 units)
1 000 000**
Setup time (hours)
Investment (€)
8
-
Direct labor
20 000
7
50 000
Factory overhead
15 000
6
125 000
S, G & A
40 000
5
250 000
1 250
4
500 000
50 000**
3
1 250 000
Lead time (days)
1-5
Depreciation (Building)
Payment time (days)
20
Depreciation (Equipment)
*Billed automatically
Financial Statements - R1
Team
Credit ratings
Interest Rate
Rank
(%)
F
A
8
K
A
8
L
A8.25
J
A
8
G
A8.25
E
A
8
I
BBB+
8.75
H
BBB+
8.75
1
2
3
4
5
6
7
8
Company valuation Cumulative Net Income Total sales
67,629,180.33
561,708.47 1,591,804.81
63,181,206.33
173,478.73 1,667,093.49
34,991,501.71
-101,128.42 1,316,216.35
30,684,459.00
306,844.59 1,166,688.38
20,872,289.96
-245,262.04 1,307,873.44
17,042,910.00
170,429.10 1,049,601.33
-22,094,021.33
-387,832.31 640,930.18
-149,839,380.71
-1,592,043.42
0
Gross Margin
Net(%)
MarginROE
(%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity
75.767
35.288
2.732
2.015
35.55
0
561,708.47
70
70.719
10.406
0.86
0.623
38.114
0.375
173,478.73
75.833
70.315
-7.683
-0.508
-0.357
42.347
2.735
-101,128.42
64.167
70.963
26.3
1.511
1.134
33.285
0
306,844.59
54.411
70.721 -18.753
-1.242
-0.85
46.02
0.078
-245,262.04
70.833
69.286
16.238
0.845
0.601
40.615
0
170,429.10
53.333
72.778 -60.511
-1.978
-1.396
41.683
14.643
-387,832.31
44.169
0
0
-8.649
-5.969
44.9
0
-1,592,043.42
0
Round Sales per Team
1,591,804.81
1,667,093.49
1,316,216.35
1,166,688.38
1,307,873.44
1,049,601.33
640,930.18
0
Financial Statements - R2
Team
Credit ratings
Interest Rate
Rank
(%)
F
A+
7.75
K
A
8
L
A8.25
J
A
8
G
A
8
E
A
8
I
BBB+
8.75
H
BBB+
8.75
1
2
3
4
5
6
7
8
Company valuation Cumulative Net Income Total sales
98,480,446.81
1,824,408.75 3,893,608.63
73,912,990.83
1,061,593.15 3,469,846.01
47,956,082.78
562,436.69 2,969,561.30
39,857,949.50
797,158.99 2,615,707.93
34,540,614.83
274,145.63 2,943,319.35
22,355,553.50
447,111.07 2,155,507.08
15,688,203.61
194,207.66 2,662,004.13
-109,882,469.18
-2,335,002.47 955,292.16
Gross Margin
Net(%)
MarginROE
(%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity
76.045
46.857
8.359
6.499
28.629
0
1,262,700.28
77.5
75.37
30.595
5.04
3.838
31.331
0.604
888,114.42
65.417
71.434
18.94
2.735
1.981
38.085
1.455
663,565.11
74.2
71.182
30.476
3.833
2.908
31.79
0
490,314.40
62.898
69.338
9.314
1.352
0.969
39.601
1.028
519,407.67
66.875
72.297
20.743
2.187
1.575
38.877
0.172
276,681.97
48.333
67.805
7.296
0.962
0.665
44.67
8.935
582,039.97
89.504
70.263 -244.428 -13.218
-8.935
47.93 198.159
-742,959.05
46.667
Round Sales per Team
2,301,803.82
1,802,752.52
1,653,344.95
1,449,019.55
1,635,445.91
1,105,905.75
2,021,073.95
955,292.16
Financial Statements - R3
Team
Credit ratings
Interest Rate
Rank
(%)
F
AA
7
K
AA7.25
L
A
8
J
A
8
E
A+
7.75
G
A
8
I
A8.25
H
BBB
9
1
2
3
4
5
6
7
8
Company valuation Cumulative Net Income Total sales
121,951,160.73
3,259,906.92 6,350,196.27
84,079,931.38
1,989,748.07 5,372,788.06
67,627,572.33
1,653,827.17 5,213,916.05
39,693,276.67
1,190,798.30 3,930,348.90
35,245,614.30
1,035,339.92 3,606,378.38
32,524,750.33
38,242.51 4,432,575.25
30,910,196.90
821,374.78 4,532,550.39
-95,143,676.00
-3,092,169.47 2,009,817.99
Gross Margin
Net(%)
MarginROE
(%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity
76.157
51.336
14.015
11.434
22.576
0
1,435,498.17
78.75
75.469
37.034
9.049
7.258
24.667
0.51
928,154.92
73.958
71.926
31.719
7.638
5.715
33.647
0.829
1,091,390.48
86
71.18
30.298
5.619
4.301
30.659
0.003
393,639.31
65.453
74.399
28.709
4.922
3.577
37.609
0.158
588,228.85
49.167
69.788
0.863
0.191
0.134
42.587
1.292
-235,903.12
80
68.684
18.122
3.945
2.812
40.267
5.855
627,167.12
88.338
71.468 -153.853 -18.288 -11.819
54.74 142.252
-757,167.00
46.667
Round Sales per Team
2,456,587.64
1,902,942.05
2,244,354.75
1,314,640.97
1,450,871.30
1,489,255.90
1,870,546.26
1,054,525.83
Financial Statements - R4
Team
Credit ratings
Interest Rate
Rank
(%)
F
AA+
6.5
L
AA7.25
K
AA
7
E
AA7.25
G
A+
7.75
J
A8.25
I
A
8
H
BBB
9
1
2
3
4
5
6
7
8
Company valuation Cumulative Net Income Total sales
121,464,781.49
4,269,154.67 8,263,716.14
96,710,046.22
3,293,293.40 7,923,602.05
89,406,777.36
2,944,915.17 7,304,136.15
49,361,922.40
1,851,072.09 5,387,314.03
39,994,434.98
733,115.37 6,304,693.91
38,735,628.73
1,581,704.84 5,354,930.41
37,900,834.58
1,404,700.05 6,449,187.64
-75,762,911.31
-3,283,059.49 2,704,130.25
Gross Margin
Net(%)
MarginROE
(%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity
76.618
51.661
17.591
15.743
11.735
0
1,009,247.75
75
74.378
41.563
14.138
10.915
29.535
0.545
1,639,466.23
79.6
75.826
40.318
12.835
10.801
18.828
0.411
955,167.10
84.167
74.983
34.36
8.471
6.366
33.064
0.135
815,732.17
68.333
69.747
11.628
3.536
2.603
35.833
1.657
694,872.86
85.625
70.9
29.537
7.329
5.538
32.327
0.837
390,906.54
58.896
67.522
21.781
6.563
4.692
39.872
4.542
583,325.27
88.338
70.561 -121.409 -19.639 -12.565
56.306 109.136
-190,890.02
33.333
Round Sales per Team
1,913,519.87
2,709,686.00
1,931,348.09
1,780,935.65
1,872,118.66
1,424,581.51
1,916,637.25
694,312.26
Financial Statements - R5
Team
Credit ratings
Interest Rate
Rank
(%)
F
AAA+
6
L
AA+
6.5
K
AA+
6.5
E
AA
7
I
A+
7.75
G
A+
7.75
J
A8.25
H
BBB
9
1
2
3
4
5
6
7
8
Company valuation Cumulative Net Income Total sales
141,653,847.28
5,829,326.97 11,000,859.28
109,455,453.69
4,611,025.53 10,363,013.05
86,471,182.14
3,581,521.70 8,777,348.82
63,115,596.00
2,892,798.15 7,472,144.18
43,687,479.76
2,041,449.53 8,333,059.70
43,261,150.91
1,388,827.18 8,093,537.97
37,967,532.54
1,937,926.14 6,667,390.29
-58,627,442.77
-3,175,653.15 3,709,427.32
Gross Margin
Net(%)
MarginROE
(%) (%) ROA (%) D/E (%) Mktg/S (%)Round Net Income Round Productivity
76.364
52.99
22.569
21.052
7.202
0
1,560,172.30
69.792
75.347
44.495
18.736
14.566
28.626
0.417
1,317,732.13
74.6
76.006
40.804
15.188
13.488
12.599
0.398
636,606.53
45.833
75.839
38.714
12.636
9.874
27.98
0.119
1,041,726.06
62.083
68.241
24.498
9.262
6.753
37.159
3.55
636,749.48
89.504
69.742
17.16
6.493
5.112
27.02
1.767
655,711.81
88.125
71.1
29.066
8.834
6.69
32.04
0.732
356,221.30
51.833
70.583
-85.61 -18.875 -12.135
55.546
79.699
107,406.34
40
Round Sales per Team
2,737,143.14
2,439,411.00
1,473,212.67
2,084,830.15
1,883,872.06
1,788,844.06
1,312,459.88
1,005,297.07
Purchase answer to see full
attachment