XYZ Paper Inc Excel file is starting point, seen below. XYZ Paper Inc sells copy paper to the local businesses. The standard carton of 5000 sheets of paper sells for $50 per carton. XYZ Inc offers a discount based on quantity. The following table shows the discount depending on order size:

Quantity ordered
From	To	Discount
1	50	0%
51	100	1%
101	200	4%
201	And up	8%

XYZ Paper Inc Excel file contains 159 orders that have been received.

- Build a complete spreadsheet that will calculate and match a proper price (discounted) for each order

• -Create a table that determines the revenue in each price category
• -Calculate a total revenue
• -Create a function that would allow user to display the entire order information when you type an order number. Should be able to input an order number in cell I14 and Excel should display the entire order information in cells J14:L14 automatically
• - If XYZ Paper Inc wished to achieve $2,000,000 in sales revenue, what price should they have charged?

Use this in excel XYZ Paper Inc Excel file as a starting point.

Order	Quantity	Price per carton	Revenue		Original Price	$ 50.00
1	86
2	452				Quantity Ordered
3	492				From	To	Discount	Price per carton	Number Orders	% of Orders	Revenue per group
4	191				1	50	0%
5	356				51	100	1%
6	148				101	200	4%
7	342				201	and up	8%
8	382							Totals:
9	276
10	118
11	464
12	188							Order #	Quantity	Price per carton	Revenue
13	25
14	427
15	30
16	111
17	161
18	314
19	442
20	429
21	451
22	32
23	181
24	163
25	336
26	240
27	68
28	317
29	435
30	211
31	76
32	374
33	415
34	408
35	196
36	302
37	312
38	31
39	317
40	394
41	348
42	49
43	500
44	490
45	94
46	285
47	237
48	101
49	53
50	257
51	273
52	415
53	346
54	133
55	287
56	431
57	113
58	197
59	6
60	328
61	114
62	207
63	273
64	257
65	113
66	400
67	324
68	500
69	60
70	117
71	466
72	370
73	293
74	164
75	63
76	252
77	394
78	109
79	233
80	340
81	430
82	210
83	363
84	120
85	429
86	113
87	391
88	375
89	487
90	11
91	264
92	14
93	177
94	193
95	427
96	320
97	347
98	64
99	430
100	282
101	66
102	457
103	377
104	15
105	333
106	23
107	230
108	378
109	136
110	250
111	377
112	388
113	256
114	337
115	419
116	171
117	278
118	184
119	357
120	368
121	409
122	100
123	154
124	160
125	239
126	186
127	383
128	156
129	217
130	452
131	111
132	208
133	317
134	60
135	185
136	383
137	52
138	282
139	188
140	52
141	106
142	346
143	277
144	484
145	208
146	229
147	311
148	450
149	304
150	379
151	15
152	99
153	324
154	151
155	179
156	460
157	441
158	309
159	37