Scribd
Upload
65 views10 pages

Sales

The document summarizes sales data for 8 products over 4 years from 2018 to 2022. It provides monthly and total annual sales figures as well as average annual sales for each product. The highest selling products were Product 3, which averaged over $260,000 annually, and Product 5, which averaged around $260,000 annually.

Uploaded by

Ishita
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
65 views10 pages

Sales

The document summarizes sales data for 8 products over 4 years from 2018 to 2022. It provides monthly and total annual sales figures as well as average annual sales for each product. The highest selling products were Product 3, which averaged over $260,000 annually, and Product 5, which averaged around $260,000 annually.

Uploaded by

Ishita
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/ 10

SALES FOR THE YEAR 2018-2019

PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
PRODUCT 1 39 88 52 78 20 38 64 76 20 75 34 20 604 50.33
PRODUCT 2 87 63 34 57 64 39 91 60 20 33 29 88 665 55.42
PRODUCT 3 23 60 93 46 73 99 54 35 82 92 56 93 806 67.17
PRODUCT 4 94 86 63 20 78 43 39 82 53 48 79 59 744 62.00
PRODUCT 5 76 93 62 81 95 88 50 87 51 51 65 36 835 69.58
PRODUCT 6 74 29 28 63 30 84 46 78 73 54 86 98 743 61.92
PRODUCT 7 97 65 40 57 21 80 62 34 92 44 99 73 764 63.67
PRODUCT 8 87 34 41 94 35 28 92 55 72 56 63 51 708 59.00
PRODUCT PRODUCT PRODUCT PRODUCT PRODUCT PRODUCT PRODUCT PRODUCT PRODUCT 8
JAN 39 87 23 94 76 74 97 87
FEB 88 63 60 86 93 29 65 34
SALES FOR THE YEAR 2018-2019

MAR 52 34 93 63 62 28 40 41
APR 78 57 46 20 81 63 57 94
MAY 20 64 73 78 95 30 21 35
JUN 38 39 99 43 88 84 80 28
JUL 64 91 54 39 50 46 62 92
AUG 76 60 35 82 87 78 34 55
SEP 20 20 82 53 51 73 92 72
OCT 75 33 92 48 51 54 44 56
NOV 34 29 56 79 65 86 99 63
DEC 20 88 93 59 36 98 73 51
TOTAL 604 665 806 744 835 743 764 708
AVERAGE 50.33333 55.41667 67.16667 62 69.58333 61.91667 63.66667 59
PRODUCT 8
SALES FOR THE YEAR 2018-2022
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
88 52 78 20 38 64 76 20 75 34 20
63 57 80 94 88 32 44 99 87 93 34 81
88 95 97 45 50 65 44 64 78 62 67 61
48 62 41 56 91 27 40 55 94 67 62 94
PRODUCT 1 199 302 270 273 249 162 192 294 279 297 197 256 2970 247.50
87 63 34 57 64 39 91 60 20 33 29 88
73 60 47 41 32 24 29 69 56 71 56 23
38 96 34 84 85 96 50 94 52 37 38 78
76 62 34 48 69 49 20 72 58 99 52 26
PRODUCT 2 274 281 149 230 250 208 190 295 186 240 175 215 2693 224.42
23 60 93 46 73 99 54 35 82 92 56 93
62 82 77 67 68 55 23 95 85 91 30 83
40 88 75 33 61 68 23 91 97 27 42 76
99 47 80 46 30 46 89 65 58 90 69 91
PRODUCT 3 224 277 325 192 232 268 189 286 322 300 197 343 3155 262.92
94 86 63 20 78 43 39 82 53 48 79 59
36 69 49 82 26 80 95 32 75 55 55 46
53 37 79 96 94 34 72 24 33 45 37 90
24 40 35 70 98 50 43 78 20 84 28 24
PRODUCT 4 207 232 226 268 296 207 249 216 181 232 199 219 2732 227.67
76 93 62 81 95 88 50 87 51 51 65 36
57 28 99 70 87 84 47 82 55 44 53 35
79 55 95 47 91 98 70 72 33 22 30 96
46 74 37 78 78 90 82 71 52 79 70 40
PRODUCT 5 258 250 293 276 351 360 249 312 191 196 218 207 3161 263.42
74 29 28 63 30 84 46 78 73 54 86 98
83 87 60 22 33 28 20 93 93 71 50 70
61 63 35 21 70 31 42 61 52 31 52 74
82 31 94 20 47 66 27 79 89 98 37 76
PRODUCT 6 300 210 217 126 180 209 135 311 307 254 225 318 2792 232.67
97 65 40 57 21 80 62 34 92 44 99 73
90 36 37 30 45 55 85 35 37 61 69 56
70 50 74 57 90 38 79 37 80 70 54 52
30 62 36 27 61 89 25 60 52 32 71 37
PRODUCT 7 287 213 187 171 217 262 251 166 261 207 293 218 2733 227.75
87 34 41 94 35 28 92 55 72 56 63 51
75 63 46 31 95 90 97 72 63 46 87 78
29 22 24 74 36 60 94 79 38 56 35 55
37 88 28 54 24 30 73 47 63 93 38 72
PRODUCT 8 228 207 139 253 190 208 356 253 236 251 223 256 2800 233.33
SALES FOR THE YEAR 2018-2022
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP
PRODUCT 238 302 270 273 249 162 192 294 279
PRODUCT 274 281 149 230 250 208 190 295 186
PRODUCT 224 277 325 192 232 268 189 286 322
PRODUCT 207 232 226 268 296 207 249 216 181
PRODUCT 258 250 293 276 351 360 249 312 191
PRODUCT 300 210 217 126 180 209 135 311 307
PRODUCT 287 213 187 171 217 262 251 166 261
PRODUCT 228 207 139 253 190 208 356 253 236
2
OCT NOV DEC TOTAL AVERAGE
297 197 256 3009 250.75
240 175 215 2693 224.42
300 197 343 3155 262.92
232 199 219 2732 227.67
196 218 207 3161 263.42
254 225 318 2792 232.67
207 293 218 2733 227.75
251 223 256 2800 233.33
SALES FOR THE YEAR 2018-2022
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
PRODUCT 1 238 302 270 273 249 162 192 294 279 297 197 256 3009 250.75
PRODUCT 2 274 281 149 230 250 208 190 295 186 240 175 215 2693 224.42
PRODUCT 3 224 277 325 192 232 268 189 286 322 300 197 343 3155 262.92
PRODUCT 4 207 232 226 268 296 207 249 216 181 232 199 219 2732 227.67
PRODUCT 5 258 250 293 276 351 360 249 312 191 196 218 207 3161 263.42
PRODUCT 6 300 210 217 126 180 209 135 311 307 254 225 318 2792 232.67
PRODUCT 7 287 213 187 171 217 262 251 166 261 207 293 218 2733 227.75
PRODUCT 8 228 207 139 253 190 208 356 253 236 251 223 256 2800 233.33
SALES FOR THE YEAR 2019-2020
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
PRODUCT 1 63 57 80 94 88 32 44 99 87 93 34 81 852 71.00
PRODUCT 2 73 60 47 41 32 24 29 69 56 71 56 23 581 48.42
PRODUCT 3 62 82 77 67 68 55 23 95 85 91 30 83 818 68.17
PRODUCT 4 36 69 49 82 26 80 95 32 75 55 55 46 700 58.33
PRODUCT 5 57 28 99 70 87 84 47 82 55 44 53 35 741 61.75
PRODUCT 6 83 87 60 22 33 28 20 93 93 71 50 70 710 59.17
PRODUCT 7 90 36 37 30 45 55 85 35 37 61 69 56 636 53.00
PRODUCT 8 75 63 46 31 95 90 97 72 63 46 87 78 843 70.25
SALES FOR THE YEAR 2020-2021
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
PRODUCT 1 88 95 97 45 50 65 44 64 78 62 67 61 816 68.00
PRODUCT 2 38 96 34 84 85 96 50 94 52 37 38 78 782 65.17
PRODUCT 3 40 88 75 33 61 68 23 91 97 27 42 76 721 60.08
PRODUCT 4 53 37 79 96 94 34 72 24 33 45 37 90 694 57.83
PRODUCT 5 79 55 95 47 91 98 70 72 33 22 30 96 788 65.67
PRODUCT 6 61 63 35 21 70 31 42 61 52 31 52 74 593 49.42
PRODUCT 7 70 50 74 57 90 38 79 37 80 70 54 52 751 62.58
PRODUCT 8 29 22 24 74 36 60 94 79 38 56 35 55 602 50.17
SALES FOR THE YEAR 2021-2022
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL AVERAGE
PRODUCT 1 48 62 41 56 91 27 40 55 94 67 62 94 737 61.42
PRODUCT 2 76 62 34 48 69 49 20 72 58 99 52 26 665 55.42
PRODUCT 3 99 47 80 46 30 46 89 65 58 90 69 91 810 67.50
PRODUCT 4 24 40 35 70 98 50 43 78 20 84 28 24 594 49.50
PRODUCT 5 46 74 37 78 78 90 82 71 52 79 70 40 797 66.42
PRODUCT 6 82 31 94 20 47 66 27 79 89 98 37 76 746 62.17
PRODUCT 7 30 62 36 27 61 89 25 60 52 32 71 37 582 48.50
PRODUCT 8 37 88 28 54 24 30 73 47 63 93 38 72 647 53.92

You might also like