KEMBAR78
Advanced Excel 4 | PDF | Business Economics | Financial Economics
Scribd
Upload
16 views2 pages

Advanced Excel 4

The document provides sales data for various products across different countries, detailing segments, discounts, units sold, manufacturing sale prices, gross sales, discounts, and profits. It highlights the performance of both small businesses and enterprises in Mexico, the United States, Germany, Canada, and France. Key metrics include gross sales, discounts applied, and resulting profits or losses for each product sold.

Uploaded by

kshdnbsfhs
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
16 views2 pages

Advanced Excel 4

The document provides sales data for various products across different countries, detailing segments, discounts, units sold, manufacturing sale prices, gross sales, discounts, and profits. It highlights the performance of both small businesses and enterprises in Mexico, the United States, Germany, Canada, and France. Key metrics include gross sales, discounts applied, and resulting profits or losses for each product sold.

Uploaded by

kshdnbsfhs
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/ 2

Segment Country Product Discount BUnits Sold ManufacturSale Price Gross SalesDiscounts Sales

Small Busi Mexico Paseo None 788 10 300 236400 0 236400


Enterprise United Sta Carretera Low 330 3 125 41250 412.5 40837.5
Small Busi United Sta Montana Low 2498 5 300 749400 7494 741906
Small Busi Germany Paseo Medium 1123 10 300 336900 23583 313317
Enterprise Germany Amarilla Medium 994 260 125 124250 8697.5 115552.5
Small Busi Canada Montana Medium 1283 5 300 384900 30792 354108
Small Busi France Montana Medium 322 5 300 96600 8694 87906
Enterprise Mexico Amarilla High 947 260 125 118375 13021.25 105353.8
Enterprise Canada Carretera High 2416 3 125 302000 36240 265760
Enterprise France Carretera High 1023 3 125 127875 17902.5 109972.5
Enterprise Canada Montana None 345 5 125 43125 0 43125
Enterprise Canada Velo None 345 120 125 43125 0 43125
Small Busi Mexico Carretera Low 494 3 300 148200 1482 146718
Enterprise United Sta Montana Low 663 5 125 82875 828.75 82046.25
Enterprise United Sta Velo Low 663 120 125 82875 828.75 82046.25
Small Busi Mexico VTT Low 494 250 300 148200 1482 146718
Small Busi Germany Carretera Low 214 3 300 64200 1284 62916
Enterprise Germany Paseo Low 809 10 125 101125 2022.5 99102.5
Enterprise Mexico Paseo Low 2145 10 125 268125 5362.5 262762.5
Enterprise Germany Velo Low 809 120 125 101125 2022.5 99102.5
Enterprise Mexico Velo Low 2145 120 125 268125 5362.5 262762.5

Mexico 788
COGS Profit
197000 39400
40425 39600 1237.5
624500 117406
280750 32567
119280 -3727.5
320750 33358
80500 7406
113640 -8286.25
289920 -24160
122760 -12787.5
41400 1725
41400 1725
123500 23218
79560 2486.25
79560 2486.25
123500 23218
53500 9416
97080 2022.5
257400 5362.5
97080 2022.5
257400 5362.5

You might also like