Part C. Model with Quantity Discounts. Allen Erosion Prevention (AEP) sells plastic barriers that prevent soil erosion on construction sites. The product comes in 200-foot roles and sells for $88 per roll. For larger construction projects, AEP offers quantity discounts. The following table show the price per roll depending on order size:

	QuantityOrdered
From	To	Price Per Roll($)
1	20	88
21	100	80
101	150	75
151	and up	70

A workbook contains 170 orders recently submitted by customers. Management has asked you to determine:
a) 10 points. The total number of orders and dollar value of orders for each pricing category
b) 10 points. How much AEP should invoice each customer.
c) 10 points. The revenue grand total.
Use appropriate MS Excel functions to make the above calculations. Be sure to show all your work and clearly indicate your answers

Answer rating: 100% (QA)

aThe total number of orders and dollar value of orders for each pricing categor... View the full answer