Segment Country Product Discount Band

Small Business Mexico Paseo None

Enterprise United States of America Carretera Low
Small Business United States of America Montana Low
Small Business Germany Paseo Medium
Enterprise Germany Amarilla Medium
Small Business Canada Montana Medium
Small Business France Montana Medium
Enterprise Mexico Amarilla High
Enterprise Canada Carretera High
Enterprise France Carretera High
Enterprise Canada Montana None
Enterprise Canada Velo None
Small Business Mexico Carretera Low
Enterprise United States of America Montana Low
Enterprise United States of America Velo Low
Small Business Mexico VTT Low
Small Business Germany Carretera Low
Enterprise Germany Paseo Low
Enterprise Mexico Paseo Low
Enterprise Germany Velo Low
Enterprise Mexico Velo Low
Units Sold Manufacturing Price Sale Price Gross Sales
788 ₹ 10.00 ₹ 300.00 ₹ 236,400.00
330 ₹ 3.00 ₹ 125.00 ₹ 41,250.00
2498 ₹ 5.00 ₹ 300.00 ₹ 749,400.00
1123 ₹ 10.00 ₹ 300.00 ₹ 336,900.00
994 ₹ 260.00 ₹ 125.00 ₹ 124,250.00
1283 ₹ 5.00 ₹ 300.00 ₹ 384,900.00
322 ₹ 5.00 ₹ 300.00 ₹ 96,600.00
947 ₹ 260.00 ₹ 125.00 ₹ 118,375.00
2416 ₹ 3.00 ₹ 125.00 ₹ 302,000.00
1023 ₹ 3.00 ₹ 125.00 ₹ 127,875.00
345 ₹ 5.00 ₹ 125.00 ₹ 43,125.00
345 ₹ 120.00 ₹ 125.00 ₹ 43,125.00
494 ₹ 3.00 ₹ 300.00 ₹ 148,200.00
663 ₹ 5.00 ₹ 125.00 ₹ 82,875.00
663 ₹ 120.00 ₹ 125.00 ₹ 82,875.00
494 ₹ 250.00 ₹ 300.00 ₹ 148,200.00
214 ₹ 3.00 ₹ 300.00 ₹ 64,200.00
809 ₹ 10.00 ₹ 125.00 ₹ 101,125.00
2145 ₹ 10.00 ₹ 125.00 ₹ 268,125.00
809 ₹ 120.00 ₹ 125.00 ₹ 101,125.00
2145 ₹ 120.00 ₹ 125.00 ₹ 268,125.00

A1 vlookup Segment Units Sold

Germany 2022.5

6
finding column number by formula of e5 5
Discounts Sales COGS Profit
₹ - ₹ 236,400.00 ₹ 197,000.00 ₹ 39,400.00
₹ 412.50 ₹ 40,837.50 ₹ 40,425.00 ₹ 39,600.00 ₹ 1,237.50
₹ 7,494.00 ₹ 741,906.00 ₹ 624,500.00 ₹ 117,406.00
₹ 23,583.00 ₹ 313,317.00 ₹ 280,750.00 ₹ 32,567.00
₹ 8,697.50 ₹ 115,552.50 ₹ 119,280.00 ₹ -3,727.50
₹ 30,792.00 ₹ 354,108.00 ₹ 320,750.00 ₹ 33,358.00
₹ 8,694.00 ₹ 87,906.00 ₹ 80,500.00 ₹ 7,406.00
₹ 13,021.25 ₹ 105,353.75 ₹ 113,640.00 ₹ -8,286.25
₹ 36,240.00 ₹ 265,760.00 ₹ 289,920.00 ₹ -24,160.00
₹ 17,902.50 ₹ 109,972.50 ₹ 122,760.00 ₹ -12,787.50
₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 1,284.00 ₹ 62,916.00 ₹ 53,500.00 ₹ 9,416.00
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50
Product Units Sold
Paseo 788
Carretera 330
Montana 2498
Paseo 1123
Units Sold
Amarilla 994 3000
Montana 1283
Montana 322 2500
Amarilla 947
2000
Carretera 2416
Carretera 1023
1500
Montana 345
Velo 345 1000
Carretera 494
Montana 663 500
Velo 663
VTT 494 0
0 5 10 15
Carretera 214
Paseo 809
Paseo 2145
Velo 809
Velo 2145
Units Sold

10 15 20 25
Product Sale Price
Paseo ₹ 15.00
Paseo ₹ 300.00
VTT ₹ 350.00
Carretera ₹ 125.00
Montana ₹ 300.00
Amarilla ₹ 12.00
Montana ₹ 350.00
Paseo ₹ 7.00
Velo ₹ 20.00
Velo ₹ 20.00
VTT ₹ 350.00
Paseo ₹ 7.00
Montana ₹ 350.00
Carretera ₹ 20.00
Paseo ₹ 7.00
VTT ₹ 12.00
Paseo ₹ 15.00
Paseo ₹ 300.00
Amarilla ₹ 125.00
Montana ₹ 300.00
Paseo ₹ 7.00
Montana ₹ 300.00
VTT ₹ 12.00
VTT ₹ 12.00
Velo ₹ 20.00
Velo ₹ 15.00
Amarilla ₹ 125.00
Paseo ₹ 7.00
Carretera ₹ 125.00
VTT ₹ 350.00
Amarilla ₹ 12.00
Carretera ₹ 20.00
Velo ₹ 15.00
Carretera ₹ 125.00
Paseo ₹ 15.00
Montana ₹ 125.00
Velo ₹ 125.00
Carretera ₹ 12.00
Carretera ₹ 300.00
Montana ₹ 125.00
Paseo ₹ 12.00
Velo ₹ 125.00
VTT ₹ 300.00
Carretera ₹ 300.00
Paseo ₹ 125.00
Paseo ₹ 125.00
Velo ₹ 350.00
Velo ₹ 125.00
Velo ₹ 125.00
Small Business United States o Montana Low 2498 ₹ 5.00 ₹ 300.00 ₹ 749,400.00
Channel PartnerUnited States o Amarilla Low 1989 ₹ 260.00 ₹ 12.00 ₹ 23,868.00
Government Germany Montana Low 1797 ₹ 5.00 ₹ 350.00 ₹ 628,950.00
Government Mexico Paseo Low 1760 ₹ 10.00 ₹ 7.00 ₹ 12,320.00
Government United States o Velo Low 736 ₹ 120.00 ₹ 20.00 ₹ 14,720.00
Government Canada Velo Low 2646 ₹ 120.00 ₹ 20.00 ₹ 52,920.00
Government United States o VTT Low 349 ₹ 250.00 ₹ 350.00 ₹ 122,150.00
Government Canada Paseo Medium 2349 ₹ 10.00 ₹ 7.00 ₹ 16,443.00
Government Mexico Montana Medium 720 ₹ 5.00 ₹ 350.00 ₹ 252,000.00
Government Mexico Carretera Medium 1834 ₹ 3.00 ₹ 20.00 ₹ 36,680.00
Government France Paseo Medium 1031 ₹ 10.00 ₹ 7.00 ₹ 7,217.00
Channel PartnerGermany VTT Medium 2215 ₹ 250.00 ₹ 12.00 ₹ 26,580.00
Midmarket United States o Paseo Medium 2931 ₹ 10.00 ₹ 15.00 ₹ 43,965.00
Small Business Germany Paseo Medium 1123 ₹ 10.00 ₹ 300.00 ₹ 336,900.00
Enterprise Germany Amarilla Medium 994 ₹ 260.00 ₹ 125.00 ₹ 124,250.00
Small Business Canada Montana Medium 1283 ₹ 5.00 ₹ 300.00 ₹ 384,900.00
Government Germany Paseo Medium 2409 ₹ 10.00 ₹ 7.00 ₹ 16,863.00
Small Business France Montana Medium 322 ₹ 5.00 ₹ 300.00 ₹ 96,600.00
Channel PartnerFrance VTT Medium 2234 ₹ 250.00 ₹ 12.00 ₹ 26,808.00
Channel PartnerMexico VTT High 1005 ₹ 250.00 ₹ 12.00 ₹ 12,060.00
Government France Velo High 2805 ₹ 120.00 ₹ 20.00 ₹ 56,100.00
Midmarket Mexico Velo High 655 ₹ 120.00 ₹ 15.00 ₹ 9,825.00
Enterprise Mexico Amarilla High 947 ₹ 260.00 ₹ 125.00 ₹ 118,375.00
Government United States o Paseo High 380 ₹ 10.00 ₹ 7.00 ₹ 2,660.00
Enterprise Canada Carretera High 2416 ₹ 3.00 ₹ 125.00 ₹ 302,000.00
Government Canada VTT High 623 ₹ 250.00 ₹ 350.00 ₹ 218,050.00
Channel PartnerCanada Amarilla High 2761 ₹ 260.00 ₹ 12.00 ₹ 33,132.00
Government Germany Carretera High 442 ₹ 3.00 ₹ 20.00 ₹ 8,840.00
Midmarket Germany Velo High 660 ₹ 120.00 ₹ 15.00 ₹ 9,900.00
Enterprise France Carretera High 1023 ₹ 3.00 ₹ 125.00 ₹ 127,875.00
Midmarket Canada Paseo High 2470 ₹ 10.00 ₹ 15.00 ₹ 37,050.00
Enterprise Canada Montana None 345 ₹ 5.00 ₹ 125.00 ₹ 43,125.00
Enterprise Canada Velo None 345 ₹ 120.00 ₹ 125.00 ₹ 43,125.00
Channel PartnerGermany Carretera Low 766 ₹ 3.00 ₹ 12.00 ₹ 9,192.00
Small Business Mexico Carretera Low 494 ₹ 3.00 ₹ 300.00 ₹ 148,200.00
Enterprise United States o Montana Low 663 ₹ 5.00 ₹ 125.00 ₹ 82,875.00
Channel PartnerGermany Paseo Low 766 ₹ 10.00 ₹ 12.00 ₹ 9,192.00
Enterprise United States o Velo Low 663 ₹ 120.00 ₹ 125.00 ₹ 82,875.00
Small Business Mexico VTT Low 494 ₹ 250.00 ₹ 300.00 ₹ 148,200.00
Small Business Germany Carretera Low 214 ₹ 3.00 ₹ 300.00 ₹ 64,200.00
Enterprise Germany Paseo Low 809 ₹ 10.00 ₹ 125.00 ₹ 101,125.00
Enterprise Mexico Paseo Low 2145 ₹ 10.00 ₹ 125.00 ₹ 268,125.00
Government Germany Velo Low 2966 ₹ 120.00 ₹ 350.00 ₹ 1,038,100.00
Enterprise Germany Velo Low 809 ₹ 120.00 ₹ 125.00 ₹ 101,125.00
Enterprise Mexico Velo Low 2145 ₹ 120.00 ₹ 125.00 ₹ 268,125.00
₹ 7,494.00 ₹ 741,906.00 ₹ 624,500.00 ₹ 117,406.00
₹ 238.68 ₹ 23,629.32 ₹ 5,967.00 ₹ 17,662.32
₹ 18,868.50 ₹ 610,081.50 ₹ 467,220.00 ₹ 142,861.50
₹ 369.60 ₹ 11,950.40 ₹ 8,800.00 ₹ 3,150.40
₹ 588.80 ₹ 14,131.20 ₹ 7,360.00 ₹ 6,771.20
₹ 2,116.80 ₹ 50,803.20 ₹ 26,460.00 ₹ 24,343.20
₹ 4,886.00 ₹ 117,264.00 ₹ 90,740.00 ₹ 26,524.00
₹ 822.15 ₹ 15,620.85 ₹ 11,745.00 ₹ 3,875.85
₹ 12,600.00 ₹ 239,400.00 ₹ 187,200.00 ₹ 52,200.00
₹ 2,567.60 ₹ 34,112.40 ₹ 18,340.00 ₹ 15,772.40
₹ 505.19 ₹ 6,711.81 ₹ 5,155.00 ₹ 1,556.81
₹ 1,860.60 ₹ 24,719.40 ₹ 6,645.00 ₹ 18,074.40
₹ 3,077.55 ₹ 40,887.45 ₹ 29,310.00 ₹ 11,577.45
₹ 23,583.00 ₹ 313,317.00 ₹ 280,750.00 ₹ 32,567.00
₹ 8,697.50 ₹ 115,552.50 ₹ 119,280.00 ₹ -3,727.50
₹ 30,792.00 ₹ 354,108.00 ₹ 320,750.00 ₹ 33,358.00
₹ 1,349.04 ₹ 15,513.96 ₹ 12,045.00 ₹ 3,468.96
₹ 8,694.00 ₹ 87,906.00 ₹ 80,500.00 ₹ 7,406.00
₹ 2,412.72 ₹ 24,395.28 ₹ 6,702.00 ₹ 17,693.28
₹ 1,326.60 ₹ 10,733.40 ₹ 3,015.00 ₹ 7,718.40
₹ 6,171.00 ₹ 49,929.00 ₹ 28,050.00 ₹ 21,879.00
₹ 1,080.75 ₹ 8,744.25 ₹ 6,550.00 ₹ 2,194.25
₹ 13,021.25 ₹ 105,353.75 ₹ 113,640.00 ₹ -8,286.25
₹ 292.60 ₹ 2,367.40 ₹ 1,900.00 ₹ 467.40
₹ 36,240.00 ₹ 265,760.00 ₹ 289,920.00 ₹ -24,160.00
₹ 26,166.00 ₹ 191,884.00 ₹ 161,980.00 ₹ 29,904.00
₹ 3,975.84 ₹ 29,156.16 ₹ 8,283.00 ₹ 20,873.16
₹ 1,149.20 ₹ 7,690.80 ₹ 4,420.00 ₹ 3,270.80
₹ 1,287.00 ₹ 8,613.00 ₹ 6,600.00 ₹ 2,013.00
₹ 17,902.50 ₹ 109,972.50 ₹ 122,760.00 ₹ -12,787.50
₹ 5,187.00 ₹ 31,863.00 ₹ 24,700.00 ₹ 7,163.00
₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹ - ₹ 43,125.00 ₹ 41,400.00 ₹ 1,725.00
₹ 91.92 ₹ 9,100.08 ₹ 2,298.00 ₹ 6,802.08
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 91.92 ₹ 9,100.08 ₹ 2,298.00 ₹ 6,802.08
₹ 828.75 ₹ 82,046.25 ₹ 79,560.00 ₹ 2,486.25
₹ 1,482.00 ₹ 146,718.00 ₹ 123,500.00 ₹ 23,218.00
₹ 1,284.00 ₹ 62,916.00 ₹ 53,500.00 ₹ 9,416.00
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50
₹ 20,762.00 ₹ 1,017,338.00 ₹ 771,160.00 ₹ 246,178.00
₹ 2,022.50 ₹ 99,102.50 ₹ 97,080.00 ₹ 2,022.50
₹ 5,362.50 ₹ 262,762.50 ₹ 257,400.00 ₹ 5,362.50