0% found this document useful (0 votes)
8 views7 pages

Conditional Formatting

The document contains a detailed sales report including customer orders, product discounts, and financial summaries for various luxury bags sold. It lists customer details, order totals, discounts applied, and the average order value (AOV). Additionally, it provides insights into sales revenue, costs, profits, and profit margins for the products sold.

Uploaded by

faizajellybean
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)
8 views7 pages

Conditional Formatting

The document contains a detailed sales report including customer orders, product discounts, and financial summaries for various luxury bags sold. It lists customer details, order totals, discounts applied, and the average order value (AOV). Additionally, it provides insights into sales revenue, costs, profits, and profit margins for the products sold.

Uploaded by

faizajellybean
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

Customer Email Address City Country Order Date

Giada Graziano [email protected] Milan IT 1/1/2022


Laura Weir [email protected] New York US 1/2/2022
Rachel Besser [email protected] Berlin DE 1/3/2022
Brooke Bobb [email protected] Barcelona SP 1/4/2022
Dominique [email protected] London UK 1/5/2022
Natasha Pearlma [email protected] Lisbon PT 1/6/2022
Christian Allaire [email protected] Toronto CA 1/7/2022
Alexandra [email protected] New York US 1/8/2022
Paulina Jayne Isa [email protected] Berlin DE 1/9/2022
ROSE [email protected] Barcelona SP 1/10/2022
Alyssa Hardy [email protected] London UK 1/11/2022
Sarah Lindig [email protected] Barcelona SP 1/12/2022
Alyssa Bailey [email protected] London UK 1/13/2022
ULIA [email protected] Berlin DE 1/14/2022
Katharine K. [email protected] Barcelona SP 1/15/2022
Asia Milia [email protected] London UK 1/16/2022
Rachel Besser [email protected] Berlin US 1/15/2022
Product SKU Discount Order Total
14521411 25% 2,630.0 €
13874522 10% 3,560.0 €
124587845 24% 1,700.0 €
365841 50% 920.0 €
12014 30% 250.0 €
2568 0% 2,142.0 €
1254441 70% 540.0 €
656898 85% 1,983.0 €
56894521 15% 756.0 €
564645 10% 4,690.0 €
4164545 13% 1,100.0 €
4545210 25% 890.0 €
45451123 36% 3,855.0 €
64512165 48% 1,481.0 €
4612 36% 740.0 €
54514525 87% 2,560.0 €
124587845 24% 300.0 €
Customer Email Address Order Date P1 P2 P3 P4
Giada Graziano [email protected] 1/1/2022 1,500.00 € 300.00 € 780.00 € 50.00 €
Laura Weir [email protected] 1/2/2022 3,200.00 € 360.00 €
Rachel Besser [email protected] 1/3/2022 1,700.00 €
Brooke Bobb [email protected] 1/4/2022 560.00 € 360.00 €
Dominique [email protected] 1/5/2022 250.00 €
Natasha Pearlma [email protected] 1/6/2022 989.00 € 258.00 € 895.00 €
Christian Allaire [email protected] 1/7/2022 540.00 €
Alexandra [email protected] 1/8/2022 369.00 € 250.00 € 587.00 € 777.00 €
Paulina Jayne Isa [email protected] 1/9/2022 756.00 €
ROSE [email protected] 1/10/2022 2,143.00 € 2,547.00 €
Alyssa Hardy [email protected] 1/11/2022 740.00 € 360.00 €
Sarah Lindig [email protected] 1/12/2022 890.00 €
Alyssa Bailey [email protected] 1/13/2022 896.00 € 695.00 € 1,700.00 € 564.00 €
ULIA [email protected] 1/14/2022 475.00 € 256.00 € 750.00 €
Katharine K. [email protected] 1/15/2022 740.00 €
Asia Milia [email protected] 1/16/2022 2,560.00 €
Order Total Discount Order Total After Discount # of items per order AOV
2,630.0 € 25% 1,972.5 € 4 657.5 €
3,560.0 € 10% 3,204.0 € 2 1,780.0 €
1,700.0 € 24% 1,292.0 € 1 1,700.0 €
920.0 € 50% 460.0 € 2 460.0 €
250.0 € 30% 175.0 € 1 250.0 €
2,142.0 € 0% 2,142.0 € 3 714.0 €
540.0 € 70% 162.0 € 1 540.0 €
1,983.0 € 85% 297.5 € 4 495.8 €
756.0 € 15% 642.6 € 1 756.0 €
4,690.0 € 10% 4,221.0 € 2 2,345.0 €
1,100.0 € 13% 957.0 € 2 550.0 €
890.0 € 25% 667.5 € 1 890.0 €
3,855.0 € 36% 2,467.2 € 4 963.8 €
1,481.0 € 48% 770.1 € 3 493.7 €
740.0 € 36% 473.6 € 1 740.0 €
2,560.0 € 87% 332.8 € 1 2,560.0 €
Luxury Hit Bags Qty Sold Price
Bag1 100 2,700.00 €
Bag2 200 2,300.00 €
Bag3 250 900.00 €
Bag4 150 1,200.00 €
Bag5 235 2,700.00 €
Bag6 300 2,300.00 €
Bag7 154 900.00 €
Bag8 321 1,200.00 €
Bag9 89 2,700.00 €
Bag10 698 2,300.00 €
Bag11 451 900.00 €
Bag12 1545 1,200.00 €
Bag13 254 2,700.00 €
Bag14 478 2,300.00 €
Bag15 512 900.00 €
Bag16 120 1,200.00 €
Sales/ Revenue Costs Profit Margin
270,000.00 € 120,000.00 € 150,000.00 € 56%
460,000.00 € 180,000.00 € 280,000.00 € 61%
225,000.00 € 175,000.00 € 50,000.00 € 22%
180,000.00 € 45,000.00 € 135,000.00 € 75%
634,500.00 € 282,000.00 € 352,500.00 € 56%
690,000.00 € 270,000.00 € 420,000.00 € 61%
138,600.00 € 100,716.00 € 37,884.00 € 27%
385,200.00 € 272,850.00 € 112,350.00 € 29%
240,300.00 € 106,800.00 € 133,500.00 € 56%
1,605,400.00 € 628,200.00 € 977,200.00 € 61%
405,900.00 € 400,488.00 € 5,412.00 € 1%
1,854,000.00 € 772,500.00 € 1,081,500.00 € 58%
685,800.00 € 420,116.00 € 265,684.00 € 39%
1,099,400.00 € 334,600.00 € 764,800.00 € 70%
460,800.00 € 102,400.00 € 358,400.00 € 78%
144,000.00 € 83,760.00 € 60,240.00 € 42%
>50%
<20%

You might also like