0% found this document useful (0 votes)
49 views3 pages

NM Assignment Excel 3

Uploaded by

naga143433
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)
49 views3 pages

NM Assignment Excel 3

Uploaded by

naga143433
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

segment Country Product Discount Band Units Sold Manufacturing pSale price

Small Business Mexico Paseo None 788 10 300


Enterprise United StatesCarretera Low 330 3 125
Small Business United StatesMontana Low 2498 5 300
Small Business Germany Paseo Medium 1123 10 300
Enterprise Germany Amarilla Medium 994 260 125
Small Business Canada Montana Medium 1283 5 300
Small Business France Montana Medium 322 5 300
Enterprise Mexico Amarilla High 947 260 125
Enterprise Canada Carretera High 2416 3 125
Enterprise France Carretera High 1023 3 125
Enterprise Canada Montana None 345 5 125
Enterprise Canada Velo None 345 120 125
Small Business Mexico Carretera Low 494 3 300
Enterprise United StatesMontana Low 663 5 125
Enterprise United StatesVelo Low 663 120 125
Small Business Mexico VTT Low 494 250 300
Small Business Germany Carretera Low 214 3 300
Enterprise Germany Paseo Low 809 10 125
Enterprise Mexico Paseo Low 2145 10 125
Enterprise Germany Velo Low 809 120 125
Enterprise Mexico Velo Low 2145 120 125
Gross sales discount sales cogs profit Product Sale price
236,400.00 236400 197000 39400 Paseo 300
41,250 412.5 40837.5 39600 1237.5 Carretera 125
749,400 7,494.00 741906 624500 117406 Montana 300
336,900 23,583.00 313317 280750 32567 Paseo 300
124,250 8,697.50 115552.5 119280 -3727.5 Amarilla 125
384,900 30,792.00 354108 320750 33358 Montana 300
96,600 8,694.00 87906 80500 7406 Montana 300
118,375 13,021.25 105353.8 113640 -8286.25 Amarilla 125
302,000 36,240.00 265760 289920 -24160 Carretera 125
127,875 17,902.50 109972.5 122760 -12787.5 Carretera 125
43,125 - 43125 41400 1725 Montana 125
43,125 - 43125 41400 1725 Velo 125
148,200 1,482.00 146718 123500 23218 Carretera 300
82,875 828.75 82046.25 79560 2486.25 Montana 125
82,875 828.75 82046.25 79560 2486.25 Velo 125
148,200 1,482.00 146718 123500 23218 VTT 300
64,200 1,284.00 62916 53500 9416 Carretera 300
101,125 2,022.50 99102.5 97080 2022.5 Paseo 125
268,125 5,362.50 262762.5 257400 5362.5 Paseo 125
101,125 2,022.50 99102.5 97080 2022.5 Velo 125
268,125 5,362.50 262762.5 257400 5362.5 Velo 125
Sale price
350
300
250
200
150
100
50
0
eo na rilla ana tera ana tera lo ra seo lo
Pa
s ta a nt re t Ve te
Pa Ve
on
Am Mo Car on arre rre
M M C Ca

350 300 300 Sale price


300 300
300 300 300300
300
250
Axis Title

200
125 125 125 125
125
125
125 125
125 125125
125
125
150
100
50
0
0 5 10 15 20 25
Axis Title

You might also like