Results 1 to 5 of 5

Thread: Oh dear heavens...I've been on this same question for DAYS!!!
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Oh dear heavens...I've been on this same question for DAYS!!!

    A company will be able to obtain a quantity discount on component parts for its three products, X1, X2 and X3 if it produces beyond certain limits. To get the X1 discount it must produce more than 50 X1's. It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount. Which of the following pair of constraints enforces the quantity discount relationship on X3?

  2. #2
    Board Regular
    Join Date
    Sep 2007
    Location
    Australia
    Posts
    224
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Oh dear heavens...I've been on this same question for DAYS!!!

    =IF(X3>=70,X3Disc,IF(X2>60,X2Disc,IF(X1>50,X1Disc,NoDisc)))

  3. #3
    Board Regular
    Join Date
    Sep 2007
    Location
    Australia
    Posts
    224
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Oh dear heavens...I've been on this same question for DAYS!!!

    For clarity ~

    You have 3 columns C,D and E
    in C you have X1, in D you have X2, in E you have X3.
    Your Discount rate is named in your Name manager for each product as in the Formula.
    Your formula would then look like this in another column.

    If your 1st row of data was in row 3.

    =IF(E3>=70,X3Disc,IF(D3>60,X2Disc,IF(C3>50,X1Disc,"NoDiscount")))

  4. #4
    New Member
    Join Date
    Jan 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Oh dear heavens...I've been on this same question for DAYS!!!

    Hmmm...so I'm confused....I have to choose between these answers

    A. X31 < M3Y3, X32 > 50Y3
    B. X31 < M3Y3, X31 > 50
    C. X32 > (1/50)X31, X31 < 50
    D. X32 < M3Y3, X31 > 50Y3

  5. #5
    Board Regular
    Join Date
    Sep 2007
    Location
    Australia
    Posts
    224
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Oh dear heavens...I've been on this same question for DAYS!!!

    IF you want different discount rates depending on quantity for each separate product
    So new formula for each product

    If product X3 was in column E3

    =IF(E3>=70,X3Disc3,IF(E3>60,X3Disc2,IF(E3>50,X3Disc1,"NoDiscount")))

    Do the same for the other products changing the references to suit.

    I don't follow this, what it all refers to (in relation to X1,X2 and X3)
    A. X31 < M3Y3, X32 > 50Y3
    B. X31 < M3Y3, X31 > 50
    C. X32 > (1/50)X31, X31 < 50
    D. X32 < M3Y3, X31 > 50Y3

    What is M3Y3 for instance is it range references, products or what?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •