How-to-calculate-product-margin

How to Calculate Product Margin | 9 Exercises

by

Coffee House

States :

Maison du Café, a company specializing in roasting high-quality coffees, wants to evaluate the performance of its new product, Gourmet coffee. The purchase cost excluding tax of a packet is €8 and it is sold at a price of €12 excluding tax. Management wants to analyze the unit margin, the overall margin on a sale of 500 packets, the margin rate, the brand rate, and the strategic implications of these results for the development of the product.

Work to do :

  1. Calculate the unit margin of Gourmet coffee.
  2. Determine the overall margin if 500 packs are sold.
  3. Calculate the product's margin rate.
  4. Establish the markup rate for Gourmet Coffee.
  5. Analyze how these results could influence Maison du Café’s strategic decisions.

Proposed correction:

  1. The unit margin is calculated by subtracting the pre-tax purchase price from the pre-tax sale price:

    €12 – €8 = €4

    The unit margin for the Gourmet coffee product is €4.

  2. The overall margin is obtained by multiplying the unit margin by the quantity sold:

    4 € x 500 = 2 €

    Selling 500 packs, the overall margin is €2.

  3. The margin rate is calculated using the formula:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€12 – €8) ÷ €8) x 100 = 50%

The margin rate for Gourmet Coffee is 50%.

  1. To obtain the mark rate, we use:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€12 – €8) ÷ €12) x 100 = 33,33%

    The product's markup rate is 33,33%.

  2. The strong unit and overall margins, as well as the margin and brand rates, show that Gourmet coffee is a profitable product. These indicators will allow Maison du Café to decide whether to increase production volumes or invest in other promotions to strengthen its presence in the market.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Smart Fashion

States :

La Mode Futée, a boutique specializing in women's clothing, has just introduced a trendy blazer for the fall-winter season. The blazer's purchase price excluding VAT is €45 and it is offered for sale at a price of €80 excluding VAT. The boutique wishes to evaluate the performance of this product through the unit margin, the sale of 300 units, the margin rate, the brand rate and the strategic implications of these results.

Work to do :

  1. Calculate the unit margin of the blazer.
  2. Determine the overall margin for selling 300 blazers.
  3. Calculate the margin rate for the blazer.
  4. Set the markup rate for this product.
  5. Discuss the strategic implications of these findings for La Mode Futée.

Proposed correction:

  1. The unit margin is the difference between the selling price excluding VAT and the purchasing price excluding VAT:

    €80 – €45 = €35

    The unit margin for the blazer is €35.

  2. To find the overall margin, we multiply the unit margin by the quantity sold:

    35 € x 300 = 10 €

    The sale of 300 blazers generates an overall margin of €10.

  3. The margin rate is calculated as follows:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€80 – €45) ÷ €45) x 100 = 77,78%

The margin rate for the blazer is 77,78%.

  1. The mark rate is obtained by:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€80 – €45) ÷ €80) x 100 = 43,75%

    The markup rate for the blazer is 43,75%.

  2. The blazer's high margins indicate strong profitability for La Mode Futée. These results may encourage the store to invest more in production or explore new distribution channels to maximize sales.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

High Tech Solution

States :

High Tech Solution, an electronic gadget distribution company, is offering a new smartwatch at a production price of €120 excluding VAT. The company plans to sell it at €200 excluding VAT to test its profitability. You are tasked with evaluating the unit margin, the overall margin after selling 1000 units, the margin rate, the markup rate, and providing an outlook on the future of this product on the market.

Work to do :

  1. What is the unit margin of the smartwatch?
  2. What is the overall margin if 1000 smartwatches are sold?
  3. What is the smartwatch margin rate?
  4. What is the markup rate for this smartwatch?
  5. Discuss the impact of these results on High Tech Solution's future strategies.

Proposed correction:

  1. The unit margin is calculated by the difference between the selling price excluding tax and the production cost excluding tax:

    €200 – €120 = €80

    The unit margin for the smartwatch is €80.

  2. The overall margin is found by multiplying the unit margin by the number of units sold:

    80 € x 1000 = 80 €

    The sale of 1000 smartwatches produces an overall margin of €80.

  3. The margin rate is obtained using the formula:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€200 – €120) ÷ €120) x 100 = 66,67%

The smartwatch margin rate is 66,67%.

  1. The markup rate is calculated as follows:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€200 – €120) ÷ €200) x 100 = 40%

    The markup rate for the smartwatch is 40%.

  2. The results indicate that the product is profitable, which justifies the possible expansion of High Tech Solution's offerings, including an increased marketing strategy to strengthen its presence in the electronic gadget market.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Active Health

States :

Santé Active, a company specializing in the distribution of health products, is launching a new food supplement with a purchase price excluding tax of €15, sold at €30 excluding tax. In order to direct their future marketing strategies, it is essential to evaluate the unit margin, the overall margin on 2000 units sold, the margin rate, the brand rate, and the strategic implications of these financial results.

Work to do :

  1. Calculate the unit margin for the food supplement.
  2. Determine the overall margin for selling 2000 units.
  3. Evaluate the margin rate for this product.
  4. Establish the markup rate of the complement.
  5. Analyze how these results can influence Santé Active’s future strategy.

Proposed correction:

  1. The unit margin is calculated as follows:

    €30 – €15 = €15

    For each food supplement sold, the unit margin is €15.

  2. The overall margin is calculated by:

    15 € x 2000 = 30 €

    If 2000 food supplements are sold, the overall margin reaches €30.

  3. The margin rate is determined by:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€30 – €15) ÷ €15) x 100 = 100%

The product has a margin rate of 100%.

  1. For the markup rate, calculate:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€30 – €15) ÷ €30) x 100 = 50%

    The markup rate for this supplement is 50%.

  2. High margins ensure that this dietary supplement is extremely profitable, offering Santé Active the opportunity to intensify distribution and marketing, or to allocate funds for the development of new products in the same range.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Education Plus

States :

Education Plus, a company offering digital educational resources, wants to determine the viability of its new educational tool sold for €60 excluding VAT, with a development cost excluding VAT of €40. To prepare their marketing strategy, it is important to evaluate the unit margin, the overall margin on 150 units sold, the margin rate, the brand rate, and the strategic recommendations resulting from these calculations.

Work to do :

  1. Calculate the unit margin of the educational tool.
  2. Establish the overall margin for 150 units sold.
  3. Determine the margin rate for this tool.
  4. Calculate the markup rate of the educational tool.
  5. Suggest actions based on your analytics for Education Plus.

Proposed correction:

  1. The unit margin is calculated by the difference between the selling price excluding tax and the development cost:

    €60 – €40 = €20

    Each educational tool sold generates a unit margin of €20.

  2. The overall margin is determined by:

    20 € x 150 = 3 €

    Selling 150 educational tools produces an overall margin of €3.

  3. The margin rate amounts to:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€60 – €40) ÷ €40) x 100 = 50%

The margin rate of the educational tool is 50%.

  1. For the markup rate, the formula is:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€60 – €40) ÷ €60) x 100 = 33,33%

    The mark rate reached 33,33%.

  2. The margins recorded indicate good profitability of the educational tool. Education Plus could increase its advertising efforts and consider collaborating with institutions to expand its customer base.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Green Growth

States :

Vert Croissance, a company dedicated to ecological gardening products, starts with a planting kit sold at €25 excluding VAT, with a manufacturing cost excluding VAT of €10. To develop their business strategy, it is crucial to analyze the unit margin, the overall margin on 500 units, the margin rate, the brand rate, and potential strategies based on these figures.

Work to do :

  1. Determine the unit margin of the planting kit.
  2. Calculate the overall margin after selling 500 kits.
  3. Evaluate the margin rate for this product.
  4. Set the markup rate for the planting kit.
  5. Discuss the strategic impact of these results for Vert Croissance.

Proposed correction:

  1. The unit margin is the difference between the selling price excluding tax and the manufacturing cost:

    €25 – €10 = €15

    The unit margin per planting kit is €15.

  2. The overall margin is calculated as follows:

    15 € x 500 = 7 €

    The sale of 500 kits results in an overall margin of €7.

  3. The margin rate is determined by:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€25 – €10) ÷ €10) x 100 = 150%

The margin rate for the kit is 150%.

  1. For the markup rate, calculate:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€25 – €10) ÷ €25) x 100 = 60%

    The markup rate for the kit is 60%.

  2. High margins justify increased investment in marketing and distribution. Vert Croissance could also diversify its product range by exploiting this profitable model.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

TechnoLab Design

States :

TechnoLab Design, an industrial design firm, has developed a new ergonomic workstation sold at €400 excluding VAT, for a manufacturing cost excluding VAT of €250. In order to structure their development strategy, it is necessary to calculate the unit margin, the overall margin after the sale of 80 units, the margin rate, the brand rate, and to propose strategic recommendations.

Work to do :

  1. What is the unit margin of the workstation?
  2. Calculate the overall margin for selling 80 workstations.
  3. Evaluate the margin rate of this product.
  4. Determine the markup rate of the position.
  5. Propose strategic recommendations based on these analyses for TechnoLab Design.

Proposed correction:

  1. The unit margin is calculated by:

    €400 – €250 = €150

    The workstation generates a unit margin of €150.

  2. The overall margin is calculated by:

    150 € x 80 = 12 €

    By selling 80 workstations, the overall margin is €12.

  3. The margin rate is determined as follows:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€400 – €250) ÷ €250) x 100 = 60%

The margin rate of the workstation is 60%.

  1. To get the mark rate, use:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€400 – €250) ÷ €400) x 100 = 37,5%

    The markup rate for this job is 37,5%.

  2. Comfortable margins indicate that TechnoLab Design can afford to expand its product line and intensify its marketing efforts to distinguish itself in the field of ergonomic industrial design.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Authentic Fashion

States :

Mode Authentik, a textile brand offering eco-friendly clothing, is launching a new t-shirt sold for €50 excluding VAT with a production cost of €20 excluding VAT. To guide their growth strategy, it is crucial to analyze the unit margin, the overall margin on 1000 units sold, the margin rate, the brand rate, and the financial implications of these results.

Work to do :

  1. What is the unit margin on the t-shirt?
  2. Calculate the overall margin for selling 1000 t-shirts.
  3. Evaluate the margin rate of this garment.
  4. Determine the markup rate of the t-shirt.
  5. Discuss the financial implications of these margins for Mode Authentik.

Proposed correction:

  1. The unit margin is calculated by:

    €50 – €20 = €30

    The unit margin for the t-shirt is €30.

  2. The overall margin is obtained by multiplying:

    30 € x 1000 = 30 €

    The sale of 1000 t-shirts brings in a total margin of €30.

  3. The margin rate amounts to:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€50 – €20) ÷ €20) x 100 = 150%

The markup for the t-shirt is 150%.

  1. To calculate the markup rate, use:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€50 – €20) ÷ €50) x 100 = 60%

    The markup rate for this product is 60%.

  2. The high margins demonstrate strong profitability, allowing Mode Authentik to strengthen its range of eco-responsible products while devoting more resources to marketing and innovation.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Gourmet break

States :

Pause Gourmande, an establishment specializing in quality fast food, is adding a new sandwich to its menu sold at €8 excluding VAT, with a cost price excluding VAT of €3. In order to develop an effective sales strategy, it is important to calculate the unit margin, the overall margin on 500 units sold, the margin rate, the brand rate, and to analyze the strategic implications.

Work to do :

  1. Calculate the unit margin of the sandwich.
  2. Determine the overall margin after selling 500 sandwiches.
  3. Estimate the margin rate for this sandwich.
  4. Determine the markup rate of the product.
  5. Analyze the strategic implications of this financial data for Pause Gourmande.

Proposed correction:

  1. The unit margin is calculated as follows:

    €8 – €3 = €5

    The unit margin per sandwich is €5.

  2. The overall margin is obtained by:

    5 € x 500 = 2 €

    The sale of 500 sandwiches generates an overall margin of €2.

  3. The margin rate is calculated as follows:

((PV excluding tax – PA excluding tax) ÷ PA excluding tax) x 100 = ((€8 – €3) ÷ €3) x 100 = 166,67%

The margin rate for the sandwich is 166,67%.

  1. The markup rate is determined by:

    ((PV excluding tax – PA excluding tax) ÷ PV excluding tax) x 100 = ((€8 – €3) ÷ €8) x 100 = 62,5%

    The markup rate for this product is 62,5%.

  2. These favorable margins suggest high profitability, encouraging Pause Gourmande to promote this sandwich vigorously and potentially develop other similar offers to increase its turnover and build customer loyalty.

Formulas Used:

Title Formulas
Unit margin PV HT – PA HT
Overall margin Unit margin x Quantity sold
Margin rate ((PV HT – PA HT) ÷ PA HT) x 100
Brand taxes ((PV HT – PA HT) ÷ PV HT) x 100

Leave comments