ID A001 A002 A003 A004 A005
NAMA LAPTOP TOSHIBA ACER DELL HP ASUS
MEREK INTEL(N) CORRE I3 CORRE I7 INTEL (R) CORRE I3
PRESSU $ 450.00 $ 550.00 $ 1,000.00 $ 400.00 $ 500.00
ID NAMA LAPTOP MEREK PRESSU UNIT TOTAL
A001 TOSHIBA INTEL(N) $ 450.00 4 $ 1,800.00
A002 ACER CORRE I3 $ 550.00 1 $ 550.00
A003 DELL CORRE I7 $ 1,000.00 6 $ 6,000.00
A004 HP INTEL (R) $ 400.00 10 $ 4,000.00
A005 ASUS CORRE I3 $ 500.00 3 $ 1,500.00
A006 ASUS CORRE I3 $ 500.00 2 $ 1,000.00
NARAN SASAN KODE PRODUK GRAM PRESSU NORMAL
KOMPUTER KRG003 302 450
MEJA KRG004 303 50
KADEIRA KRG005 304 26
MONITOR KRG006 305 50
KEYBOARD KRG007 306 10
MOUSE KRG008 307 5
NARAN SASAN KODE PRODUK GRAM PRESSU NORMAL
KOMPUTER KRG007
FORMULA SASAN TAMA HO SAI NIAN HANESAN DEIT
1-SUMIF(BLOK KODE SASAN,KODE,TOTAL
KODE PRODUK NARAN SASAN STOK HAHU TAMA SAI
A001 KOMPUTER $ 100.00 5 6
A002 MEJA $ 100.00 3 1
A003 KADEIRA $ 100.00 7 9
STOK AKIR
30
3
63
TAMA
TANGAL KODE PRODUK NARAN SASAN TOTAL
1-Jan A001 KOMPUTER 5
2-Jan A002 MEJA 3
3-Jan A003 KADEIRA 7
SAI
TANGAL KODE PRODUK NARAN SASAN TOTAL
1-Jan A001 KOMPUTER 6
2-Jan A002 MEJA 1
3-Jan A003 KADEIRA 9