Spreadsheet to accompany post on book-hacking (see A1 for link)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
http://barefootintocyberspace.com/2012/02/07/pricing-and-di…post-mortem-25/
2
(All foreign currencies have been converted to GBP)
3
4
5
The ACTUAL figures
6
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
7
html5026£0£0£0£0£0£0
8
pdf4654£0£0£0£0£0£0
9
ePub929£0£0£0£0£0£0
10
Kindle - UK146£2.05£0.62£0£0.26£1.18£171.55
11
Kindle - US (70%)76£1.89£0.57£0£0.24£1.08£82.42
12
Kindle - ROW (35%)25£1.89£1.23£0£0£0.66£16.56
13
Kindle - EU11£2.56£0.77£0£0.26£1.53£16.88
14
Print - direct119£8.99£0£3.16£0.62£5.21£619.77
15
Print - POD - UK117£8.99£4.94£3.16£0£0.89£103.6
16
Print - POD - US42£8.22£4.52£2.6£0£1.11£46.41
17
Total11145£0.09£1,057.21
18
19
Scenario 1: Increasing the (print) cover price to 12.99
20
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
21
html5026£0£0£0£0£0£0
22
pdf4654£0£0£0£0£0£0
23
ePub929£0£0£0£0£0£0
24
Kindle - UK146£2.05£0.62£0£0.26£1.18£171.55
25
Kindle - US (70%)76£1.89£0.57£0£0.24£1.08£82.42
26
Kindle - ROW (35%)25£1.89£1.23£0£0£0.66£16.56
27
Kindle - EU11£2.56£0.77£0£0.26£1.53£16.88
28
Print - direct119£12.99£0£3.16£0.62£9.21£1,095.77
29
Print - POD - UK117£12.99£7.14£3.16£0£2.69£314.2
30
Print - POD - US42£12.99£7.14£2.6£0£3.25£136.49
31
Total11145£0.16£1,833.88
32
33
Scenario 2: If I had increased the Kindle version
34
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
35
html5026£0£0£0£0£0£0
36
pdf4654£0£0£0£0£0£0
37
ePub929£0£0£0£0£0£0
38
Kindle - UK146£6.99£2.1£0£0.26£4.63£676.42
39
Kindle - US (70%)76£6.99£2.1£0£0.24£4.65£353.58
40
Kindle - ROW (35%)25£6.99£4.54£0£0£2.45£61.16
41
Kindle - EU11£6.99£2.1£0£0.26£4.64£50.99
42
Print - direct119£8.99£0£3.16£0.62£5.21£619.77
43
Print - POD - UK117£8.99£4.94£3.16£0£0.89£103.6
44
Print - POD - US42£8.99£4.94£2.6£0£1.45£60.89
45
Total11145£0.17£1,926.41
46
47
Scenario 3: If I had sold all print copies direct, instead of going through Amazon
48
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
49
html5026£0£0£0£0£0£0
50
pdf4654£0£0£0£0£0£0
51
ePub929£0£0£0£0£0£0
52
Kindle - UK146£2.05£0.62£0£0.26£1.18£171.55
53
Kindle - US (70%)76£1.89£0.57£0£0.24£1.08£82.42
54
Kindle - ROW (35%)25£1.89£1.23£0£0£0.66£16.56
55
Kindle - EU11£2.56£0.77£0£0.26£1.53£16.88
56
Print - direct119£12.99£0£3.16£0.62£9.21£1,095.77
57
Print - POD - UK117£12.99£0.65£3.16£1.25£7.93£927.87
58
Print - POD - US42£12.99£0.65£3.16£1.25£7.93£333.08
59
Total11145£0.24£2,644.14
60
61
Scenario 4: Increased print and Kindle cover prices, all print sales direct
62
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
63
html5026£0£0£0£0£0£0
64
pdf4654£0£0£0£0£0£0
65
ePub929£0£0£0£0£0£0
66
Kindle - UK146£6.99£2.1£0£0.26£4.63£676.42
67
Kindle - US (70%)76£6.99£2.1£0£0.24£4.65£353.58
68
Kindle - ROW (35%)25£6.99£4.54£0£0£2.45£61.16
69
Kindle - EU11£6.99£2.1£0£0.26£4.64£50.99
70
Print - direct119£12.99£0£3.16£0.62£9.21£1,095.77
71
Print - POD - UK117£12.99£0.65£3.16£1.25£7.93£927.87
72
Print - POD - US42£12.99£0.65£3.16£1.25£7.93£333.08
73
Total11145£0.31£3,498.87
74
75
Scenario 5: RIAA model - every download a lost sale
76
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
77
html5026£12.99£7.14£3.16£0£2.69£13,497.32
78
pdf4654£12.99£7.14£3.16£0£2.69£12,498.32
79
ePub929£12.99£7.14£3.16£0£2.69£2,494.83
80
Kindle - UK146£6.99£2.1£0£0.26£4.63£676.42
81
Kindle - US (70%)76£6.99£2.1£0£0.24£4.65£353.58
82
Kindle - ROW (35%)25£6.99£4.54£0£0£2.45£61.16
83
Kindle - EU11£6.99£2.1£0£0.26£4.64£50.99
84
Print - direct119£12.99£0£3.16£0.62£9.21£1,095.77
85
Print - POD - UK117£12.99£7.14£3.16£0£2.69£314.2
86
Print - POD - US42£12.99£7.14£2.6£0£3.25£136.49
87
Total11145£2.8£31,179.08
88
89
Scenario 6: Unicorn double rainbow model
90
#Cost to readerMerchant cutLightning Source cutDelivery costsNet revenue per unitNet revenue
91
Print - direct11145£12.99£0£3.16£0.62£9.21£102,624.85
92
Total11145£9.21£102,624.85
93
94
95
96
97
98
99
100
Loading...
Main menu