M&M Magma Estimator.xlsx

	A	B	C	D	E	F	G	H	I	J
1	19 oz Bags	Needed	Color	19.2	oz			Total	Average
2	Si	184	Blue	152	112	144	111	519	130
3	Al	68	Orange	148	150	116	141	555	139
4	Fe	39	Red	66	79	79	84	308	77
5	Mg	40	Green	79	126	88	121	414	104
6	Ca	34	Brown	72	84	97	83	336	84
7	Na	24	Yellow	72	47	73	71	263	66
8
9	Total	389		589	598	597	611
10
11	21 oz Bags	Needed	Color	21	oz (1/2 42 oz)			Total	Average	Avg Diff
12	Si	184	Blue	166	123	158	121	446	149	-35
13	Al	68	Orange	162	164	127	154	453	151	83
14	Fe	39	Red	72	86	86	92	245	82	43
15	Mg	40	Green	86	138	96	132	320	107	67
16	Ca	34	Brown	79	92	106	91	277	92	58
17	Na	24	Yellow	79	51	80	78	210	70	46
18
19	Total	389		644	654	653	668
20
21	Group Estimator
22	No. of Students =	30
23	Group Size =	3
24	No. Groups =	10		42 oz bags needed =		5.0	based on 21 oz per group
25				42 oz bags needed =		6.2	based on limiting color
26
27		Per Gr	Total Needed		Bag Calc	Group Calc	Diff	Net
28	Si (blue or orange)	184	1840		6.2	-353	353	0
29	Al (orange or blue)	68	680		2.3	829	-829	0
30	Fe (red)	39	390		2.4	427	-427	0
31	Mg (green)	40	400		1.9	668	-668	0
32	Ca (brown)	34	340		1.8	582	-582	0
33	Na (yellow)	24	240		1.7	460	-460	0
34
35	Total	389
36
37	ASSUMING NO TRADING:					ASSUMING TRADING Si & Al Colors:
38	Buy this many 42 oz bags =			7		Buy this many 42 oz bags =			5
39
40	Weigh out this many 21 oz bags =			10		Weigh out this many 21 oz bags =			10
41
42	Sort this many 42 oz bags by color =			2.0		Groups Alternate Si & Al to B & O; trade
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