Extruded Beam Cost Generator

	A	B	D	E	F	G	H	I
1	Cost Generator	Prepared by Ben	http://www.instagram.com/preciousplasticciledug				Note:
2							Please change number format to your currency.
3	I. Dimension		IV. Material Cost Per Plank				Originally this was created for Indonesian Rupiah.
4		Size (cm)	Material cost per product
5	Width	5	HDPE	195.00			How to use?
6	Height	15	PP	135.00			Adjust values for Dimension, Material Cost, Machine
7	Length	200	PS	135.00			specs, and electricity pricing. Then get your cost in
8	Total cubed	15,000					the total cost per beam section.
9	II. Material Cost		V. Machine Specs
10	Price per KG	NOK		rate grams/hour	KWH per Hour	Required Time
11	HDPE	13	Extruder 1	2000	1.2	7.5		https://docs.google.com/spreadsheets/d/1-L9mgjZ2ZIXi6qlmEPtT-lk3FdozrgemmA8xtPZcVCg/edit?usp=sharing
12	PP	9	Extruder 2	1000	0.5	15
13	PS	9	VI. Electricty Pricing
14			Rate
15	III. Density		1 KWH	0.19
16	Weight per cm3	grams	VII. Total cost per beam (excluding labor)
17	HDPE	0.96	Cost/Beam	Machine 1	Machine 2
18	PP	0.9	HDPE	196.70	196.41
19	PS	1.06	PP	136.70	136.41
20			PS	136.70	136.41
21
22
23
24
25
26
27
28
29
30
31
32
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