ࡱ> ZY (ɀ\pOlivier van Lieshout Ba==Z[J#8X@"1Arial1Calibri1Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Arial1Calibri1$Arial1Calibri1,8Calibri18Calibri18Calibri1 Arial1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Arial1Arial1 Arial1Arial1Arial1Arial1Arial1 Arial1Arial1Arial1 Arial1Arial1Arial1QTahoma1QTahoma1QTahoma1QTahoma1QTahoma+" "#,##0;\-" "#,##05" "#,##0;[Red]\-" "#,##07" "#,##0.00;\-" "#,##0.00A" "#,##0.00;[Red]\-" "#,##0.00e*0_-" "* #,##0_-;\-" "* #,##0_-;_-" "* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-u,8_-" "* #,##0.00_-;\-" "* #,##0.00_-;_-" "* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-.)_-* #,##0_-;\-* #,##0_-;_-* "-"??_-;_-@_- 0.0%0.0 #,##0.02-_-* #,##0.0_-;\-* #,##0.0_-;_-* "-"??_-;_-@_-[$SAR]\ #,##0.00 0\ "kg" 0.0\ "kg" 0.00\ "kg"[$IRR]\ #,##0.00[$IRR]\ #,##0.0 [$IRR]\ #,##00+_-* #,##0.0_-;\-* #,##0.0_-;_-* "-"_-;_-@_-2-_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"_-;_-@_-                                                                      ff  +  )  ,  *      P  P         `            a>   h@ @   h@ @    d@ @   `@ @   `@ @   d@ @   @  H  `@ @  "|@ @   `@ @  "|@ @   `@ @   `@ @  "| "x "x@ @  "X "x@ @   l@ @   !x   d  `@ @    H  l@ @   d  h@ @   l x@@-  x@- |@- | @-  l  `@ @    `@ @   `@ @  x@-  |- |- |-  |-  | -   d@ @   `  x- ) h@ @   l@ @   l@ @   !|  !|@ @  |- )x- + l@ @   l x@ - x - | -  | - | - | -   X !|  `@ @  x@@,  x@, "x@,  x @,  h@ @  x@,  |, )x,  |,  )| ,  x,  l@ @   l@ @  !|  l@ @   l   x ,  h@ @   h@ @   l@ @   !|@ @  x@ , x , )x , | , )x ,  P   `  h@ @   @  + l@ @   h@ @   `@ @    d@ @   h@ @   h@ @   H  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text0  1Good2 Heading 13 Heading 24 Heading 35 Heading 46 7Input8 Linked Cell 9Neutral :Note ;Output< =Title >Total? Warning Text`bbGoudse 150g (4800),ROE: ROE: T 4b4bZ4}]u58'S64n.4}]u58'SPNG  IHDRdÆ tEXtSoftwareAdobe ImageReadyqe<3IDATx]|>5m+ Z(wT@O@,"*`WDX"VR4!Rwwl!òIvI/ٙ;|ޫz/Zh{DS4hz4 UDvYb E-[2EhEKErkhH NYDK47 | EYdw5iZ׊qa!rk p]ɢ-^DSAv,R"HE\&0(-+x jJ𙥆ޗGdkco+-0$- hGE;!.i lѢIoh`r-WQ-HD C?sUS.'Aю_opz0@'-<$/xiש@Xz[HqsD]7Z$0x^^pك6 P&!2, y@jĈWΈv ^߫hB#/ ˺6X8lm/zr;$D[Sq;7_IX4HâEɫ7')66!&Ƀv >/6հfݎ z HSv\'ڇ%&ڻU3`쿘JZ"DSY Ea~hq d J (hg}\ * 4ƥW<:^{`$hω^`PR|SUP.0jj>?+Wx}v${g+Hyo':sxqDVc^S6lA%6(`&_g&PϦ4>naP;L8}83)3q4sckcΞn ƻ`;tihSy@=vP v?rv?Pe^H9J1= ed:pxZ=r򹝈F x܄qß/L\)QtmhiǝW陟@JзڐBB 2 $#JFh?g$x0A8 FO>zYޟ[.&0 .UA}>c|#xVN2,P'k"Z?y鯁MEn4&C,N0CsN=H󭷡:80F 7C׫TL(OiJ`n H׍tX˪Zvc9C zYLvs򾂩tL'"q4;C1wP=W)wD~Tdq%0 (+ }(|MGFDߐ LGq7XU^`cF8FT^x |i0|_)rF}Dӌ:S=pQ򑜇;KDqHs8N@0ȻNP|XuΪ4"Z#j z g5yh!!t oTb4R Z $x(-2iWx_ EfJ܎h/UQ^$ r.J}伈p}F?옦_``̊E)T:hc7A5Os UXBIEMăU 4DKUU~+$MWFYm$`CyƑ ÊH,}F4=>g8X{hb-wPǕ_gvPj` +UH j!-0LˈN:pCn[پx} {e!qoUZB{V ;)w &y9J- +3\< E=߉Y Cl:ʢ^cDYtCI@$U_[W^ Ҡ2.~wT3T Rtf z, |Jy~u6S8#^T/v238#|Ex"TEF}ȎtUzr_TE?R:[!e2Uvay¤#N|o) ,^ 3x 3%]Hj]oDkR*Q+W}ʩ*WȑaGn:XdcŃW@nEFqj% r$!؝KEJg~t6x= 90gLc@6F>"^-MѕHe"\r i.sJ+^U9GٽTWx6c#P$8\RkJ5b7;)jTZv{T%ΪH$.c%/ZS"Jw%[Faإp&$9yb48u#iwΕcZZ=ؑeWƑۖX! ]tCj #g *fq*GrL@8jJ^5wŠR{Wp92T"VbN7iaYUJtEh/'$rAv hMjܽODᩏuz58GQ H%%6k<|nL4Ri8T֭x c{UDe #{y7 Ts1Hn<P j+lDPEҰqTe&ZQcC}BlV 7_My`$QR4U]Ljt8^o0?'…p Ӽ|{yun}V6$[ZRD mN? k0^J77`le2nz`h"쁭$isK{ wAܜ!xL#~7߳6ݫQD)a0EWj>(3<}ἹjMp/X'A2o DJO+iU F&ntAԧIߦ%@m睕$asbUQ~}!Co^^G,}IxM,3ؠ7λSRvVZިz7~VVmc#{cEYY;yT#܁|G. +l{7ZL 0/OeV9 *_('(+cΠ):*YhXMf?VpѸ36mْT\lu tyIߒ|2)yyHT\\$E"6>o |A@PRi45k>z"WD~˄uef-.XXJj$-,k> G)G"V0Γޱ7|eIxuN @0T:_?KnԎLӓ2>1Ç ;P@+X[zzZkuXz<` $>l8f˟tz$`]IM=! XNM@GO4܅"Ezzxo|(O?Ӟ}{|Apll`SRhӶmY.g=r33-G?F~y |v%\jazE^^b<;#wG8t߰}=[j9zܪ}y}s/ZvyK.'9{齌Lyga5zxΤ!=A: vQHxbI*vR_$Ͻr gdZIGng3^.+'$iEt!fXE="8zu'RPP䟗,=P1՘%]M2yAF~~RDx,QP` &ziVAϗ:vyGcO>EA.6sgɐAvN= yjo0f{9 {HHzDw] ha &q]рkdu8I8oƧ!)i/_1^~`M>>rHX"n e}YӬvAu۟剧9f_6z{ۚ)0X u&_Yv=X:tiأ 7 ,[eknnﰬXpFnު. $1zHvT6DRz.s#*\. Ć', ?|g\m}w6]dD<11Q^h}{mow^itlL<ȝL[mv.yIjo[ܤؠ1jH]4to`P|V?R?ҖU7O?Y]X__zL{쥃PJj ^(|*MyIںeӂij3mسkt]^uC<>gAE1xVr~zi#8n*O&/ۻ :DO*(, rߜ- }ަO>}R``egeH:u?@;w2:q<9/;{ YRҦ*=΂qw@LMM* D$\`yytWl7g񧞴$K ""رÇMVvcPcNQ#qltB墢b͹DJMMq,ST94$>`$xgfqMw0 bkaaAQQaal1[)Rԁ<#3UWadMdcZA AbۯB1-[j,f+{ȞPct9z)'. qi,Z-usV(b`(h5oϙK{EyyIYLMyLC֑#8BzkM~XJNNgIϾOW ?x!JgϞgMzY~UHEb˔[o eFցkc=BnF:r].17H;p&ۯټeE$rrt:Y%\_#hT| ZppEuFͲX%Im[Χf3&Oʦit.p|z:]5( Dcp#o'f$\V+}:=7aU(wQ@ JK@'IEfsyAۜ%?D>tQg?ͣ=G"e?j@ ?qϼn>)[d, Hϳadefhq9)r>&ƍӇsRHHe%.2LI9/oڲٺfosRxx+O8i}F9*uQż/i-D>}x'Tްa<6yqy}D $`p +Ce6={&[iժe9ˋ44lI9# |pE旾%b?;}œD>As?J7<tf;wtȧ^H3g;v/9kSzOHʦ;bZ"׈5&d 7h4"JHՅ']qum)R*rZQG 6{M2?_b42٭'OӲp.SKZb|Jra0aUY =5CJ=z‚ZO?D6m ]wАaiӦ-N3;'5U}8ڵo/ (7/>rBCH" u0wdjW/oS_ +J)tp[ֈuU'Qʣ`ycZS;NE.S ;Y䉭ga 7H_$o9i醮]͛Xcqq{y4H_`1籌H(1 F'c8vA$ޔUZ5yf$Q_;+*r_ňʤ1èi\9{*'_qY8a`DT2W[P]t\a~~Եgς ֳgGDD]qF٣^%VK^^\jE:A$fp#wD4:q.'KaA enNݎA7gс gJk =O-kFG/-w]gq|HRC@[)h!42p4)(ȷwŒtn`wgӻϵWmR V3eӼ҉oTSiMmuUs8OW}4p^~G 41-8#Tڽ裸QZ^w9RYKϫfoƋ`@B% 79K(բ^&ѳd0ݓ5=zk^sW^J.(8]dQfF&%:QW`6"*pD G:wzH1*(.5Ѻp)oL&\_ڱ&7!DKuD(6HLV%K 'ɶ0mơ>p.9uPJO~oݍVXI .θk7|awwwI'댁p; }pk$D8eJ0)46sbqNC(ˎQ-DHB^\=~|"nZR۞l[MըUe(զm[^_#fp^t:N-s**KYg{l,]RG$,pE8dvsD~3 NrE7\2ȵ*Cxd"GIqLƹA4Q"wMMOBj*}ͷ%+wQuIklR25QvsAz>V(V+K?nS&Y:57J2x ?R^wuv{n0]3i3ߍ <I?dV`uP Ԇq~RGw!?m I][=r~{<5Ll\(VmHBs&v t}[< Uo3+ၿf= ZZohVMV4P8DGtk0}@ǡU׳JV+p*J5`KOp7iOa^.pn8 *F1P0 ePG0{؝w fS<@tpkzg`s%&YVf0K9W=gw.^UTLG dxI%y* r0nG9?I#UfAhy =2iȸ 0ŕ~0DDC?0U5D6_2_B% B߲,FYaR]c-X<:!# UeOBX li8ehYADlA"h[{>lb=ӎ9|YuUΓQ,$7] Gr͕Uv:oB/"b!U;BC"!?KUyc;%:?js!ЇyZy9 e<; @!]3)oFՔxP!L+AeU2޵+ !t̡ҢM05ë"yӕ|Th'}#@q7f-385ྦ㺦{kag߅g>>8)DHsr#uN%#Wz~0W`(@sRTPc|LDSw+f/̶$eѬ"PC*O\Vr\MQtFq̀ %x݅.~LWgEҾ0?00Sߍv5@UmD3mr5Y,W$Lpt#x`CBWNg n89`FYDfjWE*<{/H 㩴z dKCTTWi =xQf~<AYTZkl V(FξgfBrVΚ,h1X{1a| dU|-=&(! h>`[V`*](*`U0"82qS}"˧GAq'}VAɳ)_q57s0o$teA aP n~4@`^ .V1k;x G`dw\Hr >r+[nB= {" Ar2w9sWNnqAp}:iv9^Ȝ~7-;Pi\שvn D<0B=0O ?0AB0 25 Brix, 0A5?B8G5A:85 <5H:8 ?> 220 :3. 2 AB0;L=KE 1>G:0Eper tonper yearPrice (Retail price, delivered)&5=0 (DDU >A:20) Total Revenue 1I0O 2K@CG:0VAT 6%<?>@B=K5 ?>H;8=K, 10% Total Cost1I85 8745@6:8Transport cost)"@0=A?>@B8@>2:0 (114$/B>=) 8 :><8AA8O, 3%Profit Before Tax@81K;L 4> C?;0BK =0;>3>2 IngredientRecipe Cost per Kg Cost in batch% Price (EXW) &5=0 (EXW)Profitability %>MDD8F85=B (%) @5=B015;L=>AB8CDLF Instant Gouda FlavorBase powder FCMP (DDP)Price (Gouda CDLF, DDP factory)&5=0 (AK@L5, A 4>AB02:>9) Asset value!B>8<>ABL >A=.A@54AB2WaterProcessing ratio>MDD8F85=B ?5@5@01>B:8Depreciation % <>@B870F8O %Raw Material cost!B>8<>ABL AK@LOFC1Other ingredients, DDP factory@C385 8=3@5485=BKVC1Debt (40% of Asset value)>;3 Interest rate@>F5=B=0O AB02:0+Production cost per hour (gas, electricity)@>872>4AB25==K5 @0AE>4K 2 G0AFC2BATCH%Production volume per hour (ton/hour)1J5< ?@>872>4AB20 2 G0AVC2 Number of FTE (8hr/day) employed&>;8G5AB2> A>B@C4=8:>2 (M:282.?>;=.7.) Investment Price EUR Depreciation!Salaries staff incl. social taxes&/?;. HB0B=KE A>B@-2 + A>F. >BG8A;5=8OMix & smelt unit$Other overhead, repairs, maintenance@C385 =0:;04=K5 @0AE>4KInline homogeniser'Cost of packing (cup, seal, label, box)!B>8<>ABL 548=8FK C?0:>2:8FC3UHT pasterurizerNumber of bags per ton>;-2> 548=8F C?0:>2:8 =0 B>==CCup filler (4800/hr)VC3FCFC (>1I85 ?>AB>O==K5 70B@0BK) UtilitiesFC % attributed to productFC %, >B=5A5==K5 : ?@>4C:BCBuilding FG losses %VCVC (>1I85 ?5@5<5==K5 70B@0BK)FC (attributed to product)FC (>B=5A5==K5 : ?@>4C:BC) Gross margin0;>20O <0@60 (20;>20O ?@81K;L)Volume sold q (ton)1J5< ?@>406 qGross margin %>MDD8F85=B (%) 20;>2>9 <0@68 Contribution>=B@81CF8O/2:;04 Variable costBreak even volume (sales)"">G:0 157C1KB>G=>AB8 (?> ?@>4060<) Break even volume (raw material)">G:0 157C1KB>G=>AB8 (?> AK@LN)Fixed Cost / qFC / qOutput capacity per hour in ton>I=>ABL 2 G0A (2 B>==0E)Total Cost / qTC / qOperating hours per day>;-2> @01>G8E G0A>2 2 45=LWorking days per year;8=0 A57>=0 2 4=OE Profit / q @81K;L / qMax. output capacity per year0:A8<0;L=0O <>I=>ABL 2 3>4Capacity utilization %$03@C7:0 (8A?>;L7>20=85) <>I=>AB59 %uNote: figures in blue are assumptions; figures in pink are calculated in another sheet; figures in black are formulas 2!6c"h_ 0<5B:0: F8D@K A8=8<-4>?CI5=8O; F8D@K @>7>2K<-@0AAG8B0=K =0 4@C3>< ;8AB5, F8D@K G5@=K< -D>@<C;K#&$-P%V6This Cigar Box is a real company case. See www.cdlf.nlz R STFU2TV@"WXYZ[[ \ 8^$ _ :`& (ɀ 'hh_  dMbP?_*+%MBCanon MF5600 SeriesdG 4dXA4Canon$U Canon MF5600 SeriesLddd      d d d d dd  d  d dd edd     dd"ddd@8 4 22h 1 4 22h 1XXdd\SRGBCO~1.ICM\SRGBCO~1.ICM\SRGBCO~1.ICM CONFIDENTIALCONFIDENTIALHArialDefault Settings " dX??U} $F} I'F} *F} F} F} &F} %F}  F} mF} mF} F} IF} F} F}  F}  F} mF} F} F} $ F'       @ ABCDD~ E`@C G HH9I#C  $  $ B JHHKDL G MM N OPP QR M M~ S@T M M!Uoed@A  DDV WWWWWWWW M M %X>Ԅt@DjT M M 'Y=@1D>ADDDV WWWWWWWW M M ~ XY@T Z Z![i(A DDV \  ]  ] ^ ^ _ WW Z Z'`R@DDDT a a!b? DDc~  d?  e~  f@!g@y\,@ t#h4æS@ LLiBh? LD WWHHjJMMkV~  d@  l f4@g@hW@ia=y0L?  WW M M- m/0@@8t\(\"@p k M M~ X#A V~ d@ l f@g@ h|Gz?  iOCLԁ?  WW M M!) n? @ L@ k M" M#~ o @ V~ d@ lfg h  i  WW M$ M%! U0<Xe@  D D ! pTĥ?  D D Z& Z&! [j@  D D ! q ?o?  D D~ d@ lfg h  i  WW M' M(2 mX@ _{Gz? L@! p]d?  D D MMkq~ d@ lfg h  i  WW Z) Z)! `4{8$@ D D ! pXQ "W?  D D M* M+ XA D ( q~ d@ lfg h  i WWMMUk M, M-~ o.@V~  d @  lrshi WW M. M/'t۶m۶m%@ ?<u Z0 Z0![O@ D D!qo*p? DD v  w1# x L@ % e@y#ze@ %@@{? WW M2 M3+n ]? L@<kMMkV ||||||WW Z4 Z4!`HH6@ DD!}v't? DD M5 ~6~ X(@q   7  8  9 |WWZZ`p M: ;#X@ DX !q/]? DD~  ?  < L@$@p@ LL |WWMMUk M= M>~ Xj@!q ?o? DD~  @  ? L@$@p@ |WW M@ MA-433333? ??k ZB ZB#`A %!q T~? DD~  @  C @$@d@ |WW MD ME(qq\@ 333333?kMMkV~  @  F @$@@ |WW ZG ZG!;8@ DD!pܮ=z? DD ZH ZI'`T AD DD!q? DD~  @  J @$@d@ |WWMMUk MK L~ ?V~  @  M A@j@ |WW MNM~ o@kMV~  @ |WW O P31/@ D DDD!? DD ZQ ZR![T A DDq~  @ |WWHHjJHHJL  1# #A % e@!{Gz? DD #j@ %e@ |WW ZS ZT!`d@ DDk MU MV~ Sy@V  MW MX!P-? DDk ZY Z!`4ǾA DDVMMkZZ`V Z[Z`1/@ D!p׍}CKc? DD" Z\ Z]![1%l@ DDV M^ M_!YC@  DD V Z` Za! `~@" DD! pJ?! D D" MMkqDlPDi 6Ty 3`]!"#$%&!MMUk !Mb !Mc! ]?"D!V "Zd "Ze!"`1^@ DD !"p?$ D"D" "Mf "Mg~ "X @"q " r" #MMUk #Mh #Mi~ #@o@#V $Zj $Zk!$`0y@$ DD"$p $Zl $Zm'$`۶m۶ @%D!D"D#$q%aa %an %ao!%Jŵw?t' DD$%c &p &q&cdWF]N6(  x  6dcnX? i ]4@dcnt O$ eAW,oH <gestel: 10 jaar levensduur<&&'e~~  <cnXPP?bi@]4@cn(t nxͽE.9,,O 2<3Olivier van Lieshout: 2% packaging material losses<(i ){ 2 ~~  <0nXPP?bi@]4@0nt yBPn < <yOlivier van Lieshout: Batch cost 1.25 batch time: 7 minutes< (i ) *<!~~  <nXPP?b i@]4@nt kJCM>; "<#Olivier van Lieshout: FCMP + water<(i )= " ~~  <nXPP?bi@ ]4@nt Q~Gu ' S <Olivier van Lieshout: Sea container 3700 door-to-door 9,18 ton + 12% import duties< (i ) *6S nf  C ,ACDLF logo S !]&`"t Olivier van Lieshout gestelr Olivier van Lieshout Olivier van Lieshout Olivier van Lieshout>@ wb(b(5 ?ϿggD Oh+'0@Hh Olivier van LieshoutOlivier van LieshoutMicrosoft Excel@J|@e}՜.+,0 PXx  ACC Business Creation Goudse 150g (4800)'Goudse 150g (4800)'!ROE  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHJKLMNOPRSTUVWXRoot Entry FWorkbookTSummaryInformation(IDocumentSummaryInformation8Q