A)
Building Investment (1800 sq. ft.) : Rs. 100 per sq. ft. Underground godown(@ Rs. 25 per sq. ft.)
B) C)
Fixed Furniture Initital office investment Total A Initial Stock Total B
200,000.00 100,000.00 525,000.00 900,000.00 900,000.00
Working Capital
600,000.00 600,000.00
Total C D)
Development costs : a) Colour and Painting b) Electricity fitting Total D
E)
150,000.00 200,000.00 350,000.00
Other investments : Open display rerigerator ( One, 12' x 6') Freezer Computer (3, two for store, 1 for godown) Air Conditioner (5 units) Close Circuit T. V (8 units) Application software Display racks Vegetable racks Crates Baskets Bar code machine(1) Scanner(2, one for godown, one for store) Printer(2, one for godown, one for store) Weighing scale Auto Advertisement expenditure
Total E F)
180,000.00 45,000.00
400,000.00 100,000.00 75,000.00 125,000.00 100,000.00 50,000.00 300,000.00 25,000.00 20,000.00 20,000.00 20,000.00 4,000.00 36,000.00 25,000.00 120,000.00 100,000.00
1,520,000.00
Employee salaries : i) Store Cashier (1) Weighing person(1) Sales person (4) Helper(3) Gateman Auto driver Total i ii) Godown
5,000.00 5,000.00 20,000.00 9,000.00 3,000.00 3,000.00 45,000.00
Accountant(1) Computer operator(1) Labour (5) Total ii Total F
10,000.00 5,000.00 15,000.00 30,000.00 75,000.00
Intial Investment Furniture Office Expences Intial store and godown investment* Motor expenditure**
*Colour and Painting *Electricity fitting *Open display rerigerator ( One, 12' x 6') *Freezer *Computer (3, two for store, 1 for godown) *Air Conditioner (5 units) *Close Circuit T. V (8 units) *Application software *Display racks *Vegetable racks *Crates *Baskets *Bar code machine(1) *Scanner(2, one for godown, one for store) *Printer(2, one for godown, one for store) *Weighing scale
200,000 100,000 1,650,000.00 120,000
150,000.00 200,000.00 400,000.00 100,000.00 75,000.00 125,000.00 100,000.00 50,000.00 300,000.00 25,000.00 20,000.00 20,000.00 20,000.00 4,000.00 36,000.00 25,000.00 1,650,000.00
Purchases (fruits & vegetables) Purchases (Grossary)
Tot Purchases (fruits & vegetables) Purchases Fixed Costs: Rent of building Underground godown Depriciation on furniture * Depriciation on operational equipments ** Depriciation on office equipments *** Depriciation on vehicle **** Salary # Total fixed cost
Variable Costs: Telephone charges Electricity bill Fuel Stationary Maintainance Misc.
Total variable cost Total cost
* 2,00,000/10 = 20,000 ** 16,50,000/10 = 1,65,000 *** 1,00,000/10 = 10,000 **** 1,20,000/10 = 12,000
Employee salaries
#
i) Store Cashier (1) Weighing person (1) Sales person (4) Helper (3) Gateman
Auto driver Total i ii) Godown Accountant (1) Computer operator (1) Labour (5) Total ii Total
8800000 3200000 12000000
l Cost 8800000 3200000 2,160,000 540,000 20,000 165,000 10,000 12,000 900,000 15,807,000 ##
48000
##
480000
##
36000
##
14400
##
24000
##
42000
##
644400
##
16,451,400
## ## ## ## ## ## ##
:
## ##
5,000.00 5,000.00 20,000.00 9,000.00 3,000.00
###
3,000.00 45,000.00 10,000.00 5,000.00 15,000.00 30,000.00 75,000.00
Initial Investment Furniture
200,000
Office expences
100,000
Intial store and godown investment ##
1,650,000
Motor expenditure ### Advertisement expenses Total
120,000 100,000 2,170,000
Colour and painting
150,000.00
Electricity fitting
200,000.00
Open display rerigerator ( One, 12' x 6')
400,000.00
Freezer
100,000.00
Computer (3, two for store, 1 for godown)
75,000.00
Air conditioner (5 units)
125,000.00
Close circuit T. V (8 units)
100,000.00
Application software Display racks
50,000.00 300,000.00
Vegetable racks
25,000.00
Crates
20,000.00
Baskets
20,000.00
Bar code machine(1)
20,000.00
Scanner(2, one for godown, one for store)
4,000.00
Printer(2, one for godown, one for store)
36,000.00
Weighing scale
25,000.00
Total
###
Auto
120,000.00
Revenue (est.) Fruits and vegetables turnover Grossary turnover Total turnover *Profit before tax
16,425,000 5,475,000 21,900,000 5,448,600
* Profit = Total Total turnover - Total Total cost
Payback Period Initial investment Payback Period ( in years) Payback Period ( in months) Payback Period ( in days)
2,170,000 0.40 5 145
*Reliance fresh **Fresh N Green ***National h an andloom Total
3,080,000 2,200,000 3,520,000 ###
Year 2006 2007 2008 Total
Fresh N Green Nil Nil 18250000
Estimated sales
a= b=
Year 2006 2007 2008 2009 2010 2011
2009 2010 2011
24536111.11 304166.67
Purchase 17793750 19162500 18250000 18858333.33 19086458.33 19314583.33
Reliance Fr Fresh Naitonal Ha Handloom Avgerage sa sales (Y (Y) Nil 23725000 23725000 Nil 25550000 25550000 25550000 29200000 24333333.33 73608333.33
Sales 24231944.44 24536111.11 24840277.78 25144444.44 25448611.11 25752777.78
X -1 0 1 0
X2 1 0 1 2
XY -237 -23725 2500 000 0 0 ## # 608333.33
Y C = a+bx 242 4231 3194 944. 4.4 44 24536111.11 24840277.78
25144444.44 25448611.11 25752777.78
