Mathematics of Merchandising
7.1 Trade Discounts
A. Introduction to Mathematics of Merchandising
Imagine walking into a shopping mall during the holiday season. Every store displays an array of products, each tagged with a price, and every discount sign represents a carefully calculated decision. This is where the unseen world of merchandising mathematics plays a pivotal role.
In this chapter, we will explore the fundamental mathematical concepts essential to successful merchandising. We start by understanding the supply chain and the relationships between its members. Moving forward, we will delve into the calculations of trade discounts, both single and series, and understand the significance of cash discounts in financial transactions.
The art of pricing, through markup and markdown strategies, will be our next focus, uncovering how businesses balance profitability with market competitiveness. We will then study integrated real-world problems, providing a practical perspective on how mathematics is applied in various merchandising scenarios.
Merchandising is the strategic promotion and sale of products to consumers. It involves a range of activities including product selection, pricing, display, and advertising. The primary goal of merchandising is to attract customers and motivate purchases, thus driving sales and profitability for businesses. It is a key component in retail, but it also extends to various other sectors where goods are sold, be it physical products or online services.
The supply chain encompasses the entire process of producing and delivering a product or service, from the sourcing of raw materials to the delivery of the final product to the consumer. The supply chain is concerned with the flow of materials, information, and finances as they move from manufacturer to wholesaler to retailer to consumer.
Figure 7.1.1 Members of a typical supply chain
As shown in Figure 7.1.1, the typical members of a supply chain include:
- Manufacturers/Producers: They create the product, sourcing raw materials and turning them into finished goods.
- Distributors/Wholesalers: They buy in bulk from manufacturers and sell in smaller quantities to retailers or sometimes directly to consumers.
- Retailers: They sell products to the end consumer, either from physical stores or online platforms.
- Consumers: The end-users who purchase and use the products.
Some organizations may bypass one or more stages of the traditional supply chain. For instance, a manufacturer might also act as a retailer, selling directly to consumers, Apple is a notable example of this. Similarly, a wholesaler can sometimes also be a retailer, as is the case with Costco.
Each member of the supply chain adds costs to the product, from production, handling, and transportation to storage and marketing. As a product moves through the supply chain, these costs accumulate, and each member, except the consumer, adds a markup to cover their costs and earn a profit. The cumulative effect of these markups contributes to the final price paid by the consumer.
B. Trade Discounts
Manufacturers usually recommend the price a product should be sold to the consumer. This price is referred to as the Manufacturer’s Suggested Retail Price (MSRP), catalog price, or list price. It represents the intended final sale price before any discounts are applied. When manufacturers set the MSRP, they often take into account the potential discounts they will offer to supply chain members. When a manufacturer sells a product to the members of the supply chain, they deduct a certain amount from their list price, usually a percentage of the list price. This is known as a trade discount. They are often used in business-to-business transactions such as the name ‘trade’ discount. Trade discounts can serve other functions:
- Volume Incentives: Larger orders are often incentivized with bigger discounts, encouraging bulk purchases and ensuring more significant sales for manufacturers.
- Promoting New Products: Discounts can be used to encourage retailers to stock and promote new or less popular products.
- Maintaining Relationships: Offering discounts helps in building and maintaining long-term business relationships between various supply chain members.
- Competitive Strategy: In highly competitive markets, manufacturers might offer trade discounts to make their products more attractive to retailers compared to rival products.
Each member of the supply chain offers successive buyer trade discounts. the final price that a buyer pays for a product after all trade discounts have been applied is called the net price. If only one trade discount is offered to a buyer, it is called a single trade discount. If a buyer is qualified for more than one trade discount, the discount is referred to as a trade discount series.
C. Single Trade Discount
A single trade discount involves only one discount percentage being applied to the list price of a product. The amount of trade discount, denoted as ‘A’, is calculated by multiplying the discount rate, represented by ‘d’, by the list price, denoted as ‘L’.
[asciimath]A=L*d[/asciimath]Formula 7.1a
The net price, denoted as ‘N’, is determined by subtracting the discount amount from the list price.
[asciimath]N=L-A[/asciimath]Formula 7.2
By inserting the discount amount from Formula 7.1a into Formula 7.2, we establish a relationship between the net price and the list price, expressed as
[asciimath]N = L - L*d[/asciimath]
[asciimath]N= L(1 - d)[/asciimath]Formula 7.3a
The term [asciimath](1-d)[/asciimath], known as the net price factor (NPF), yields the net price when multiplied by the list price, similar to how the discount rate determines the discount amount. The discount rate and the net price factor are complementary to each other, and they are typically expressed as percentages. Formula 7.3a can also be expressed in terms of the net price factor.
[asciimath]N=L*NPF[/asciimath]
where [asciimath]NPF=1-d[/asciimath].
A bicycle has a list price of $800.00 and qualifies for a trade discount of 20%. a) Determine the amount of trade discount. b) Calculate the net price of the bicycle after applying the trade discount.
Watch Video
Show/Hide Solution
- The list price is $800: [asciimath]L=800[/asciimath]
- Trade discount rate: [asciimath]d=20%=0.2[/asciimath]
a) [asciimath]A=?[/asciimath]
Substituting the given values into Formula 7.1a, we obtain
[asciimath]A=L*d[/asciimath]
[asciimath]A=800(20%)[/asciimath]
[asciimath]=$160[/asciimath]
b) [asciimath]N=?[/asciimath]
Since the amount of discount is now known, we can use Formula 7.2 to find the net price.
[asciimath]N=L-A[/asciimath]
[asciimath]N=800-160[/asciimath]
[asciimath]=$640[/asciimath]
Alternatively, we can apply Formula 7.3a to calculate the net price directly.
[asciimath]N=L(1-d)[/asciimath]
[asciimath]N=800(1-0.2)[/asciimath]
[asciimath]=800(0.8)[/asciimath]
[asciimath]=$640[/asciimath]
Try an Example
Sometimes, we may know the discount amount and need to find the original list price or the discount rate. In these instances, we can adjust Formula 7.1a to isolate and solve for the unknown variable.
- If looking for the list price: [asciimath]L=A/d[/asciimath] Formula 7.1b
- If looking for the trade discount rate: [asciimath]d=A/L[/asciimath] Formula 7.1c
When we know the net price and need to find the original list price or the discount rate, we can rearrange Formula 7.3a to isolate and solve for the unknown variable.
- If looking for the list price: [asciimath]L=N/(1-d)[/asciimath] Formula 7.3b
- If looking for the trade discount rate: [asciimath]d=1-N/L[/asciimath] Formula 7.3c
A retailer is offered a 12% trade discount on a product, and this discount amounts to $30. Calculate the list price of the product.
Show/Hide Solution
- Trade discount rate: [asciimath]d=12%=0.12[/asciimath]
- The discount amount: [asciimath]A=$30[/asciimath]
[asciimath]L=?[/asciimath]
Since the list price is asked for given the amount of discount, we apply Formula 7.1b.
[asciimath]L=A/d[/asciimath]
[asciimath]L=30/0.12[/asciimath]
[asciimath]=$250[/asciimath]
Try an Example
If an item has a net price of $174 after a 25% trade discount is applied, a) what was the original list price, and b) how much was the trade discount amount?
Show/Hide Solution
- Trade discount rate: [asciimath]d=25%=0.25[/asciimath]
- The net price: [asciimath]N=$174[/asciimath]
a) [asciimath]L=?[/asciimath]
Since the list price is asked for given the net price, we apply Formula 7.3b.
[asciimath]L=N/(1-d)[/asciimath]
[asciimath]L=174/(1-0.25)[/asciimath]
[asciimath]=174/0.75[/asciimath]
[asciimath]=$232[/asciimath]
b) [asciimath]A=?[/asciimath]
We can apply either Formula 7.1a or 7.2. Let us use Formula 7.2:
[asciimath]N=L-A[/asciimath]
[asciimath]174=232-A[/asciimath]
[asciimath]A=232-174[/asciimath]
[asciimath]=$58[/asciimath]
Try an Example
The list price of an item is $200 and the net price after applying a trade discount is $150. a) What is the net price factor? b) What is the trade discount rate?
Show/Hide Solution
- List price: [asciimath]L=$200[/asciimath]
- Net price: [asciimath]N=$150[/asciimath]
a) [asciimath]NPF=?[/asciimath]
The relation between the list price and the net price is given by
[asciimath]N=L*NPF[/asciimath]
We can rearrange the formula for[asciimath]NPF[/asciimath].
[asciimath]NPF=N/L[/asciimath]
[asciimath]NPF=150/200[/asciimath]
[asciimath]=0.75[/asciimath]
[asciimath]=75%[/asciimath]
b) [asciimath]d=?[/asciimath]
We can find the discount rate as
[asciimath]d=1-NPF[/asciimath]
[asciimath]=1-0.75[/asciimath]
[asciimath]=0.25[/asciimath]
[asciimath]=25%[/asciimath]
Alternatively, since the list price and the net price are given, we can apply Formula 7.3c to determine the discount rate.
[asciimath]d=1-N/L[/asciimath]
[asciimath]d=1-150/200[/asciimath]
[asciimath]=1-0.75[/asciimath]
[asciimath]=0.25[/asciimath]
[asciimath]=25%[/asciimath]
Try an Example
D. Trade Discount Series
As previously mentioned, there are various reasons why trade discounts are offered. Occasionally, a buyer might qualify for multiple discounts, such as one for placing a large order and another for a marketing incentive. When a buyer is offered multiple discount rates, this set of discounts is known as a trade discount series. In such cases, When calculating the net price it is important to apply each discount rate in the series sequentially, rather than combining them into a single rate. For instance, if an item’s list price is $100 and the trade discount series offered is 10%, 20%, and 30%, the calculation should proceed in stages:
- Net price after the first discount rate [asciimath]= 100(1-10%) = $90[/asciimath]
- Net price after the second discount rate [asciimath]= 90(1-20%) = $72[/asciimath]
- Net price after the third discount rate [asciimath]= 72(1-30%) = $50.40[/asciimath]
Figure 7.1.2: Example of sequential application of discount series
To simplify the calculation of the final net price with multiple trade discounts, we can extend the Net Price Factor (NPF) method to a discount series. This approach consolidates all the calculations into one step. Here, the NPF for each discount rate is first multiplied together, and then this cumulative NPF is applied to the list price. This method is more efficient than applying each discount rate one at a time. For instance:
With a single discount rate, the net price formula is: [asciimath]N=L(1-d)[/asciimath]
For two discount rates, it becomes: [asciimath]N=L(1-d_1)(1-d_2)[/asciimath]
For three discount rates, the formula is: [asciimath]N=L(1-d_1)(1-d_2)(1-d_3)[/asciimath]
In general, if there are ‘n‘ discount rates, the net price is calculated using the formula:
[asciimath]N=L(1-d_1)(1-d_2)...(1-d_n)[/asciimath]Formula 7.4
Where the product of the individual net price factor is the overall net price factor:
[asciimath]NPF=underbrace((1-d_1))_(NPF_1)underbrace((1-d_2))_(NPF_2) ...underbrace((1-d_n))_(NPF_n)[/asciimath]
Determine the net price of a product with a list price of $1400, considering it is subject to a trade discount series of 25%, 10%, and 5%.
Show/Hide Solution
- List price: [asciimath]L=$1400[/asciimath]
- Trade discount rate 1: [asciimath]d_1=25%=0.25[/asciimath]
- Trade discount rate 2: [asciimath]d_2=10%=0.1[/asciimath]
- Trade discount rate 3: [asciimath]d_3=5%=0.05[/asciimath]
[asciimath]N=?[/asciimath]
Substituting the given values into Formula 7.4 gives
[asciimath]N=L(1-d_1)(1-d_2)(1-d_3)[/asciimath]
[asciimath]N=1400(1-0.25)(1-0.1)(1-0.05)[/asciimath]
[asciimath]=1400(0.75)(0.90)(0.95)[/asciimath]
[asciimath]=$897.75[/asciimath]
Notice that the overall net price factor here is
[asciimath]NPF=(1-d_1)(1-d_2)(1-d_3)[/asciimath]
[asciimath]=(0.75)(0.90)(0.95)[/asciimath]
[asciimath]=0.64125[/asciimath]
Try an Example
E. Single Equivalent Trade Discount for a Discount Series
When dealing with multiple discounts, it can be complex and time-consuming to understand the total impact. A single equivalent rate simplifies this by providing a clear, concise figure that represents the overall effect of all the discounts combined. This makes it easier to compare different discount strategies or options. The equivalent rate of discount for a discount series is a single percentage that represents the cumulative effect of multiple trade discounts applied in sequence. It is a way to summarize the overall impact of a discount series as if it were a single discount rate.
For a single trade discount, the discount rate [asciimath]d[/asciimath] is calculated as [asciimath]d=1-NPF[/asciimath]. Similarly, for a series of discounts, the single equivalent discount rate [asciimath]d_(eq)[/asciimath] is determined as one minus the overall net price factor. Therefore, you can obtain [asciimath]d_(eq)[/asciimath] by using the formula
[asciimath]d_(eq)=1-NPF[/asciimath]
[asciimath]d_(eq)=1-[(1-d_1)(1-d_2)...(1-d_n) ][/asciimath]Formula 7.5
This single equivalent discount rate, when applied to the same list price, results in the same net price as that achieved through the series of discount rates.
A manufacturer offers a TV for sale at $1080 with a trade discount series of 30%, 15%, and 20%. Calculate the following: a) The Net Price after applying all discounts, b) The Total Amount of Discount given, and c) The Single Equivalent Rate of Discount for the entire series.
Show/Hide Solution
- List price: [asciimath]L=$1080[/asciimath]
- Trade discount rate 1: [asciimath]d_1=30%=0.30[/asciimath]
- Trade discount rate 2: [asciimath]d_2=15%=0.15[/asciimath]
- Trade discount rate 3: [asciimath]d_3=20%=0.20[/asciimath]
a) [asciimath]N=?[/asciimath]
Substituting the given values into Formula 7.4 gives
[asciimath]N=L(1-d_1)(1-d_2)(1-d_3)[/asciimath]
[asciimath]N=1080(1-0.30)(1-0.15)(1-0.20)[/asciimath]
[asciimath]=1080(0.70)(0.85)(0.80)[/asciimath]
[asciimath]1080underbrace ((0.476 ))_(NPF)[/asciimath]
[asciimath]=$514.08[/asciimath]
b) [asciimath]A_("total")=?[/asciimath]
To find the total amount of discount, we can apply Formula 7.2.
[asciimath]N=L-A_("total")[/asciimath]
[asciimath]514.08=1080-A_("total")[/asciimath]
[asciimath]A_("total") =1080-514.08[/asciimath]
[asciimath]=$565.92[/asciimath]
c) [asciimath]d_(eq)=?[/asciimath]
Approach 1:
The single equivalent discount rate is calculated by Formula 7.5.
[asciimath]d_(eq)=1-[(1-0.30)(1-0.15)(1-0.20) ][/asciimath]
[asciimath]d_(eq) =1-underbrace ( 0.476)_(NPF)[/asciimath]
[asciimath]=0.524[/asciimath]
[asciimath]=52.4%[/asciimath]
Approach 2:
The single equivalent discount rate can also be calculated using Formula 7.1c given the total amount of discount is known.
[asciimath]d_(eq)=A_("total")/L[/asciimath]
[asciimath]d_(eq)=565.92/1080[/asciimath]
[asciimath]=0.524[/asciimath]
[asciimath]=52.4%[/asciimath]
Try an Example
Section 7.1 Exercises
- A laptop is listed for $380 and is subject to a trade discount of 19%. a) Calculate the amount of trade discount. b) Calculate the net price.
Show/Hide Answer
a) A = $72.20
b) N = $307.80
- After a 28% trade discount, the net price of an item is $455. a) Calculate the list price. b) How much is the amount of discount?
Show/Hide Answer
a) L = $631.94
b) A = $176.94
- The list price of an item is $314.92 and the net price after applying a trade discount is $285. a) What is the net price factor? b) What is the trade discount rate? Give your answers in percent rounded to two decimal places.
Show/Hide Answer
a) NPF = 90.5%
b) d = 9.5%
- A wholesaler sells a phone for $900 less trade discount series of 20%, 14.4%, 5.7%. a) Find the net price. b) Find the amount of discount. c) Determine the single equivalent rate of discount. Round your answers to two decimal places if required.
Show/Hide Answer
a) N = $581.19
b) A = 318.81
c) d = 35.42%
- BestStuff offers an item for $560 with three trade discounts of 29%, 16%, and 4.7%. QualStuff offers the same model for $627.20 with two trade discounts of 27.5% and 23%. a) Which offer is cheaper? b) and by how much?
Show/Hide Answer
a) BestStuff offer is cheaper
b) by $31.84