Results 1 to 2 of 2

Thread: Distributed Discount.

  1. #1
    Newbie
    Joined
    Feb 2018
    From
    UK
    Posts
    4

    Distributed Discount.

    Hi All,

    Wasn't to sure what to title this with, I would like to apply a discount for multi-qty's orders of Items. More Specifically, for every Six (6) ordered, One (1) Item is Free. So Ordering Twelve (12), would get Two (2) for Free BUT I would like Qty Breaks for 1,2,6 & 12.

    1 - 22.00
    2 -
    6 - ((6 * 22.00) - 22.00)
    12 -

    What approach do I need to take to creation of a formula AND are there any considerations I should be aware of when quantities increase pass 100 (for example).

    Qty 1 - Base Price
    Qty 2 - Discounted
    Qty 6 - Base for Discount (Order 6, Pay for 5)
    Qty 12 - Discounted

    Thanks in advance for your advice

    Stuart
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Feb 2015
    From
    Ottawa Ontario
    Posts
    1,935
    Thanks
    360

    Re: Distributed Discount.

    Quote Originally Posted by stuartcameron View Post
    Wasn't to sure what to title this with, I would like to apply a discount for multi-qty's orders of Items. More Specifically, for every Six (6) ordered, One (1) Item is Free. So Ordering Twelve (12), would get Two (2) for Free BUT I would like Qty Breaks for 1,2,6 & 12.

    1 - 22.00
    2 -
    6 - ((6 * 22.00) - 22.00)
    12 -

    What approach do I need to take to creation of a formula AND are there any considerations I should be aware of when quantities increase pass 100 (for example).

    Qty 1 - Base Price
    Qty 2 - Discounted
    Qty 6 - Base for Discount (Order 6, Pay for 5)
    Qty 12 - Discounted
    How can Qty 2 be discounted if no discounts before Qty 6?
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. What's The Discount I need to give?
    Posted in the Math Challenge Problems Forum
    Replies: 2
    Last Post: Sep 21st 2012, 05:09 PM
  2. Percentage discount.
    Posted in the Algebra Forum
    Replies: 2
    Last Post: Apr 18th 2011, 03:52 PM
  3. Discount
    Posted in the Algebra Forum
    Replies: 1
    Last Post: Aug 28th 2008, 04:18 AM
  4. discount
    Posted in the Algebra Forum
    Replies: 2
    Last Post: May 28th 2005, 09:46 AM

Search Tags


/mathhelpforum @mathhelpforum