Transcript
Calculaton of Firs Year Break Even Poins Noe
M1
M2
Jan
M3
Feb
M4
Mar
Ar
Stores
1
1,200
1,200
1,200
1,200
Mulply by 200 carts Total Carts Mulply by Revenue per cart !oal "evenues
3 3 1 1
240,000 240,000 67! 1#$2%#%%%
240,000 480,000 67! 3#24%#%%%
240,000 720,000 6 7 ! 4#&$%#%%%
240,000 960,000 6 7 ! $#4&%#%%%
"#or$aon %2 year S&'(
2
746,400
746,400
746,400
746,400
)r*nn+ Replace#ent %even *str*buon(
3 4
26,400 7!,960
!2,800 7!,960
79,200 7!,960
132,000 7!,960
Cart Rental %10- Revenue( M.t+ Sales / Co##
! 6
162,000 861,000
324,000 861,000
486,000 861,000
648,000 1,!90,000
rocery Store peraons !oal 'C
7
840,000 2#*11#*
%$840,000 2#+%%#1
%$840,000 3#%&,
%$960,000 4#1,2#3
%$%1,091,760( %4!!(
339,840 071
1,771,440 246
2,327,640 242
'ariable Coss ('C)
Contr*buon Mar+*n %CM( CM per n*t&Cart
Fi-e. Coss (FC)
"ccounn+ / "u*t
8
6,000
6,000
6,000
6,000
"vers*n+ %even *str*buon( "uto 'ease
9 10
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
an. Car+es 5nterta*n#ent / )ro#oon nsurance
11 12 13
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
'e+al
14
10,000
10,000
10,000
10,000
Mana+e#ent ees
1!
24,167
24,167
24,167
24,167
ce / Sunry )ubl*c Relaons
16 17
!,000 33,333
!,000 33,333
!,000 33,333
3,000 33,333
Rent Salar*es / enets Staonary / )r*nn+
18 19 20
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
Telepone / a: Travel / "cco##oaon !oal FC
21 22
3,!00 10,000 1&$#*%&
3,!00 10,000 1&$#*%&
3,!00 10,000 1&$#*%&
3,!00 20,000 1+4#*%&
2#&+$&
3#%&$#&$&
3#2*,#2$&
4#34*#%$&
(1#2*$&)
1,3#132
1#,&4#*32
2#132#+32
!oal E-enses ('C / FC)
Ne 0eratn ncoe Break Even Poin in ers of cars Break Even Poin in ers of sores
M,
M$
Ma
M*
Jun
M&
Jul
M+
Au
5e
M1%
M11
M12
1s
0c
Nov
6ec
Year
1,200
1,200
1,200
1,200
1,200
1,200
1,200
1,200
14,400
240,000 1,200,000 6 7 ! %% #1%%#% #%% %%
240,000 1,440,000 67! +#*2 +#*2% %#%%% #%%%
240,000 1,680,000 6 7 ! 11#3 11#34 4%#%% %#%%% %
240,000 1,920,000 6 7 ! 12#+ 12#+$% $%#% #%%% %%
240,000 2,160,000 67! 14#, 14#,&% &%#% #%%% %%
240,000 2,400,000 67! 1$#2 1$#2%% %%#% #%%% %%
240,000 2,640,000 67! 1*#& 1*#&2% 2%#% #%%% %%
240,000 2,880,000 6 7 ! 1+#4 1+#44 4%#%% %#%%% %
2,880,000 2,880,000 6 7 ! 12$# 12$#3 3$%#% $%#%%% %%
746,400
746,400
746,400
746,400
746,400
746,400
746,400
746,400
8,9!6,800
1!8,400 7!,960
184,800 7!,960
211,200 7!,960
237,600 7!,960
264,000 7!,960
290,400 7!,960
316,800 7!,960
343,200 7!,960
2,296,800 911,!20
810,000 1,!90,000
972,000 1,!90,000
1,134,000 2,319,000
1,296,000 2,319,000
1,4!8,000 2,319,000
1,620,000 3,048,000
1,782,000 3,048,000
1,944,000 3,048,000
12,636,000 23,4!4,000
960,000 4#34%#*
%$960,000 4#,2+#1
%$1,080,000 ,#,$$#,
%$1,080,000 ,#*,4#+
%$1,080,000 ,#+43#3
%$1,200,000 $#+&%#*
%$1,200,000 *#1$+#1
%$1,200,000 *#3,*#,
%$12,240,000 $%#4+,#12%
3,7!9,240 313
!,190,840 360 360
!,773,440 344
7,20!,040 37!
8,636,640 400
9,219,240 384
10,6!0,840 403
12,082,440 420
6!,864,880 2287
6,000
6,000
6,000
6,000
6,000
8,000
8,000
8,000
78,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
39,37! 2,000
472,!00 24,000
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
167 10,000 8,333
2,000 120,000 100,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
120,000
24,167
24,167
24,167
24,167
24,167
24,167
24,167
24,167
290,000
3,000 33,333
3,000 33,333
4,000 33,333
4,000 33,333
4,000 33,333
!,000 33,333
!,000 33,333
!,000 33,333
!1,000 400,000
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
10,000 24,000 833
120,000 288,000 10,000
3,!00 20,000 1+4#*%&
3,!00 20,000 1+4#*%&
3,!00 30,000 2%,#*%&
3,!00 30,000 2%,#*%&
3,!00 30,000 2%,#*%&
3,!00 4!,000 223#*%&
3,!00 4!,000 223#*%&
3,!00 4!,000 223#*%&
42,000 31!,000 2#432#,%%
4#,3,#4$&
4#*23#&$&
,#**2#2$&
,#+$%#$$&
$#14+#%$&
*#2%4#4$&
*#3+2#&$&
*#,&1#2$&
$2#+2*#$2%
3#,$4#,32
4#++$#132
$#+++#332
+%#+32
1%#42*#132
11#&,*32
$3#432#3&%
,#,$*#*32
++,#,32
1%$#3$3 ,32
Calculaton of Firs Year Break Even Poins 1s
2n.
8r
8r
3r.
47
1s
8r
8r
Year
3,600
7,200
10,800
14,400
14,400
720,000 720,000 9,720,000 +#*2 +#*2%# %#%% %%% %
1,440,000 1,440,000 24,300,000 24#3 24#3%% %%#% #%%% %%
2,160,000 2,160,000 38,880,000 3& 3&&% &%#% #%%% %%
2,880,000 2,880,000 !3,460,000 ,3#4 ,3#4$ $%#%% %#%%% %
2,880,000 2,880,000 126,360,000 12$# 12$#3$ 3$%# %#% %%%
2,239,200
2,239,200
2,239,200
2,239,200
8,9!6,800
1!8,400 227,880
47!,200 227,880
712,800 227,880
9!0,400 227,880
2,296,800 911,!20
972,000 2,!83,000
2,430,000 4,770,000
3,888,000 6,9!7,000
!,346,000 9,144,000
12,636,000 23,4!4,000
2,!20,000 *%%#4&%
2,880,000 13#%22#2&%
3,240,000 1*#2$4#&&%
3,600,000 21#,%*#4&%
12,240,000 $%#4+,#12%
1,019,!20 142
11,277,720 783
21,61!,120 1001
31,9!2,!20 1109
6!,864,880 2287
18,000
18,000
18,000
24,000
78,000
118,12! 6,000
118,12! 6,000
118,12! 6,000
118,12! 6,000
472,!00 24,000
!00 30,000 2!,000
!00 30,000 2!,000
!00 30,000 2!,000
!00 30,000 2!,000
2,000 120,000 100,000
30,000
30,000
30,000
30,000
120,000
72,!00
72,!00
72,!00
72,!00
290,000
1!,000 100,000
9,000 100,000
12,000 100,000
1!,000 100,000
!1,000 400,000
30,000 72,000 2,!00
30,000 72,000 2,!00
30,000 72,000 2,!00
30,000 72,000 2,!00
120,000 288,000 10,000
10,!00 30,000 ,$%#12,
10,!00 60,000 ,&4#12,
10,!00 90,000 $1*#12,
10,!00 13!,000 $*1#12,
42,000 31!,000 2#432#,%%
+#2$%#$%,
13#$%$#4%,
1*#&&2#%%,
22#1*$%,
$2#+2*#$2%
4,+#3+,
1%#$+3#,+,
2%#++*#++,
31#2&1#3+,
$3#432#3&% 1%$#3$3 ,32
5ock
9 of
Fir
!icker
5ores
Nae
S;<
2,200 Sa=e>ay
S? )r*vate "@RA<
2,012 Supervalu 1,300 "l* 1,214 "olB@ela*$e
)r*vate R
1,148 )ubl*: 782 ro+er
)r*vate ;M
690 *B'o 466 ;ole oos Mar.et
)r*vate )r*vate ")TG )r*vate
46! 340 300 23!
)r*vate MT" S)TA
210 Save Mar 200 n+les 1!0 Aas *nc
RA@< )r*vate
148 RounyEs 100 ;*nco oos
)r*vate
90 ;e+#anEs
Total
!oal 9 of 5ores
12,0!0
241%%
Traer DoeEs F5 reat "tlanc / )ac*c Tea Co FyB?ee