Title P&L Worksheet_Storiad
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
To Edit This File
3
Save this Worksheet to your computer: File/Make a Copy/Select Folder/[Name File]/OK
4
5
Title P&L Worksheet for Self-Published Titles
6
**For Illustrative Purposes Only**
7
Need Help? Visit storiad.com
8
9
PEPORTING PERIOD: START/END DATES
10
11
Start DateJanuary 1, 2019
12
End dateDecember 31, 2019
13
14
TITLE DATA
15
TitleAGreatBook
16
AuthorAnnieB.Jones
17
Trim size
18
Pages211
19
20
PRICING DATA
21
Retail Price (Print)$12.95
22
Retail Price (eBook)$9.95
23
Retail Price (Audio Book)$6.99
24
25
SPECIFIC TITLE COSTS
26
Freelance$100
27
Art/Photo$100
28
Marketing$100
29
Total$300
30
31
BY SEGMENTS
32
ALLOCATIONS of TITLE COSTS PRINTEBOOKAUDIO
33
Freelance$40 $22 $37
34
Art/Photo$40 $22 $37
35
Marketing$40 $22 $37
36
Total$121 $67 $112 Check$300
37
Looks Good!
38
39
BY SEGMENTS
40
MANUFACTURING COSTSPRINTEBOOKAUDIO
41
Manufacturing (Print)$3,500
42
Formatting (eBook)$2,500
43
Recording (Audio Book)$3,500
44
Freight (Print)$450
45
Subtotal$3,950$2,500$3,500$9,950
46
Mfg per Unit$1.46 $1.67 $1.40
47
Title Costs$121 $67 $112 Check$300
48
Total Cost per Unit$1.51 $1.71 $1.44 Looks Good!
49
50
OVERHEAD COSTS (TOTAL)
51
Office-related Expenses$3,000 Drfine office expenses
52
Misc. O/H Expenses$3,000 Define O/H expenses
53
Total$6,000
54
55
BY SEGMENTS
56
ALLOCATIONS of OVERHEAD COSTS PRINTEBOOKAUDIO
57
Office-related Expenses$1,209 $672 $1,119
58
Misc. O/H Expenses$1,209 $672 $1,119
59
Total$2,418 $1,343 $2,239 Check$6,000
60
Looks Good
61
62
BY SEGMENTS
63
SALES QUANTITY (BY SEGMENT)PRINTEBOOKAUDIO
64
Bookstores1,2001,5000
65
Specialty000
66
Direct to Consumer1,00000
67
Mass Market50000
68
Audio Channels002,500
69
Total2,7001,5002,500
70
Total all Forms6,700
71
as a % of Total40.30%22.39%37.31%100.00%
72
73
BY SEGMENTS
74
PROFIT & LOSS (BY SEGMENT)PRINTEBOOKAUDIO
75
Retail Price$12.95 $9.95 $6.99
76
Gross Units Sold2,7001,5002,500
77
Returns %
78
Net Units Sold2,7001,5002,5000returns
79
Average Discount$0.00 inv
80
Gross Sales$34,965 $14,925 $17,475
81
Returns$0 $0 $0
82
Net Sales$34,965 $14,925 $17,475 $67,365 Net Sales
83
Mfg Cost for Net Units($3,950)($2,500)($3,500)
84
Title Costs for Net Units($121)($67)($112)-$300.00
85
Total Cost of Sales($4,071)($2,567)($3,612)-$300.00
less Title costs
86
Overhead($2,418)($1,343)($2,239)Check($6,000)-$3,950.00
less sold units Print bk cost
87
Looks Good!-$6,000.00
Less E and Audio bk costs
88
89
NET EARNINGS $ (BY SEGMENT)$28,476 $11,015 $11,624 -$6,000.00
less overhead
90
NET EARNINGS % (BY SEGMENT)81.44%73.80%66.52%$51,115
Net Earnings Total
91
92
NET EARNINGS $ (TOTAL)$51,115 Final Check:
93
NET EARNINGS % (TOTAL)75.88%Looks Good!
94
95
© 2019 Storiad, Inc.
96
MGFR costs (INV COST as well)$1.46
97
TITLE costs$0.04
98
Total book cost$1.51
99
100
Loading...