Inventory Sim
AZ
March
Prodn Plan
Shipment Plan
Total Balance
Remaining Finished Goods (Ideal)
325.66
April-
May
May
June
-
July
-
-
August
-
-
September-
-
October-
November-
-
December-
-
January
September
October
November
December-
January
-
February-
-
March-
-
February-
March-
(200.50)
-
GA
Prodn Plan
Shipment Plan
Total Balance
Remaining Finished Goods (Ideal)
March
481.23
April-
-
TTL
806.89
1094.40
March
Beginning Inventory
Ending Inventory
Diff
Actual Result
TTL Amount (Php)
Ending Inventory (WIP)
Ending Inventory (FG)
Yen
TTL
Beginning Inventory
Diff
WIP ($)
WIP (Yen)
FG ($)
FG (Yen)
TTL
April-
(10.12)
-
May
June-
-
June
July
August
-
-
July
-
(20.78)
-
-
-
433
675
-
-
734
937
-
740
774
-
2325.94
3010.09
1824.49
August-
(18.07)
September-
October-
(33.87)
November-
December-
(1.54)
January-
(12.27)
February-
March-
March
March
1,351,106
8,822,-,789,558
April
3,628,864
11,061,-,907,381
May
4,136,368
19,940,-,690,308
June
2,233,041
14,545,-,416,167
July
2,020,585
10,745,-,085,925
August
1,798,325
19,182,-,157,537
September
1,710,183
10,848,-,378,260
October
3,042,584
24,858,-,661,479
November
2,982,383
20,382,-,168,754
December
3,134,130
20,198,-,566,123
January
1,514,354
26,775,-,576,801
February
2.20
March
April
73,015.37
8,108,-
May
82,943.01
9,224,-
June
44,244.91
4,979,-
July
39,948.31
4,445,-
August
35,554.07
3,956,-
September
33,486.88
3,728,-
October
58,737.14
6,678,-
November
59,209.52
6,538,-
December
62,783.05
7,086,-
January
30,335.61
3,424,-
February
63,947.29
6,956,-
222,-,828,-
399,-,466,-
288,-,436,-
212,-,640,-
379,-,201,-
212,-,650,-
479,-,568,-
404,-,686,-
404,-,674,-
520,-,778,-
334,-,379,-
32.94
53.69
37.42
28.09
46.16
27.38
61.25
51.22
52.76
62.20
43.34
2.20
March
81,015.55
8,813,-
(5,733.53)
(623,751.24)
(0.62)
8.19