ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sari-sari Store Inventory 2021 v 2.1https://espirituatnegosyo.blogspot.com
2
Welcome! This is a nonPOS style of inventory. No barcode making, no clicking cash register, no scanning, no tapping of screen. If you want (optional) you can manually list and tally all sold items daily, then enter it in Nabenta Sheet, which will automatically subtract to all your stocks at hand.
3
Legend:enter data
This Worksheet has lots of examples for you to understand how to use it. You can delete those before using.
4
5
Date End
Gross Income if All is Sold
capture date
6
18-Dec-14PHP 69,439.98fromtono. of daysstocks if soldactual salesdifference
days it could have been sold
probable sales per day
percentagedays differenceadvice
7
1-Nov-15142,879.062-Jan-1815-Feb-1844210,494.60175,853.0034,641.6052.673,996.66119.70%8.67
8
1-Oct-16200,136.992-Jan-1828-Mar-1885386,790.40336,458.0050,332.4097.723,958.33114.96%12.72
lessen inventory of slow moving products
9
1-Jun-17229,216.982-Jan-1830-Apr-18118482,945.90470,310.0012,635.90121.173,985.68102.69%3.17
good keep up, might be a good idea to lessen inventory of expirable products but nonexpirable fast moving products can be stocked up that can be sold at its fad time extent when inflation is continuing
10
1-Jan-18215,266.311-May-1831-Dec-18244858,407.20908,628.75-50,221.55230.513,723.8994.47%-13.49same as below
11
1-Jan-19203,974.782-Jan-1831-Dec-183631,366,473.201,378,938.75-12,465.55359.723,798.7399.10%-3.28
tsk tsk di ka nagstock moderately ng mga fast moving natakot ako maexpiran na naman
12
1-Jan-20140,932.281-Jan-1931-Aug-19242868,261.30836,714.9331,546.37251.123,457.50103.77%9.12balik na sa dati
13
1-Jan-2142,524.54running
14
TotalPHP 1,244,370.92
15
16
10.96%
Mark Up Average
17
PHP 307.94
Gross Profit Per Day
18
PHP 112,396.78
Gross Profit Per Year
legend of inventory days average multiplier:
19
105.78%
Inventory Days Average Multiplier
100%
perfect inventory
20
483.28%IDAM 2021
greater than 100%
good inventory, in excess of what can be sold
21
less than 100%
lacks inventory, could result to loss opportunity/sales
22
start date12/18/2014
23
end date1/10/2026
1. Because we don't have a Point of Sales it is safe to assume at 100% perfect inventory that we already earned the gross income because all inventory is sold. The same is true if you have less than 100%
24
# of days4041
2. But we hardly hit 100%, so inventories are either lacking or in excess that adds up to the next additional inventory days
25
3. Stocking in excess advantage: If you will inspect probable sales per day column the ones that has positive inventory in days difference column (meaning excess) has a higher PhP200 per day sales except for Jan 2019
26
4. Even though the sales trend from 2018-2019 is decreasing, you never know when the people will buy so better stock up but not so much
27
28
29
30
Top Twenty Earning ProductsEarnings Per Dealer
31
Row Labels
Sum of total tubo
Row Labels
Sum of total tubo
32
Load (0.11205)5,412.02J&J7,415.00
33
Mt. Dew plastic small 12s2,961.00Beejay5,747.02
34
Coke mismo2,444.00puregold5,034.10
35
Nature's Spring 350ml 40s
1,710.00nestle4,915.11
36
Harina Tercera1,240.00pepsi3,851.00
37
Eco bag small900.00thoch2,330.51
38
Asukal Washed890.00unilever2,255.26
39
Le Mineral 600ml756.00kopiko1,902.00
40
Milo 22g twin692.17argentina1,675.91
41
Asukal Brown570.00oyt1,467.31
42
Chuckie 110ml557.38luckyme1,447.48
43
Bear Brand 33g532.82deleon1,198.75
44
Bear Brand 320g483.80le mineral756.00
45
C2 solo 24s480.96kendihan530.00
46
Breeze powder399.00roaving ahente500.00
47
Nescafe 25g397.18carpio359.00
48
Kopiko Café blanca twin385.00delmonte339.11
49
Coke mini375.00datu304.85
50
Energen choco/vanilla 10s
359.00silverswan211.14
51
Great Taste 3n1 choco twin
328.75aji196.00
52
Grand Total21,874.07taiwanese89.00
53
Grand Total42,524.54
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