Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
Please use M XYZ Paper Inc Excel file as a starting point.
M XYZ Paper Inc sells copy paper to the local businesses. The standard carton of sheets of paper sells for $ 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
And up
M XYZ Paper Inc Excel file contains orders that have been received.
Step : Make a copy of the sheet provided in the excel file,
Step : Build your solutions Q on the new copied sheet rename it: model
Step : Add new sheet for Q
Step : Add fourth sheet to explain your steps & model.
Additional sheets optional
In building your model address the following questions:
Q Build a complete spreadsheet that will calculate and match a proper price discounted for each order.
Q Create complete a table that determines the revenue in each price category.
Q Calculate a total revenue.
Q Create a function that would allow user to display the entire order information when you type an order number.
Q To increase revenue by $ in sales, what price XYZ should charge?
Q If you are appointed as the CEO of the company what would you to increase revenue. Mention two strategies.
Hints:
Formulas to answer Q should be placed in cells J:L
Formula to answer Q should be placed in cell L
Q involves a logical function. A user should be able to input an order number in cell I and Excel should display the entire order information in cells J:L automatically
You can place your answer for Q in any cell that is convenient for you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started