Wednesday, 16 May 2012

BUDGET


First year:
Month 
1
2
3
4
5
6
7
8
9
10
11
12

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEPT
OCT
NOV
DEC
Start-up


123,600









TV adverts


4,500
3,500
 3,500





2,000
 2,000
Flyers


2,500
 1,500
1,500





1,000
1,000
Opening Night


1,400









Print menu


 6,000
3,000
3,000





1,500
1,500
Total


138,000
8,000
 8,000





4,500
 4,500

Second year:
Month 
1
2
3
4
5
6
7
8
9
10
11
12

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEPT
OCT
NOV
DEC
Sales


53,377
53,377
53,377




65,700
65,700
72,000
Meals


 21,721
 21,721
21,721




 34,650
34,650
42,000
Beverages


 11,656
11,656
 11,656




22,100
22,100
 22,150
Others


20,000
20,000
20,000




8,950
8.950
7,850
Food Cost


10,675
10,675
10,675




13,140
13,140
14,400
Utilities


8,000
8,000
 8,000




9,500
9,500
 9,800
Rent


13,000
13,000
13,000




 13,000
13,000
13,000
Net Profit


 21,702
21,702
 21,702




30,060
30,060
34,800














Third year:

Month 
1
2
3
4
5
6
7
8
9
10
11
12

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEPT
OCT
NOV
DEC
Sales


73,496
73,496
73,496




95,674
95,674
100,700
Meals


 55,600
55,600
55,600




58,994
58,994
56,755
Beverages


30,000
30,000
 30,000




33,400
33,400
 43,210
Others


12,104
12,104
12,104




3,280
3,280
735
Food Cost


14,699
14,699
14,699




19,134
19,134
20,104
Utilities


8,700
 8,700
8,700




9,200
9,200
 9,800
Rent


13,000
13,000
 13,000




 13,000
13,000
13,000
Net Profit


 37,097
37,097
 37,097




54,340
54,340
57,760

No comments:

Post a Comment