0% found this document useful (0 votes)
3 views4 pages

Sales Data for Footwear Suppliers

The document contains order information for various bicycle products across different segments and countries from 2013 to 2014. It includes product lists with details such as product codes and years, as well as sales data including gross sales, cost of goods sold, and profit. Additionally, it highlights discounts applied to certain products and their corresponding sales figures.

Uploaded by

Nam Nguyễn
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)
3 views4 pages

Sales Data for Footwear Suppliers

The document contains order information for various bicycle products across different segments and countries from 2013 to 2014. It includes product lists with details such as product codes and years, as well as sales data including gross sales, cost of goods sold, and profit. Additionally, it highlights discounts applied to certain products and their corresponding sales figures.

Uploaded by

Nam Nguyễn
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

more info

Order Information
Segment Country Product Month Name Year
Government Canada Carretera January 2014
Government Germany Carretera January 2014
Midmarket France Carretera June 2014
Midmarket Germany Carretera June 2014
Midmarket Mexico Carretera June 2014
Government Germany Carretera December 2014
Midmarket Germany Montana March 2014
Channel Partners Canada Montana June 2014
Government France Montana June 2014
Channel Partners Germany Montana June 2014
Midmarket Mexico Montana June 2014
Enterprise Canada Montana July 2014
Small Business Mexico Montana August 2014
Government Germany Montana September 2014
Enterprise Canada Montana October 2013
Midmarket USA Montana December 2014
Government Canada Paseo February 2014
Midmarket Mexico Paseo February 2014
Channel Partners Canada Paseo June 2014
Government Germany Paseo June 2014
theYOUNG Bicycle
Product List
Segment Country Product Product Code Year
Government Canada Carretera Ca 2021
Midmarket Germany Montana Mo 2018
Government Canada Paseo Pa 2020
Government Mexico Velo Ve 2019
Small Business Canada VTT VT 2020
Government France Amarilla Am 2022
theYOUNG Bi
Product Discount Band Units Sold Manufacturing Pr Sale Price Gross Sales
Carretera None $ 1,618.50 $ 3.00 $ 20.00 $ 32,370.00
Montana None $ 921.00 $ 5.00 $ 15.00 $ 13,815.00
Montana None $ 2,146.00 $ 5.00 $ 7.00 $ 15,022.00
Paseo None $ 292.00 $ 10.00 $ 20.00 $ 5,840.00
Paseo None $ 2,152.00 $ 10.00 $ 15.00 $ 32,280.00
Paseo None $ 1,513.00 $ 10.00 $ 350.00 $ 529,550.00
Velo None $ 1,493.00 $ 120.00 $ 7.00 $ 10,451.00
Velo None $ 1,804.00 $ 120.00 $ 125.00 $ 225,500.00
VTT None $ 888.00 $ 250.00 $ 15.00 $ 13,320.00
Amarilla None $ 2,750.00 $ 260.00 $ 350.00 $ 962,500.00
Amarilla None $ 1,953.00 $ 260.00 $ 12.00 $ 23,436.00
Paseo Low $ 2,296.00 $ 10.00 $ 15.00 $ 34,440.00
Paseo Low $ 1,030.00 $ 10.00 $ 7.00 $ 7,210.00
Velo Low $ 639.00 $ 120.00 $ 7.00 $ 4,473.00
VTT Low $ 1,326.00 $ 250.00 $ 7.00 $ 9,282.00
Carretera Low $ 1,858.00 $ 3.00 $ 12.00 $ 22,296.00
NG Bicycle
Discounts Sales COGS Profit Date
$ - $ 32,370.00 $ 16,185.00 $ 16,185.00 1/1/2014
$ - $ 13,815.00 $ 9,210.00 $ 4,605.00 3/1/2014
$ - $ 15,022.00 $ 10,730.00 $ 4,292.00 9/1/2014
$ - $ 5,840.00 $ 2,920.00 $ 2,920.00 2/1/2014
$ - $ 32,280.00 $ 21,520.00 $ 10,760.00 12/1/2013
$ - $ 529,550.00 $ 393,380.00 $ 136,170.00 12/1/2014
$ - $ 10,451.00 $ 7,465.00 $ 2,986.00 1/1/2014
$ - $ 225,500.00 $ 216,480.00 $ 9,020.00 2/1/2014
$ - $ 13,320.00 $ 8,880.00 $ 4,440.00 6/1/2014
$ - $ 962,500.00 $ 715,000.00 $ 247,500.00 2/1/2014
$ - $ 23,436.00 $ 5,859.00 $ 17,577.00 4/1/2014
$ 344.40 $ 34,095.60 $ 22,960.00 $ 11,135.60 2/1/2014
$ 72.10 $ 7,137.90 $ 5,150.00 $ 1,987.90 5/1/2014
$ 44.73 $ 4,428.27 $ 3,195.00 $ 1,233.27 11/1/2014
$ 92.82 $ 9,189.18 $ 6,630.00 $ 2,559.18 3/1/2014
$ 222.96 $ 22,073.04 $ 5,574.00 $ 16,499.04 2/1/2014

You might also like