qrb 501 case solution
Refer to and use the following abbreviations for the problems below:
• PP = Parma minimum supply purchase
• S1 = Supplier 1
• S2 = Supplier 2
• CDF = Chain Discount Factor
• NP = Net Price
• NDE = Net Decimal Equivalent
• TD = Trade Discount
1. The Artist’s Palette purchases its inventory from a number of suppliers and each supplier offers different purchasing discounts. The manager of The Artist’s Palette, Marty Parma, is currently comparing two offers for purchasing modeling clay and supplies. The first company offers a chain discount of 20/10/5, and the second company offers a chain discount of 18/12/7 as long as the total purchases are $300 or more. Assuming Parma purchases $300 worth of supplies, a) what is the net price from supplier 1? And b) From supplier 2? And c) From which supplier would you recommend Parma purchase her modeling clay and supplies?
Now use the marked cells below to fill in the appropriate numbers for the variables to check your answers. | ||||||||||
| Variables Used |
| S1 | S2 |
|
|
|
|
| |
|
|
| PP= |
|
|
|
|
|
|
|
|
|
| 1st CDF |
|
|
|
|
|
|
|
|
|
| 2nd CDF |
|
|
|
|
|
|
|
|
|
| 3rd CDF |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Excel Formula | NP= |
|
|
|
|
|
|
| |
|
|
|
| In the yellow cells, create the Microsoft® Excel® formulas that will give you the net prices for the two suppliers. Use cell references in the formula—do NOT use numbers. | ||||||
12 years ago
Purchase the answer to view it

- artists_palette.xlsx