ISM3011 Excel 2 Project

ItemCode
Department
BQ1001
Beauty Care
BQ1002
BQ1003
Beauty Care
Beauty Care
BQ1004
Beauty Care
BR5007
BQ2001
BR5008
BR5009
BR5010
Cleansers
Cleansers
Cleansers
Cleansers
Cleansers
BT5005
Cleansers
BT5006
BU6015
Cleansers
Cleansers
BU6016
Cleansers
TQ2003
Dental Care
TT6002
Dental Care
TU6002
Dental Care
TU6003
TU6004
TU6005
TU6006
Dental Care
Dental Care
Dental Care
Dental Care
TU6007
Dental Care
Item Name
K’s Signature Daily Facial
Towelettes
Nocturnal Make-Up
Remover Facial Towelettes
Cotton Swabs
Premium Hypoallergenic
Cotton Rounds
Docs Deep Moisture Body
Wash
Docs Moisturizing Bar
Docs Sensitive Skin Bar Soap
Shamrock Bar Soap
K’s Signature Body Soap
K’s Signature Natural Citrus
Body Wash
Nocturnal Rain Bath Shower
Gel
Oeys Moisture Body Wash
Hardsoap Advanced Clean
Soap
Ultra Advanced Optic White
Toothbrush
Ultra Total Advanced
Toothpaste
3D White Advanced
Mouthwash
3D White Advanced
Toothpaste
3D White Strips
Pro Mouthwash
Pro-health Advanced Floss
K’s Signature Antiseptic
Mouth Rinse
Cost
Selling
Price
2023
Sold To
Date
2023
Sales
Goal
2022
Sales
Q1
2022
Sales Q2
2022 Sales
Q3
2022
Sales
Q4
$5.60
$11.99
1601
2204
433
527
428
529
$5.20
$5.60
$14.99
$8.99
1776
3681
2517
2776
649
577
503
548
535
698
502
591
$3.25
$12.99
2560
1729
261
668
296
279
$5.40
$9.22
$14.19
$5.30
$3.25
$14.99
$15.99
$15.99
$8.99
$9.99
2299
1695
1803
2948
3789
1551
2229
245
670
407
468
536
227
438
540
468
495
301
428
604
263
217
576
500
687
407
691
$9.99
$20.99
2042
2035
403
460
319
588
$12.97
$11.99
$20.99
$20.99
1515
3074
2029
2433
451
401
554
458
341
586
419
671
$8.99
$31.49
1139
2719
647
443
593
682
$5.20
$14.99
2473
2121
525
633
369
318
$5.40
$12.99
1154
2700
485
665
617
581
$5.40
$9.99
1339
2300
392
481
619
508
$7.08
$19.00
$3.25
$3.25
$14.99
$39.99
$9.49
$12.99
2507
3280
1283
3340
2012
2134
483
623
412
545
398
580
643
624
457
302
291
473
412
578
515
214
$3.25
$7.89
1265
2592
648
523
625
458
2341
2573
1846
2395
2140
TU6008
Dental Care
TU6009
Dental Care
TU6010
Dental Care
TU6011
Dental Care
BU6017
Hair Care
BU6018
BU6019
Hair Care
Hair Care
EU5018
Hair Care
EU5020
Hair Care
EU5024
EU5025
EU5026
EU5027
Hair Care
Hair Care
Hair Care
Hair Care
EU5028
Hair Care
FH5041
Hair Care
FH5042
Hair Care
FH6001
Hair Care
TB4024
TP1011
TP1010
TP1014
TP2004
TP2006
TP2009
Shaving Needs
Shaving Needs
Shaving Needs
Shaving Needs
Shaving Needs
Shaving Needs
Shaving Needs
OB1 3D White Pulsar Battery
Toothbrush
OB1 Pro Cross Action
Toothbrush
Gentle Whitening
Toothpaste
Squid Extra Whitening
Toothpaste
Docs Advance Moisture
Conditioner
Docs Advanced Moisture
Shampoo
H&S Complete Scalp Care
K’s Signature 5% Minoxidil
Foam For Men
K’s Signature Moisture
Conditioner
K’s Signature Moisture
Shampoo
Hummers Conditioner
Therappe Shampoo
Pita Argan Gloss Conditioner
Pita Argan Gloss Shampoo
with Travel Argan Oil
Potato Advanced Care
Conditioner
Potato Advanced Care
Shampoo
Bed Head Shampoo &
Conditioner
Custom Plus 3 Disposable
Razors
Fusion Pro2-in-1 Shave Gel
Fusion ProPower Cartridges
Fusion ProShield Razor
Muddy 3 Signature Razor
Muddy Embrace Snap Razor
Muddy Spa Razor
$5.40
$14.99
1312
2402
684
322
473
610
$10.64
$13.99
3701
1761
354
330
342
506
$11.35
$21.99
3131
2651
498
690
489
629
$10.64
$21.99
1250
1883
534
317
444
343
$8.99
$17.49
2735
1612
386
314
465
237
$8.99
$3.25
$26.59
$11.99
1081
3245
1997
2060
319
496
463
501
369
456
586
339
$18.97
$44.99
1260
1948
433
242
378
641
$7.49
$13.86
2342
2475
576
635
448
494
$9.99
$11.67
$5.20
$11.67
$23.35
$24.99
$16.99
$14.99
3091
1294
3540
3511
2019
1923
591
402
700
264
284
608
293
684
576
539
466
501
305
536
431
224
$12.06
$14.99
1843
2167
613
211
513
548
$3.25
$9.99
1160
2106
593
211
428
600
$9.99
$10.94
3353
1781
363
229
436
521
$3.25
$9.97
1651
2155
588
643
342
301
$9.22
$5.50
$20.00
$24.48
$9.93
$10.94
$13.06
$25.99
$11.49
$44.99
$34.97
$31.99
$32.99
$29.99
2192
1978
1850
1987
1220
1994
3768
1634
248
578
235
638
594
206
226
606
417
317
606
244
324
279
337
262
536
223
609
545
523
230
202
464
677
657
206
583
2397
2173
1677
1784
2465
2419
1473
1852
TQ2001
Shaving Needs
FH6002
HQ4028
HQ4030
HQ4033
HQ5002
RQ5010
Skin care
Skin care
Skin care
Skin care
Skin care
Skin care
RQ5011
Skin care
TB4021
RQ5012
Skin care
Skin care
RQ5017
Skin care
RQ5018
Skin care
TB4010
Skin care
TB4012
TB4015
TB4018
Skin care
Skin care
Skin care
TB4019
Skin care
Muddy Disposable Razor
Hawaiian Sunscreen Spray
SPF 50
Avocado Moisturizing Lotion
Apricot Moisturizing Lotion
Coconut Moisturizing Cream
Coconut Moisturizing Lotion
Coconut Skin Cleanser
Sport Sunscreen SPF 50
Spray & Lotion
Retinol Corrosion
Moisturizer
Hydra Anti-Aging BB Cream
Dermo Moisture Lotion
Daily
Nocturnal Beach Defense
SPF 70 Spray & Lotion
Nocturnal Rapid Wrinkle
Repair Cream
Nocturnal Ultra Sheer Lotion
SPF55 + Lip Balm
Oeys Micro-Sculpting Cream
Oeys Serum
Oeys Total Effects SPF 15
Fragrance Free
$6.74
$24.99
2363
1840
245
401
421
533
$5.60
$15.61
$14.99
$12.06
$18.24
$5.30
$15.99
$17.89
$15.61
$15.99
$18.99
$19.99
2822
2436
3875
2126
3484
2605
1578
2256
268
255
513
433
522
563
386
459
285
631
426
583
244
673
564
499
554
379
475
358
655
274
442
437
$5.10
$16.99
2927
1782
289
441
503
317
$24.08
$10.94
$29.99
$19.99
2894
2619
2222
1948
262
511
550
392
608
565
513
226
$8.51
$13.49
1914
2083
675
498
245
394
$7.09
$14.99
3137
1964
598
362
399
349
$18.00
$36.99
3233
1711
347
411
305
425
$7.09
$19.00
$11.67
$13.99
$39.99
$37.99
1266
2153
3544
2586
2609
544
274
665
604
555
443
438
362
660
663
299
501
$13.99
$29.99
2439
2158
541
633
265
438
2006
2319
2112
2235
1713