UTS APSI5_FIRDAUS ROHMAH ALAMUDI_4420210026.xlsx

	A	B	C	D	E	F	G	H	M	N	O	P	Q
1	[Purchase Requisition]			PURCHASE REQUISITION					FORMAT PR :
2									No	Nama Data	Tipe	Contoh Format	Statis/Dinamis
3	PR00054			PT. SINAR PRATAMA PELANGI					1	Judul Form	Character	PURCHASE REQUISITION	Statis
4									2	No PR	Numerik	54	Dinamis, setiap nomer PR akan berurut
5	Responsible	:	Requestor		Date	:	24/4/2022		3	Tanggal	Date	24/4/2022	Dinamis, berganti setiap berganti tanggal
6	Requisitioning Dept	:	Sales		Date Needed	:	26/4/2022		4	Responsible	Character	Requestor	Statis
7	Charging Dept	:	Administration		Purpose	:	Office Supplies		5	Requisitioning Dept	Numerik	Sales	Dinamis, karena bisa berubah
8	Currency	:	IDR						6	Purpose	Character	Office Supplies	Dinamis, tergantung tujuan request
9									7	Unit Price	Numerik	3500	Dinamis, jika ada kenaikan harga
10	ITEMS #	DESCRIPTION			QTY AVAILABLE	REQUEST QTY	UNIT PRICE	TOTAL	8	Description	Character	Lampu LED	Statis
11	WC1921	LAMPU LED			10	6	Rp7.200,00	Rp43.200,00	9	Quantity	Numerik	10	Dinamis, tergantung stok persediaan
12	WF1728	KERAN AIR			10	7	Rp3.500,00	Rp24.500,00	10	Items	String	WF1728	Statis
13	WC1376	KABEL TIS			10	8	Rp2.000,00	Rp16.000,00	11	Total	Numerik	15807000	Dinamis, tergantung total pembelian
14	WC1721	PARALON			10	4	Rp15.000,00	Rp60.000,00
15								-
16								-
17								-
18								-
19								-
20								-
21								-
22								-
23								-
24								-
25								-
26					[42]		SUBTOTAL	Rp143.700,00
27	Other Comments or Special Instructions						TAX RATE	10%
28							TAX	Rp14.370,00
29							S & H	0
30							OTHER	0
31							TOTAL	Rp158.070,00
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100