Fab Lab Cost Analysis and Order Form - Oct 2016
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
MATERIAL COST ANALYSIS
Name:Project:
School project cost budget:
$2
2
Instructions:1 - Click "File - Make A Copy" to save the file for your specific project
2 - Enter the appropriate information in the PURPLE cells only
3 - When entering the quantity, you must use the same units as indicated on the price sheet in number format only. (Ex. 6" of vinyl is actually 0.5 linear ft)
4 - Click on the cell with the price per unit and then click Ctrl+C to copy. Click on the appropriate cell in the unit price column and click Ctrl+V to paste.
5 - The RED cells will automatically be filled in for you.
3
Material Thermo Vinyl Film 15"Permanent Vinyl Film 15"Permanent Vinyl Film 24"Cling Material30" BannerMaker Bot MaterialUPrint Material
Soluble Support
H800 3D Printer MaterialDremel 3D Printer Material
4
Cost$6.52$1.65$1.79$0.01$1.00$0.05$2.45$4.76$0.03$0.06
5
Per Unitlinear ftlinear ftlinear ftsq inchlinear ftGramCu InCu InGramGram
6
Material Red Cedar 4/4"Cherry 4/4"Ash 4/4"Alder 4/4"Cherry 4/4"Red Oak 4/4"Walnut 4/4"White Pine 4/4"Birch 4/4"Walnut 4/4"
7
Cost$3.00$3.50$2.75$4.50$3.50$4.00$7.00$3.25$3.50$7.00
8
Per UnitBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtBoard Ft
9
Material Yellow Poplar 4/4"Oak 6/4"Oak 8/4"Pine 8/4"Brown Maple 4/4"Ash 4/4"Alder 4/4"1/4" Oak Plywood1/2" Oak Plywood3/4" Oak Plywood
10
Cost$2.50$4.25$5.00$2.50$2.50$2.75$4.50$1.50$2.00$2.00
11
Per UnitBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtBoard FtSq FtSq FtSq Ft
12
Material 1/8" Acrylic16 ga 4' x 4' sheet steelSafety Glasses
13
Cost$0.09$1.37$2.87
14
Per Unitsq insq ftOne Pair
15
16
MATERIALS COST ANALYSIS
CONVERSION CALCS
17
MaterialQty Used
(in, in sqd, bd/ft, gm, etc)
Unit PriceTotal Price of Material UsedBoard Foot CalculatorBoard Feet =3.611111111
18
Example: Cherry4$3.50$14.00
Thickness Inches
1
19
0.09$0.09Width Inches20
20
$0.00Length Inches26
21
$0.00
22
0$0.00Square Foot CalculatorSquare Feet = 0.5555555556
23
0$0.00Length Inches4
24
0$0.00Width Inches20
25
0$0.00
26
0$0.00
27
0$0.00
28
TOTAL MATERIALS$0.09
29
10% equipment usage fee$0.01
30
Enter cost of any pre-approved materials from home as negative
31
FINAL TOTAL$0.10
32
Round up to the nearest quarter$5.00
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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
Loading...
 
 
 
Cost Analysis
Copy of Cost Analysis
Materials
Materials (Wood)