Scribd
Upload
9 views4 pages

Phase 1 Assignment 3

The document presents sales data for various products across different countries, detailing units sold, discount bands, and sales figures. It includes financial metrics such as gross sales, discounts, and cost of goods sold (COGS) for each product. Additionally, it highlights profits associated with each product and their respective sale prices.

Uploaded by

lawrencebcom7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views4 pages

Phase 1 Assignment 3

The document presents sales data for various products across different countries, detailing units sold, discount bands, and sales figures. It includes financial metrics such as gross sales, discounts, and cost of goods sold (COGS) for each product. Additionally, it highlights profits associated with each product and their respective sale prices.

Uploaded by

lawrencebcom7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Segment Country Product Discount Band Units Sold

Small Business Mexico Paseo None 788


Enterprise United States of America Carretera Low 330
Small Business United States of America Montana Low 2498
Small Business Germany Paseo Medium 1123
Enterprise Germany Amarilla Medium 994
Small Business Canada Montana Medium 1283
Small Business France Montana Medium 322
Enterprise Mexico Amarilla High 947
Enterprise Canada Carretera High 2416
Enterprise France Carretera High 1023
Enterprise Canada Montana None 345
Enterprise Canada Velo None 345
Small Business Mexico Carretera Low 494
Enterprise United States of America Montana Low 663
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
Enterprise Germany Velo Low 809
Enterprise Mexico Velo Low 2145
Manufacturing Price Sale Price Gross Sales Discounts Sales COGS
10 300 236400 0 236400 197000
3 125 41250 412.5 40837.5 40425 39600
5 300 749400 7494 741906 624500
10 300 336900 23583 313317 280750
260 125 124250 8697.5 115552.5 119280
5 300 384900 30792 354108 320750
5 300 96600 8694 87906 80500
260 125 118375 13021.25 105353.75 113640
3 125 302000 36240 265760 289920
3 125 127875 17902.5 109972.5 122760
5 125 43125 0 43125 41400
120 125 43125 0 43125 41400
3 300 148200 1482 146718 123500
5 125 82875 828.75 82046.25 79560
120 125 82875 828.75 82046.25 79560
250 300 148200 1482 146718 123500
3 300 64200 1284 62916 53500
10 125 101125 2022.5 99102.5 97080
10 125 268125 5362.5 262762.5 257400
120 125 101125 2022.5 99102.5 97080
120 125 268125 5362.5 262762.5 257400

Units Sold
3000

2500

2000

1500

1000

500

0
0 5 10 15 20 25
Profit Product Sale Price
39400 Paseo 300
1237.5 Carretera 125
117406 Montana 300
32567 Paseo 300
350 Sale Price
-3727.5 Amarilla 125 300
33358 Montana 300 250
7406 Montana 300
200
-8286.25 Amarilla 125
-24160 Carretera 125 150
-12787.5 Carretera 125 100
1725 Montana 125
50
1725 Velo 125
23218 Carretera 300 0

2486.25 Montana 125


2486.25 Velo 125
23218 VTT 300
9416 Carretera 300
2022.5 Paseo 125
5362.5 Paseo 125
2022.5 Velo 125
5362.5 Velo 125
Sale Price

You might also like