ࡱ> :9  !"#$%&'()*+,-./012345678E<=>?@ABCDFIGHRoot Entry FEr;Workbook m_VBA_PROJECT_CUR" `9rErVBA`9r*9r (ɀ\pais Ba= ThisWorkbook=xiL,8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1QTahoma1QTahoma1QTahoma1QTahoma1Arial1Arial1QTahoma1Arial1Tahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) "$"#,##0 "$"#,##0.00$[$-409]dddd\,\ mmmm\ dd\,\ yyyy mm/dd/yy;@[$-409]h:mm:ss\ AM/PM 0.000% "$"#,##0.000                + ) , *   A@ @ Aa@ A@@ Af@ @ A"@@ A"@ A"` @ A` @ Af @ A@A A` @A  @@  @  ` @  `@  `  `` 0 0`  8@  8  8 A  (  (` <  ,  A@ @  A!@ @  A@ @  A@ Aa@ Aa@ Aa!@ Aa@  A @  A @ Af@  A@ @ Aa@ Aa@ @  8@@ 0@ 0` @ 0@ 0 0` 0`@ 0` 0`` 8 8`  8@  8  8@  8 A@@ A` @ A@@ A` @ A A A ` A A ` A A `` A Aa@@ A`a @ Aa@@ A`a @ Aa@@ A`a @ A`a@ A@@ A` @ A@ @ A@@ A@ @ Aa@ @ Aa@ A@ @ Aa@ @ A @ A  @ A ` @ A@ @ Aa@ @ A ! @ A !@ A `! @ A@A A A A@@ A` @ A@ A` A `@  !8@  !8 "8 A@@ A@ A` @ A A` +&Normal_Common_Long_Term_Deal_Form v1.1`3LT Estimate SheetTfVf@  @  'bHM E nn~HM E nPNG  IHDRf,WPgAMABO pHYs.#.#x?v$tEXtSoftwareQuickTime 7.1.2 (Mac OS X)3:$tIME3EPLTE:AHRAJ$T4[8^DeSoIhYri]Mbxi|qyŒɘƔϢڵѧײ ',!+-1<9*&7+<8Q;E3J@WI]EcSiOo\uY{gtcp闂집﷢dzȱIDATxycކqiQkq鋵.hkQ$!a }r5f@f'JFɉ]ZM,@3P]3H|*\b3*ecDԠ#یFnf e"tz=XW1!~3B'`tzUTN؂f`SPNpجNw-srWB%t8MJӌ]"Gb[Ǧ?F9 dk6 h4kPseU%k6hVf^eY52kۧrFh2\fP3ClqFv1-&NC3#JfCLS`[O`rFhT0]spYhh6"N?Û)IJqUg 0譾Ӭ,̤q3g'hR2?Yq jB5wpɡgFF ]=B>4i`7+jFi33uɑF{Ua# ՠHAÝ hfha-[ 7Qەڊ䟫4),+EYfVIE8Ma6^Ltd;Dh6òRk.趨f5khB)vLUI4vVKhE>R!SǗ AيDcߝ1Ua|?$O7*A<]5tfZd'O4I1y33BzެD6j2bdLL K/,j bL҉F3=qA'*bX^ z4:%L2f !#~px_xKVbfۡYdۊ.L$&}uMgQ_@jDg4" &4x3Ң3$+#w+rYfhh)+%.;Ŷ M-l* j2 *z-GxB3F9SLbvXE F6A),A3PDL\C:x.d5+Zplb܀ @3s0$K70 gYg` \Uz'j+hVH~F#f[}cmŦ. C3PT#ghf5%(fuZZ"xRfvvVDf,!]Ԍf¯CIv RRI[4f7ًz;L 4,i@324Ca lf|4f h͠4˗fYSh4Mh5h04 hpn=4fζfQ˧B32)>> ͠Y~4kA3ͲlcΠ4y*A"...?<n1{^/.db:͟fߓd<} |6{ȋBFԆ۳iRٓ5+f+S$1W_ܫ0)'7~lv,ohH9NWO*il氨-\/i`,QӼRl[f '3[-NE=YW^WCfln%yBsZwr uҟpBl5[/gy<_lК rI+l@ƳqTWf}V ʑ1$YS>>>_Кdx̳4),Ki3 і%?˥g١}ve\dYj68TTLn< ,{4gy2?oi6*_8c^&iv&Yi5;*JAsّd @F i*ȇfgRl6 l(5)fLu&NRMK1tBkF3Nz«g:ˏfגIgYx8iD)mUpϟԧ~/?I&(l>h5;)kBE~P-f$,,J4تH"YLh2V4fLDvkZE׍E l ~ bh62uˍ_Gٯ wQ5 l8{:VQrkf7iƛ8)-yuJftc4_7N#כfчiƛj9ٿ6M3t ̾JaY aewDs4QT7λf4Jl4i4ph+dYe * eH2jU9hCf5̪XF*~Di (Lfoi4kHYFIkvNiܠYR͞3ЬύxlWoDkA= v~ffRtf5kC]묙,f/eCHMِn6FvgfҚ}*3})h&^0849ǪdX7 B39^.R2|>i"^*f&aR˲™#h&Y/,/I&HZ A3h&Lt,$4˓fř_nZ0 Tj.{fLf72ř_ݑVߒ Riv!d:ޡB3H[~U[AT]Jx)fShLchqޏr@/nهtD'-7 hB39̈́s>&+4˓fR^&lYh!?7j&7H37f6ciQQY-h& gYhv $5|gB*Zi(Y_Vh&}]B3I)Ng4iK²l/) 3jf?I'4.-\lA8ӗ˥\]f_LZ3۞De,+ 5f,ehFphd~ҵ@6!8Nl4Dx,ڲ hNy͎W@XOO(,zI+eLZ:RbivRH2hG3K@DfQ Rkv uW3*CDR7$LZ3,9E@QrYf 83CzڬTFdZt 4+f/,S<*kt]oatEGxfqxRH0^h6B xq|f ؚ*NL W3j˟ /Q bk&ivH3+nbk6Ii5ela L8u\ͺaS4Wauƚ$l4_Y̚˕\NI͞S,ЌzX$k$:>h,d_f*~᪯5hھP{.~'U:\<ͷh&wxX$}>͗hL7;^};KWY gY໢ߓcEWP IdYwTh>c^h6=HWeI?'3YTj6;}4ȵ"bvud8[buəUQf[)]ר,gdxRiUMʋTvîh*[ry48Ln"B&GmIٳؚٳO5yV=M1F}'Iu7>fKv+ubdUi'Fgm?loL2L0ScM?&-SQL5ߏkf%AZT/̶oNKx:Z3{69={)÷ +̞'2l-,5G5[t.RxałkJf_ə~NRzm/`> _)f? o1Lcup9 _A3Ech@v-˩(  > 8\/fl<8J4f `<~_A3h" .^_K8l͠d= H/exh@@3hf @3͠fA3@z\hf@3fh4@3 f@34 hf@3 h4@3 fh4 hf@34 h4@3fh4 f@34 hf@3fhVlv3$ͽZJ4+f *w(jl4Ӵ4,kY˜՜ז(?j&G&Ь5Kv͚h{{9'͕;H3?_-D1fЬȚٽB4+f A4ݭXO{6׶vۻU.L[nhxs}WEJ2'vݬ%hDYtlڶ'ʭ;d;~ Y 4y[uw jбuĮ[Eh)Kt2H⎻3˦<(99N։ko9;ΞЬ-*u޽=0x FYD!쑅GH0Lg2xr³\6:kU+AmεȉpϷ#R܋ҌjT3қ=@e6\3aj#}6]ոgԀsW'4˭fΜnhsx7ۮ^Daw99#:TR !j[k, ̵|w0,yb5?V7a[ܖGݬmsFw֚;9Q8Rq20^ ӌw[s?ߋflksфwnNFh6&.WCe? <0BY]ߣRC"h慌hv[e6 & NGj&Ȭ͂'^3/#t@iޙ`qTڲה7joj&lxj80NEω!I4ٞ{gjt߃%G͙;~U 9T&20ܼ'\ݎ ̡YN57L0| oi134ݟ`ѡ2LYfɅm.w-^v{ /]ofU䖾,j6Pvɭ[nZnApcL*D L@^GOo9gfn䞂3GDi掛a;׼tB.xĄ?CbW#cӢC hU\Ek&l UoQY'?d+|= b_ӌzs~0w7l"S@g^5p ;,IsPoL@ߢ,]Q0qR :\=ݦN@3o"yso]j1' a/sDσk&l UoAV Ւ0dE~-ړ{]z,'w)}õ(ĆYM;T4 3˦zjDkƞZ~sǁu]u%W-K6DNjW;{?ҵ;kO@f'ڋ<W^͢3E?9"ZȒb[ўlK)xls,2^|f+,_jb]P⤗X,X yC⤗"XXX??U} }        @ @  (!""#"""#""""""""# J KHI L MHI u vvww---. J KHI L MHI u vvv ~ / ---. )*'(++'( u vvv ~ 0 ---.( $%%&%%%&%%%%%%%%& p q       n nn  x yyyz rs  5 ,   5 ooo;{{{{| NO~ 1!6 D D~ 9! D D1 LL6 fft    gfffh de~ 1!6 D D~ 9! D D16fffgfffh de~ 1!6 D D~ 9! D D16fffgfffh de~ 1!6 D D~ 9! D D16fffgfffh de1!6 D D9! D D16fffgfffh ij2!6 D D9! D D27fffklllm P Q3 -=:#> %<8 4   ] ^_` ab_cRRRRRRRRS V WXY Z[X\TTTTTTTTU ?&@@@@@@@@@@@@@@@A(BCCCCCCCCCCCCCCCD(BCCCCCCCCCCCCCCCD(EFFFFFFFFFFFFFFFG0 ,dzX,~NN8,,,f&N(    B8# XPP?+<]4@8#_ cLFkẩ (<BILO MERCHANDISING Each quarter and fiscal year covered by the deal period. For off invoice purchased based deals, this section does not need to be completed.<(   th  B# XPP?d  x]4@#t_ xKKT,  W<XBILO MERCHANDISING This must be completed at the time this form is initially submitted.< zW  B# XPP? X PZ]4@#_ ofT N*L } <~BILO MERCHANDISING Prior to the end of each quarter a revised estimate for this deal must be submitted to contract control. <  U| }  BP$ XPP?  7]4@P$_ ݓ6[J<ޟur <Calculated Fields <j    B$ XPP? r  ]4@$_ ꢷ!OM" ?<@BILO MERCHANDISING Explain the reason for the revised estimate < ?th  B% XPP? p P]4@%_ 8s Gtg F <GBILO ACCOUNTING Select 'Yes' if an accounting adjustment is required. < } (E F  Bp XPP? ;p]4@p`_ EOj>_B <ACCOUNTING (Mandatory) Enter the name and signature of the Accountant making the decision regarding the need for an accounting adjustment.< t  B XPP? ]4@L_ 1iBߓXS z<{BILO MERCHANDISING Enter the initial estimated percent of business for each quarter. The total percent must equal 100%. < Qzth   B9 XPP?  ]4 @9_ ]jQoO>.5 <Calculated Automatically displays the estimated income. If calculation is based on 'Lump Sum / Flat' then the 'Amount' above is used, otherwise the SKU total is used.< P s   B: XPP?`   v]4 @:_ @DkWj z<{BILO MERCHANDISING Enter the revised estimated percent of business for each quarter. The total percent must equal 100%. < \zth   BP: XPP? ]4 @P:_ CA~l_CP3@ <Calculated Automatically displays the estimated income. If calculation is based on 'Lump Sum / Flat' then the 'Amount' above is used, otherwise the SKU total is used.< P s   B: XPP? pr @]4 @:_ l}1M L= C<DCalculated Change from the original and revised estimated percent.<P GCth   B; XPP? pU}]4 @;8_ jep2 E%IM& A<BCalculated Change from the original and revised estimated income.<P AAth  B|; XPP? i]4@|;$_ ]mR4F?h <Select from drop-down<   B; XPP?r]4@;_ hW}K&@ .</Calculated Field Total percent must equal 100%<c .0  BD< XPP? !<]4@D<l_ ǝ&Gmdz@l _ <`SUPPLIER/BILO MERCHANDISING (Optional) Use this free-form space for explanations and comments. <  ' H^ _te   B< XPP?` ]4@<_ _J6}G٨z r W<XBILO MERCHANDISING Enter the name of the person responsible for updating the estimate. < Wth  B = XPP?d]4@ =!_ 0nw@LXJV 6<7BILO MERCHANDISING Enter the date estimate is updated < 6th  S HA*  BiLo_Letterhead3_1-23"p< ]&`"_  B= XPP?]4@=$_ }/ XPP?`K`x]4@>$_ GpѣI_{\e  0<1Category the vendor funds will be recorded under< 0   Bt> XPP? ]4 @t><%_ t>Os? <<=Select from drop down: flat fee allowance or item allowance < [;< ! B> XPP? ]4!@>('_ 8~1AbQ _<`Enter total estimated dollars here in order to calculate estimated income by period or quarter.< _ " B @<d  j-                             7?          d?          &0  YES NON K %"Flat Fee Allowance Item Allowance Module1sThisWorkbook_VBA_PROJECT" dirG  !#$%&'()*+,-./0123456789:;<=>?@ABCDEFHIJKLMNOQSTUVWYZ[]^_`bfxME @hMacro recorded 5/12/2008 by smk 14hxmI"   &( P X`p Macro1 Macro Macro recorded 5/12/2008 by smkoAttribute VB_Name = "Module1" Sub Macro`1() L.Descrip0tiontX recorded 5/12/2008 by smkProcDataPInvok@e_FuncP \n146' >'m" !End K#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2as  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.4#0#C:\Program Files\Microsoft Office\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\Stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 10.0 Object Library  mIModule10149c0d608Module1fThisWorkbook0249c0d608ThisWorkbookK%8HZNlO͍1Z^H^: %dH %Excel+VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuModule1b _EvaluateMacro1N ThisWorkbook|WorkbookkT   $0* pHd VBAProject4@j = r mI J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst@em32\Se2.tlb#OLE Automat8ion`EOfficEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\@10\MSO.DLL# 10.0 Ob LibrXaryK Module1GduQ1 2Q HB1pŰB,Bf!B+BqThisWorkbookG@T@sisW rkboZ 2 $%$K,"B#$PROJECTwmPAPROJECTR]SummaryInformation( XDocumentSummaryInformation8\Module1Module1ThisWorkbookThisWorkbookID="{B7CD69B6-A0AD-4130-B9C4-C67A6D9B1EDC}" Module=Module1 Document=ThisWorkbook/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="A7A5816C8FB432B832B832B832B8" DPB="4E4C68D5A8DB4EDC4EDC4E" GC="F5F7D3BADD60DE60DE9F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 Oh+'0HP\h aisaisMicrosoft Excel@CZ@ b@1#r՜.+,0 PXh px Bilo LT Estimate Sheet  Worksheets FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qCompObjaf