ࡱ> Root EntryRoot Entry F0IFkCompObj fWorkbookC7MSDigSig(Author)$8(  !"#$%&'()*+,-./012345679:;<=>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^SummaryInformation(_DocumentSummaryInformation80 ՜.+,D՜.+,  PXd lt| / Advertising AnalysisExample  Worksheets 8@ _PID_HLINKSANmsbpz://-r:276DB10A/Jmsbpz://-r:276DB18E/>8msbp://-r:276DB10A/Nmsbpz://-r:276DB10A/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0T_ X` Advertising AnalysisMicrosoft CorporationMicrosoft CorporationMicrosoft Excel@/@7)+@BGH^& /&" WMFC@ @d7& EMF@ @    !" !" !  " !  8'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 68% Ld77!??% #6#% Ld###!??% 6% Ld!??% 767% Ld777!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0z \l|pd+%w0%    TT AA LP14   ( &% 6% Ld!??   TT (7AA (LP2y   %  6 % Ld   !??   TT :IAA :LP3`   % :6:% Ld:::!??   TT KZAA KLP423   % K6K% LdKKK!??   TT \kAA \LP5U   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7   % ~6~% Ld~~~!??   TT AA LP8O   % 6% Ld!??   TT AA LP9y    % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TTrzAArLPB0    % $6$% Ld$$$!??   TTAALPC2.    % 6% Ld!??% % " !% %   8'%    Ld#9 )!??'% (  Ld#79#)!??'% (  Ld9#&" WMFC @9 !??'% (  Ld#97#9!??RL Tahoma TahomaDhۍ0WXw !\@$0 !\ $ 0%  % % " !% %   $ 79   T3 +8AA3 LMicrosoft Business Planner       % % " !% %   8RL Verdana Verdana`hۍ0WXw "\@$0 "\0%    T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw *\@$0 *\3 0% RL  Verdana Verdana`hۍ0WXw %\@$0 %\ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% %  % % % % % % " !% %   $8%   T3AA3LtAdvertising Analysis      % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $8% % % % % % %   T27AA2eLUse this table to measure the effectiveness and efficiency of your advertising. The cells displaying  T27AA2fLzeroes or "#DIV/0!" contain formulae which will perform automatic calculations on the data you enter.       T27AA2fLDo not enter data into these cells as you will erase the formulae in them. Click on the "Example" tab      T82AA2'Lto view a worked example of this table.   % % % % " !% %   $\7l  T$2^kAA2^$LChoosing Your Promotional Activities % % " !% %   8% % " !% %   8' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld7!??'%   ( &% #}69}% Ld#}7}#}!??% ( % " !%   8% " !%   8'%    ( &% 68% Ld78!?&WMFC@?% 6% Ld!??% "   8  '' ' ,8-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-8- @ !7-##- @ !#-- @ !-77- @ !7-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1p -- @ !  2 ( 2a -  - @ !   2 : 3  -::- @ !:  2 K 4\ -KK- @ !K  2 \ 5p -\\- @ !\  2 m 6a -mm- @ !m  2 ~ 7  -~~- @ !~  2 8\ -- @ !  2 9p -- @ !  2 #Aa  -- @ !  2 rB  -$$- @ !$  2 C\  -- @ !-"System-'-- ,8-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  --'- -  ,97 $ .2 3Microsoft Business Planner       --'- -  ,8 Verdana-   2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana--  - - - - --'- -  ,8$-  %2 3Advertising Analysis      - - ------------------------------------'--  ,8$------- 2 2eUse this table to measure the effectiveness and efficiency of your advertising. The cells displaying  2 2fzeroes or "#DIV/0!" contain formulae which will perform automatic calculations on the data you enter.       2 2fDo not enter data into these cells as you will erase the formulae in them. Click on the "Example" tab      B2 2'to view a worked example of this table.o   -- --'- -  ,l7\$ =2 ^2$Choosing Your Promotional Activities --'- -  ,8--'- -  ,8-   -- @ !-- @ !#-- @ !-- @ !7-  -}#}9- @ !}#- -'-  ,8-'-  ,8-   -8- @ !8-- @ !-'0" *H 010 *H 0g +7Y0W03 +70%7)O•0 0 *H $6XF>aI ?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1L0H0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1'/Q~6 0z +7 1l0j*(Advertising Analysis<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H ok#g:B D??>-jI`,+hkbF%XFK*zݘGYȤ:Hvm.Fç^JVl)<ƞcY? †st@ y5:y_MiY @!Rzѷլ12qP50_7S[08~eo(9lueo1Xtݡ0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201005132Z0 *H  1pcUFDCs0  *H 2Fx4p6_/L JhCw N.T:.דi-m_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                %@@   7  % @ %@"@     D  $  # ! ! ) ) % @   !7  7    !  @ %1`@  ` %  % 7 %Q @% !7  %0!7  %8!7  q q   q(  '$  h@@  `@  ` @ %1(@ %1 @ %1`@  %Q @Q(7 @Q q 7 Q   q( 7 %  % 7  % !7  %0!7 7  %Ah@@  %Ah@  'Al@  %Ah @  q(% 7 %( %(  !7   H7 !  @  !  `  `7 H @ ) ) X P h7 `7  H )  !7 # ) ) ) ! !  amount Body text  header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title !Text "Title`Advertising AnalysisQ*Example  ;!  ;  g5 Media Used EnquiriesCost of Number of Customers Cost per PostersPersonal Recommendation? TotalAdvertising AnalysisAdvertising CostAdvertising () Enquiry ()per Customer ()Sunday NewspaperDaily NewspaperLocal Weekly NewspaperGo to Article:XUse this table to measure the effectiveness and efficiency of your advertising. The cells displaying zeroes or "#DIV/0!" contain formulae which will perform automatic calculations on the data you enter. Do not enter data into these cells as you will erase the formulae in them. Click on the "Example" tab to view a worked example of this table.Look at the table below. Although the Sunday newspaper cost the most, its cost per enquiry was only slightly more than the other media. However, the objective of this advertising was to sell places on the course and, since only 10 of the 75 enquiries were converted into orders, the advertising cost per head shows that the Sunday newspaper is in fact 2.5 to 3.5 times more expensive than any other medium.Advertising Analysis: Example$Choosing Your Promotional Activities See Also:Where to AdvertiseMicrosoft Business PlannerNote: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.R Colin and Paul Barrow 1998, The Business Plan Workbook, published by Kogan Page.9" wz @ $&(  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX@w  XX@MSUDOHP LaserJet 4Si MX<d " dXX `? `?U} I} } } I$@@,[@  @    $IJJJJJ&$ ZJJJJJ&$KLLLLL&$ MLLLLL&$ __LLLL&$NNNNNN&$OOOOOO&$ \ \\\\R&$ ]]]]]S& $TUUUUU& $ ^ ^^^^S& $PQQQQQ& $VWWWWW& $ K QQQQQ&$PQQQQQ&$ #QQQQQ&$#QQQQQ&$XLLLL [&$122223&& 4 5%%%6&&7))))8& &9- - E - : && ; . / / . <&& G ''!0""""8& DD'!> DD&& H ((!0y DD(!> DD&& = ''!0 DD'!> DD&& G ''!0 DD'!> DD&& = ''0!  LL'>  LL&&F((0(>&&F((!0 DD(!> DD&&F((0(>&&F((0 (> &Dz l..........Rhdpd  !"# &?*+ 0 * > &!& !A #!B! % &#!B! % !!Ca D!D!#!B! % )!!D! D!D!!&"$$$$$$$$#$$$$$$$$ <d>@" 7\yK yK (msbp://-r:276DB10A/^yK yK *msbpz://-r:276DB18E/^yK yK *msbpz://-r:276DB10A/ @ p-6  dMbP?_*+% &LDate: &D&xA@ DD&& H(K@(@m@!0yJ@ DD~ (1@!>+@ DD&& ='>@'@_@!0@ DD~ '$@!>)@ DD&& G'$@'D@!0@ DD~ '@!>$@ DD&& ?~ *4@ + ,~ *3@ @&& A #Bg@ %&#B@ %!Cڱa@ DD#BN@ %)!D"""""(@ DD&$$$$$$$$$$$$$$$$8........Rhh>@<dccc" 7FyK yK http:///^yK yK *msbpz://-r:276DB10A/