Disagg Problem.xlsx

	A	B	C	D	E	F	G
1		Man-hours
2	Pt (Production rate)	2500
3
4		A	B	C	D	SUMA
5	DEMAND	400	600	800	700	2500
6	INVENTORY	200	400	500	300	1400
7	R	0.5	0.6666666667	0.625	0.4285714286	0.56	LESSER R FIRST
8
9	PRODUCTION ORDER	D-A-C-B
10
11
12	T	tD	tA	tC	tB	tD+T	start time of production
13	0.8771929825	0	0.2456140351	0.3859649123	0.6666666667	0.8771929825
14		T
15
16	CONSTRAINTS
17		tD	tA	tC	tB
18		614.0350877	350.877193	701.754386	526.3157895
19		614.0350877	350.877193	701.754386	526.3157895
20
21
22	INVENTORY
23	t	D	A	C	B	SUMA
24	0	300	200	500	400	1400
25	0.2456140351	742	102	304	253	1400
26	0.3859649123	644	397	192	168	1401
27	0.6666666667	447	285	670	0	1402
28	0.8771929825	300	201	502	400	1402
29
30
31
32
33
34
35
36
37
38
39
40
41
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