kosmetik pesanan.xlsx

22
1= Aksesoris 2=Barang khusus salon 3=obat 4a =umum (berhubungan dengan rambut) 4b =umum (berhubungan dengan badan) 4c=umum (berhubungan dengan muka ) 4d =umum (diluar kategory diatas) Nama Satuan Harga Pokok Harga Jual 1 SET AKSESORIS pcs 60,000 60,000 1 SET AKSESORIS PENGANTEN pcs 300,000 375,000 99 DAY pcs 5,000 10,000 ABALON HAIR DRAYER pcs 160,000 200,000 ACL ANGGUR CREAMBATH pcs 19,000 24,000 ACL AVOCADO CREAMBATH pcs 19,000 24,000 ACL COKLAT CREAMBATH pcs 19,000 24,000 \ pcs 19,000 24,000 ACL KEMIRI CREAMBATH pcs 19,000 24,000 ACL LIDAH BUAYA pcs 19,000 24,000 ACL MESSAGE CREAM 1 KG pcs 25,000 27,500 ACL RUMPUT LAUT CREAMBATH 1 KG pcs 19,000 24,000 ACL STRAWBERRY CREAMBATH pcs 19,000 24,000 ACL TREATMENT 1 KG pcs 15,000 20,000 ANTING PENGANTEN pcs 20,000 30,000 ASETON KECIL pcs 3,000 4,000 ASETON SEDANG pcs 8,000 10,000 AVION LIP GLOSS pcs 9,000 10,000 BANDO BESAR pcs 1,500 2,000 BANDO KECIL pcs 500 1,000 BANDO SEDANG pcs 1,000 1,500 BARBARA WOLDEN HAIR DYE LOTION pcs 4,950 7,000 BAYLU CATOK BESAR pcs 285,000 375,000 BAYLU CATOK KECIL pcs 270,000 350,000 BEAUTS HAIR COLOR BLACK pcs 18,000 20,000 BEAUTY TREATS BLUSH ON pcs 8,000 15,000 BETADINE 15ML pcs 7,500 8,500 BETADINE 30ML pcs 12,500 14,000 BETADINE 5ML pcs 2,500 3,000 BIOKOS DAY CREAM pcs 77,000 90,000 BIOKOS OVERNIGHT CREAM pcs 77,000 90,000 BIOVIC HAIR MASK pcs 40,000 45,000 BOTOL OBAT pcs 3,500 4,000 BQ4 HAIR SPRAY 550 ML pcs 50,000 55,000 BRUSH KUAS BLUSH ON pcs 15,000 18,000 BSY NONI BLACK HAIR MAGIC pcs 12,500 16,000 BULU MATA 1 pcs 2,500 3,000 BULU MATA 2 pcs 3,500 4,000 BULU MATA MURAH pcs 1,450 2,000 BUNGA pcs 17,000 20,000 BURUNG KAKAK TUA SAKIT GIGI pcs 8,000 10,000 CAMELEON MASCARA pcs 10,000 14,000 CANDY JARUM KOMEDO pcs 3,500 5,000 CANDY SPONS pcs 3,500 5,000 CANDY SPONS BULAT pcs 3,500 5,000 CANDY SPONS KOTAK pcs 3,500 5,000 CANDY SPONS MURAH pcs 2,000 2,500 CARING DUAL ACTION CAKE PINK SHELL pcs 26,000 28,500 CARING DUAL ACTION CAKE SEA GOLD pcs 26,000 28,500 CARING EYESHEDOW pcs 45,600 50,000 CARING REFF DUAL ACTION CAKE PURE WHITE 04 pcs 15,000 17,500 CARING REFF DUAL ACTION CAKE WHITE BEIGE 01 pcs 15,000 17,500 CASANDRA HAIR DYE pcs 2,500 3,000 CASANDRA TWC pcs 7,000 10,000 CHRISTY KUAS BLUSH ON pcs 12,500 15,000 CILUNG pcs 2,500 3,500 CINCIN pcs 4,000 7,500 CINCIN PENGANTEN pcs 25,000 30,000 CITRA BODY SCRUB 200 ML pcs 11,100 12,000 CITRA FRESH RADIANCE 120 ML pcs 9,200 10,000 CITRA H.B FRESH RADIANCE 60 ML pcs 4,300 5,000 CITRA H.B LASTING GLOW 60 ML pcs 4,300 5,000 CITRA H.B YOUTFUL RADIANCE 60 ML pcs 4,800 5,500

Upload: daniel-setiadi-lokasurya

Post on 27-Oct-2015

517 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: kosmetik pesanan.xlsx

1= Aksesoris2=Barang khusus salon3=obat4a =umum (berhubungan dengan rambut)4b =umum (berhubungan dengan badan)4c=umum (berhubungan dengan muka )4d =umum (diluar kategory diatas)Nama Satuan Harga Pokok Harga Jual Stok

1 SET AKSESORIS pcs 60,000 60,000 1.00

1 SET AKSESORIS PENGANTEN pcs 300,000 375,000 1.00

99 DAY pcs 5,000 10,000 9.00

ABALON HAIR DRAYER pcs 160,000 200,000 2.00

ACL ANGGUR CREAMBATH pcs 19,000 24,000 1.00

ACL AVOCADO CREAMBATH pcs 19,000 24,000 5.00

ACL COKLAT CREAMBATH pcs 19,000 24,000 3.00

\ pcs 19,000 24,000 1.00

ACL KEMIRI CREAMBATH pcs 19,000 24,000 1.00

ACL LIDAH BUAYA pcs 19,000 24,000 1.00

ACL MESSAGE CREAM 1 KG pcs 25,000 27,500 1.00

ACL RUMPUT LAUT CREAMBATH 1 KG pcs 19,000 24,000 3.00

ACL STRAWBERRY CREAMBATH pcs 19,000 24,000 4.00

ACL TREATMENT 1 KG pcs 15,000 20,000 6.00

ANTING PENGANTEN pcs 20,000 30,000 2.00

ASETON KECIL pcs 3,000 4,000 9.00

ASETON SEDANG pcs 8,000 10,000 9.00

AVION LIP GLOSS pcs 9,000 10,000 7.00

BANDO BESAR pcs 1,500 2,000 11.00

BANDO KECIL pcs 500 1,000 5.00

BANDO SEDANG pcs 1,000 1,500 8.00

BARBARA WOLDEN HAIR DYE LOTION pcs 4,950 7,000 17.00

BAYLU CATOK BESAR pcs 285,000 375,000 1.00

BAYLU CATOK KECIL pcs 270,000 350,000 1.00

BEAUTS HAIR COLOR BLACK pcs 18,000 20,000 3.00

BEAUTY TREATS BLUSH ON pcs 8,000 15,000 2.00

BETADINE 15ML pcs 7,500 8,500 10.00

BETADINE 30ML pcs 12,500 14,000 6.00

BETADINE 5ML pcs 2,500 3,000 4.00

BIOKOS DAY CREAM pcs 77,000 90,000 3.00

BIOKOS OVERNIGHT CREAM pcs 77,000 90,000 3.00

BIOVIC HAIR MASK pcs 40,000 45,000 3.00

BOTOL OBAT pcs 3,500 4,000 5.00

BQ4 HAIR SPRAY 550 ML pcs 50,000 55,000 6.00

BRUSH KUAS BLUSH ON pcs 15,000 18,000 2.00

BSY NONI BLACK HAIR MAGIC pcs 12,500 16,000 14.00

BULU MATA 1 pcs 2,500 3,000 155.00

BULU MATA 2 pcs 3,500 4,000 114.00

BULU MATA MURAH pcs 1,450 2,000 1,034.00

BUNGA pcs 17,000 20,000 3.00

BURUNG KAKAK TUA SAKIT GIGI pcs 8,000 10,000 3.00

CAMELEON MASCARA pcs 10,000 14,000 2.00

CANDY JARUM KOMEDO pcs 3,500 5,000 2.00

CANDY SPONS pcs 3,500 5,000 4.00

CANDY SPONS BULAT pcs 3,500 5,000 1.00

CANDY SPONS KOTAK pcs 3,500 5,000 2.00

CANDY SPONS MURAH pcs 2,000 2,500 5.00

CARING DUAL ACTION CAKE PINK SHELL pcs 26,000 28,500 12.00

CARING DUAL ACTION CAKE SEA GOLD pcs 26,000 28,500 2.00

CARING EYESHEDOW pcs 45,600 50,000 1.00

CARING REFF DUAL ACTION CAKE PURE WHITE 04 pcs 15,000 17,500 2.00

CARING REFF DUAL ACTION CAKE WHITE BEIGE 01 pcs 15,000 17,500 4.00

CASANDRA HAIR DYE pcs 2,500 3,000 10.00

CASANDRA TWC pcs 7,000 10,000 2.00

CHRISTY KUAS BLUSH ON pcs 12,500 15,000 2.00

CILUNG pcs 2,500 3,500 3.00

CINCIN pcs 4,000 7,500 23.00

CINCIN PENGANTEN pcs 25,000 30,000 1.00

CITRA BODY SCRUB 200 ML pcs 11,100 12,000 1.00

CITRA FRESH RADIANCE 120 ML pcs 9,200 10,000 2.00

CITRA H.B FRESH RADIANCE 60 ML pcs 4,300 5,000 4.00

CITRA H.B LASTING GLOW 60 ML pcs 4,300 5,000 1.00

CITRA H.B YOUTFUL RADIANCE 60 ML pcs 4,800 5,500 5.00

Page 2: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

CITRA HAZELINE 4 GR (PINK) pcs 4,500 6,000 1.00

CITRA HAZELINE 40 GR (BIRU) pcs 9,900 12,000 10.00

CITRA LASTING WHITE 120 ML pcs 8,150 10,000 1.00

CLAIROL PROF 6.45 pcs 36,500 50,000 1.00

CLAIROL PROF 8.45 pcs 36,500 50,000 1.00

COSMIC BLUSH ON pcs 11,750 15,000 17.00

COTTA COTTON BUD pcs 3,850 4,500 6.00

CRRANTE CREAMBATH ALPUKAT pcs 28,000 30,000 3.00

CRRANTE CREAMBATH GINSENG pcs 28,000 30,000 2.00

CRRANTE CREAMBATH KEMIRI pcs 22,500 25,000 1.00

CRRANTE FACIAL SCRUB BENGKOANG pcs 10,000 13,000 1.00

CRRANTE HOT PERM SMOOTHING STEP 2 pcs 23,000 25,000 1.00

CRRANTE STEP 1 & STEP 2 pcs 22,500 25,000 1.00

CRRANTE STEP 1 ALPUCAT pcs 47,500 55,000 3.00

CRRANTE STEP 1 STRAWBERRY pcs 47,600 55,000 3.00

CRRANTE STEP 1 SUSU pcs 47,600 55,000 2.00

CUBIC EYESHEDOW+PRESSED POWDER pcs 20,000 30,000 1.00

CUKURAN ALIS pcs 8,000 10,000 6.00

DAVIS EYESHEDOW PENSIL pcs 8,000 15,000 10.00

DIO BLEACHING pcs 6,000 7,000 18.00

DODO REAL LOOSE POWDER pcs 17,000 35,000 3.00

DOLBY 3000 pcs 7,000 10,000 4.00

DOUBLE RING GUNTING PANJANG pcs 41,000 50,000 3.00

DOUBLE RING GUNTING PENDEK pcs 22,000 30,000 2.00

DRUSH KUAS BLUSH ON pcs 14,000 17,000 2.00

ELLIPS TWIN PACK NC pcs 9,500 9,500 10 ELLIPS TWIN PACK SB pcs 9,500 9,500 5 ELLIPS UT 3X8 ML pcs 9,000 9,000 15 ELLIPS VR HT BLISTER pcs 5,500 5,500 576 ELLIPS VR HT JAR pcs 37,500 37,500 9 ELLIPS VR NC JAR pcs 37,500 37,500 5 ELLIPS VR SB BLISTER pcs 5,500 5,500 720 ELLIPS VR SHINY BLACK JAR pcs 37,500 37,500 6 ELLIPS VR SS JAR pcs 37,500 37,500 3 ESENE FACE MASK pcs 10,000 13,500 8.00

ESSANCE MASCARA pcs 10,000 17,000 1.00

EVANY SENSES MASCARA pcs 7,500 12,500 1.00

EXZO BODY MILK pcs 15,000 17,000 1.00

EYE PUTTY pcs 8,000 9,000 4.00

EYE PUTTY BIRU pcs 7,000 9,000 22.00

FACIAL SPONS pcs 7,000 8,000 1.00

FAIR & LOVELY 25 GR pcs 7,200 8,000 1.00

FAIR CHEEK MASCARA pcs 7,000 9,000 2.00

FLOWERS CATOK pcs 120,000 150,000 1.00

FRESH CARE GREEN TEA pcs 8,500 10,000 4.00

FRESH CARE LOVENDER pcs 8,500 10,000 8.00

FRESH CARE STRONG pcs 8,500 10,000 1.00

FRESHCARE SPLASH FRUITY pcs 8,500 10,000 1.00

FRUITY SPA SOAP pcs 16,000 19,000 6.00

FUJIYAMA pcs 9,500 10,000 5.00

FUNBO SPONS BULAT pcs 2,280 3,000 5.00

FUNBO SPONS KOTAK pcs 3,800 6,000 4.00

GARNIER LIGHT COMPLETE BONUS pcs 12,750 14,000 2.00

GARNIER LIGHT FOAM 50 ML pcs 9,250 10,000 3.00

GARNIER SKIN NAT LIGHT 50 ML pcs 33,250 35,000 2.00

GARNIER SKIN NATURAL LIGHT 40 ML pcs 22,500 25,000 3.00

GATSBY ROLL ON COOL AROMA pcs 8,000 9,000 2.00

GATSBY ROLL ON FLORAL WOODY pcs 8,000 9,000 1.00

GATSBY ROLL ON WOODY FOUGERE pcs 8,000 9,000 2.00

GATSBY SPLASH COLOGNE AMBER pcs 4,650 6,000 1.00

GATSBY SPLASH COLOGNE FOUGERE pcs 4,650 6,000 9.00

GATSBY SPLASH COLOGNE MUSKY pcs 4,650 6,000 10.00

GATSBY SPLASH COLOGNE OZONE pcs 4,650 6,000 4.00

GATSBY SPLASH COLOGNE SPICY pcs 4,650 6,000 4.00

GATSBY SPLASH COLOGNE WOODY pcs 4,650 6,000 3.00

GATSBY TALC pcs 2,500 3,000 5.00

GATSBY WAX BRITISH STYLE pcs 4,900 5,500 11.00

GATSBY WAX BRITISH WAVE STYLE pcs 4,900 5,500 12.00

GATSBY WAX EMO STYLE pcs 4,900 5,500 11.00

GATSBY WAX HARAJUKU STYLE pcs 4,900 5,500 12.00

Page 3: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

GATSBY WAX SPIKY STYLE pcs 4,900 5,500 10.00

GATSBY WG HARD pcs 2,300 2,750 9.00

GATSBY WG HARD pcs 3,100.00 3,600.00 0.00

GATSBY WG SOFT pcs 2,300 2,750 6.00

GATSBY WG SUPER HARD pcs 2,300 2,750 9.00

GATSBY WG SUPER HARD pcs 3,100.00 3,600.00 0.00

GELIGA 20GRM pcs 4,300 5,000 2.00

GELIGA10GRM pcs 2,100 2,750 7.00

GLITER pcs 4,000 5,000 3.00

GLITER BOTOL pcs 2,500 3,000 48.00

GO STREET ANTI FRIZZ 250 ML pcs 29,000 35,000 1.00

GO STREET SERUM pcs 27,000 30,000 6.00

GOAL pcs 9,000 10,000 36.00

GOOD CREAMBATH CARROT 250 G pcs 12,200 13,500 2.00

GOOD CREAMBATH GREEN TEA 250 G pcs 12,200 13,500 2.00

GOOD CREAMBATH LEMON 250 G pcs 12,200 13,500 2.00

GOOD H. CONDITIONING HERBAL 1000 ML pcs 27,000 28,500 1.00

GOOD KERITING 120 ML pcs 6,250 8,000 1.00

GOOD NEUTRALIZER CREAM pcs 13,500 15,000 1.00

GOOD SHAMPOO ALOE VERA 1000 ML pcs 25,000 27,500 1.00

GOOD SHAMPOO APPLE 1000 ML pcs 25,000 27,500 1.00

GOOD STEP 1 250 G pcs 27,000 30,000 3.00

GOOD STEP 2 250 G pcs 16,000 19,000 3.00

GPU pcs 4,000 5,000 3.00

GUNTING 1SET pcs 15,000 17,000 3.00

GUNTING DOVO pcs 13,000 15,000 2.00

HANDUK HITAM pcs 10,000 11,000 17.00

HANDUK PUTIH pcs 2,000 2,500 8.00

HANDUK PUTIH LUSINAN pcs 24,000 26,000 1.00

HANDUK WARNA pcs 9,000 10,000 9.00

HARNAL pcs 1,500 3,000 42.00

HENNA PASTE BLACK pcs 15,000 20,000 3.00

HENNA PASTE BROWN pcs 15,000 20,000 4.00

HERBORIST AROMA GREEN TEA pcs 8,000 10,000 4.00

HERBORIST AROMA LEMON pcs 8,000 10,000 3.00

HERBORIST AROMA PEPPERMINT pcs 8,000 10,000 3.00

HERBORIST SABUN SERE pcs 3,500 5,000 19.00

HEROCYN BEDAK 150 GR pcs 8,200 9,000 5.00

HEROCYN BEDAK 75 GR pcs 5,000 5,500 2.00

HEVINY HAIR MASK AVOCADO 500 ML pcs 16,500 20,000 2.00

HEVINY HAIRMASK MILKY 500 GR pcs 21,500 25,000 9.00

HEVINY HERBAL CONDITIONER 1 KG pcs 8,500 11,000 1.00

HEVINY STRAWBERRY CONDITIONER 1 KG pcs 8,700 11,000 3.00

HI TOP 10ML pcs 4,300 5,000 19.00

HIGHLIGHT PLASTIK pcs 6,500 8,000 3.00

HIKARI CATOK pcs 250,000 300,000 1.00

HUANG LIAN SU MENCRET pcs 2,500 3,000 12.00

IDA PEROXID 1 KG pcs 80,000 90,000 3.00

IMPLORA PENSIL ALIS pcs 2,950 4,000 12.00

IMPLORA SHEDOW pcs 9,400 15,000 2.00

INAURA HAIR NUTRIENT SOYA pcs 30,000 35,000 4.00

INAURA HAIR NUTRIENT SPRAY pcs 30,000 35,000 5.00

INAURA NOFRIZZ 250 ML pcs 34,000 40,000 6.00

INEZ EYE LINER FLORAL WHITE pcs 26,600 30,000 1.00

INEZ LIGHTWEIGHT MOIST CREAM pcs 21,500 22,500 3.00

INEZ MOIST CREAM pcs 21,250 22,500 1.00

INEZ OILFREE FACIAL FOAM pcs 21,250 21,500 1.00

INEZ SEVENTH DAY SCRUB CREAM pcs 22,950 24,000 1.00

INEZ SPONS pcs 7,500 9,000 4.00

INEZ SUN BLOCK pcs 33,150 35,000 2.00

J FIVE EXTREME (RED) pcs 8,000 10,000 2.00

JEPET BEBEK pcs 10,000 12,000 11.00

JEPET BITING 555 pcs 7,500 8,500 15.00

JEPIT BULU MATA pcs 6,000 7,000 1.00

JEPIT BULU MATA BIASA pcs 4,000 5,000 4.00

JINZU SOAP PAPAYA 90 GR pcs 6,500 8,000 7.00

JOHNNY ANDREAN STYLING GEL pcs 14,500 16,000 1.00

JUST MIST 3 EYESHEDOW pcs 8,500 10,000 1.00

JUST MIST 6 EYESHEDOW pcs 12,600 15,000 6.00

JUST MIST LIP pcs 6,000 7,500 11.00

Page 4: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

JUST MIST LIP ULIR pcs 7,500 9,000 12.00

KACA pcs 20,000 25,000 2.00

KAI BLUSH ON pcs 9,000 11,000 19.00

KAI LIP GLOSS pcs 5,500 7,500 8.00

KAINOS BATH SALT pcs 11,000 15,000 4.00

KAMARIA FACE MASK 250GR pcs 12,500 15,000 1.00

KANNA CREAM 15 GR pcs 5,200 5,500 11.00

KANNA CREAM 30 GR pcs 9,000 10,000 21.00

KAPAS pcs 2,800 3,500 10.00

KAPAS COTTA pcs 3,400 4,000 24.00

KEEP POTONG pcs 10,000 12,000 1.00

KEEP POTONG 1 pcs 17,000 19,000 4.00

KEEP POTONG 2 pcs 37,000 40,000 3.00

KEEP SEMIR pcs 4,000 6,000 9.00

KEEP SEMIR 1 pcs 8,000 10,000 7.00

KELLY BESAR pcs 4,000 4,500 24.00

KELLY KECIL pcs 2,500 3,000 25.00

KEMBANG GOYANG pcs 27,500 35,000 7.00

KENNY HAIR SPRAY 420 ML pcs 14,500 16,500 7.00

KERTAS KRITING pcs 7,000 10,000 3.00

KIWI SHOE POLISH pcs 4,250 5,000 2.00

KK HAIR CREAM pcs 27,500 30,000 5.00

KONDE pcs 17,000 30,000 15.00

KRAYOLAN NB pcs 160,000 170,000 2.00

KUAS BLUSH ON pcs 6,000 7,500 1.00

KUAS EYESHEDOW pcs 3,000 4,000 5.00

KUAS EYESHEDOW ISI 12 pcs 3,500 7,000 5.00

KUAS FACIAL pcs 2,000 5,000 21.00

KUAS PAKET pcs 11,000 15,000 3.00

KUAS PORTABLE pcs 14,250 17,000 5.00

KUAS SHEDOW 12 pcs 5,000 7,500 6.00

KUKU pcs 2,500 4,000 3.00

KUTEK 1 pcs 2,200 3,000 13.00

KUTEK 2 pcs 4,000 5,000 5.00

KUTEK 3 pcs 5,000 7,000 20.00

KUTEK 4 pcs 2,800 3,500 13.00

KUTEK 5 pcs 8,000 10,000 9.00

LA TULIPE FACE POWDER 50 G pcs 28,000 31,000 3.00

LA TULIPE REFF TWC 08 pcs 23,200 25,000 1.00

LABBIO SPA TREATMENT 500 ML pcs 55,000 60,000 1.00

LAILA FEELING 800 G pcs 71,250 75,000 2.00

LAILA PEELING 50 G pcs 9,200 11,000 4.00

LANEIGE BEDAK pcs 15,000 25,000 6.00

LELIA PEELING 800 G pcs 70,000 75,000 3.00

LEM KUKU pcs 10,000 12,500 1.00

LING SHI DAY pcs 4,800 8,000 4.00

LING SHI NIGHT pcs 4,500 8,000 1.00

LOREAL EXCELLENCE 4,45 MAHOGANY COPPER BROWN pcs 59,000 70,000 1.00

LOREAL EXCELLENCE 5 NATURAL LIGHT BROWN pcs 59,000 70,000 1.00

LOREAL HAIR MASK RE NUTRITION SCHT pcs 3,500 4,000 21.00

LOREAL HAIR MASK SMOOTH INTENSE SCHT pcs 3,500 4,000 6.00

LOREAL MASCARA EYELINER pcs 8,000 15,000 5.00

LOREAL SHAMPOO COLOR VIVE 375ML pcs 24,000 31,000 3.00

LOREAL SHAMPOO NUTRI GLOSS 375ML pcs 23,000 30,000 1.00

LOREAL SHAMPOO RE NUTRITION 375ML pcs 23,000 30,000 1.00

LOUVRE LIP ICE pcs 3,500 5,000 11.00

LUX B. WASH WAKE ME UP 250 ML pcs 9,500 10,500 1.00

MAC 2 SHEDOW 1 BLUSH ON pcs 10,000 15,000 3.00

MAC 9 EYESHEDOW pcs 15,000 20,000 7.00

MAC 9 EYESHEDOW 3 BLUSH ON pcs 21,000 30,000 3.00

MAC 9 SHEDOW pcs 20,000 30,000 8.00

MAC BLUSH ON pcs 10,000 15,000 13.00

MAC EYE LINER PENSIL pcs 3,500 5,000 17.00

MAC EYE LINER PENSILTINTA pcs 20,000 25,000 6.00

MAC EYESHEDOW PENSIL pcs 7,000 12,500 6.00

MAC EYESHEDOW+BLUSH ON pcs 13,000 20,000 1.00

MAC KUAS BLUSH ON BESAR pcs 17,000 20,000 1.00

MAC LIPSTICK pcs 10,000 15,000 17.00

MAC MASCARA pcs 10,000 15,000 6.00

MAC WONDER WOMAN pcs 15,000 25,000 3.00

Page 5: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

MAGNUM MASCARA pcs 11,000 15,000 5.00

MAKARIZO ADVISOR TUBE 8 ML pcs 4,700 6,000 4.00

MAKARIZO ADVISOR TUBE ISI 8 X 8 ML pcs 37,500 45,000 9.00

MAKARIZO ANTI FRIZZ ADVISOR 265 ML pcs 38,000 47,500 2.00

MAKARIZO ANTI FRIZZ ADVISOR 50 ML pcs 17,600 19,000 16.00

MAKARIZO CONDITIONER AFTER COLOUR 265 ML pcs 48,000 52,500 4.00

MAKARIZO HAIR ENERGI ALOE 500 GR pcs 37,300 43,000 1.00

MAKARIZO HAIR ENERGI ROYAR JELLY 500 GR pcs 37,300 43,000 1.00

MAKARIZO HAIR ENERGY KIWI 500 GR pcs 37,300 43,000 5.00

MAKARIZO HAIR ENERGY KIWI SASHET 30 GR pcs 2,750 4,000 23.00

MAKARIZO HAIR ENERGY ROYAL JELLY SASHET 30 GR pcs 2,750 4,000 11.00

MAKARIZO HAIR REPAIR MASK 45 ML TUBE pcs 9,200 10,000 42.00

MAKARIZO REBONDING SYSTEM DAMAGE HAIR 120 GR pcs 30,000 38,500 5.00

MAKARIZO REBONDING SYSTEM SSS pcs 30,000 38,500 5.00

MAKARIZO REBONDING SYSTEM SUPER GOLD 120 GR pcs 30,000 38,500 5.00

MAKARIZO RECOVERY DROPS 50 ML pcs 56,000 60,000 3.00

MAKARIZO RECOVERY SPRAY 50 ML pcs 56,000 60,000 2.00

MAKARIZO SHAMPO AFTER COLOUR 265 ML pcs 43,000 47,500 3.00

MAKARIZO SHAMPO DAILY 1 LT pcs 39,000 44,000 2.00

MANGKOK SEMIR pcs 2,750 4,000 8.00

MARCKS BEDAK PUTIH pcs 6,500 7,000 4.00

MARCKS BEDAK ROSE pcs 6,500 7,000 1.00

MARCKS VENUS PWDR 01 pcs 19,500 21,000 1.00

MARCKS VENUS PWDR 02 pcs 19,500 21,000 1.00

MARCKS VENUS PWDR 03 pcs 19,500 21,000 5.00

MARINA SPRY CLGN FUN DAY 100 ML pcs 7,600 8,000 2.00

MARINA SPRY CLGN MIDNIGHT 100 ML pcs 7,600 8,000 2.00

MARINA UV WHITE FRESH 100 ML pcs 3,800 4,500 4.00

MARK BIKCH pcs 10,000 15,000 12.00

MARYQUANT LINER pcs 1,700 2,500 23.00

MASKER BENGKOANG 125 G MUSTIKA RATU pcs 15,150 18,500 12.00

MATRIX PAKET STRAIGHT SYSTEM pcs 35,000 40,000 1.00

MATRIX STEP 1 STRIP 1 500 ML pcs 85,000 92,500 1.00

MATRIX STEP 1 STRIP 3 500 ML pcs 85,000 92,500 8.00

MATRIX STEP 2 1 KG pcs 95,000 100,000 4.00

MATRIX STEP 2 500 ML pcs 46,500 52,500 9.00

MAYBELINE BB CREAM pcs 24,800 28,000 2.00

MAYON HAIR SPRAY 350 ML pcs 30,000 34,000 4.00

MAYON HAIR SPRAY 450 ML pcs 35,000 39,000 3.00

MAYON HAIR SPRAY 550 ML pcs 43,000 48,000 7.00

MAYON HAIR SPRAY 75 ML pcs 8,500 12,000 2.00

MECO LIGHTENING CREAM pcs 28,000 30,000 3.00

MECO PEARL CREAM pcs 8,750 11,000 16.00

MEDICATED OIL pcs 8,000 9,000 2.00

MEI XUE YI ZU ALIS pcs 1,000 2,000 5.00

MENIPEDI pcs 12,000 15,000 2.00

METAL FORTIS SHAMPOO 150ML pcs 21,500 22,500 2.00

MINYAK ANGIN KAPAK BESAR pcs 5,900 6,500 6.00

MINYAK ANGIN KAPAK KECIL pcs 3,100 4,000 9.00

MINYAK ANGIN LANG pcs 5,200 6,000 9.00

MINYAK ZAITUN 175 ML MUSTIKA RATU pcs 16,250 20,000 12.00

MIRABELLA MASCARA pcs 20,000 22,000 3.00

MIRABELLA MOIST LIP 01 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 02 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 03 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 04 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 05 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 06 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 07 pcs 6,400 7,500 1.00

MIRABELLA MOIST LIP 08 pcs 6,400 7,500 1.00

MIRABELLA REFF TWC 01 pcs 6,500 8,000 7.00

MIRABELLA REFF TWC 02 pcs 6,300 8,000 5.00

MIRABELLA TWC 01 pcs 10,750 13,000 6.00

MIRABELLA TWC 02 pcs 10,750 13,000 7.00

MISSMAY H.B BENGKOANG 600 ML pcs 10,000 11,000 1.00

MISSMAY H.B GREEN TEA 600 ML pcs 10,000 11,000 1.00

MISSMAY H.B JASMINE 600 ML pcs 10,000 11,000 2.00

MUKKA 2 BLUSH ON pcs 15,000 20,000 5.00

MUKKA SHEDOW pcs 6,000 10,000 4.00

MUSTIKA RATU BEDAK PADAT K.LANGSAT 2 pcs 14,417 16,000 2.00

Page 6: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

MUSTIKA RATU BEDAK PADAT K.TEMANTEN 1 pcs 14,417 16,000 2.00

MUSTIKA RATU REFF BEDAK PADAT K.LANGSAT 2 pcs 8,500 10,000 1.00

MUSTIKA RATU REFF BEDAK PADAT K.TEMANTEN 1 pcs 8,500 10,000 2.00

MY DARLING EYELINER pcs 10,000 11,000 18.00

MY DARLING MASCARA pcs 9,500 11,000 19.00

NEFERTITI SHAMPOO pcs 22,000 25,000 3.00

NERIL H.TONIC A.DANDRUFF pcs 29,500 32,500 2.00

NEW RDL PAPAYA WHITENING SOAP 135 GR pcs 6,500 8,000 54.00

NICHI BABY POWDER pcs 7,000 10,000 6.00

NIVEA BODY LOTION NIGHT WHITENING 200 ML pcs 19,200 21,000 2.00

NIVEA F.FOAM SPARKLING WHITE 50 ML pcs 8,200 9,000 5.00

NIVEA H.B UV WHITENING pcs 9,250 11,000 1.00

NIVEA INTENSIVE 100 ML pcs 7,500 9,000 2.00

NIVEA MEN F.FOAM OIL CONTROL 50 ML pcs 8,200 9,000 5.00

NIVEA MEN F.FOAM WHITENING 50 ML pcs 8,200 9,000 5.00

NIVEA MEN MULTI PROTECTING 50 G pcs 8,100 9,000 5.00

NORIT pcs 8,000 9,000 6.00

OIMIO LIP pcs 1,900 4,000 1.00

OIMIO LIP GLOSS pcs 7,000 10,000 3.00

OKANA TALCUM POWDER pcs 2,700 4,000 20.00

OLAY MOISTURISING LOTION 30 ML pcs 13,750 15,000 10.00

OLAY NAT WHITE DAY CREAM 20 GR pcs 10,000 13,000 10.00

OLAY NATURAL WHITE DAY LOTION 30 ML pcs 15,350 17,500 5.00

OLAY NATURAL WHITE LIGHT 40 GR pcs 19,800 21,000 7.00

OLAY WHITE RADIANCE 30 ML pcs 18,300 19,500 2.00

ORIFLAME MASCARA pcs 50,000 55,000 2.00

PALMOLIVE A.THERAPY ABSOLUTE RELAX pcs 15,000 20,000 1.00

PALMOLIVE A.THERAPY SENSUAL pcs 15,000 20,000 1.00

PALMOLIVE A.THERAPY MORNING TONIC pcs 15,000 20,000 1.00

PALMOLIVE THERMAL SPA pcs 15,000 20,000 1.00

PANTENE PRO-V 100 ML pcs 27,000 29,000 2.00

PANTENE SHMP ANTI DENDRUFF 90 ML pcs 8,000 8,500 3.00

PANTENE SHMP BLACK 180 ML pcs 16,300 17,000 2.00

PANTENE SHMP HAIR FALL 90 ML pcs 8,000 8,500 4.00

PANTENE SHMP TOTAL CARE 180 ML pcs 16,700 17,500 3.00

PANTENE SMOOTH & SILKY 180 ML pcs 17,100 18,000 4.00

PANTENE SMOOTH & SILKY 90 ML pcs 8,000 8,500 6.00

PARFUM pcs 40,000 50,000 3.00

PEDITOX pcs 3,500 5,000 9.00

PINSET HITAM pcs 4,000 7,500 5.00

PINSET PUTIH pcs 5,500 9,000 3.00

PLACENTA FACE CLEANSER BLUE pcs 3,500 4,500 2.00

PLACENTA FACE CLEANSER GREENTEA pcs 3,500 4,500 1.00

PLACENTA FACE CLEANSER ROSE pcs 3,500 4,500 2.00

PLACENTA FACE TONER GREENTEA pcs 3,500 4,500 1.00

PLACENTA FACE TONER ROSE pcs 3,500 4,500 2.00

PLACENTA SPA SOAP GINSENG pcs 3,950 4,500 9.00

PLACENTA SPA SOAP VIT E pcs 3,950 4,500 8.00

PLATIMUM HAIR MASK pcs 40,000 43,000 2.00

PO CHAI PILLS MENCRET pcs 2,000 2,500 6.00

PONDS AGE MIRACLE DAILY CREAM pcs 95,000 100,000 1.00

PONDS AGE MIRACLE OVERNIGHT pcs 100,000 105,000 1.00

PONDS CLEAR SOLUTION 20 GR pcs 11,850 13,500 1.00

PONDS CLEAR SOLUTION 40 GR pcs 22,250 24,000 1.00

PONDS CLEAR SOLUTION SHAKE & CLEAN pcs 13,750 15,000 4.00

PONDS F.FOAM CLEAR SLTN ANTI BACT 20 GR pcs 5,350 6,000 8.00

PONDS GOLD RADIANCE NIGHT pcs 105,000 110,000 1.00

PONDS LIGHTENING FACIAL FOAM 20 G pcs 5,100 6,000 12.00

PONDS MAKE UP pcs 20,000 30,000 6.00

PONDS PERFECT MATTE 100 G pcs 15,650 17,000 2.00

PONDS PERFECT MATTE 50 G pcs 9,600 10,500 2.00

PONDS PURE WHITE 20 G pcs 5,350 6,000 11.00

PONDS PURE WHITE 50 G pcs 10,200 11,500 6.00

PONDS WHITE BEAUTY 10G pcs 5,700 6,500 10.00

PONDS WHT BEAUTY FF NATURAL 50 G pcs 10,200 11,500 5.00

PONDS WHT BEAUTY NATURAL 20 G pcs 12,250 14,000 3.00

PONDS WHT BEAUTY PINKIS WHT 20 GR pcs 11,950 14,000 11.00

PONDS WHT BEAUTY PINKIS WHT 40 GR pcs 24,000 25,000 3.00

PONDS WHT BEAUTY SHAKE & CLEAN pcs 13,750 15,000 6.00

PONDS WHT BEAUTY SPOTLESS 20 GR pcs 11,850 13,000 1.00

Page 7: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

PONDS WHT BEAUTY UV PROTEC 20 GR pcs 14,400 16,000 12.00

PONDS WHT BEAUTY UV PROTECT 40 GR pcs 22,500 24,000 2.00

PP 2 IN 1BENGKOANG 150 ML pcs 10,200 12,500 13.00

PUCELLE MIST CLGN ECCENTRIC BREEZE (HIJAU) pcs 9,600 11,000 6.00

PUCELLE MIST CLGN ELECTRIC SUNRISE (ORG) pcs 9,600 11,000 7.00

PUCELLE MIST CLGN SPARKLING LOVE (PINK) pcs 9,600 11,000 1.00

PUCELLE MIST CLGN TROPICAL SPIRIT (KUNING) pcs 9,600 11,000 6.00

PUCELLE ROLL ON INTENSE FRESH pcs 7,500 8,000 1.00

PUCELLE ROLL ON SENSITIVE EXPERT pcs 7,500 8,000 2.00

PUCELLE SPLASH COLOGNE CHYPRE 35 ML pcs 2,600 3,000 12.00

PUCELLE SPLASH COLOGNE MUSK 35 ML pcs 2,600 3,000 9.00

PUCELLE SPLASH COLOGNE SWEET 35 ML pcs 2,600 3,000 7.00

PURBASARI BLUSH ON 2001 pcs 17,600 20,000 2.00

PURBASARI BLUSH ON 2002 pcs 17,600 20,000 1.00

PURBASARI BLUSH ON P 01 pcs 17,600 20,000 1.00

PURBASARI EYE SHEDOW 2001 pcs 19,200 22,000 1.00

PURBASARI EYE SHEDOW 2002 pcs 19,200 22,000 2.00

PURBASARI EYE SHEDOW 2003 pcs 19,200 22,000 2.00

PURBASARI EYE SHEDOW P 01 pcs 18,400 21,000 2.00

PURBASARI EYE SHEDOW P 02 pcs 18,400 21,000 2.00

PURBASARI EYE SHEDOW P 03 pcs 18,400 21,000 2.00

PURBASARI EYE SHEDOW P 04 pcs 18,400 21,000 2.00

PURBASARI LULUR GREENTEA pcs 10,450 13,000 3.00

PURBASARI LULUR MUTIARA pcs 10,450 13,000 3.00

PURBASARI LULUR PENGANTEN BENGKOANG pcs 21,500 25,000 1.00

PURBASARI LULUR SUSU pcs 10,450 13,000 2.00

PUTERI BDY SPLASH CHAMOMILE 135 ML (ORG) pcs 8,500 9,000 5.00

PUTERI BDY SPLASH CHRYSANT 135 ML (KNG) pcs 8,500 9,000 6.00

PUTERI BDY SPLASH FLOWER BOUQUET 135 ML (UNG) pcs 8,500 9,000 5.00

PUTERI BDY SPLASH ORCHID 135 ML (PINK) pcs 8,500 9,000 3.00

PUTERI BDY SPLASH ROSE 135 ML (MRH) pcs 8,500 9,000 5.00

PUTERI BDY SPLASH ROSE MANGO 135 ML (ORG) pcs 8,500 9,000 3.00

PUTERI BDY SPLASH WHITE LILY 135 ML (BIRU) pcs 8,500 9,000 3.00

PUTRI H.TONIC SPA pcs 17,500 19,000 2.00

PUTRI HAIR MASK 240ML pcs 25,000 27,000 2.00

PUTRI HAIR MASK 720ML pcs 55,000 60,000 2.00

PUTRI HT A.DANDRUFF (BIRU) 200 ML pcs 16,200 18,000 1.00

PUTRI HT GINGSENG 200 ML pcs 13,600 17,000 7.00

PUTRI HT GINGSENG 450 ML pcs 23,400 29,000 5.00

PUTRI HT GINSENG (ORG) 200 ML pcs 15,700 17,500 2.00

PUTRI HT MENTHOL (HIJAU) 200 ML pcs 15,000 17,000 2.00

PUTRI HT MENTHOL 200 ML pcs 13,600 17,500 5.00

PUTRI HT MENTHOL 450 ML pcs 23,400 29,000 6.00

PUTRI HT NORMAL HAIR 450 ML pcs 23,400 29,000 1.00

PUTRI STEP 2 NETRAL pcs 13,000 16,000 1.00

QL ANTI ACNE SOAP pcs 5,850 6,500 2.00

QL CREAM NIGHT pcs 23,000 25,000 3.00

QL EYE LINER pcs 20,000 25,000 16.00

QL MASCARA BLACK pcs 22,500 25,000 5.00

QL MASCARA BLUE pcs 22,000 25,000 6.00

QUINA LIPSTICK pcs 4,000 6,000 4.00

RANEE EYE LINER pcs 24,500 27,000 2.00

RANEE SPONS pcs 5,000 7,000 4.00

RDL PAPAYA WHITENING SOAP 135 GR pcs 6,500 8,000 9.00

REFANI CONDITIONER 1 LITER pcs 14,100 16,000 8.00

REFANI CONDITIONER 5 LITER pcs 41,000 50,000 1.00

REFANI SHAMPO 5 LITER pcs 37,000 45,000 2.00

REVLON EYESHEDOW+PRESSED POWDER pcs 20,000 30,000 2.00

REVLON LIPSTICK pcs 8,000 12,500 5.00

REVLON MAKEUP pcs 20,000 30,000 2.00

REXONA ADVENTURE ROLL ON pcs 10,000 11,500 5.00

REXONA ICE COOL ROLL ON pcs 10,800 12,500 4.00

REXONA MEN V8 ROLL ON pcs 10,500 11,500 1.00

REXONA QUANTUM pcs 10,000 11,000 2.00

REXONA SPORT MEN ROLL ON pcs 10,800 11,500 2.00

REXONA STICK SPORT pcs 10,000 11,000 1.00

REXONA WOMEN DEO LOTION pcs 1,700 2,000 42.00

REXONA WOMEN NATURAL ROLL ON pcs 10,000 10,750 2.00

REXONA WOMEN OXYGEN ROLL ON pcs 10,000 10,750 2.00

REXONA WOMEN PASSION ROLL ON pcs 10,000 10,750 3.00

Page 8: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

REXONA WOMEN SKIN LIGHT ROLL ON pcs 10,000 10,750 2.00

RITA LIDA BUAYA SHAMPOO pcs 6,000 7,500 3.00

ROLL KARET pcs 11,000 15,000 2.00

ROSE PEMUTIH pcs 8,000 12,000 2.00

RUDY ANTI DANDRUFF SERUM pcs 55,000 59,000 1.00

RUDY HAIR SERUM0 pcs 52,050 55,000 3.00

SA PEMBERSIH JERUK 100 ML pcs 6,350 7,500 2.00

SA PEMBERSIH KENANGA 100 ML pcs 6,350 7,500 2.00

SA PEMBERSIH MAWAR 100 ML pcs 6,350 7,500 2.00

SA PENYEGAR JERUK 100 ML pcs 5,550 7,000 2.00

SA PENYEGAR KENANGA 100 ML pcs 5,550 7,000 2.00

SA PENYEGAR MAWAR 100 ML pcs 5,550 7,000 2.00

SAFE CARE MINYAK ANGIN pcs 12,000 13,500 4.00

SALEP 88 pcs 4,000 4,700 7.00

SANGGUL KURLY pcs 17,000 30,000 13.00

SARI AYU ALAS BEDAK K.PENGANTIN pcs 5,000 6,500 1.00

SARUNG TANGAN HITAM pcs 4,000 5,000 16.00

SARUNG TANGAN KARET pcs 1,000 2,000 17.00

SASHA VR JAR pcs 22,000 22,000 1 SAYOTA BLOW pcs 120,000 150,000 1.00

SAYOTA KERLY pcs 65,000 80,000 2.00

SC MASKER BENGKOANG 500GR pcs 21,000 23,000 1.00

SC MASKER PEMUTIH500GR pcs 21,000 23,000 2.00

SCHOLAR DAY pcs 13,000 15,000 35.00

SCHOLAR HB ORANGE 600ML pcs 10,000 12,000 1.00

SCHOLAR HB STRAWBERRY 600ML pcs 10,000 12,000 1.00

SCHOLAR NIGHT pcs 13,000 15,000 58.00

SCOTH BEAUTY VISION pcs 7,500 10,000 6.00

SCOTH COKLAT pcs 8,500 11,000 1.00

SCOTH MAGIC pcs 12,500 15,000 2.00

SCOTH WARNA pcs 2,500 3,500 14.00

SEMPROTAN BESAR pcs 12,500 15,000 9.00

SEMPROTAN KECIL pcs 7,500 8,500 7.00

SEPATU KLIPER pcs 30,000 40,000 2.00

SERUTAN pcs 3,500 4,000 16.00

SHILA GUNTING SASAK 1 SISI pcs 37,600 47,000 3.00

SHILA GUNTING SASAK 2 SISI pcs 53,500 65,000 2.00

SHILA GUNTING TEMP pcs 35,625 42,000 6.00

SHILA GUNTING TEMP BIRU pcs 33,700 40,000 6.00

SIKAT ALIS pcs 1,700 3,000 5.00

SILKS GUNTING SASAK pcs 25,000 30,000 2.00

SISIR pcs 2,000 3,000 4.00

SISIR BIRU pcs 4,000 5,000 11.00

SISIR BULAT pcs 21,000 25,000 2.00

SISIR MURAH pcs 900 1,250 32.00

SISIR SEMIR BIASA pcs 1,000 2,000 8.00

SISIR SEMIR TEBEL pcs 3,000 4,000 6.00

SISIR SILET pcs 4,500 6,000 7.00

SISIR TULANG BIASA BESAR pcs 16,000 17,500 4.00

SISIR TULANG BIASA KECIL pcs 12,000 14,000 3.00

SISIR TULANG SASAK BESAR pcs 16,000 17,500 13.00

SISIR TULANG SASAK KECIL pcs 11,000 13,000 14.00

SISIR WARNA pcs 3,000 4,000 1.00

SIZI CREAM pcs 6,000 7,500 1.00

SP SPESIAL pcs 6,000 10,000 2.00

SPALDING TALC pcs 2,500 3,000 3.00

SPONS ISI 6 pcs 8,000 13,000 4.00

SPONS PERSEGI pcs 6,000 10,000 2.00

SPONS PERSEGI PANJANG pcs 8,000 13,000 4.00

SRITI pcs 2,500 4,000 23.00

SUPER MAX pcs 3,000 3,500 40.00

SUPERIOR SARIAWAN pcs 3,000 4,000 12.00

TANCHO HAIR DYE pcs 8,350 9,500 18.00

TANCHO LIQUID pcs 8,100 9,500 5.00

TANG pcs 12,500 15,000 5.00

TARIKAN pcs 5,000 7,500 9.00

TIGER pcs 2,500 3,500 21.00

TJE FUK WHITENING WITH SCRUB pcs 26,750 35,000 1.00

TOMO CATOK pcs 213,750 250,000 1.00

TOP LADY CREAM pcs 8,000 9,000 8.00

Page 9: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

TOP LADY HAIR DYE SHAMPOO pcs 4,000 5,000 72.00

TUSUK KONDE pcs 8,000 10,000 1.00

TUTUP KEPALA HITAM pcs 4,000 6,000 6.00

TUTUP KEPALA MURAH pcs 5,000 6,000 53.00

TUTUP KUPING pcs 1,000 2,000 16.00

VALENO FACIAL FOAM pcs 10,600 13,000 1.00

VALENO GINSENG pcs 8,500 10,000 2.00

VALENO MASK pcs 16,200 18,000 1.00

VANESTRIX STEP 2 pcs 37,500 45,000 4.00

VASELINE ALOE FRESH HYDRATING 100 ML pcs 7,750 8,500 3.00

VASELINE FIRMING 200 ML pcs 19,200 22,000 2.00

VASELINE SEDAP KOSMETIK pcs 4,000 5,000 8.00

VEET KULIT KERING 25 GR pcs 10,500 11,000 1.00

VEET KULIT KERING 60 GR pcs 19,000 20,000 2.00

VEET KULIT NORMAL 60 GR pcs 19,000 20,000 1.00

VEET KULIT SENSITIF 60 GR pcs 19,000 20,000 1.00

VENON HT MERAH pcs 26,000 33,000 20.00

VENON HT UNGU pcs 29,000 32,000 10.00

VERRA CONDITIONER 2LTR pcs 34,200 38,000 1.00

VERRA SHAMPOO 2LTR pcs 33,250 37,000 3.00

VERSACE MASCARA pcs 9,000 15,000 5.00

VIOLETIME LIPSTICK pcs 6,000 8,000 1.00

VIVA ASTRINGENT 100 ML pcs 3,250 4,000 4.00

VIVA EYE BROW BLACK pcs 18,333 19,000 3.00

VIVA FACE MASK pcs 3,000 5,000 15.00

VIVA FACE POWDER SATIN 3 pcs 1,100 1,500 33.00

VIVA FACE POWDER SATIN 4 pcs 1,100 1,500 26.00

VIVA FACE TONIC 100 ML pcs 3,250 4,000 2.00

VIVA FACE TONIC AVERRHOA pcs 3,250 4,000 1.00

VIVA FACE TONIC BENGKOANG pcs 3,400 4,000 7.00

VIVA H.B LOTION BENGKOANG 100 ML pcs 3,000 3,500 12.00

VIVA H.B LOTION MANGIR 100 ML pcs 2,100 2,500 5.00

VIVA H.B. LOTION 100 ML pcs 2,100 2,500 7.00

VIVA LIQUID FOUNDATION K.LANGSAT pcs 3,500 4,000 7.00

VIVA LIQUID FOUNDATION NATURAL pcs 3,500 4,000 9.00

VIVA LOTHO pcs 7,500 9,500 5.00

VIVA MASSAGE CREAM pcs 6,000 7,000 2.00

VIVA MILK CLEANSER 100 ML pcs 3,100 4,000 4.00

VIVA MILK CLEANSER AVERRHOA pcs 3,100 4,000 2.00

VIVA MILK CLEANSER BENGKUANG pcs 3,625 4,000 5.00

VIVA MILK CLEANSER LEMON pcs 3,200 4,000 6.00

VIVA PELEMBAB pcs 3,700 4,500 2.00

VIVA PELEMBAB GREEN TEA pcs 3,700 4,500 5.00

VIVA REMOVER pcs 3,750 4,500 4.00

VIVA SKIN FOOD pcs 5,600 6,500 17.00

VIVA ULTRA FOUNDATION RACHEL pcs 3,100 4,000 5.00

VIVELLE H.B BENGKUANG 150 ML pcs 14,500 15,000 4.00

VIVELLE H.B ORANGE LEMONGRASS 150 ML pcs 14,500 15,000 6.00

VIVELLE H.B WHITE TEA 150 ML pcs 14,500 15,000 5.00

VIVIAN CATOK pcs 65,000 75,000 3.00

VOV EYESHEDOW pcs 20,000 25,000 5.00

WELLA KOLESTON 6/41 pcs 57,500 65,000 1.00

WELLA KOLESTON 8/45 pcs 57,500 65,000 1.00

WELLOXON PERFECT 60 ML 20 VOL pcs 14,500 16,000 1.00

WELLOXON PERFECT 60 ML 30 VOL pcs 14,500 16,000 4.00

WELLOXON PERFECT 60 ML 40 VOL pcs 14,500 16,000 3.00

X PERT KUAS SHEDOW pcs 8,820 10,000 9.00

X PERT SCOTH pcs 6,615 7,500 17.00

X PERT SPONS POWDER pcs 6,615 7,500 20.00

X PERT SPONS THREE pcs 6,615 7,500 36.00

X PERT SPONS TWO pcs 6,615 7,500 32.00

XI XIU LIPSTICK pcs 6,500 8,000 10.00

XI XIU SHEDOW BLUSH pcs 20,000 25,000 3.00

XL PROF HAIR SERUM 10 ML pcs 7,150 10,000 12.00

XL PROF HAIR SERUM 115 ML pcs 34,700 40,000 5.00

XPERT HAIR SPRAY COLOUR pcs 28,000 32,500 1.00

XPERT HAIR SPRAY COLOUR GLAMOUR pcs 25,000 27,500 1.00

Y2000 STEP 1 pcs 57,000 70,000 6.00

Y2000 STEP 2 pcs 57,000 65,000 11.00

YA SHANG LIP pcs 2,500 4,000 2.00

Page 10: kosmetik pesanan.xlsx

Nama Satuan Harga Pokok Harga Jual Stok

YESTA HB 100ML pcs 48,000 55,000 8.00

YESTA HB 150ML pcs 74,000 80,000 1.00

ZHENG GU SHUI pcs 10,500 12,500 3.00

ZORIC pcs 3,000 3,500 43.00

Page 11: kosmetik pesanan.xlsx

51,456,397

TOTAL tanda

60,000 1 300,000 1 45,000 5 320,000 6 19,000 2 95,000 2 57,000 2 19,000 2 19,000 2 19,000 2 25,000 2 57,000 2 76,000 2 90,000 2 40,000 1 27,000 4d 72,000 4d 63,000 4d 16,500 1 2,500 1 8,000 1 84,150 4a 285,000 1 270,000 1 54,000 4a 16,000 8 75,000 75,000 10,000 231,000 4c 231,000 4c 120,000 2 17,500 1 300,000 4a 30,000 1 175,000 1 387,500 1 399,000 1 1,499,300 1 51,000 1 24,000 20,000 8 7,000 1 14,000 1 3,500 1 7,000 1 10,000 1 312,000 4c 52,000 4c 45,600 4c 30,000 4c 60,000 4c 25,000 4a 14,000 6 25,000 1 7,500 92,000 1 25,000 1 11,100 4b 18,400 4b 17,200 4b 4,300 4b 24,000 4b

Page 12: kosmetik pesanan.xlsx

TOTAL tanda

4,500 4c 99,000 4c 8,150 4b 36,500 2 36,500 2 199,750 8 23,100 1 84,000 2 56,000 2 22,500 2 10,000 4c 23,000 2 22,500 2 142,500 2 142,800 2 95,200 2 20,000 8 48,000 1 80,000 8 108,000 2 51,000 4c 28,000 8 123,000 1 44,000 1 28,000 1 95,000 4a 47,500 4a 135,000 4a 3,168,000 4a 337,500 4a 187,500 4a 3,960,000 4a 225,000 4a 112,500 4a 80,000 4c 10,000 8 7,500 8 15,000 32,000 1 154,000 1 7,000 1 7,200 4c 14,000 8 120,000 1 34,000 68,000 8,500 8,500 96,000 4b 47,500 11,400 1 15,200 1 25,500 4c 27,750 4c 66,500 4c 67,500 4c 16,000 4b 8,000 4b 16,000 4b 4,650 4b 41,850 4b 46,500 4b 18,600 4b 18,600 4b 13,950 4b 12,500 4b 53,900 4a 58,800 4a 53,900 4a 58,800 4a

Page 13: kosmetik pesanan.xlsx

TOTAL tanda

49,000 4a 20,700 4a - 4a 13,800 4a 20,700 4a - 4a 8,600 14,700 12,000 1 120,000 1 29,000 2 162,000 2 324,000 1 24,400 4a 24,400 4a 24,400 4a 27,000 4a 6,250 4a 13,500 4a 25,000 4a 25,000 4a 81,000 2 48,000 2 12,000 45,000 1 26,000 1 170,000 1 16,000 1 24,000 1 81,000 1 63,000 1 45,000 4a 60,000 4a 32,000 24,000 24,000 66,500 41,000 10,000 33,000 2 193,500 2 8,500 2 26,100 2 81,700 4a 19,500 1 250,000 1 30,000 240,000 2 35,400 8 18,800 8 120,000 2 150,000 2 204,000 2 26,600 7 64,500 7 21,250 7 21,250 7 22,950 7 30,000 1 66,300 7 16,000 4b 110,000 1 112,500 1 6,000 1 16,000 1 45,500 8 14,500 4a 8,500 8 75,600 8 66,000 8

Page 14: kosmetik pesanan.xlsx

TOTAL tanda

90,000 8 40,000 1 171,000 4c 44,000 4c 44,000 4b 12,500 4c 57,200 4b 189,000 4b 28,000 1 81,600 1 10,000 1 68,000 1 111,000 1 36,000 1 56,000 1 96,000 4c 62,500 4c 192,500 1 101,500 6 21,000 1 8,500 4d 137,500 4a 255,000 1 320,000 5 6,000 1 15,000 1 17,500 1 42,000 1 33,000 1 71,250 1 30,000 1 7,500 1 28,600 4d

warna apa? Dibawa , lihat warna dulu 20,000 4d 100,000 4d 36,400 4d 72,000 4d 84,000 23,200 55,000 2 142,500 4c 36,800 4c 90,000 8 210,000 4c 10,000 1 19,200 5 4,500 5 59,000 4a 59,000 4a 73,500 4a 21,000 4a 40,000 8 72,000 4a 23,000 4a 23,000 4a 38,500 8 9,500 4b 30,000 8 105,000 8 63,000 8 160,000 8 130,000 8 59,500 8 120,000 8 42,000 8 13,000 8 17,000 1 170,000 8 60,000 8 45,000 8

Page 15: kosmetik pesanan.xlsx

TOTAL tanda

55,000 8 18,800 4a 337,500 4a 76,000 4a 281,600 4a 192,000 4a 37,300 4a 37,300 4a 186,500 4a 63,250 4a 30,250 4a 386,400 4a 150,000 4a 150,000 4a 150,000 4a 168,000 4a 112,000 4a 129,000 4a 78,000 pake sendiri 22,000 1 26,000 4c 6,500 4c 19,500 4c 19,500 4c 97,500 4c 15,200 4b 15,200 4b 15,200 4b 120,000 8 39,100 8 181,800 4c 35,000 2 85,000 2 680,000 2 380,000 2 418,500 2 49,600 4c 120,000 4a 105,000 4a 301,000 4a 17,000 4a 84,000 4c 140,000 4c 16,000 5,000 8 24,000 1 43,000 4a 35,400 27,900 46,800 195,000 4a 60,000 4c 6,400 4c 6,400 4c 6,400 4c 6,400 4c 6,400 4c 6,400 4c 6,400 4c 6,400 4c 45,500 4c 31,500 4c 64,500 4c 75,250 4c 10,000 6 10,000 6 20,000 6 75,000 8 24,000 8 28,834 4c

Page 16: kosmetik pesanan.xlsx

TOTAL tanda

28,834 4c 8,500 4c 17,000 4c 180,000 4c 180,500 4c 66,000 4a 59,000 4a 351,000 4c 42,000 8 38,400 4b 41,000 4b 9,250 4b 15,000 4b 41,000 4c 41,000 4c 40,500 4c 48,000 1,900 8 21,000 8 54,000 4b 137,500 4c 100,000 4c 76,750 4c 138,600 4c 36,600 4c 100,000 4c 15,000 4b 15,000 4b 15,000 4b 15,000 4b 54,000 4a 24,000 4a 32,600 4a 32,000 4a 50,100 4a 68,400 4a 48,000 4a 120,000 8 31,500 20,000 1 16,500 1 7,000 4c 3,500 4c 7,000 4c 3,500 4c 7,000 4c 35,550 4c 31,600 4c 80,000 4a 12,000 95,000 6 100,000 6 11,850 4c 22,250 4c 55,000 4c 42,800 4c 105,000 6 61,200 120,000 8 31,300 4c 19,200 4c 58,850 4c 61,200 4c 57,000 4c 51,000 4c 36,750 4c 131,450 4c 72,000 4c 82,500 4c 11,850 4c

Page 17: kosmetik pesanan.xlsx

TOTAL tanda

172,800 4c 45,000 4c 132,600 57,600 4b 67,200 4b 9,600 4b 57,600 4b 7,500 4b 15,000 4b 31,200 4b 23,400 4b 18,200 4b 35,200 4c 17,600 4c 17,600 4c 19,200 4c 38,400 4c 38,400 4c 36,800 4c 36,800 4c 36,800 4c 36,800 4c 31,350 4b 31,350 4b 21,500 4b 20,900 4b 42,500 4b 51,000 4b 42,500 4b 25,500 4b 42,500 4b 25,500 4b 25,500 4b 35,000 4a 50,000 4a 110,000 4a 16,200 4a 95,200 4a 117,000 4a 31,400 4a 30,000 4a 68,000 4a 140,400 4a 23,400 4a 13,000 2 11,700 4c 69,000 4c 320,000 4c 112,500 4c 132,000 4c 16,000 8 49,000 8 20,000 1 58,500 4c 112,800 2 41,000 2 74,000 2 40,000 8 40,000 8 40,000 8 50,000 4b 43,200 4b 10,500 4b 20,000 4b 21,600 4b 10,000 4b 71,400 4b 20,000 4b 20,000 4b 30,000 4b

Page 18: kosmetik pesanan.xlsx

TOTAL tanda

20,000 4b 18,000 4a 22,000 1 16,000 4d 55,000 4a 156,150 4a 12,700 4c 12,700 4c 12,700 4c 11,100 4c 11,100 4c 11,100 4c 48,000 28,000 221,000 1 5,000 4c 64,000 1 17,000 1 22,000 4a 120,000 5 130,000 5 21,000 2 42,000 2 455,000 4c 10,000 6 10,000 6 754,000 4c 45,000 1 8,500 1 25,000 1 35,000 1 112,500 1 52,500 1 60,000 5 56,000 1 112,800 1 107,000 1 213,750 1 202,200 1 8,500 1 50,000 1 8,000 1 44,000 1 42,000 1 28,800 1 8,000 1 18,000 1 31,500 1 64,000 1 36,000 1 208,000 1 154,000 1 3,000 1 6,000 4c 12,000 5 7,500 4b 32,000 1 12,000 1 32,000 1 57,500 120,000 1 36,000 150,300 4a 40,500 4a 62,500 1 45,000 1 52,500 1 26,750 213,750 5 64,000 4a

Page 19: kosmetik pesanan.xlsx

TOTAL tanda

288,000 4a 8,000 1 24,000 1 265,000 1 16,000 1 10,600 4c 17,000 4c 16,200 4c 150,000 2 23,250 4b 38,400 4b 32,000 4b 10,500 4c 38,000 4c 19,000 4c 19,000 4c 520,000 4a 290,000 4a 34,200 4a 99,750 4a 45,000 8 6,000 8 13,000 4c 54,999 4c 45,000 4c 36,300 4c 28,600 4c 6,500 4c 3,250 4c 23,800 4c 36,000 4b 10,500 4b 14,700 4b 24,500 4c 31,500 4c 37,500 4b 12,000 4b 12,400 4c 6,200 4c 18,125 4c 19,200 4c 7,400 4c 18,500 4c 15,000 4d 95,200 4b 15,500 4c 58,000 4b 87,000 4b 72,500 4b4b 195,000 5 100,000 8 57,500 2 57,500 2 14,500 2 58,000 2 43,500 2 79,380 1 112,455 1 132,300 1 238,140 1 211,680 1 65,000 8 60,000 8 85,800 4a 173,500 4a 28,000 4a 25,000 4a 342,000 2 627,000 2 5,000

Page 20: kosmetik pesanan.xlsx

TOTAL tanda

384,000 4b 74,000 4b 31,500 129,000 1

Page 21: kosmetik pesanan.xlsx

Nama Harga Stok (pcs) TOTAL BETADINE ANTISEPTIC 30 ML 11,700 6 70,200 BETADINE ANTISEPTIC 15 ML 7,100 6 42,600 BETADINE ANTISEPTIC 5 ML 2,510 4 10,040 NORIT 8,000 6 48,000 GELIGA BALSAM 20 GR 4,300 2 8,600 GELIGA BALASM 10 GR 2,100 7 14,700 BODREX MIGRAN 1,320 24 31,680 BODREX EXTRA 1,440 23 33,120 HEROCYN 150 GR 7,800 4 31,200 HEROCYN 75 GR 4,900 1 4,900 MINYAK KAPAK 5 ML 5,900 6 35,400 MINYAK KAPAK 3 ML 3,500 9 31,500 MINYAK ANGIN CAP LANG 5,200 9 46,800 LAXING 1,700 17 28,900 INZA 1,300 45 58,500 DECOLGEN 1,240 12 14,880 FRESH CARE LAVENDER 8,500 8 68,000 FRESH CARE GREEN TEA 8,500 4 34,000 FRESH CARE STRONG 8,500 2 17,000 FRESHCARE SPLASH FRUITY 8,500 2 17,000 HERBORIST AROMA GREEN TEA 8,000 4 32,000 HERBORIST AROMA LEMON 8,000 3 24,000 HERBORIST AROMA PEPPERMINT 8,000 3 24,000 SAFE CARE MINYAK ANGIN 12,000 4 48,000

775,020