Hi I need help with the functions in finding the "Revenue per group" in the second chart.

The question is: If XYZ paper Inc wished to achieve $2,000,000 in sales revenue, what price should they have charged?

Now - the price they should charge is $52.68 ( I think) please help!

Order	Quantity	Price per carton	Revenue		Original Price	$ 50.00
1	86	$49.50	$4,257.00
2	452	$46.00	$20,792.00		Quantity Ordered
3	492	$46.00	$22,632.00		From	To	Discount	Price per carton	Number Orders	% of Orders	Revenue per group
4	191	$48.00	$9,168.00		1	50	0%	50	12	7.55%	$ 14,400.00
5	356	$46.00	$16,376.00		51	100	1%	49.5	14	8.81%	$ 49,153.50
6	148	$48.00	$7,104.00		101	200	5%	49	35	22.01%	$ 253,824.00
7	342	$46.00	$15,732.00		201	and up	8%	46	98	61.64%	$1,580,836.00
8	382	$46.00	$17,572.00					Totals:	159	100.0%	$1,898,213.50
9	276	$46.00	$12,696.00
10	118	$48.00	$5,664.00
11	464	$46.00	$21,344.00
12	188	$48.00	$9,024.00					Order #	Quantity	Price per carton	Revenue
13	25	$50.00	$1,250.00					2	452	$46.00	$20,792.00
14	427	$46.00	$19,642.00
15	30	$50.00	$1,500.00
16	111	$48.00	$5,328.00		Original Price
17	161	$48.00	$7,728.00		$ 52.68
18	314	$46.00	$14,444.00		From	To	Discount	Price per carton	Number Orders	% of Orders	Revenue per group
19	442	$46.00	$20,332.00		1	50	0%	$ 52.68	12	7.55%
20	429	$46.00	$19,734.00		51	100	1%	$ 52.15	14	8.81%
21	451	$46.00	$20,746.00		101	200	5%	$ 50.05	35	22.01%
22	32	$50.00	$1,600.00		201	and up	8%	$ 48.47	98	61.64%
23	181	$48.00	$8,688.00					Totals:	159	100.00%
24	163	$48.00	$7,824.00
25	336	$46.00	$15,456.00
26	240	$46.00	$11,040.00
27	68	$49.50	$3,366.00
28	317	$46.00	$14,582.00
29	435	$46.00	$20,010.00
30	211	$46.00	$9,706.00
31	76	$49.50	$3,762.00
32	374	$46.00	$17,204.00
33	415	$46.00	$19,090.00
34	408	$46.00	$18,768.00
35	196	$48.00	$9,408.00
36	302	$46.00	$13,892.00
37	312	$46.00	$14,352.00
38	31	$50.00	$1,550.00
39	317	$46.00	$14,582.00
40	394	$46.00	$18,124.00
41	348	$46.00	$16,008.00
42	49	$50.00	$2,450.00
43	500	$46.00	$23,000.00
44	490	$46.00	$22,540.00
45	94	$49.50	$4,653.00
46	285	$46.00	$13,110.00
47	237	$46.00	$10,902.00
48	101	$48.00	$4,848.00
49	53	$49.50	$2,623.50
50	257	$46.00	$11,822.00
51	273	$46.00	$12,558.00
52	415	$46.00	$19,090.00
53	346	$46.00	$15,916.00
54	133	$48.00	$6,384.00
55	287	$46.00	$13,202.00
56	431	$46.00	$19,826.00
57	113	$48.00	$5,424.00
58	197	$48.00	$9,456.00
59	6	$50.00	$300.00
60	328	$46.00	$15,088.00
61	114	$48.00	$5,472.00
62	207	$46.00	$9,522.00
63	273	$46.00	$12,558.00
64	257	$46.00	$11,822.00
65	113	$48.00	$5,424.00
66	400	$46.00	$18,400.00
67	324	$46.00	$14,904.00
68	500	$46.00	$23,000.00
69	60	$49.50	$2,970.00
70	117	$48.00	$5,616.00
71	466	$46.00	$21,436.00
72	370	$46.00	$17,020.00
73	293	$46.00	$13,478.00
74	164	$48.00	$7,872.00
75	63	$49.50	$3,118.50
76	252	$46.00	$11,592.00
77	394	$46.00	$18,124.00
78	109	$48.00	$5,232.00
79	233	$46.00	$10,718.00
80	340	$46.00	$15,640.00
81	430	$46.00	$19,780.00
82	210	$46.00	$9,660.00
83	363	$46.00	$16,698.00
84	120	$48.00	$5,760.00
85	429	$46.00	$19,734.00
86	113	$48.00	$5,424.00
87	391	$46.00	$17,986.00
88	375	$46.00	$17,250.00
89	487	$46.00	$22,402.00
90	11	$50.00	$550.00
91	264	$46.00	$12,144.00
92	14	$50.00	$700.00
93	177	$48.00	$8,496.00
94	193	$48.00	$9,264.00
95	427	$46.00	$19,642.00
96	320	$46.00	$14,720.00
97	347	$46.00	$15,962.00
98	64	$49.50	$3,168.00
99	430	$46.00	$19,780.00
100	282	$46.00	$12,972.00
101	66	$49.50	$3,267.00
102	457	$46.00	$21,022.00
103	377	$46.00	$17,342.00
104	15	$50.00	$750.00
105	333	$46.00	$15,318.00
106	23	$50.00	$1,150.00
107	230	$46.00	$10,580.00
108	378	$46.00	$17,388.00
109	136	$48.00	$6,528.00
110	250	$46.00	$11,500.00
111	377	$46.00	$17,342.00
112	388	$46.00	$17,848.00
113	256	$46.00	$11,776.00
114	337	$46.00	$15,502.00
115	419	$46.00	$19,274.00
116	171	$48.00	$8,208.00
117	278	$46.00	$12,788.00
118	184	$48.00	$8,832.00
119	357	$46.00	$16,422.00
120	368	$46.00	$16,928.00
121	409	$46.00	$18,814.00
122	100	$49.50	$4,950.00
123	154	$48.00	$7,392.00
124	160	$48.00	$7,680.00
125	239	$46.00	$10,994.00
126	186	$48.00	$8,928.00
127	383	$46.00	$17,618.00
128	156	$48.00	$7,488.00
129	217	$46.00	$9,982.00
130	452	$46.00	$20,792.00
131	111	$48.00	$5,328.00
132	208	$46.00	$9,568.00
133	317	$46.00	$14,582.00
134	60	$49.50	$2,970.00
135	185	$48.00	$8,880.00
136	383	$46.00	$17,618.00
137	52	$49.50	$2,574.00
138	282	$46.00	$12,972.00
139	188	$48.00	$9,024.00
140	52	$49.50	$2,574.00
141	106	$48.00	$5,088.00
142	346	$46.00	$15,916.00
143	277	$46.00	$12,742.00
144	484	$46.00	$22,264.00
145	208	$46.00	$9,568.00
146	229	$46.00	$10,534.00
147	311	$46.00	$14,306.00
148	450	$46.00	$20,700.00
149	304	$46.00	$13,984.00
150	379	$46.00	$17,434.00
151	15	$50.00	$750.00
152	99	$49.50	$4,900.50
153	324	$46.00	$14,904.00
154	151	$48.00	$7,248.00
155	179	$48.00	$8,592.00
156	460	$46.00	$21,160.00
157	441	$46.00	$20,286.00
158	309	$46.00	$14,214.00
159	37	$50.00	$1,850.00