Screen Print Shop Cost Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Download for personal use
2
Please note this is a starting point. Use your own values & modify as needed. Also, be careful about moving or cut/paste of cells, which may break formulas.
3
prepared by DecoPro: Tom Vann - for assitance or consulting email tvann@decoprotommy.com
4
5
Determine Hourly Rate
Analyze Production Output
6
Wages
Output Previous Year
7
DepartmentNumber EmployeesAnnual Rate
Annual Income
Hourly (2080hrs)ForecastTotal Units
Avg Yield/Hr
8
Management1$60,000.00$60,000.00$28.85Potential *2,080,000 1,000
9
Office2$30,000.00$60,000.00$28.85Actual750,000 361
10
Production $15/hr6$31,200.00$187,200.00$90.00
* based on 2 presses output 500pcs/hr each, 2080hrs/yr
11
Total Wages$307,200.00$147.69
12
13
Overhead
Hourly Rate & Average Unit Cost
14
TypeDescriptionMonthlyAnnualHourly (2080hrs)
Wages & Overhead only
15
UtilitiesGas1000$12,000.00$5.77Forecast
Total Hourly **
Number Presses
Hourly/Press ***
OutputUnit Cost
w/Materials
16
UtilitiesElectric2000$24,000.00$11.54Potential *$217.532 $108.76500 $0.22$0.29
17
BuildingRent$5,000.00$60,000.00$28.85Actual Prev Year$217.532 $108.76180 $0.60$0.68
18
BuildingMaintenance$150.00$1,800.00$0.87Target*$217.532 $108.76312 $0.35$0.42
19
Equipment12-color auto$2,841.00$34,092.00$16.39
* decrease downtime, avg 5 hours printing per/press, per/day at 500/hr
20
Equipment6-color auto$959.00$11,508.00$5.53
** Adds Wages & Overhead
21
EquipmentExposure Unit$105.00$1,260.00$0.61
*** Adjusts by how many presses you decide to amortize total shop hourly
22
EquipmentOther$50.00$600.00$0.29
23
Office & Art DeptComputers$204.00$2,448.00$1.18
24
ShippingUPS Daily Pickup $15.00$180.00$0.09
25
Total Overhead
$145,260.00$69.84
26
27
28
Determine Material Unit Costs
Apply Data To Price Matrix
29
Materials
30
TypeDescriptionMonthlyAnnualPer Unit Cost*
Screen Print Cost
31
Office & Art DeptSupplies$150.00$1,800.000.0024
Setup Time/hr/Color *
Hourly Rate **
Setup Rate
32
Screen DeptMesh$300.00$3,600.000.00480.25$108.76$27.19
33
Screen DeptEmulsion$500.00$6,000.000.0080Press Rate/hr *
Hourly Rate **
Unit Cost
w/Materials ***
34
Screen DeptMisc Supplies$150.00$1,800.000.0024300$108.76$0.36$0.44
35
ProductionInk$3,125.00$37,500.000.0500Colors/Qty12 24 48 96 144 250 5001000
36
ProductionMisc Supplies$150.00$1,800.000.00241 $2.70$1.57$1.00$0.72$0.62$0.54$0.49$0.46
37
ShippingSupplies$200.00$2,400.000.00322 $4.97$2.70$1.57$1.00$0.81$0.65$0.54$0.49
38
Total Supplies$54,900.000.07323 $7.23$3.83$2.14$1.29$1.00$0.76$0.60$0.52
39
* per unit based on prev years output (calculates unit cost as total supplies divided by previous years atual output
4 $9.50$4.97$2.70$1.57$1.19$0.87$0.65$0.54
40
Note: Can also base unit material costs based on known ink coverage & material use/job
5 $11.77$6.10$3.27$1.85$1.38$0.98$0.71$0.57
41
6 $14.03$7.23$3.83$2.14$1.57$1.09$0.76$0.60
42
* Enter values per your shop
43
** This hourly rate pulls from TARGET Hourly/Press from above Hourly Rate & Average Unit Cost section
44
** This adds calculated unit material cost from Materials section
45
46
Screen Print Prices
47
Profit Margin *30%
48
Colors/Qty12 24 48 96 144 250 5001000
49
1 $3.86$2.24$1.43$1.03$0.89$0.78$0.70$0.66
50
2 $7.10$3.86$2.24$1.43$1.16$0.93$0.78$0.70
51
3 $10.33$5.48$3.05$1.84$1.43$1.09$0.86$0.74
52
4 $13.57$7.10$3.86$2.24$1.70$1.24$0.93$0.78
53
5 $16.81$8.72$4.67$2.65$1.97$1.40$1.01$0.82
54
6 $20.04$10.33$5.48$3.05$2.24$1.55$1.09$0.86
55
* This section applies profit margin to cost table for sale prices - adjust margin % as needed
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
Loading...