{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

freepc - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
$263.40 PC Cost $1,000.00 Retention Rate #ADDIN? discount rate 0.1 Price increase 0.03 Switch back 0.1 NPV #ADDIN? Time With us? Quit? Comeback? Revenue Price 0 Yes 0 0 $263.40 1 Yes 0 0 $263.40 0.5 0.6 0.7 0.8 0.9 2 Yes #ADDIN? 0 $263.40 $263.40 Name NPV NPV NPV NPV NPV 3 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $271.30 Description Output (Sim Output (Sim Output (Sim Output (Sim Output (Sim#5) 4 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $279.44 Cell F8 F8 F8 F8 F8 5 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $287.82 Minimum = -312.99 -312.99 -312.99 -312.99 -312.99 6 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $296.46 Maximum = 1371.32 1766.71 2061.12 2219.84 2489.99 7 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $305.35 Mean = 262.65 391.32 584.3 871.87 1375.44 8 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $314.51 Std Deviatio 335.7 404.43 482.37 549.28 642.35 9 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $323.95 Variance = 112692.7 163564.6 232677.1 301711.7 412612.4 10 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $333.67 Skewness = 0.55 0.49 0.43 0.02 -0.21 11 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $343.68 Kurtosis = 2.9 2.79 2.71 2.35 2.27 32 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $639.34 95% Perc = 848.44 1132.05 1415.91 1758.87 2368 33 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $658.52 Filter Minimum = 34 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $678.28 Filter Maximum = 35 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $698.63 Type (1 or 2) = 36 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $719.58 # Values Fi 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -400 -400 -400 -400 -400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $741.17 Scenario #1 >75% >75% >75% >75% >75% 38 #ADDIN? #ADDIN? #ADDIN? #ADDIN? $763.41 Scenario #2 <25% <25% <25% <25% <25% 39 #ADDIN? #ADDIN?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}