ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
UNIT REVENUE - SHIPPINGUNIT PRODUCTION AND HOLDING COSTNET UNIT PROFITFEB DEMAND - PRODUCT 1 IN EASTFEB DEMAND - PRODUCT 1 IN WESTFEB DEMAND - PRODUCT 2 IN EASTFEB DEMAND - PRODUCT 2 IN WESTMAR DEMAND - PRODUCT 1 IN EASTMAR DEMAND - PRODUCT 1 IN WESTMAR DEMAND - PRODUCT 2 IN EASTMAR DEMAND - PRODUCT 2 IN WESTSTORAGE LIMIT EASTSTORAGE LIMIT WEST PROCESS 1 DAYS EAST FEB PROCESS 2 DAYS EAST FEB PROCESS 1 DAYS WEST FEB PROCESS 2 DAYS WEST FEB PROCESS 1 DAYS EAST MAR PROCESS 2 DAYS EAST MAR PROCESS 1 DAYS WEST MAR PROCESS 2 DAYS WEST MARstored must be made: product 1 in Eaststored must be made: product 1 in Weststored must be made: product 2 in Eaststored must be made: product 2 in west
2
made in Feb and stored in Inventory $ 638,282.75 840568.7545005100756544.37554006000002020202023232323840568.7545005100
3
productregion360049004500510063004200540060001000100020202020232323230000
4
01E $ 3.00 $ (3.00)-111-1
5
01W $ 3.00 $ (3.00)-111-1
6
02E $ 4.00 $ (4.00)-111-1
7
02W $ 4.00 $ (4.00)-111-1
8
0manufactured total
9
0productmonthplantprocessregion
10
01FE1E $ 83.00 $ 62.00 $ 21.00 10.011
11
01FE1w $ 74.00 $ 62.00 $ 12.00 10.011
12
8401FE2E $ 83.00 $ 59.00 $ 24.00 10.0071428571431
13
01FE2W $ 74.00 $ 59.00 $ 15.00 10.0071428571431
14
01FW1E $ 74.00 $ 61.00 $ 13.00 10.0076923076921
15
568.751FW1W $ 83.00 $ 61.00 $ 22.00 10.0076923076921
16
01FW2E $ 74.00 $ 65.00 $ 9.00 10.0090909090911
17
01FW2W $ 83.00 $ 65.00 $ 18.00 10.0090909090911
18
01M E1E $ 83.00 $ 62.00 $ 21.00 10.01
19
01ME1w $ 74.00 $ 62.00 $ 12.00 10.01
20
7561ME2E $ 83.00 $ 59.00 $ 24.00 10.007142857143
21
01ME2W $ 74.00 $ 59.00 $ 15.00 10.007142857143
22
01MW1E $ 74.00 $ 61.00 $ 13.00 10.007692307692
23
544.3751MW1W $ 83.00 $ 61.00 $ 22.00 10.007692307692
24
01MW2E $ 74.00 $ 65.00 $ 9.00 10.009090909091
25
01MW2W $ 83.00 $ 65.00 $ 18.00 10.009090909091
26
24002FE1E $ 112.00 $ 78.00 $ 34.00 10.0083333333331
27
02FE1w $ 105.00 $ 78.00 $ 27.00 10.0083333333331
28
21002FE2E $ 112.00 $ 85.00 $ 27.00 10.0066666666671
29
02FE2W $ 105.00 $ 85.00 $ 20.00 10.0066666666671
30
02FW1E $ 105.00 $ 89.00 $ 16.00 10.006251
31
25002FW1W $ 112.00 $ 89.00 $ 23.00 10.006251
32
02FW2E $ 105.00 $ 86.00 $ 19.00 10.0076923076921
33
26002FW2W $ 112.00 $ 86.00 $ 26.00 10.0076923076921
34
27602M E1E $ 112.00 $ 78.00 $ 34.00 10.008333333333
35
02ME1w $ 105.00 $ 78.00 $ 27.00 10.008333333333
36
26402ME2E $ 112.00 $ 85.00 $ 27.00 10.006666666667
37
02ME2W $ 105.00 $ 85.00 $ 20.00 10.006666666667
38
02MW1E $ 105.00 $ 89.00 $ 16.00 10.00625
39
30102MW1W $ 112.00 $ 89.00 $ 23.00 10.00625
40
02MW2E $ 105.00 $ 86.00 $ 19.00 10.007692307692
41
29902MW2W $ 112.00 $ 86.00 $ 26.00 10.007692307692
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100