Scribd
Upload
11 views15 pages

Monthly Sales and Profit Summary

The document contains a sales report detailing the sum of sale prices attributed to various individuals, totaling $19,270.00. It includes a breakdown of transactions by month, product codes, and product descriptions for items sold throughout the year. Additionally, it provides information on store costs, sale prices, profits, and commissions for individual transactions.

Uploaded by

black bills
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
11 views15 pages

Monthly Sales and Profit Summary

The document contains a sales report detailing the sum of sale prices attributed to various individuals, totaling $19,270.00. It includes a breakdown of transactions by month, product codes, and product descriptions for items sold throughout the year. Additionally, it provides information on store costs, sale prices, profits, and commissions for individual transactions.

Uploaded by

black bills
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

Last name Sum of Sale Price

Black $ 3,300.00
Brown $ 13,000.00
Clark $ 220.00 Total
Davis $ 2,750.00
Total Result $ 19,270.00
Total

Black
Brown
Clark
Davis
Total Result
Month Transaction Product code Product
Description
January 1,015 151 Drone
January 1,030 301 Drone
January 1,045 451 Drone
January 1,060 601 Drone
January 1,075 751 Drone
January 1,090 901 Drone
January 1,105 1051 Drone
January 1,120 1201 Drone
January 1,135 1351 Drone
January 1,150 1501 Drone
January 1,165 1651 Drone
January 1,009 91 Camera
January 1,024 241 Camera
January 1,039 391 Camera
January 1,054 541 Camera
January 1,069 691 Camera
February 1,084 841 Camera
February 1,099 991 Camera
February 1,114 1141 Camera
February 1,129 1291 Camera
February 1,144 1441 Camera
February 1,159 1591 Camera
February 1,001 11 Laptop
February 1,016 161 Laptop
February 1,031 311 Laptop
February 1,046 461 Laptop
February 1,061 611 Laptop
February 1,076 761 Laptop
February 1,091 911 Laptop
February 1,106 1061 Laptop
February 1,121 1211 Laptop
February 1,136 1361 Laptop
March 1,151 1511 Laptop
March 1,166 1661 Laptop
March 1,014 141 Gaming Console
March 1,029 291 Gaming Console
March 1,044 441 Gaming Console
March 1,059 591 Gaming Console
March 1,074 741 Gaming Console
March 1,089 891 Gaming Console
March 1,104 1041 Gaming Console
March 1,119 1191 Gaming Console
March 1,134 1341 Gaming Console
March 1,149 1491 Gaming Console
March 1,164 1641 Gaming Console
March 1,002 21 Smartphone
March 1,017 171 Smartphone
March 1,032 321 Smartphone
March 1,047 471 Smartphone
April 1,062 621 Smartphone
April 1,077 771 Smartphone
April 1,092 921 Smartphone
April 1,107 1071 Smartphone
April 1,122 1221 Smartphone
April 1,137 1371 Smartphone
April 1,152 1521 Smartphone
April 1,167 1671 Smartphone
April 1,003 31 Tablet
April 1,018 181 Tablet
April 1,033 331 Tablet
April 1,048 481 Tablet
April 1,063 631 Tablet
April 1,078 781 Tablet
April 1,093 931 Tablet
April 1,108 1081 Tablet
April 1,123 1231 Tablet
May 1,138 1381 Tablet
May 1,153 1531 Tablet
May 1,168 1681 Tablet
May 1,008 81 Printer
May 1,023 231 Printer
May 1,038 381 Printer
May 1,053 531 Printer
May 1,068 681 Printer
May 1,083 831 Printer
May 1,098 981 Printer
May 1,113 1131 Printer
May 1,128 1281 Printer
May 1,143 1431 Printer
May 1,158 1581 Printer
May 1,010 101 Smartwatch
May 1,025 251 Smartwatch
June 1,040 401 Smartwatch
June 1,055 551 Smartwatch
June 1,070 701 Smartwatch
June 1,085 851 Smartwatch
June 1,100 1001 Smartwatch
June 1,115 1151 Smartwatch
June 1,130 1301 Smartwatch
June 1,145 1451 Smartwatch
June 1,160 1601 Smartwatch
June 1,004 41 Monitor
June 1,019 191 Monitor
June 1,034 341 Monitor
June 1,049 491 Monitor
June 1,064 641 Monitor
June 1,079 791 Monitor
June 1,094 941 Monitor
July 1,109 1091 Monitor
July 1,124 1241 Monitor
July 1,139 1391 Monitor
July 1,154 1541 Monitor
July 1,169 1691 Monitor
July 1,012 121 Power Bank
July 1,027 271 Power Bank
July 1,042 421 Power Bank
July 1,057 571 Power Bank
July 1,072 721 Power Bank
July 1,087 871 Power Bank
July 1,102 1021 Power Bank
July 1,117 1171 Power Bank
July 1,132 1321 Power Bank
July 1,147 1471 Power Bank
July 1,162 1621 Power Bank
August 1,007 71 Headphones
August 1,022 221 Headphones
August 1,037 371 Headphones
August 1,052 521 Headphones
August 1,067 671 Headphones
August 1,082 821 Headphones
August 1,097 971 Headphones
August 1,112 1121 Headphones
August 1,127 1271 Headphones
August 1,142 1421 Headphones
August 1,157 1571 Headphones
August 1,172 1721 Headphones
August 1,005 51 Keyboard
August 1,020 201 Keyboard
August 1,035 351 Keyboard
August 1,050 501 Keyboard

September
1,065 651 Keyboard

September
1,080 801 Keyboard

September
1,095 951 Keyboard

September
1,110 1101 Keyboard

September
1,125 1251 Keyboard

September
1,140 1401 Keyboard
September
1,155 1551 Keyboard

September
1,170 1701 Keyboard

September
1,131 1311 Charger

September
1,011 111 Charger

September
1,026 261 Charger

September
1,041 411 Charger

September
1,056 561 Charger

September
1,071 711 Charger

September
1,086 861 Charger

September
1,101 1011 Charger
October 1,116 1161 Charger
October 1,146 1461 Charger
October 1,161 1611 Charger
October 1,006 61 Mouse
October 1,021 211 Mouse
October 1,036 361 Mouse
October 1,051 511 Mouse
October 1,066 661 Mouse
October 1,081 811 Mouse
October 1,096 961 Mouse
October 1,111 1111 Mouse
October 1,126 1261 Mouse
October 1,141 1411 Mouse
October 1,156 1561 Mouse
October 1,171 1711 Mouse
October 1,013 131 USB Cable
November 1,028 281 USB Cable
November 1,043 431 USB Cable
November 1,058 581 USB Cable
November 1,073 731 USB Cable
November 1,088 881 USB Cable
November 1,103 1031 USB Cable
November 1,118 1181 USB Cable
November 1,133 1331 USB Cable
November 1,148 1481 USB Cable
November 1,163 1631 USB Cable
Store Cost Sale Price Profit Commission (10%)

$ 700.00 $ 1,000.00 $ 300.00 $ 60.00


$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 700.00 $ 1,000.00 $ 300.00 $ 60.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 600.00 $ 800.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 500.00 $ 700.00 $ 200.00 $ 40.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 400.00 $ 550.00 $ 150.00 $ 30.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 300.00 $ 450.00 $ 150.00 $ 15.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 250.00 $ 350.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 200.00 $ 300.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 150.00 $ 250.00 $ 100.00 $ 10.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 100.00 $ 150.00 $ 50.00 $ 5.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 50.00 $ 80.00 $ 30.00 $ 3.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 40.00 $ 60.00 $ 20.00 $ 2.00
$ 30.00 $ 50.00 $ 20.00 $ 2.00
$ 30.00 $ 50.00 $ 20.00 $ 2.00
$ 30.00 $ 50.00 $ 20.00 $ 2.00
$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00


$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 30.00 $ 50.00 $ 20.00 $ 2.00

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50

$ 25.00 $ 40.00 $ 15.00 $ 1.50


$ 25.00 $ 40.00 $ 15.00 $ 1.50
$ 25.00 $ 40.00 $ 15.00 $ 1.50
$ 25.00 $ 40.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 20.00 $ 35.00 $ 15.00 $ 1.50
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00
$ 10.00 $ 20.00 $ 10.00 $ 1.00

total $ 54,980.00
higher than 50 $ 53,300.00
lower than 50 $ 1,680.00
First name Last name Sale Location

Mia Thompson Portland


Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Mia Thompson Portland
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
Lily Brown Dallas
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
John Doe New York
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
James Lewis Las Vegas
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Jane Smith Los Angeles
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Mike Brown Chicago
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Oliver Black San Francisco
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Noah Davis Atlanta
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
Anna Taylor Houston
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
William Moore Phoenix
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Emily White Seattle
Sarah Wilson Miami
Sarah Wilson Miami
Sarah Wilson Miami
Sarah Wilson Miami

Sarah Wilson Miami

Sarah Wilson Miami

Sarah Wilson Miami

Sarah Wilson Miami

Sarah Wilson Miami

Sarah Wilson Miami


Sarah Wilson Miami

Sarah Wilson Miami

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando

Ava Harris Orlando


Ava Harris Orlando
Ava Harris Orlando
Ava Harris Orlando
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Paul Green Boston
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver
Sophia Clark Denver

You might also like