Shop Rate Calculator.xlsx

	A	B	C	E	F	I	J	M	N
1	Shop Rate Calculator
2	By Barbie McCormick
3
4	NON-BILLABLE ITEMS:
5
6	Annual purchases:	$		Bi or tri annual purchases:	$	5 to 10 year purchases:	$	10+ yeears:	$
7
8	Thread	0		labels		Rugs		Shelves
9	chalk			garment bags		Sewing machine		garment racks
10	needles			hangers		Serger		mirror
11	machine needles			notebooks		specialty machine		remodeling
12	pens/ pencils			sketch pads		industrial iron		light fixtures
13	shoulder pads			lightbulbs		pressing tools		tables
14	elastic rolls			cleaning/ dusting tools		drafting tools		drafting tables
15	velcro rolls			rotary blades		task lights		cabinets
16	zippers			welcome mat		office chairs		Thread racks
17	books/ cds/ dvds			thumb drives		storage bins		test	1000
18	magazines			business cards		scissors
19	tracing paper			test	1000	rotary cutters
20	tracing wheels					rotary mats
21	seam rippers					presser feet
22	patterns					rulers
23	pattern paper					Snap pliers
24	pins					eyelet pliers
25	replacement buttons					boning cutters
26	snaps					pinking shears
27	hooks and eyes					test	1000
28	room freshener
29	test	1000
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50	Subtotal Annual	1000		Subtotal biannual	1000	Subtotal 5 to 10	1000	subtotal 10 plus	1000
51
52	Total Annual	1000		Total biannual	500	Total 5 to 10 yrs	133.3333333	Total 10 plus	100
53
54	Total average annual non-billable items:		1733.333333
55
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