Discount rule shopping cart design and development

For detail, please check the attached file: Using shopping cart oversea and we provide with program and test space. We need to develop two functions control via BIGcommerce store admin as following, Function A, wholesale price and retail price We need this part show at the product price view and category view, and we can set the price at store admin control end. For product category view, the display in the ellipse is required. The wholesale price as low as: ( The lowest price is set at the store admin control) And the product view is this, the quality and price is for range, not the exact number, however, we can set the exact number at the store admin control panel: Similar to above example, please see excel file named wholesale [login to view URL], see sheet 3 For example, cost price is US$100 Quantity 1 to 5, cost price (US$100), no discount Quantity 6 to 10, wholesale price available, US$81 – US$85 Quantity 11 to 30, wholesale price available, US$80 – US$75.25 Quantity 31 to 50, wholesale price available, US$75 – US$70.25 50+, please contact us Formula should be, Final price = Cost price * Discount rate * Quantity Requirement: after knowing the rules, we can manually add wholesale price lists on our own. For example, please see excel file named wholesale [login to view URL], see sheet 1 and sheet 2