Compagnie du Froid, S.A. Harvard Business School Case #197-0! Case So"$are %&S-10'
Cop(righ ) *010 +residen and Fello$s Fello$s o" Harvard College. o par o" his produc ma( e reproduced, sored in a rerieval s(sem or ransmied in an( "orm or ( an( meanselecronic, mechanical, phoocop(ing, recording or oher$ise$ihou he permission o" Harvard Business School.
&'ibit 2 4renc Re&ion, *009 Results Proft Plan
Sales Data Sales ice-cream (volume in litres) Sales specialties (litres) Revenue rom !istri"ution Total Sales Cost o Goods Sold
A
Volume
Euros
('000)
('000)
5rice per unit
Volum e ('000)
4,010 445 4,455
### 17,879 9.99% 3,661
### 4,618 405 ###
###
5,023
2,887 1,844 38.29
7,893 *,8+1 371
### 3,317 ### 2,047 ### 43.56
410 316 40.03
1,1*1 693 388
368 ### 298 ### ### 36.02
ost ice-cream $air% in&re!ients (litres) ter in&re!ients (100 &r) a"or (ours) ost specialties $air% in&re!ients (litres) ter in&re!ients (100 &r) a"or (ours) otal Contribution margin
8,233
Oter Costs Supervision, ener&%, maintenance,
*,*06
$epreciation
+67
O!erating margin
","$
Selling and Administrati%e &'!enses $eliver% e.penses
861
$epreciation o truc/s
07
Sellin& e.penses
1,078
!vertisin&
1,1+1
!ministrative salaries an! e.penses
788
llocate! central o2ce e.penses
18
Profts beore (nterest and Ta'es
),$2*
(dentifable Assets as (avera&e)
9+
ccounts Receiva"le (avera&e)
80
5lant an! euipment (net o !epreciation
+,713
Total identifable assets
",38*
Conditions or tourism vera&e summer temperature
Actual Quantity Variance Actual Mix Variance Actual Price Variance Variable !"t Variance Fixe# !"t Variance
*98
€ 1,049.68 F € 14.19 U € 460.75 U € 144.75 U € $15.00 U
*9*
%e&'erature Variance
€
$57.5$ F
ctual Euros ('000)
5rice per unit
+le' to Actual uantit le' to Actual .i
7arianc e
*,1*6 (*8+) 79 ),/2)
4 4 +
9,1+* *76 (1,*+9) 3,186 16 (3+) +38 ### (67)
*0,00 +33 3,377 83+ 79 ###
*0,18* +,1*777
*0,8983 3,3319*
21,282/
0
23,/2)*"
8,8993+ 3,*03** +1830
9,06861 3,1376 +**06
0
),$)" *76 6 **0 36* ###
106 38 *6
4 4 4
1,*639* 78136 +37+7 1,00361
1,00617 633 3+913 1+,63*
8,3
13$
+
0
/,2828
0
/,28"$
*,3*+
(118)
*,*0600
*,*0600
+67
+6700
+6700
",8*2
3)2
,$/8
0
,"/""$
+
0
-
-
908
(+7)
86100
86100
10
(3)
0700
0700
1,139
(61)
1,07800
1,07800
1,070
71
4
1,1+100
1,1+100
810
(**)
78800
78800
193
(3)
1800
1800
),212
2)"
+
0
2,$*8
0
2,$2"$
1+1
(+7)
63+
(+)
+,7*6
(13)
","$)
4)1)5
6
le' to Actual Price le' to 7ariable Cos e' to +i'ed Co Tem!erature 7ariance
*0,0000 3,37700 7900 0 23,1)$$
Volume
/uros
('000)
0002
0
*0,0000 3,37700 7900 23,1)$$
0
*0,0000 3,37700 7900 23,1)$$
+76+ +171
9,06861 3,1376 +**06
9,1+*00 3,18600 +3800
9,1+*00 3,18600 +3800
3,'17 *,10 '!
9+16*6 3*818 +11+
1,00617 633 3+913 1+,63*
1,0100 600 36*00 1+,79800
1,0100 600 36*00 1+,79800
379.0' 304.9' 37.10
10++ 67+6 37*86 ###
0
8,8$**"
0
8,3$$
0
8,3$$
###
*,*0600
*,*0600
*,3*+00
*,3*+
+6700
+6700
+6700
+67
0
,)31*"
0
",//$$$
0
",8*2$$
###
86100
86100
90800
908
0700
0700
1000
10
1,07800
1,07800
1,13900
1139
1,1+100
1,1+100
1,07000
1070
78800
78800
81000
810
1800
1800
19300
193
0
),$)*"
0
),1"*$$
0
),212$$
###
### ### 7900 ###
xibit 4 Spanish ;egion, *009 ;esuls Pr!(it Plan
)ale" *ata Sales ice-cream volume in lires2 Sales specialies lires2 %!tal )ale" !"t !( +!!#" )!l#
Ac
Volume
/uros
('000)
0002
Volume +rice per uni ('000)
3,685 90.01% 14,*9' 5 '.'* 409 9.99% 3,330 5 .1' 19,6$4 4,094
3,975
6air( ingrediens lires2 her ingrediens 100 gr.2 &aor hours2 Cos specialies
2,653 1,769 34.37
4,9*3 5 3.1 *,470 5 1.' *79 5 9.!!
2,175 1,450 29.21
6air( ingrediens lires2 her ingrediens 100 gr.2 &aor hours2 !ntributi!n &arin
381 299 37.09
99' 433 301 7,8$4
362 275 34.73
3,575 400
Cos ice-cream
5 *.7! 5 *.30 5 .47
-ter !"t" Supervision, energ(, mainenance, ...
*,1'!
6epreciaion
391
8rans"er "rom France
/
-'eratin &arin
5,$88
)ellin an# A#&ini"tratie x'en"e" 6eliver( epenses
734
6epreciaion o" ruc:s
'13
Suconraced ransporaion
-
Selling epenses
*7
Adverising
1,'04
Adminisraive salaries and epenses
4*0
;en
100
Allocaed cenral o""ice epenses
1!
Pr!(it" be(!re 2ntere"t an# %axe"
1,0$8
2#enti(iable A""et" Cash average2
9'
Accouns ;eceivale average2
'*3
+lan and e
',74'
%!tal i#enti(iable a""et"
5,$81
!n#iti!n" (!r t!uri"& Average summer emperaure
Actual Quantity Variance Actual Mix Variance Actual Price Variance Variable !"t Variance
30.*= C
€ $,36$.68 U € 1,803.01 F € 306.34 U € 1,966.00 F
*.!= C
Fixe# !"t Variance %e&'erature Variance
€ $,$77.00 U € $67.7$ F
ual
Variance
/uros
' to Actual uanti
+le' to Actual .i'
Price per unit
0002 1!,!07 € 4.34 3,*!1 € 8.13 18,758
772 792 866
> > U 0
1,8*038 3,*33*1 )/,$"3"/
0
1,80761 3,*67* )/,$131
!,407 € 2.58 *,*0* € 1.52 *3 € 8.15
1,314 '4 '1
F F F
8,19901 3,16*7* 3187+
6,9*300 *,67000 *7900
933 € 2.58 !71 € 2.08 *3 € 8.15 8,9$4
41 4* 1 1,100
F F F F
1,0176 7971 9888
99+00 63300 30100
0
",1)32
0
*,2131
*,144
*12
>
*,1+00
*,1+00
391
/
39100
39100
*,1*4
*,1*42
> -
4,$41
1,047
U 0
2,/2"32
7!
**2
>
73600
73600
'*'
112
>
+1300
+1300
77
772
> -
74
'1
F
8*700
8*700
1,'0
*2
>
1,+0600
1,+0600
4''
*'2
>
6*000
6*000
100
-
10000
10000
193
3!2
>
1800
1800
149
1,177
4),33185 0
1831
9
'2
*44
1!4
',37
732
5,$01
80
U
0
0
1,*2831
-
le' to Actual Pric le' to 7ariable Cos +le' to +i'ed Cost Tem!erature 7ariance Volume
/uros
('000)
0002
0
1,0700 3,*100 )8,*"8$$
0
1,0700 3,*100 )8,*"8$$
0
1,0700 3,*100 )8,*"8$$
368** +1*
### ### ###
6,9*300 *,67000 *7900
,60700 *,*0*00 *3800
,60700 *,*0*00 *3800
*,*'0 1,'9' 30
### ### *+1+
99+00 63300 30100
93300 7100 *8300
93300 7100 *8300
37*.4 *3.*! 3!.77
96099 8813 *91+9
0
,/"8$$
0
8,/21$$
0
8,/21$$
*,1+00
*,1+
*,166
39100
391
391
-
### 5 *,144.00 5
391.00
*,1*600
5 *,1*4.00
###
0
1,122$$
0
,388$$
0
1,21)$$
73600
73600
7800
7800
+1300
+1300
+*+00
+*+00
7700
-
-
7700
8*700
8*700
78600
1,+0600
1,+0600
1,+0800
6*000
6*000
6++00
6++00
10000
10000
10000
10000
1800
18
19300
19300
0
)2$$
4)1/$$5
###
0
2,)28$$
0
78600 ###
xibit 1 /amples o" Sandards "or he *009 +ro"i +lan Spanish ;egion2 )tan#ar#" +ercenage o" volume "rom specialies Selling prices in /uros2 @ce-cream per lire2 Specialies per lire2 anu"acuring coss in /uros2 6air( ice-cream per lire2 her ingrediens ice-cream sugar, "lavor, ec. per 100 grams2 her ingrediens specialies sugar, "lavor, ec. per 100 grams2 &aor $age per hour2 &aor hours ice-cream lires per hour2 &aor hours specialies lires per hour2 olume 6air( ingrediensice-cream ? o" volume2 her ingrediensice cream grams per lire2 6air( ingrediensspecialies ? o" volume2 her ingrediensspecialies grams per lire2
)'ain 10? '.'* .13 *.41 1.!1 *.1* .13 107.*0 11.0' 7*? ' 93? 73
xibit 3 @alian ;egion, *009 ;esuls
)ale" *ata Sales ice-cream volume in lires2 Sales specialies lires2 %!tal )ale" !"t !( +!!#" )!l#
Pr!(it Plan Volume /uros
Actual Volume /uros
('000)
('000)
0002
Variance
0002
2,453 10,947 2,480 11,104 272 *,*3* 276 *,*!3 2,725 13,199 2,756 13,359
139 *1 160
F F F
6air( ingrediens lires2 her ingrediens 100 gr.2 &aor hours2 Cos specialies
1,864 1,275 33.10
',943 1,! 300
1,895 1,296 36.03
',94 1,93* 3*
*32 '72 *2
> > U
6air( ingrediens lires2 her ingrediens 100 gr.2 &aor hours2 !ntributi!n &arin
259 196 24.24
49 '*! **0 4,717
257 197 23.29
474 '30 *1* 4,795
13 !2 78
F > F F
1,1'*
1,13!
7
F
109
109
/
3,466
3,551
85
F
6eliver( epenses
3*9
31!
1'
F
6epreciaion o" ruc:s
19
19
/
>
Selling epenses
31'
3''
302
>
1,3*
1,*
'0
F
Adminisraive salaries and epenses
!!
!7'
142
>
;en
1**
1**
/
Allocaed cenral o""ice epenses
1!
193
3!2
>
Pr!(it" be(!re 2ntere"t an# %axe"
459
517
58
F
9'
10
1'2
377
3!7
*0
*,743
*,74'
12
3,$34
3,$$9
!
Cos ice-cream
-ter !"t" Supervision, energ(, mainenance, ... 6epreciaion -'eratin &arin )ellin an# A#&ini"tratie x'en"e"
Adverising
2#enti(iable A""et" Cash average2 Accouns ;eceivale average2 +lan and e
*9.7= C
*9.= C
xibit 5 *009 @ce-cream 8rans"ers e$een France and Spain 2ce/crea& !"t !( inre#ient"
!"t 'er litre
olume rans"erred in 000 lires2
%!tal in 000 ur!" 403
Acual Coss in /uros2 6air( @ngrediens
*.74
1.9
1,19'
her @ngrediens
1.!4
0.49
'14
&aor
0.09
0.09
!7
her coss
0.'4
*79
6epreciaion
0.09
!4
SA epenses
0.0'
*3
!? pro"i margin
0.17
101
%!tal tran"(er 'rice
3.53
$,1$6
Allocaed Fied Coss in /uros2
xibit 6 Hisorical 6aa8emperaure and Sales olume France ear %e&'erature )ale" V!lu&e degrees Celsius2 000 lires2 199! *7.7 1,3'' 1994 *9.* 1,'3! 1997 *.' 1,'' 199 30.9 1,71' 1999 3*.9 *,031 *000 *7.3 1,9' *001 30.0 *,*0 *00* 30.! *,'9 *003 30. *,741 *00' 30.0 *,99 *00! *9.7 3,*14 *004 30.3 3,''! *007 *9.4 3,797 *00 *9.' ',07 *009 udge2 ','!! Aerae
ear 199! 1994 1997 199 1999 *000 *001 *00* *003 *00' *00! *004 *007 *00 *009 udge2 Aerae
ear 1999 *000 *001 *00* *003 *00' *00! *004 *007
$9.8 =C )'ain %e&'erature )ale" V!lu&e degrees Celsius2 000 lires2 30. 1,049 31.* 1,*7* *9.0 1,'0* 31.4 1,4! *9. 1,!* *.3 *,004 *.0 1,94' *7.! *,033 *9.9 *,*31 30.' *,'1 31. *,4' 3*.' 3,034 30.' 3,3'4 31.0 3,7** ',09' 30.$ :
V!lu&e +r!t
4.7? 3.'? 1!.!? 1.!? -*.3? 11.3? 1*.7? 10.9? .4? 7.3? 7.1? 10.*? 7.4? 9.0? 9.1
V!lu&e +r!t
1.9? 10.*? *0.*? 9.9? .3? -*.1? 3.!? 9.? 11.*? .*? 13.1? 10.*? 11.3? 10.0? 10.$
2taly %e&'erature )ale" V!lu&e V!lu&e +r!t degrees Celsius2 000 lires2 3*.* 9* 30.' 1,034 14.1? *.4 1,1'3 10.3? 31. 1,'3' *!.4? *.1 1,!0 !.1? *.* 1,439 .7? *9.0 1,771 .0? *.3 1,7* !.7? 30.1 *,090 11.7?
*00 *009 udge2 Aerae
30.0 $9.7 :
*,'33 *,7*!
14.'? 1*.0? 1$.0