[go: up one dir, main page]

0% found this document useful (0 votes)
35 views12 pages

Sales Data by Segment and Country

Uploaded by

Tirumala City
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
35 views12 pages

Sales Data by Segment and Country

Uploaded by

Tirumala City
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Segment Country Product Discount Band Units Sold

Midmarket France Paseo None 549


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

You might also like