DPSMagazine_Budget.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	PRINT ESTIMATE									NOTATIONS
2		ROLE	AMOUNT	UNIT	X	RATE	TAB	TOTAL		Shift start up (minutes)	15
3	MATERIALS	Laser Proof (13 x19)	33	Unit	1	$25		$825		Shift close (minutes)	15
4		4-color -- X1 (one-sided) or 2x (two-sided)	5940000	per page	2	$ 0.05		$628,452		Make-ready time (minutes)	5
5		Black and white -- X1 (one-sided) or 2x (two-sided)	0	per page	1	$ 0.01		$0		Proofing time (minutes)	3
6		Paper: 13x19 Coated Cover = 1000 sheets	45	unit	1	$ 73.04		$3,287		Staff used	1
7		Paper: 13x19 Coated Book = 1000 sheets	1485	unit	1	$ 48.27		$71,681		Staff cost (Avg.)	$20
8		Binding (perfect binding)	45,000	per unit	1	$ 0.50		$22,500	(Publishing Xpress, n.d.)	Make-ready waste	5
9		Specialty Ink (one color)	0	per page	2	$ 0.05		$0		Overrun waste sheets	50
10	DESIGN / PRE-PRESS LABOR	Job Set up and preliminary activites	0.25	hrs	1	$44		$11		Overrun waste percent	10
11		Text processing	0.5	hrs	1	$23		$12		Run waste percent	0.2
12		Image Creation	0.5	hrs	1	$23		$12		Percentage uptime of press	80
13		Image Processing	0.5	hrs	1	$23		$12		Hours per shift	8
14		Image Manipulation	0.5	hrs	1	$23		$12		Shifts per week	5
15		Output	1	hrs	1	$23		$23		Impressions per shift	38,400
16	PRESS LABOR	Output Production cost (80 pages per minutes)	1237.5	hrs	2	$44		$108,900		Impressions per minute (pages a minute)	80
17		Output binding cost (80 pages per minutes) Additional 0.10 hr per 16 pages	618.75	hrs	1	$44		$27,225		Impressions per Month	864,000
18	POST -PRESS LABOR	Package / Box	0.5	hrs	1	$44		$22		Maintenance time per week (minutes)	120
19
20		SUB -TOTAL Management Labor = 25% OF OTHER LABOR	465	hrs	1	$39		$18,135.00		Maintenance staff	1
21		SUB -TOTAL Materials Costs		units				$726,745		Maintenance staff cost	$20
22		SUB -TOTAL Design Labor	3	hrs	1	$23		$69.00		Equipment Monthly lease	$7,000
23		SUB -TOTAL Pressman Labor	1857	hrs	1	$28		$51,996.00		Maintenance contract (per month)	$2,000
24		TOTAL HOURS	1860	hrs
25					TOTAL BUDGET			$796,945		Manager Annual salary	$75,000	Manager Hourly salary	$39
26		Contingency / Overage 10%						$79,694.48		Designer Annual salary	$45,000	Designer hourly salary	$23
27		G & A Expenses (office, Marketing, office expense, payroll taxes, insurance, Equipment leases)						$159,388.95		Pressman Annual salary	$85,000	Pressman hourly salary	$44
28		TOTAL PRINT PRODUCTION COSTS Expenses + G&A Expenses)						$956,334
29		PROFIT MARGIN (at least 20%, but something that the market will bear)						$191,266.74		TOTAL LABOR	1860
30		TOTAL COSTS for the CLIENT ESTIMATE (The sum you hand a client in an estimate)						$1,227,294.9
31			8.5x11 magazine
32			Pages	units	total of pages/units	total minutes	hours
33	Line 16	PRODUCTION OUTPUT	132	45,000	5940000	74250	1237.5
34
35	Line 17	BINDING			371250	37125	618.75
36
37
38
39	Line 6	Cover sheets	5940000	1485000	1485
40
41
42
43
44
45
46
47
48
49
50		CALCULATING TIME
51		1 hour = 1
52		45 mins = .75
53		1/2 hour = .5
54		15 mins = .25
55		Normally you never calculate less than 15 min chunks
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100