Please use the XYZ Paper Inc Excel file as a starting point.
XYZ Paper Inc sells
Please use the XYZ Paper Inc Excel file as a starting point.
XYZ Paper Inc sells copy paper to 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:
XYZ Paper Inc Excel file contains 159 orders that have been received.
Q1. Build a complete spreadsheet that will calculate and match a proper price (discounted) for each order
Q2. Create a table that determines the revenue in each price category
Q3. Calculate a total revenue
Q4. Create a function that would allow the user to display the entire order information when you type an order number
Q5. If XYZ Paper Inc wished to achieve $2,000,000 in sales revenue, what price should they have charged?