WA, LIFO and FIFO Blank.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1				//
2		Purchase			Sales			Cost of Goods Sold			Closing stock
3		Quantity	Unit Cost (RM)	Total	Quantity	Unit Cost (RM)	Total	Quantity	Unit Cost (RM)	Total	Quantity	Unit Cost (RM)	Total
4
5	2-Mar
6
7
8	6 Mar	70	675	47,250							70	675	47,250	/
9
10
11	8 Mar				50	800	40000	50	675	33750	20	675.00	13,500	/
12
13											20	675.00	13,500	/
14	16-Mar	90	650.00	58,500							90	650.00	58,500
15
16								20	675	13,500
17	30-Mar				50	860	43000	30	650	19,500	60	650.00	39,000	/
18
19
20
21				105,750			83,000			66,750			39,000
22
23					FIFO		83,000
24							66,750
25						Gross Profits	16,250	/
26
27
28
29
30
31
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