Segment Country Product Discount Band Units Sold Manufacturing p Sale price Gross sales discount discount-sale
Small Business Mexico Paseo None 788 10 300 236400 798 235602
Enterprise United StatesCarretera Low 330 3 125 41250 412.5 40425
Small Business United StatesMontana Low 2498 5 300 749400 7,494.00 Err:502
Small Business Germany Paseo Medium 1123 10 300 336900 23,583.00 Err:502
Enterprise Germany Amarilla Medium 994 260 125 124250 8,697.50 Err:502
Small Business Canada Montana Medium 1283 5 300 384900 30,792.00 Err:502
Small Business France Montana Medium 322 5 300 96600 8,694.00 Err:502
Enterprise Mexico Amarilla High 947 260 125 118375 13,021.25 Err:502
Enterprise Canada Carretera High 2416 3 125 302000 36,240.00 Err:502
Enterprise France Carretera High 1023 3 125 127875 17,902.50 Err:502
Enterprise Canada Montana None 345 5 125 43125 - 43125
Enterprise Canada Velo None 345 120 125 43125 - 43125
Small Business Mexico Carretera Low 494 3 300 148200 1,482.00 Err:502
Enterprise United StatesMontana Low 663 5 125 82875 828.75 81217.5
Enterprise United StatesVelo Low 663 120 125 82875 828.75 81217.5
Small Business Mexico VTT Low 494 250 300 148200 1,482.00 Err:502
Small Business Germany Carretera Low 214 3 300 64200 1,284.00 Err:502
Enterprise Germany Paseo Low 809 10 125 101125 2,022.50 Err:502
Enterprise Mexico Paseo Low 2145 10 125 268125 5,362.50 Err:502
Enterprise Germany Velo Low 809 120 125 101125 2,022.50 Err:502
Enterprise Mexico Velo Low 2145 120 125 268125 5,362.50 Err:502
total 1330 4025 3869050 Err:502
avg 63.33333333333 191.66666667 184240.4762 Err:502
sales cogs profit
236400 197,000.00 39400
40837.5 40425 39600 1237.5
741906 624500 117406
313317 624500 32567
115552.5 624500 -3727.5
354108 624500 33358
87906 80500 7406
105353.8 113640 -8286.25
265760 289920 -24160
109972.5 122760 -12787.5
43125 41400 1725
43125 41400 1725
146718 123500 23218
82046.25 79560 2486.25
82046.25 79560 2486.25
146718 23218
62916 53500 9416
99102.5 97080 2022.5
262762.5 257400 5362.5
99102.5 97080 2022.5
262762.5 257400 5362.5
3701538 4,469,300.00 261457.75
336503.4 223,465.00 12450.369048
