7. Product Ranking_Model2.xlsx

	B	C	D	E	F	G	H	I	J	K	M	N	O	Q
1
2	Theory of Constraints: Product Ranking Model									Graphics: Intelloc Mapping Services \| Mapmyops.com
3	Products	Selling Price	SP Rank	Variable Expenses	Contribution Margin	CM Rank	Prodn Rate/ Day	Throughput/ Day	Throughput Rank	TOC Rank				TOC Inputs
4	Products	Selling Price	SP Rank	Variable Expenses	Contribution Margin	CM Rank	Prodn Rate/ Day	Throughput/ Day	Throughput Rank	TOC Rank	Particulars	Annual (in Rs. lacs)	Per Working day (in Rs.)
5	A	1,000	9	800	200	8	1000	200,000	8	So-So	Fixed Plant OpEx	550	189,655	Winner
6	B	1,500	7	1,000	500	4	800	400,000	2	Winner	Desired Profits	600	206,897	So-So
7	C	3,020	1	2,510	510	3	500	255,000	7	So-So	Total	1,150	396,552	Resign
8	D	1,850	4	1,220	630	1	700	441,000	1	Winner	Annual Working Days	290
9	E	950	10	820	130	10	1400	182,000	9	Resign
10	F	1,810	6	1,400	410	5	800	328,000	4	So-So
11	G	2,200	3	1,860	340	7	1000	340,000	3	So-So
12	H	2,550	2	2,205	345	6	400	138,000	10	Resign
13	I	1,200	8	1,000	200	8	1400	280,000	5	So-So
14	J	1,820	5	1,210	610	2	450	274,500	6	So-So
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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