Please use M$6$ XYZ Paper Inc Excel file as a starting point.

M$6$ XYZ Paper Inc sells copy paper to the local businesses. The standard carton of $5000$ sheets of paper sells for $$54$ 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$

$40$

$0\%$

$41$

$80$

$2\%$

$81$

$160$

$4\%$

$161$

And up

$7\mathrm{.}5\%$

M$6$ XYZ Paper Inc Excel file contains $162$ orders that have been received.

Step $1$: Make a copy of the sheet provided in the excel file,

Step $2$: Build your solutions $($Q$1,2,3,4)$ on the new copied sheet $($rename it: model$)$

Step $3$: Add new sheet for Q$5$

Step $4$: Add fourth sheet to explain your steps & model.

Additional sheets $$ optional

In building your model address the following questions:

Q$1.$ Build a complete spreadsheet that will calculate and match a proper price $($discounted$)$ for each order.

Q$2.$ Create $($complete$)$ a table that determines the revenue in each price category.

Q$3.$ Calculate a total revenue.

Q$4.$ Create a function that would allow user to display the entire order information when you type an order number.

Q$5.$ To increase revenue by $$120,000$ in sales, what price XYZ should charge?

Q$6.$ If you are appointed as the CEO of the company $-$what would you$-$ to increase revenue. Mention two strategies.

Hints:

Formulas to answer Q$2$ should be placed in cells J$5$:L$8$

Formula to answer Q$3$ should be placed in cell L$9$

Q$4$ involves a logical function. A user should be able to input an order number in cell I$14$ and Excel should display the entire order information in cells J$14$:L$14$ automatically

You can place your answer for Q$5$ in any cell that is convenient for you