A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
7 | Saving Calculator | ||||||
8 | |||||||
9 | Net Saving due purchase though deep discount hub is | ₹60,755 | In Rs. | ||||
10 | Net time saved ( In Hrs.) due purchase though deep discount hub is | 2 | In. Hrs. | ||||
11 | Purchase Value for Brick & mortor Shop ( mall/kirana shop) | ||||||
12 | Grocery ( MRP) | 250,000 | Total value of grocery item purcased | ||||
13 | Avg. Discount on above purchase ( if any) | 1.00% | Mention dicount in % | ||||
14 | Transportation Using Auto | 1 | Auto/Taxi charge sent to reach shop/mall etc in Rs. | ||||
15 | Parking cost | 20 | Put parking cost if any in Rs. | ||||
16 | Your monthly salary ( in INR) | 100,000 | Required to calculate your time cost | ||||
17 | Time (in hrs) you work per day to earn | 6 | Required to calculate your time cost | ||||
18 | Nos of days you work in month | 26 | Required to calculate your time cost | ||||
19 | Total time ( in Hrs) sent for purchase above grocery | 2 | Required to calculate your time cost | ||||
20 | Cost of fuel | 70 | Cost of fuel per liter ( Rs/ Ltr) | ||||
21 | Fuel Avarage of vehical | 15 | Avarage fuel consumption per Km ( Km/Ltr.) | ||||
22 | Total distance travelled | 40 | Total distance from home to mall/shop and back ( in Km) | ||||
23 | Other-1 | 0 | Any other cost in Rs | ||||
24 | Other -2 | 0 | Any other cost in Rs | ||||
25 | Other-3 | 0.00 | Any other cost in Rs | ||||
26 | ( leave black if zero) | ||||||
27 | |||||||
28 | |||||||
29 | |||||||
30 | |||||||
31 | |||||||
32 | |||||||
33 | |||||||
34 | |||||||
35 | |||||||
36 | |||||||
37 | |||||||
38 | Summary of saving | ||||||
39 | Mortar Shop | ₹248,254.65 | |||||
40 | D D Hub | ₹187,500.00 | |||||
41 | Net Saving | ₹60,754.65 | |||||
42 | Do not change any value beyond this ... | ||||||
43 | Expense Comparision | Purchase from shop | Purchase from deep discount hub | Remark | |||
44 | Discount | 1% | 25% | Asumming Minimum discount of 25% | |||
45 | Actual Cost of Grocery | ₹247,500.00 | ₹187,500.00 | ||||
46 | Transportation Using Auto | ₹0.00 | ₹0.00 | auto charge sent to reach shop/mall etc | |||
47 | Transportation Using Own Vehical | ₹33.50 | ₹0.00 | Cost of transportation | |||
48 | Parking cost | ₹0.00 | ₹0.00 | Put parking cost if any | |||
49 | Time cost | ₹721.15 | ₹0.00 | cost of time. | |||
50 | Other-1 | ₹0.00 | ₹0.00 | Any other cost | |||
51 | Other -2 | ₹0.00 | ₹0.00 | Any other cost | |||
52 | Other-3 | ₹0.00 | ₹0.00 | Any other cost | |||
53 | |||||||
54 | Time cost | 1282 | |||||
55 | Cost of per Hour | 641 | |||||
56 | |||||||
57 | Transportation Cost | ₹187 | |||||
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 | |||||||
101 | |||||||
102 | |||||||
103 | |||||||
104 | |||||||
105 | |||||||
106 |