{UTF-8} W avg VPP all buyers= (Proportion of Influenced Purchases*Promo VPP+(1-Proportion of Influenced Purchases)\ *Uninfluenced VPP) ~ consumption unit ~ | "52W MAT volume"= DELAY FIXED(W avg VPP all buyers*W total category purchases*Total HHs*"Purchase/HH",\ 52,881386) ~ consumption unit/Week ~ first 52 weeks volume deacrease based on equilibrium scenario | Volume bought= W avg VPP all buyers*W total category purchases*Total HHs*"Purchase/HH" ~ consumption unit/Week ~ | Brand A volume sales= W Brand A volume share*Category volume ~ consumption unit ~ | Brand B volume sales= W Brand B volume share*Category volume ~ consumption unit ~ | Stable user base PF= (W Proportion of stable light buyers+"W repeat - promoted"+"W repeat - unpromoted")*\ "Weeks/year"/NBD stable category users penetration ~ 1/year ~ | Category volume= INTEG ( Volume bought-"52W MAT volume", HHP PF*HHP Category Penetration*HHP Avg VPP*Total HHs) ~ consumption unit ~ | "52W MAT promo users"= DELAY FIXED(W Proportion of opportunistic new buyers, 52, Stable 52W proportion of lapsed promo users\ ) ~ 1/Week ~ All users who bought 52 weeks before the period leave the 52 weeks user \ base | Min Brand A WD promotion change= -W Brand A WD promotions+Brand A promotions implementation*Short term WD promotions implementation ~ 1 ~ Weighted distribution cannot be negative. | Min Brand B WD promotion change= -W Brand B WD promotions+Brand B promotions implementation*Short term WD promotions implementation ~ 1 ~ Weighted distribution cannot be negative. | Short term WD promotions implementation= 1 ~ Week ~ | Stable 52W proportion of lapsed promo users= W proportion of lapsed users from NBD Dirichlet-W Proportion of stable light buyers ~ 1/Week ~ Proportion of lapsed promo users in the first 52 weeks of modeling before \ the MAT of promo users is used in the model | "Stable user base at any time - base period"= 52 ~ weeks ~ 52 weeks for user base reference | Lapsed Users= ("52W MAT promo users"+W Proportion of stable light buyers)*Total HHs ~ HH/Week ~ The proportion of non users buying in year without being driven by \ promotions is constant, and therefore doesn't need a 52W MAT adjustment \ like the promotion buyers | WD promotions change target for Brand A= Gap between target and actual share Brand A*1/(Promotions sales Impact Index-1+1e-009\ ) ~ 1 ~ All promotions are assumed the same, or the mix between promotion types \ remains constant. Assumes perfect knowledge of promotions impact and \ therefore exact need to increase promotions WD. | W avg VPP stable users= "Proportion of influenced purchases - stable users"*Promo VPP+(1-"Proportion of influenced purchases - stable users"\ )*Uninfluenced VPP ~ consumption unit ~ Average transaction size amongst stable category users. Slightly lower \ than the Year0 Avg VPP from HHP as it excludes promo-only category buyers \ that buy promotional transaction sizes that are bigger. | Max Brand A WD promotions change= 1-W Brand A WD promotions-Brand A promotions implementation*Short term WD promotions implementation ~ 1 ~ Weighted distribution cannot exceed 100%. The maximum for Brand A could be \ lower than 100% depending on promotions financials and decision psychology \ within the manufacturer. | Max Brand B WD promotion change= 1-W Brand B WD promotions-Brand B promotions implementation*Short term WD promotions implementation ~ 1 ~ Weighted distribution cannot exceed 100%. The maximum for Brand A could be \ lower than 100% depending on promotions financials and decision psychology \ within the manufacturer. | Possible Brand A WD promotions change= IF THEN ELSE(WD promotions change target for Brand A MU = a*mu & SIGMA = a*sigma | Proportion of Influenced Purchases= ACTIVE INITIAL ( ("W repeat - promoted"+"W trial - promoted")/("W repeat - promoted"+"W trial - promoted"\ +"W repeat - unpromoted"+"W trial - unpromoted"), TP Category VSOD/Promo VPP ratio to uninfluenced VPP) ~ 1 ~ Proportion of purchases done on promotion. Starting point = VSOD / Promo \ VPP ratio. | Gap between target and actual share Brand A= DELAY FIXED( (Target volume share A-W Brand A volume share), Time to measure market shares\ , 0) ~ 1 ~ Limits of share measurement and measurement volatility | "52W Rolling User base"= INTEG ( W Increase in User base-Lapsed Users, HHP Category Penetration*Total HHs) ~ HH ~ Consumer user base over 52 weeks | "W repeat - unpromoted"= W replacement repeat*(1-Total WD promotions) ~ 1/Week ~ Proportion of HHs making a repeat purchase on promotion as % of total HHs \ in week. Assumes Brands A and B are 100% substituable | W Brand A volume share= "% consumers preferring brand A"*(1-Proportion of Influenced Purchases)+Proportion of Influenced Purchases\ *W Brand A WD promotions/(W Brand A WD promotions+W Brand B WD promotions) ~ 1 ~ CAUTION: needs to integrate Yr0 calibration. Assumes promotions from all \ the brand have the same impact | W Brand B volume share= "% consumers preferring brand B"*(1-Proportion of Influenced Purchases)+Proportion of Influenced Purchases\ *W Brand B WD promotions /(W Brand A WD promotions+W Brand B WD promotions) ~ 1 ~ Caution: ex Yr0 calibration & direct ratio of WD promos on share (not \ right) | Total WD promotions= W Brand A WD promotions+W Brand B WD promotions-Promotions duplication ~ 1 ~ Total category promotions weighted distribution | Average Category volume on deal= (Proportion of Influenced Purchases*Promo VPP ratio to uninfluenced VPP)/(Proportion of Influenced Purchases\ *Promo VPP ratio to uninfluenced VPP+(1-Proportion of Influenced Purchases)*1) ~ 1 ~ Variable used to control de modelled volume sold on deal with the actual \ volume sold on deal from HHP/TP data. | Promo VPP ratio to uninfluenced VPP= Promo VPP/Uninfluenced VPP ~ 1 ~ Comes from HHP | W Avg Consumption Cat of users= 0.305056 ~ consumption unit/Week/HH ~ Weekly consumption per user. Calibrated to fit the model | TP Category VSOD= 0.31 ~ 1 ~ Year0 proportion of volume sold on deal in the category. Comes from HHP \ (TP if available). | Yr0 WD promo Brand B= 0.1 ~ 1 ~ Promotion level of 52 weeks prior to model (calibration from HHP data if \ available). In this model, 10% is a realistic assumption. | W Brand A WD promotions= INTEG ( Brand A promotions implementation, Yr0 WD promo Brand A) ~ 1 ~ Weighted Distribution of promotions for Brand A. % of stores offering a \ promotion for the brand, weighted by their category sales. | "% consumers preferring brand A"= 0.5 ~ 1 ~ Proportion of consumers preferring Brand A over B. Reflects a natural \ consumer preference towards a brand. | "% consumers preferring brand B"= 0.5 ~ 1 ~ Proportion of consumers preferring Brand B over A. Reflects a natural \ consumer preference towards a brand | Yr0 WD promo Brand A= 0.1 ~ 1 ~ Promotion level of 52 weeks prior to model (calibration from HHP data if \ available). In this model, 10% is a realistic assumption. | Promotions sales Impact Index= 1.93193 ~ 1 ~ Sales uplift on brand sales when promotion is available (index vs. \ baseline sales). Auto-calibrated to match VSOD from HHP (31%). Assumption: \ 10% WD promotions Brand A and B, all brands have the same sales uplift. \ Promo sales index can come from econometric promotion analysis if \ available. | Target volume share B= 0.5 ~ 1 ~ | Target volume share A= 0.55 ~ 1 ~ | Total HHs= 1e+007 ~ HH ~ All households in country. In this theoretical example, 10 mio HHs are \ assumed. Model dynamics and conclusions are not influenced by this \ parameter. | W Z Value Consumption= (Product at home amongst stable category users-Buyers Purchase Threshold)/"Consumption st-dev across consumers" ~ 1 ~ Z value of standardized normal distribution. Normal distribution assumed \ to approximate the NBD-Dirichlet distribution. | HHP PF= 5.45 ~ 1/HH ~ | K= 0.141 ~ 1 ~ Parameter K in NBD-Dirichlet model | Normal CDF( (-100, 1), (-4, 0.999968), (-3.99, 0.999967), (-3.98, 0.999966), (-3.97, 0.999964), (-3.96, 0.999963), (-3.95, 0.999961), (-3.94, 0.999959), (-3.93, 0.999958), (-3.92, 0.999956), (-3.91, 0.999954), (-3.9, 0.999952), (-3.89, 0.99995), (-3.88, 0.999948), (-3.87, 0.999946), (-3.86, 0.999943), (-3.85, 0.999941), (-3.84, 0.999938), (-3.83, 0.999936), (-3.82, 0.999933), (-3.81, 0.999931), (-3.8, 0.999928), (-3.79, 0.999925), (-3.78, 0.999922), (-3.77, 0.999918), (-3.76, 0.999915), (-3.75, 0.999912), (-3.74, 0.999908), (-3.73, 0.999904), (-3.72, 0.9999), (-3.71, 0.999896), (-3.7, 0.999892), (-3.69, 0.999888), (-3.68, 0.999883), (-3.67, 0.999879), (-3.66, 0.999874), (-3.65, 0.999869), (-3.64, 0.999864), (-3.63, 0.999858), (-3.62, 0.999853), (-3.61, 0.999847), (-3.6, 0.999841), (-3.59, 0.999835), (-3.58, 0.999828), (-3.57, 0.999822), (-3.56, 0.999815), (-3.55, 0.999807), (-3.54, 0.9998), (-3.53, 0.999792), (-3.52, 0.999784), (-3.51, 0.999776), (-3.5, 0.999767), (-3.49, 0.999758), (-3.48, 0.999749), (-3.47, 0.99974), (-3.46, 0.99973), (-3.45, 0.99972), (-3.44, 0.999709), (-3.43, 0.999698), (-3.42, 0.999687), (-3.41, 0.999675), (-3.4, 0.999663), (-3.39, 0.999651), (-3.38, 0.999638), (-3.37, 0.999624), (-3.36, 0.99961), (-3.35, 0.999596), (-3.34, 0.999581), (-3.33, 0.999566), (-3.32, 0.99955), (-3.31, 0.999534), (-3.3, 0.999517), (-3.29, 0.999499), (-3.28, 0.999481), (-3.27, 0.999462), (-3.26, 0.999443), (-3.25, 0.999423), (-3.24, 0.999402), (-3.23, 0.999381), (-3.22, 0.999359), (-3.21, 0.999336), (-3.2, 0.999313), (-3.19, 0.999289), (-3.18, 0.999264), (-3.17, 0.999238), (-3.16, 0.999211), (-3.15, 0.999184), (-3.14, 0.999155), (-3.13, 0.999126), (-3.12, 0.999096), (-3.11, 0.999065), (-3.1, 0.999032), (-3.09, 0.998999), (-3.08, 0.998965), (-3.07, 0.99893), (-3.06, 0.998893), (-3.05, 0.998856), (-3.04, 0.998817), (-3.03, 0.998777), (-3.02, 0.998736), (-3.01, 0.998694), (-3, 0.99865), (-2.99, 0.998605), (-2.98, 0.998559), (-2.97, 0.998511), (-2.96, 0.998462), (-2.95, 0.998411), (-2.94, 0.998359), (-2.93, 0.998305), (-2.92, 0.99825), (-2.91, 0.998193), (-2.9, 0.998134), (-2.89, 0.998074), (-2.88, 0.998012), (-2.87, 0.997948), (-2.86, 0.997882), (-2.85, 0.997814), (-2.84, 0.997744), (-2.83, 0.997673), (-2.82, 0.997599), (-2.81, 0.997523), (-2.8, 0.997445), (-2.79, 0.997365), (-2.78, 0.997282), (-2.77, 0.997197), (-2.76, 0.99711), (-2.75, 0.99702), (-2.74, 0.996928), (-2.73, 0.996833), (-2.72, 0.996736), (-2.71, 0.996636), (-2.7, 0.996533), (-2.69, 0.996427), (-2.68, 0.996319), (-2.67, 0.996207), (-2.66, 0.996093), (-2.65, 0.995975), (-2.64, 0.995855), (-2.63, 0.995731), (-2.62, 0.995604), (-2.61, 0.995473), (-2.6, 0.995339), (-2.59, 0.995201), (-2.58, 0.99506), (-2.57, 0.994915), (-2.56, 0.994766), (-2.55, 0.994614), (-2.54, 0.994457), (-2.53, 0.994297), (-2.52, 0.994132), (-2.51, 0.993963), (-2.5, 0.99379), (-2.49, 0.993613), (-2.48, 0.993431), (-2.47, 0.993244), (-2.46, 0.993053), (-2.45, 0.992857), (-2.44, 0.992656), (-2.43, 0.992451), (-2.42, 0.99224), (-2.41, 0.992024), (-2.4, 0.991802), (-2.39, 0.991576), (-2.38, 0.991344), (-2.37, 0.991106), (-2.36, 0.990863), (-2.35, 0.990613), (-2.34, 0.990358), (-2.33, 0.990097), (-2.32, 0.98983), (-2.31, 0.989556), (-2.3, 0.989276), (-2.29, 0.988989), (-2.28, 0.988696), (-2.27, 0.988396), (-2.26, 0.988089), (-2.25, 0.987776), (-2.24, 0.987455), (-2.23, 0.987126), (-2.22, 0.986791), (-2.21, 0.986447), (-2.2, 0.986097), (-2.19, 0.985738), (-2.18, 0.985371), (-2.17, 0.984997), (-2.16, 0.984614), (-2.15, 0.984222), (-2.14, 0.983823), (-2.13, 0.983414), (-2.12, 0.982997), (-2.11, 0.982571), (-2.1, 0.982136), (-2.09, 0.981691), (-2.08, 0.981237), (-2.07, 0.980774), (-2.06, 0.980301), (-2.05, 0.979818), (-2.04, 0.979325), (-2.03, 0.978822), (-2.02, 0.978308), (-2.01, 0.977784), (-2, 0.97725), (-1.99, 0.976705), (-1.98, 0.976148), (-1.97, 0.975581), (-1.96, 0.975002), (-1.95, 0.974412), (-1.94, 0.97381), (-1.93, 0.973197), (-1.92, 0.972571), (-1.91, 0.971933), (-1.9, 0.971283), (-1.89, 0.970621), (-1.88, 0.969946), (-1.87, 0.969258), (-1.86, 0.968557), (-1.85, 0.967843), (-1.84, 0.967116), (-1.83, 0.966375), (-1.82, 0.96562), (-1.81, 0.964852), (-1.8, 0.96407), (-1.79, 0.963273), (-1.78, 0.962462), (-1.77, 0.961636), (-1.76, 0.960796), (-1.75, 0.959941), (-1.74, 0.95907), (-1.73, 0.958185), (-1.72, 0.957284), (-1.71, 0.956367), (-1.7, 0.955435), (-1.69, 0.954486), (-1.68, 0.953521), (-1.67, 0.95254), (-1.66, 0.951543), (-1.65, 0.950529), (-1.64, 0.949497), (-1.63, 0.948449), (-1.62, 0.947384), (-1.61, 0.946301), (-1.6, 0.945201), (-1.59, 0.944083), (-1.58, 0.942947), (-1.57, 0.941792), (-1.56, 0.94062), (-1.55, 0.939429), (-1.54, 0.93822), (-1.53, 0.936992), (-1.52, 0.935745), (-1.51, 0.934478), (-1.5, 0.933193), (-1.49, 0.931888), (-1.48, 0.930563), (-1.47, 0.929219), (-1.46, 0.927855), (-1.45, 0.926471), (-1.44, 0.925066), (-1.43, 0.923641), (-1.42, 0.922196), (-1.41, 0.92073), (-1.4, 0.919243), (-1.39, 0.917736), (-1.38, 0.916207), (-1.37, 0.914657), (-1.36, 0.913085), (-1.35, 0.911492), (-1.34, 0.909877), (-1.33, 0.908241), (-1.32, 0.906582), (-1.31, 0.904902), (-1.3, 0.9032), (-1.29, 0.901475), (-1.28, 0.899727), (-1.27, 0.897958), (-1.26, 0.896165), (-1.25, 0.89435), (-1.24, 0.892512), (-1.23, 0.890651), (-1.22, 0.888768), (-1.21, 0.886861), (-1.2, 0.88493), (-1.19, 0.882977), (-1.18, 0.881), (-1.17, 0.879), (-1.16, 0.876976), (-1.15, 0.874928), (-1.14, 0.872857), (-1.13, 0.870762), (-1.12, 0.868643), (-1.11, 0.8665), (-1.1, 0.864334), (-1.09, 0.862143), (-1.08, 0.859929), (-1.07, 0.85769), (-1.06, 0.855428), (-1.05, 0.853141), (-1.04, 0.85083), (-1.03, 0.848495), (-1.02, 0.846136), (-1.01, 0.843752), (-1, 0.841345), (-0.99, 0.838913), (-0.98, 0.836457), (-0.97, 0.833977), (-0.96, 0.831472), (-0.95, 0.828944), (-0.94, 0.826391), (-0.93, 0.823814), (-0.92, 0.821214), (-0.91, 0.818589), (-0.9, 0.81594), (-0.89, 0.813267), (-0.88, 0.81057), (-0.87, 0.80785), (-0.86, 0.805105), (-0.85, 0.802337), (-0.84, 0.799546), (-0.83, 0.796731), (-0.82, 0.793892), (-0.81, 0.79103), (-0.8, 0.788145), (-0.79, 0.785236), (-0.78, 0.782305), (-0.77, 0.77935), (-0.76, 0.776373), (-0.75, 0.773373), (-0.74, 0.77035), (-0.73, 0.767305), (-0.72, 0.764238), (-0.71, 0.761148), (-0.7, 0.758036), (-0.69, 0.754903), (-0.68, 0.751748), (-0.67, 0.748571), (-0.66, 0.745373), (-0.65, 0.742154), (-0.64, 0.738914), (-0.63, 0.735653), (-0.62, 0.732371), (-0.61, 0.729069), (-0.6, 0.725747), (-0.59, 0.722405), (-0.58, 0.719043), (-0.57, 0.715661), (-0.56, 0.71226), (-0.55, 0.70884), (-0.54, 0.705401), (-0.53, 0.701944), (-0.52, 0.698468), (-0.51, 0.694974), (-0.5, 0.691462), (-0.49, 0.687933), (-0.48, 0.684386), (-0.47, 0.680822), (-0.46, 0.677242), (-0.45, 0.673645), (-0.44, 0.670031), (-0.43, 0.666402), (-0.42, 0.662757), (-0.41, 0.659097), (-0.4, 0.655422), (-0.39, 0.651732), (-0.38, 0.648027), (-0.37, 0.644309), (-0.36, 0.640576), (-0.35, 0.636831), (-0.34, 0.633072), (-0.33, 0.6293), (-0.32, 0.625516), (-0.31, 0.62172), (-0.3, 0.617911), (-0.29, 0.614092), (-0.28, 0.610261), (-0.27, 0.60642), (-0.26, 0.602568), (-0.25, 0.598706), (-0.24, 0.594835), (-0.23, 0.590954), (-0.22, 0.587064), (-0.21, 0.583166), (-0.2, 0.57926), (-0.19, 0.575345), (-0.18, 0.571424), (-0.17, 0.567495), (-0.16, 0.563559), (-0.15, 0.559618), (-0.14, 0.55567), (-0.13, 0.551717), (-0.12, 0.547758), (-0.11, 0.543795), (-0.1, 0.539828), (-0.09, 0.535856), (-0.08, 0.531881), (-0.07, 0.527903), (-0.06, 0.523922), (-0.05, 0.519939), (-0.04, 0.515953), (-0.03, 0.511966), (-0.02, 0.507978), (-0.01, 0.503989), (-4.09915e-014, 0.5), (0.01, 0.496011), (0.02, 0.492022), (0.03, 0.488034), (0.04, 0.484047), (0.05, 0.480061), (0.06, 0.476078), (0.07, 0.472097), (0.08, 0.468119), (0.09, 0.464144), (0.1, 0.460172), (0.11, 0.456205), (0.12, 0.452242), (0.13, 0.448283), (0.14, 0.44433), (0.15, 0.440382), (0.16, 0.436441), (0.17, 0.432505), (0.18, 0.428576), (0.19, 0.424655), (0.2, 0.42074), (0.21, 0.416834), (0.22, 0.412936), (0.23, 0.409046), (0.24, 0.405165), (0.25, 0.401294), (0.26, 0.397432), (0.27, 0.39358), (0.28, 0.389739), (0.29, 0.385908), (0.3, 0.382089), (0.31, 0.37828), (0.32, 0.374484), (0.33, 0.3707), (0.34, 0.366928), (0.35, 0.363169), (0.36, 0.359424), (0.37, 0.355691), (0.38, 0.351973), (0.39, 0.348268), (0.4, 0.344578), (0.41, 0.340903), (0.42, 0.337243), (0.43, 0.333598), (0.44, 0.329969), (0.45, 0.326355), (0.46, 0.322758), (0.47, 0.319178), (0.48, 0.315614), (0.49, 0.312067), (0.5, 0.308538), (0.51, 0.305026), (0.52, 0.301532), (0.53, 0.298056), (0.54, 0.294599), (0.55, 0.29116), (0.56, 0.28774), (0.57, 0.284339), (0.58, 0.280957), (0.59, 0.277595), (0.6, 0.274253), (0.61, 0.270931), (0.62, 0.267629), (0.63, 0.264347), (0.64, 0.261086), (0.65, 0.257846), (0.66, 0.254627), (0.67, 0.251429), (0.68, 0.248252), (0.69, 0.245097), (0.7, 0.241964), (0.71, 0.238852), (0.72, 0.235762), (0.73, 0.232695), (0.74, 0.22965), (0.75, 0.226627), (0.76, 0.223627), (0.77, 0.22065), (0.78, 0.217695), (0.79, 0.214764), (0.8, 0.211855), (0.81, 0.20897), (0.82, 0.206108), (0.83, 0.203269), (0.84, 0.200454), (0.85, 0.197663), (0.86, 0.194895), (0.87, 0.19215), (0.88, 0.18943), (0.89, 0.186733), (0.9, 0.18406), (0.91, 0.181411), (0.92, 0.178786), (0.93, 0.176186), (0.94, 0.173609), (0.95, 0.171056), (0.96, 0.168528), (0.97, 0.166023), (0.98, 0.163543), (0.99, 0.161087), (1, 0.158655), (1.01, 0.156248), (1.02, 0.153864), (1.03, 0.151505), (1.04, 0.14917), (1.05, 0.146859), (1.06, 0.144572), (1.07, 0.14231), (1.08, 0.140071), (1.09, 0.137857), (1.1, 0.135666), (1.11, 0.1335), (1.12, 0.131357), (1.13, 0.129238), (1.14, 0.127143), (1.15, 0.125072), (1.16, 0.123024), (1.17, 0.121), (1.18, 0.119), (1.19, 0.117023), (1.2, 0.11507), (1.21, 0.113139), (1.22, 0.111232), (1.23, 0.109349), (1.24, 0.107488), (1.25, 0.10565), (1.26, 0.103835), (1.27, 0.102042), (1.28, 0.100273), (1.29, 0.098525), (1.3, 0.0968), (1.31, 0.095098), (1.32, 0.093418), (1.33, 0.091759), (1.34, 0.090123), (1.35, 0.088508), (1.36, 0.086915), (1.37, 0.085343), (1.38, 0.083793), (1.39, 0.082264), (1.4, 0.080757), (1.41, 0.07927), (1.42, 0.077804), (1.43, 0.076359), (1.44, 0.074934), (1.45, 0.073529), (1.46, 0.072145), (1.47, 0.070781), (1.48, 0.069437), (1.49, 0.068112), (1.5, 0.066807), (1.51, 0.065522), (1.52, 0.064255), (1.53, 0.063008), (1.54, 0.06178), (1.55, 0.060571), (1.56, 0.05938), (1.57, 0.058208), (1.58, 0.057053), (1.59, 0.055917), (1.6, 0.054799), (1.61, 0.053699), (1.62, 0.052616), (1.63, 0.051551), (1.64, 0.050503), (1.65, 0.049471), (1.66, 0.048457), (1.67, 0.04746), (1.68, 0.046479), (1.69, 0.045514), (1.7, 0.044565), (1.71, 0.043633), (1.72, 0.042716), (1.73, 0.041815), (1.74, 0.04093), (1.75, 0.040059), (1.76, 0.039204), (1.77, 0.038364), (1.78, 0.037538), (1.79, 0.036727), (1.8, 0.03593), (1.81, 0.035148), (1.82, 0.03438), (1.83, 0.033625), (1.84, 0.032884), (1.85, 0.032157), (1.86, 0.031443), (1.87, 0.030742), (1.88, 0.030054), (1.89, 0.029379), (1.9, 0.028717), (1.91, 0.028067), (1.92, 0.027429), (1.93, 0.026803), (1.94, 0.02619), (1.95, 0.025588), (1.96, 0.024998), (1.97, 0.024419), (1.98, 0.023852), (1.99, 0.023295), (2, 0.02275), (2.01, 0.022216), (2.02, 0.021692), (2.03, 0.021178), (2.04, 0.020675), (2.05, 0.020182), (2.06, 0.019699), (2.07, 0.019226), (2.08, 0.018763), (2.09, 0.018309), (2.1, 0.017864), (2.11, 0.017429), (2.12, 0.017003), (2.13, 0.016586), (2.14, 0.016177), (2.15, 0.015778), (2.16, 0.015386), (2.17, 0.015003), (2.18, 0.014629), (2.19, 0.014262), (2.2, 0.013903), (2.21, 0.013553), (2.22, 0.013209), (2.23, 0.012874), (2.24, 0.012545), (2.25, 0.012224), (2.26, 0.011911), (2.27, 0.011604), (2.28, 0.011304), (2.29, 0.011011), (2.3, 0.010724), (2.31, 0.010444), (2.32, 0.01017), (2.33, 0.009903), (2.34, 0.009642), (2.35, 0.009387), (2.36, 0.009137), (2.37, 0.008894), (2.38, 0.008656), (2.39, 0.008424), (2.4, 0.008198), (2.41, 0.007976), (2.42, 0.00776), (2.43, 0.007549), (2.44, 0.007344), (2.45, 0.007143), (2.46, 0.006947), (2.47, 0.006756), (2.48, 0.006569), (2.49, 0.006387), (2.5, 0.00621), (2.51, 0.006037), (2.52, 0.005868), (2.53, 0.005703), (2.54, 0.005543), (2.55, 0.005386), (2.56, 0.005234), (2.57, 0.005085), (2.58, 0.00494), (2.59, 0.004799), (2.6, 0.004661), (2.61, 0.004527), (2.62, 0.004396), (2.63, 0.004269), (2.64, 0.004145), (2.65, 0.004025), (2.66, 0.003907), (2.67, 0.003793), (2.68, 0.003681), (2.69, 0.003573), (2.7, 0.003467), (2.71, 0.003364), (2.72, 0.003264), (2.73, 0.003167), (2.74, 0.003072), (2.75, 0.00298), (2.76, 0.00289), (2.77, 0.002803), (2.78, 0.002718), (2.79, 0.002635), (2.8, 0.002555), (2.81, 0.002477), (2.82, 0.002401), (2.83, 0.002327), (2.84, 0.002256), (2.85, 0.002186), (2.86, 0.002118), (2.87, 0.002052), (2.88, 0.001988), (2.89, 0.001926), (2.9, 0.001866), (2.91, 0.001807), (2.92, 0.00175), (2.93, 0.001695), (2.94, 0.001641), (2.95, 0.001589), (2.96, 0.001538), (2.97, 0.001489), (2.98, 0.001441), (2.99, 0.001395), (3, 0.00135), (3.01, 0.001306), (3.02, 0.001264), (3.03, 0.001223), (3.04, 0.001183), (3.05, 0.001144), (3.06, 0.001107), (3.07, 0.00107), (3.08, 0.001035), (3.09, 0.001001), (3.1, 0.000968), (3.11, 0.000935), (3.12, 0.000904), (3.13, 0.000874), (3.14, 0.000845), (3.15, 0.000816), (3.16, 0.000789), (3.17, 0.000762), (3.18, 0.000736), (3.19, 0.000711), (3.2, 0.000687), (3.21, 0.000664), (3.22, 0.000641), (3.23, 0.000619), (3.24, 0.000598), (3.25, 0.000577), (3.26, 0.000557), (3.27, 0.000538), (3.28, 0.000519), (3.29, 0.000501), (3.3, 0.000483), (3.31, 0.000466), (3.32, 0.00045), (3.33, 0.000434), (3.34, 0.000419), (3.35, 0.000404), (3.36, 0.00039), (3.37, 0.000376), (3.38, 0.000362), (3.39, 0.000349), (3.4, 0.000337), (3.41, 0.000325), (3.42, 0.000313), (3.43, 0.000302), (3.44, 0.000291), (3.45, 0.00028), (3.46, 0.00027), (3.47, 0.00026), (3.48, 0.000251), (3.49, 0.000242), (3.5, 0.000233), (3.51, 0.000224), (3.52, 0.000216), (3.53, 0.000208), (3.54, 0.0002), (3.55, 0.000193), (3.56, 0.000185), (3.57, 0.000178), (3.58, 0.000172), (3.59, 0.000165), (3.6, 0.000159), (3.61, 0.000153), (3.62, 0.000147), (3.63, 0.000142), (3.64, 0.000136), (3.65, 0.000131), (3.66, 0.000126), (3.67, 0.000121), (3.68, 0.000117), (3.69, 0.000112), (3.7, 0.000108), (3.71, 0.000104), (3.72, 9.96e-005), (3.73, 9.57e-005), (3.74, 9.2e-005), (3.75, 8.84e-005), (3.76, 8.5e-005), (3.77, 8.16e-005), (3.78, 7.84e-005), (3.79, 7.53e-005), (3.8, 7.23e-005), (3.81, 6.95e-005), (3.82, 6.67e-005), (3.83, 6.41e-005), (3.84, 6.15e-005), (3.85, 5.91e-005), (3.86, 5.67e-005), (3.87, 5.44e-005), (3.88, 5.22e-005), (3.89, 5.01e-005), (3.9, 4.81e-005), (3.91, 4.61e-005), (3.92, 4.43e-005), (3.93, 4.25e-005), (3.94, 4.07e-005), (3.95, 3.91e-005), (3.96, 3.75e-005), (3.97, 3.59e-005), (3.98, 3.45e-005), (3.99, 3.3e-005), (4, 3.17e-005), (100, 0)) ~ 1/Week ~ Standardized normal distribution - cumulative | HHP Category Penetration= 0.299 ~ 1 ~ Year 0 category penetration from HHP | Promo VPP= 3.3 ~ consumption unit ~ Comes from HHP | Uninfluenced VPP= 2.64 ~ consumption unit ~ Comes from HHP | ******************************************************** .Control ********************************************************~ Simulation Control Parameters | FINAL TIME = 156 ~ Week ~ The final time for the simulation. | INITIAL TIME = 0 ~ Week ~ The initial time for the simulation. | SAVEPER = TIME STEP ~ Week [0,?] ~ The frequency with which output is stored. | TIME STEP = 0.25 ~ Week [0,?] ~ The time step for the simulation. | \\\---/// Sketch information - do not modify anything except names V300 Do not put anything below this section - it will be ignored *View 1 $192-192-192,0,Times New Roman|12||0-0-0|0-0-0|0-0-255|-1--1--1|-1--1--1|120,120,50,0 10,1,Proportion of Influenced Purchases,682,1983,71,42,8,131,0,0,0,0,0,0 10,2,W replacement repeat,1523,1475,80,42,8,131,0,0,0,0,0,0 10,3,Uninfluenced VPP,456,1388,55,22,8,3,0,0,0,0,0,0 10,4,Promo VPP,485,1514,48,12,8,3,0,0,0,0,0,0 10,5,Buyers Purchase Threshold,2246,1264,69,22,8,3,0,0,0,0,0,0 10,6,W Avg Consumption Cat of users,2078,1055,89,35,8,131,0,0,0,0,0,0 10,7,"Consumption st-dev across consumers",2249,1359,83,22,8,3,0,0,0,0,0,0 10,8,Normal CDF,1760,1440,54,12,8,3,0,0,0,0,0,0 10,9,W Z Value Consumption,1956,1318,55,22,8,3,0,0,0,0,0,0 1,10,7,9,1,0,0,0,0,64,0,-1--1--1,,1|(2092,1350)| 1,11,5,9,1,0,0,0,0,64,0,-1--1--1,,1|(2149,1300)| 1,12,8,2,1,0,0,0,0,64,0,-1--1--1,,1|(1661,1467)| 1,13,9,2,1,0,0,0,0,64,0,-1--1--1,,1|(1747,1365)| 10,14,Total WD promotions,2015,1707,81,35,8,131,0,0,0,0,0,0 10,15,HHP Category Penetration,2034,1567,66,22,8,3,0,0,0,0,0,0 10,16,K,2173,1518,1,1,8,131,0,0,0,0,0,0 10,17,Purchase Frequency,940,704,58,27,8,131,0,0,0,0,0,0 10,18,HHP PF,1963,1431,35,12,8,3,0,0,0,0,0,0 10,19,"W repeat - unpromoted",1052,1794,84,22,8,3,0,0,0,0,0,0 1,20,2,19,1,0,0,0,0,64,0,-1--1--1,,1|(1281,1663)| 1,21,19,1,0,0,0,0,0,64,0,-1--1--1,,1|(887,1877)| 10,22,"52W Rolling User base",1548,519,130,47,3,131,0,0,0,0,0,0 10,23,Total Product stock stable category users,1852,921,140,47,3,131,0,0,0,0,0,0 12,24,48,1456,928,10,8,0,3,0,0,-1,0,0,0 1,25,27,23,4,0,0,22,0,0,0,-1--1--1,,1|(1660,930)| 1,26,27,24,100,0,0,22,0,0,0,-1--1--1,,1|(1531,930)| 11,27,48,1603,930,6,8,34,3,0,0,1,0,0,0 10,28,Purchases,1603,950,42,12,40,3,0,0,-1,0,0,0 12,29,48,2190,928,10,8,0,3,0,0,-1,0,0,0 1,30,32,29,4,0,0,22,0,0,0,-1--1--1,,1|(2129,930)| 1,31,32,23,100,0,0,22,0,0,0,-1--1--1,,1|(2029,930)| 11,32,48,2073,930,6,8,34,3,0,0,1,0,0,0 10,33,Consumption,2073,950,54,12,40,3,0,0,-1,0,0,0 1,34,6,33,1,0,0,0,0,64,0,-1--1--1,,1|(2071,1008)| 10,35,Product at home amongst stable category users,2230,1129,72,37,8,131,0,0,0,0,0,0 1,36,23,35,1,0,0,0,0,64,0,-1--1--1,,1|(1901,1062)| 10,37,Total HHs,1274,950,45,12,8,3,0,0,0,0,0,0 1,38,35,9,1,0,0,0,0,64,0,-1--1--1,,1|(2170,1197)| 1,39,37,28,0,0,0,0,0,64,0,-1--1--1,,1|(1433,950)| 10,40,W Brand A volume share,309,2328,69,22,8,3,0,0,0,0,0,0 10,41,W Brand B volume share,1355,2184,68,22,8,3,0,0,0,0,0,0 10,42,"% consumers preferring brand A",306,2184,78,22,8,3,0,0,0,0,0,0 10,43,"% consumers preferring brand B",1356,2080,78,22,8,3,0,0,0,0,0,0 1,44,43,41,0,0,0,0,0,64,0,-1--1--1,,1|(1355,2125)| 1,45,42,40,0,0,0,0,0,64,0,-1--1--1,,1|(306,2249)| 10,46,Target volume share A,516,2480,60,22,8,3,0,0,0,0,0,0 10,47,Target volume share B,1644,2322,60,22,8,3,0,0,0,0,0,0 10,48,W Brand A WD promotions,1511,2483,125,47,3,131,0,0,0,0,0,0 10,49,Promotions sales Impact Index,1648,1906,71,22,8,3,0,0,0,0,0,0 10,50,Promotions sales Impact Index,988,2260,77,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,51,W Brand A WD promotions,1988,1806,73,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,52,51,14,1,0,0,0,0,64,0,-1--1--1,,1|(1990,1803)| 10,53,Yr0 WD promo Brand A,1520,2594,66,22,8,3,0,0,0,0,0,0 12,54,48,1161,2479,10,8,0,3,0,0,-1,0,0,0 1,55,57,48,4,0,0,22,0,0,0,-1--1--1,,1|(1335,2479)| 1,56,57,54,100,0,0,22,0,0,0,-1--1--1,,1|(1221,2479)| 11,57,48,1278,2479,6,8,34,3,0,0,1,0,0,0 10,58,Brand A promotions implementation,1278,2509,85,22,40,3,0,0,-1,0,0,0 10,59,Gap between target and actual share Brand A,517,2342,105,22,8,3,0,0,0,0,0,0 1,60,46,59,0,0,0,0,0,64,0,-1--1--1,,1|(516,2418)| 10,61,W Brand B WD promotions,2475,2375,127,47,3,131,0,0,0,0,0,0 12,62,48,2042,2376,10,8,0,3,0,0,-1,0,0,0 1,63,65,61,4,0,0,22,0,0,0,-1--1--1,,1|(2277,2376)| 1,64,65,62,100,0,0,22,0,0,0,-1--1--1,,1|(2123,2376)| 11,65,48,2200,2376,6,8,34,3,0,0,1,0,0,0 10,66,Brand B promotions implementation,2200,2406,84,22,40,3,0,0,-1,0,0,0 1,67,61,14,1,0,0,0,0,64,0,-1--1--1,,1|(2355,1850)| 1,68,61,41,1,0,0,0,0,64,0,-1--1--1,,1|(2124,2081)| 10,69,Gap between target and actual share Brand B,1648,2206,104,22,8,3,0,0,0,0,0,0 10,70,Possible Brand B WD promotions change,1836,2306,93,22,8,131,0,0,0,0,0,0 1,71,41,69,0,0,0,0,0,64,0,-1--1--1,,1|(1476,2192)| 1,72,47,69,0,0,0,0,0,64,0,-1--1--1,,1|(1645,2270)| 10,73,Promotions sales Impact Index,2047,2144,104,40,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,74,Yr0 WD promo Brand B,2468,2544,66,22,8,3,0,0,0,0,0,0 1,75,53,48,0,0,0,0,0,64,1,-1--1--1,,1|(1517,2557)| 1,76,1,41,0,0,0,0,0,64,0,-1--1--1,,1|(1013,2081)| 1,77,1,40,1,0,0,0,0,64,0,-1--1--1,,1|(425,2175)| 1,78,48,40,1,0,0,0,0,64,0,-1--1--1,,1|(841,2151)| 1,79,40,59,0,0,0,0,0,64,0,-1--1--1,,1|(388,2332)| 10,80,Average Category volume on deal,410,1894,75,22,8,3,0,0,0,0,0,0 1,81,1,80,1,0,0,0,0,64,0,-1--1--1,,1|(488,1952)| 10,82,TP Category VSOD,404,1990,53,22,8,3,0,0,0,0,0,0 10,83,Promo VPP ratio to uninfluenced VPP,400,1780,81,22,8,3,0,0,0,0,0,0 1,84,4,83,1,0,0,0,0,64,0,-1--1--1,,1|(438,1716)| 1,85,3,83,1,0,0,0,0,64,0,-1--1--1,,1|(397,1659)| 1,86,83,80,1,0,0,0,0,64,0,-1--1--1,,1|(393,1854)| 10,87,"W repeat - promoted",1290,1830,80,22,8,3,0,0,0,0,0,0 10,88,Promo VPP ratio to uninfluenced VPP,1452,1922,87,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,89,"W repeat - promoted",1310,1060,86,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,90,87,1,0,0,0,0,0,64,0,-1--1--1,,1|(988,1905)| 10,91,Total WD promotions,805,1583,54,31,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,92,91,19,1,0,0,0,0,64,0,-1--1--1,,1|(957,1601)| 1,93,82,1,0,0,0,0,0,64,1,-1--1--1,,1|(527,1986)| 10,94,HHP based Avg product stock,1808,830,68,22,8,3,0,0,0,0,0,0 1,95,83,1,0,0,0,0,0,64,1,-1--1--1,,1|(520,1867)| 10,96,Promotions duplication,2172,1862,48,22,8,3,0,0,0,0,0,0 1,97,96,14,1,0,0,0,0,64,0,-1--1--1,,1|(2081,1758)| 1,98,61,96,1,0,0,0,0,64,0,-1--1--1,,1|(2332,2023)| 1,99,51,96,1,0,0,0,0,64,0,-1--1--1,,1|(2056,1846)| 1,100,48,41,0,0,0,0,0,64,0,-1--1--1,,1|(1429,2327)| 1,101,61,40,1,0,0,0,0,64,0,-1--1--1,,1|(1340,2870)| 10,102,"52W Rolling non-users",999,516,135,48,3,131,0,0,0,0,0,0 1,103,105,22,4,0,0,22,0,0,0,-1--1--1,,1|(1350,518)| 1,104,105,102,100,0,0,22,0,0,0,-1--1--1,,1|(1202,518)| 11,105,1164,1276,518,6,8,34,3,0,0,1,0,0,0 10,106,W Increase in User base,1276,548,68,22,40,3,0,0,-1,0,0,0 12,107,48,1942,514,10,8,0,3,0,0,-1,0,0,0 1,108,110,107,4,0,0,22,0,0,0,-1--1--1,,1|(1861,518)| 1,109,110,22,100,0,0,22,0,0,0,-1--1--1,,1|(1728,518)| 11,110,48,1785,518,6,8,34,3,0,0,1,0,0,0 10,111,Lapsed Users,1785,538,56,12,40,3,0,0,-1,0,0,0 1,112,37,106,0,0,0,0,0,64,0,-1--1--1,,1|(1274,760)| 10,113,W Proportion of stable light buyers,1438,268,86,43,8,131,0,0,0,0,0,0 10,114,W Proportion of opportunistic new buyers,1142,273,96,33,8,131,0,0,0,0,0,0 10,115,W proportion of lapsed users from NBD Dirichlet,1865,347,83,37,8,131,0,0,0,0,0,0 10,116,W Proportion of new users in Year,1272,390,76,22,8,3,0,0,0,0,0,0 1,117,114,116,0,0,0,0,0,64,0,-1--1--1,,1|(1207,332)| 1,118,113,116,0,0,0,0,0,64,0,-1--1--1,,1|(1346,335)| 1,119,116,106,0,0,0,0,0,64,0,-1--1--1,,1|(1273,462)| 10,120,W Proportion of new users in Year,1078,1054,82,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,121,Penetration,1112,700,47,12,8,3,0,0,0,0,0,0 1,122,37,121,0,0,0,0,0,64,0,-1--1--1,,1|(1196,830)| 1,123,121,17,0,0,0,0,0,64,0,-1--1--1,,1|(1038,701)| 12,124,48,620,518,10,8,0,3,0,0,-1,0,0,0 1,125,127,102,4,0,0,22,0,0,0,-1--1--1,,1|(797,522)| 1,126,127,124,100,0,0,22,0,0,0,-1--1--1,,1|(674,522)| 11,127,48,725,522,6,8,34,3,0,0,1,0,0,0 10,128,Lapsed Users over year,725,552,57,22,40,3,0,0,-1,0,0,0 10,129,Lapsed Users,722,390,80,28,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,130,129,128,0,0,0,0,0,64,0,-1--1--1,,1|(722,467)| 1,131,15,22,0,0,0,0,0,64,1,-1--1--1,,1|(1799,1061)| 1,132,37,22,0,0,0,0,0,64,1,-1--1--1,,1|(1395,757)| 1,133,37,102,0,0,0,0,0,64,1,-1--1--1,,1|(1151,756)| 10,134,W Proportion of opportunistic new buyers,604,1680,94,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,135,W Proportion of stable light buyers,842,1679,91,46,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,136,"W trial - unpromoted",842,1792,49,22,8,3,0,0,0,0,0,0 10,137,"W trial - promoted",684,1798,49,22,8,3,0,0,0,0,0,0 1,138,91,136,1,0,0,0,0,64,0,-1--1--1,,1|(956,1707)| 1,139,135,136,0,0,0,0,0,64,0,-1--1--1,,1|(842,1740)| 1,140,91,137,1,0,0,0,0,64,0,-1--1--1,,1|(696,1699)| 1,141,134,137,0,0,0,0,0,64,0,-1--1--1,,1|(643,1738)| 1,142,137,1,0,0,0,0,0,64,0,-1--1--1,,1|(683,1873)| 1,143,136,1,0,0,0,0,0,64,0,-1--1--1,,1|(775,1872)| 1,144,135,137,0,0,0,0,0,64,0,-1--1--1,,1|(752,1746)| 10,145,Annualized W category purchases,1056,1184,79,22,8,3,0,0,0,0,0,0 10,146,m,2062,1480,9,12,8,3,0,0,0,0,0,0 10,147,"Yearly purchasing rate st-dev",2104,1418,76,22,8,3,0,0,0,0,0,0 1,148,146,147,0,0,0,0,0,64,0,-1--1--1,,1|(2075,1459)| 1,149,16,147,0,0,0,0,0,64,0,-1--1--1,,1|(2150,1484)| 1,150,147,7,1,0,0,0,0,64,0,-1--1--1,,1|(2245,1366)| 10,151,HHP Avg VPP,2250,1626,62,11,8,3,0,0,0,0,0,0 1,152,151,7,0,0,0,0,0,64,0,-1--1--1,,1|(2249,1505)| 10,153,W total category purchases,1302,1186,69,22,8,3,0,0,0,0,0,0 1,154,89,153,0,0,0,0,0,64,0,-1--1--1,,1|(1306,1116)| 1,155,120,153,0,0,0,0,0,64,0,-1--1--1,,1|(1183,1116)| 1,156,153,145,0,0,0,0,0,64,0,-1--1--1,,1|(1190,1185)| 10,157,Time to adjust promotions,1276,2386,60,22,8,3,0,0,0,0,0,0 1,158,157,58,1,0,0,0,0,64,0,-1--1--1,,1|(1278,2416)| 10,159,Time to adjust promotions,2198,2226,66,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,160,159,66,0,0,0,0,0,64,0,-1--1--1,,1|(2198,2309)| 10,161,"Weeks/year",920,1112,49,12,8,3,0,0,0,0,0,0 1,162,161,145,0,0,0,0,0,64,0,-1--1--1,,1|(971,1139)| 10,163,"Purchase/HH",1442,882,55,12,8,3,0,0,0,0,0,0 1,164,163,28,0,0,0,0,0,64,0,-1--1--1,,1|(1515,913)| 10,165,Time to measure market shares,516,2266,69,22,8,3,0,0,0,0,0,0 1,166,165,59,0,0,0,0,0,64,0,-1--1--1,,1|(516,2297)| 10,167,Time to measure market shares,1648,2108,75,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,168,167,69,0,0,0,0,0,64,0,-1--1--1,,1|(1648,2150)| 1,169,15,146,0,0,0,0,0,64,0,-1--1--1,,1|(2047,1525)| 10,170,Annualized W category purchases,684,700,85,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,171,170,17,0,0,0,0,0,64,0,-1--1--1,,1|(818,701)| 10,172,Proportion of promo purchases that are repeat purchase,1780,1836,103,33,8,3,0,0,0,0,0,0 10,173,Penetration,1884,1900,58,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,174,173,172,0,0,0,0,0,64,0,-1--1--1,,1|(1855,1882)| 10,175,Proportion of promo purchases that are repeat purchase,882,270,103,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,176,175,114,0,0,0,0,0,64,0,-1--1--1,,1|(1008,271)| 1,177,18,146,0,0,0,0,0,64,0,-1--1--1,,1|(2013,1455)| 1,178,115,113,1,0,0,0,0,64,0,-1--1--1,,1|(1593,272)| 10,179,Proportion of new Year users from stable NBD Dirichlet base,1279,143,81,46,8,131,0,0,0,0,0,0 1,180,179,113,1,0,0,0,0,64,0,-1--1--1,,1|(1379,237)| 10,181,HHP Category Penetration,2028,190,67,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,182,Delay for decision making,1134,2386,68,22,8,3,0,0,0,0,0,0 1,183,102,121,0,0,0,0,0,64,0,-1--1--1,,1|(1062,620)| 1,184,22,102,0,1,0,0,0,64,1,-1--1--1,,1|(1282,517)| 10,185,"W forward repeat - promoted",1578,1772,74,22,8,3,0,0,0,0,0,0 10,186,"W opportunistic repeat - promoted",1782,1604,74,22,8,3,0,0,0,0,0,0 1,187,14,186,0,0,0,0,0,64,0,-1--1--1,,1|(1889,1651)| 1,188,2,186,0,0,0,0,0,64,0,-1--1--1,,1|(1663,1544)| 1,189,2,185,0,0,0,0,0,64,0,-1--1--1,,1|(1550,1626)| 1,190,88,185,0,0,0,0,0,64,0,-1--1--1,,1|(1509,1852)| 1,191,49,185,0,0,0,0,0,64,0,-1--1--1,,1|(1616,1845)| 1,192,172,185,0,0,0,0,0,64,0,-1--1--1,,1|(1668,1801)| 1,193,185,87,0,0,0,0,0,64,0,-1--1--1,,1|(1443,1798)| 1,194,14,185,0,0,0,0,0,64,0,-1--1--1,,1|(1799,1738)| 10,195,"W forward repeat - promoted",1046,178,80,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,196,195,114,0,0,0,0,0,64,0,-1--1--1,,1|(1083,215)| 10,197,"W opportunistic repeat - promoted",1378,1704,80,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,198,197,87,0,0,0,0,0,64,0,-1--1--1,,1|(1338,1761)| 10,199,"52W MAT promo users",1848,660,52,22,8,3,0,0,0,0,0,0 1,200,199,111,1,0,0,0,0,64,0,-1--1--1,,1|(1822,604)| 1,201,113,111,1,0,0,0,0,64,0,-1--1--1,,1|(1653,385)| 10,202,W Proportion of opportunistic new buyers,1994,764,94,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,203,202,199,1,0,0,0,0,64,0,-1--1--1,,1|(1883,744)| 10,204,Stable 52W proportion of lapsed promo users,1794,180,96,50,3,131,0,0,0,0,0,0 1,205,115,204,0,0,0,0,0,64,0,-1--1--1,,1|(1835,276)| 1,206,113,204,0,0,0,0,0,64,0,-1--1--1,,1|(1604,226)| 10,207,Stable 52W proportion of lapsed promo users,2012,630,85,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,208,"NBD-Dirichlet - stable category user base",2228,268,98,22,8,3,0,0,0,0,0,0 1,209,115,208,0,0,0,0,0,64,0,-1--1--1,,1|(2032,310)| 1,210,113,208,1,0,0,0,0,64,0,-1--1--1,,1|(1698,58)| 10,211,Total HHs,1984,420,55,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,212,211,208,0,0,0,0,0,64,0,-1--1--1,,1|(2091,352)| 1,213,181,208,0,0,0,0,0,64,0,-1--1--1,,1|(2120,226)| 1,214,208,35,1,0,0,0,0,64,0,-1--1--1,,1|(2228,684)| 1,215,94,23,0,0,0,0,0,64,1,-1--1--1,,1|(1820,856)| 1,216,37,23,0,0,0,0,0,64,1,-1--1--1,,1|(1508,938)| 1,217,208,33,1,0,0,0,0,64,0,-1--1--1,,1|(2195,601)| 1,218,89,28,0,0,0,0,0,64,0,-1--1--1,,1|(1462,1002)| 1,219,19,28,1,0,0,0,0,64,0,-1--1--1,,1|(1375,1397)| 10,220,W Proportion of stable light buyers,1606,848,92,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,221,220,28,0,0,0,0,0,64,0,-1--1--1,,1|(1604,902)| 10,222,"Proportion of influenced purchases - stable users",788,900,87,46,8,131,0,0,0,0,0,0 10,223,"W repeat - promoted",630,810,50,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,224,"W repeat - unpromoted",532,934,55,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,225,224,222,0,0,0,0,0,64,0,-1--1--1,,1|(637,919)| 1,226,223,222,0,0,0,0,0,64,0,-1--1--1,,1|(681,839)| 10,227,W Proportion of stable light buyers,620,1008,92,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,228,Total WD promotions,560,870,53,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,229,228,222,0,0,0,0,0,64,0,-1--1--1,,1|(650,881)| 1,230,227,222,0,0,0,0,0,64,0,-1--1--1,,1|(687,964)| 10,231,W avg VPP stable users,848,1022,49,22,8,3,0,0,0,0,0,0 1,232,222,231,0,0,0,0,0,64,0,-1--1--1,,1|(820,966)| 1,233,3,231,1,0,0,0,0,64,0,-1--1--1,,1|(573,1239)| 1,234,231,28,1,0,0,0,0,64,0,-1--1--1,,1|(1222,986)| 10,235,"NBD-Dirichlet - stable category user base",1689,1133,92,37,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,236,Total HHs,1874,1210,55,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,237,NBD stable category users penetration,1618,1286,87,22,8,3,0,0,0,0,0,0 1,238,235,237,0,0,0,0,0,64,0,-1--1--1,,1|(1652,1210)| 1,239,236,237,1,0,0,0,0,64,0,-1--1--1,,1|(1748,1232)| 1,240,237,2,0,0,0,0,0,64,0,-1--1--1,,1|(1578,1364)| 1,241,237,23,0,0,0,0,0,64,1,-1--1--1,,1|(1722,1121)| 10,242,Max Brand A WD promotions change,869,2676,72,38,8,131,0,0,0,0,0,0 10,243,Min Brand A WD promotion change,981,2545,70,43,8,131,0,0,0,0,0,0 10,244,WD promotions change target for Brand A,778,2322,83,38,8,131,0,0,0,0,0,0 1,245,59,244,0,0,0,0,0,64,0,-1--1--1,,1|(651,2331)| 1,246,50,244,0,0,0,0,0,64,0,-1--1--1,,1|(894,2287)| 10,247,Possible Brand A WD promotions change,784,2426,93,22,8,3,0,0,0,0,0,0 1,248,242,247,1,0,0,0,0,64,0,-1--1--1,,1|(783,2550)| 1,249,243,247,0,0,0,0,0,64,0,-1--1--1,,1|(871,2479)| 1,250,244,247,0,0,0,0,0,64,0,-1--1--1,,1|(780,2375)| 1,251,247,58,0,0,0,0,0,64,0,-1--1--1,,1|(1028,2466)| 1,252,182,58,0,0,0,0,0,64,0,-1--1--1,,1|(1200,2442)| 1,253,48,242,1,0,0,0,0,64,0,-1--1--1,,1|(1222,2695)| 1,254,48,243,1,0,0,0,0,64,0,-1--1--1,,1|(1221,2570)| 10,255,Delay for decision making,2104,2298,73,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,256,255,66,0,0,0,0,0,64,0,-1--1--1,,1|(2146,2346)| 10,257,WD promotions change target for Brand B,1834,2156,69,33,8,3,0,0,0,0,0,0 1,258,73,257,0,0,0,0,0,64,0,-1--1--1,,1|(1929,2149)| 1,259,69,257,0,0,0,0,0,64,0,-1--1--1,,1|(1740,2180)| 1,260,257,70,0,0,0,0,0,64,0,-1--1--1,,1|(1834,2229)| 1,261,70,66,0,0,0,0,0,64,0,-1--1--1,,1|(2010,2354)| 10,262,Min Brand B WD promotion change,1934,2456,74,22,8,3,0,0,0,0,0,0 10,263,Max Brand B WD promotion change,1808,2606,75,22,8,3,0,0,0,0,0,0 1,264,61,262,1,0,0,0,0,64,0,-1--1--1,,1|(2189,2472)| 1,265,262,70,1,0,0,0,0,64,0,-1--1--1,,1|(1853,2395)| 1,266,263,70,1,0,0,0,0,64,0,-1--1--1,,1|(1737,2452)| 1,267,61,263,1,0,0,0,0,64,0,-1--1--1,,1|(2140,2602)| 1,268,74,61,0,0,0,0,0,64,1,-1--1--1,,1|(2470,2478)| 1,269,58,243,0,0,0,0,0,64,0,-1--1--1,,1|(1129,2526)| 10,270,Brand A promotions implementation,676,2566,91,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,271,270,242,0,0,0,0,0,64,0,-1--1--1,,1|(751,2609)| 10,272,Brand B promotions implementation,1646,2690,90,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,273,272,263,0,0,0,0,0,64,0,-1--1--1,,1|(1720,2651)| 1,274,66,262,0,0,0,0,0,64,0,-1--1--1,,1|(2068,2430)| 1,275,207,199,0,0,0,0,0,64,1,-1--1--1,,1|(1920,646)| 1,276,211,111,0,0,0,0,0,64,0,-1--1--1,,1|(1890,475)| 10,277,Short term WD promotions implementation,1092,2640,64,33,8,3,0,0,0,0,0,0 10,278,Short term WD promotions implementation,1996,2550,70,33,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,279,278,262,0,0,0,0,0,64,0,-1--1--1,,1|(1965,2503)| 1,280,278,263,0,0,0,0,0,64,0,-1--1--1,,1|(1910,2574)| 1,281,277,243,0,0,0,0,0,64,0,-1--1--1,,1|(1047,2601)| 1,282,277,242,0,0,0,0,0,64,0,-1--1--1,,1|(991,2655)| 10,283,"Stable user base at any time - base period",2104,480,93,22,8,3,0,0,0,0,0,0 1,284,283,208,0,0,0,0,0,64,0,-1--1--1,,1|(2161,380)| 1,285,4,231,1,0,0,0,0,64,0,-1--1--1,,1|(586,1286)| 10,286,Proportion of Influenced Purchases,790,1174,93,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,287,W avg VPP all buyers,682,1304,62,22,8,3,0,0,0,0,0,0 1,288,286,287,1,0,0,0,0,64,0,-1--1--1,,1|(713,1242)| 1,289,4,287,0,0,0,0,0,64,0,-1--1--1,,1|(573,1419)| 10,290,Uninfluenced VPP,648,1444,61,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,291,290,287,0,0,0,0,0,64,0,-1--1--1,,1|(662,1380)| 10,292,Category volume,994,1357,68,39,3,131,0,0,0,0,0,0 12,293,48,1194,1360,10,8,0,3,0,0,-1,0,0,0 1,294,296,293,4,0,0,22,0,0,0,-1--1--1,,1|(1158,1362)| 1,295,296,292,100,0,0,22,0,0,0,-1--1--1,,1|(1091,1362)| 11,296,48,1127,1362,6,8,34,3,0,0,1,0,0,0 10,297,"52W MAT volume",1127,1392,46,22,40,3,0,0,-1,0,0,0 12,298,48,814,1350,10,8,0,3,0,0,-1,0,0,0 1,299,301,292,4,0,0,22,0,0,0,-1--1--1,,1|(897,1352)| 1,300,301,298,100,0,0,22,0,0,0,-1--1--1,,1|(840,1352)| 11,301,48,863,1352,6,8,34,3,0,0,1,0,0,0 10,302,Volume bought,863,1382,33,22,40,3,0,0,-1,0,0,0 10,303,W total category purchases,1002,1548,74,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,304,303,302,1,0,0,0,0,64,0,-1--1--1,,1|(868,1496)| 10,305,HHP Avg VPP,924,1472,47,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,306,HHP Category Penetration,1018,1442,67,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,307,HHP PF,1072,1480,46,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,308,305,292,0,0,0,0,0,64,1,-1--1--1,,1|(949,1428)| 1,309,306,292,0,0,0,0,0,64,1,-1--1--1,,1|(1010,1414)| 1,310,307,292,0,0,0,0,0,64,1,-1--1--1,,1|(1045,1437)| 10,311,Total HHs,970,1290,55,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,312,311,292,0,0,0,0,0,64,1,-1--1--1,,1|(974,1303)| 1,313,303,297,1,0,0,0,0,64,0,-1--1--1,,1|(1122,1531)| 1,314,311,302,1,0,0,0,0,64,0,-1--1--1,,1|(901,1306)| 1,315,311,297,1,0,0,0,0,64,0,-1--1--1,,1|(1056,1303)| 1,316,287,302,1,0,0,0,0,64,0,-1--1--1,,1|(764,1372)| 1,317,287,297,1,0,0,0,0,64,0,-1--1--1,,1|(988,1223)| 1,318,19,153,1,0,0,0,0,64,0,-1--1--1,,1|(1228,1489)| 10,319,Category volume,808,2870,44,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,320,Brand A volume sales,414,2662,69,22,8,3,0,0,0,0,0,0 10,321,Brand B volume sales,1722,2954,68,22,8,3,0,0,0,0,0,0 1,322,319,321,1,0,0,0,0,64,0,-1--1--1,,1|(1141,2943)| 1,323,319,320,1,0,0,0,0,64,0,-1--1--1,,1|(624,2793)| 1,324,40,320,0,0,0,0,0,64,0,-1--1--1,,1|(358,2488)| 10,325,W Brand B volume share,2114,2818,61,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,326,325,321,0,0,0,0,0,64,0,-1--1--1,,1|(1925,2883)| 10,327,"W repeat - promoted",1368,662,50,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,328,"W repeat - unpromoted",1410,772,55,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,329,NBD stable category users penetration,1612,640,93,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,330,"Weeks/year",1696,748,60,12,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 10,331,Stable user base PF,1548,736,47,22,8,3,0,0,0,0,0,0 1,332,328,331,0,0,0,0,0,64,0,-1--1--1,,1|(1476,754)| 1,333,327,331,0,0,0,0,0,64,0,-1--1--1,,1|(1453,696)| 1,334,329,331,0,0,0,0,0,64,0,-1--1--1,,1|(1583,682)| 1,335,330,331,0,0,0,0,0,64,0,-1--1--1,,1|(1622,742)| 1,336,220,331,0,0,0,0,0,64,0,-1--1--1,,1|(1577,792)| 10,337,"Purchase/HH",862,1273,68,24,8,130,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128 1,338,337,302,0,0,0,0,0,64,0,-1--1--1,,1|(862,1321)| 1,339,337,297,1,0,0,0,0,64,0,-1--1--1,,1|(998,1262)| ///---\\\ :L<%^E!@ 1:C:\Users\Lorenzo\Documents\AAA - Theory for services\VF Model - Lrt\Vensim PLE\Going repeat simple.vdf 1:C:\Users\Lorenzo\Documents\AAA - Theory for services\VF Model - Lrt\Vensim PLE\Current.vdf 1:C:\Users\Lorenzo\Documents\AAA - Theory for services\VF Model - Lrt\Vensim PLE\ReferenceMode.vdf 9:Going repeat simple 22:$,Dollar,Dollars,$s 22:Day,Days 22:Hour,Hours 22:Month,Months 22:Person,People,Persons 22:Unit,Units 22:Week,Weeks 22:Year,Years 13:ReferenceMode 23:0 15:0,0,0,0,0,0 19:50,0 27:2, 34:0, 4:Time 5:Yr0 WD promo Brand B 35:Date 36:YYYY-MM-DD 37:2000 38:1 39:1 40:3 41:0 24:0 25:156 26:156