ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Instructions for use:
4
(1.) Download this file to your computer and open with Microsoft Excel OR open in Google Sheets if you don't have Microsoft excel. Excel Users: Click File > Download > Microsoft Excel Google Sheet Users: Click File > Save as Google Sheets (must have google account)
5
(2.) Edit the green cells only with your local costs in the master cost list below with your local costs, DO NOT edit any cells that aren't green, as the rest of the sheet will automatically update properly when you update the green cells.
6
(3.) After you fill out the costs below, toggle to the Flatbed and Add-on Prices (Sheet 2) at the bottom of the page to view your selling prices of the base model and add-ons.
7
Watch this video for step-by-step instructions for how to use this excel sheet
8
9
Steel Costs
10
Download PDF steel list to send supplier for quote >
11
Steel Type Unit Price/Unit Price Ft
12
3/16 P+O Plate 4 x 8 sheet $ 226.00 $ 7.06
13
12 guage P+O Plate 4 x 8 sheet $ 178.00 $ 5.56
14
14 Guage Diamond Plate 4 x 8 sheet $ 137.92 $ 4.31
15
14 Guage Diamond Plate 4 x 10 sheet $ 172.00 $ 4.30
16
2.5 x 2.5 x 0.120 Wall Square Tube 20 ft stick $ 139.00 $ 6.95
17
3 x 3 x 3/16" Wall Square Tube 20 ft stick $ 187.00 $ 9.35
18
1 x 1 x 0.090 Wall Square Tube 20 ft stick $ 26.50 $ 1.33
19
2 x 2 0.120 Wall Square Tube 20 ft stick $ 73.00 $ 3.65
20
2 x 3/16 Flat Bar 20 ft stick $ 26.50 $ 1.33
21
2 x 1/8 Flat Bar 20 ft stick $ 19.80 $ 0.99
22
1 x 3/16 Flat Bar 20 ft stick $ 13.57 $ 0.68
23
2 x 3/8 Flat Bar 20 ft stick $ 49.56 $ 2.48
24
2 x 3 x .120 Wall Rectangular Tube 20 ft stick $ 95.00 $ 4.75
25
6 x 3 x .120 Wall Rectangular Tube 20 ft stick $ 158.00 $ 7.90
26
2 x 3 x .090 Wall Rectangular Tube 20 ft stick $ 87.00 $ 4.35
27
1/4 Round Stock 20 ft stick $ 4.20 $ 0.21
28
3/4" sqaure stock 20 ft stick $ 42.00 $ 2.10
29
3 x 1.410 x 0.170 Channel Iron 20 ft stick $ 94.20 $ 4.71
30
31
Labor Costs
32
Input Notes Cost/Hr.
33
Average Employee's hourly Wage: Enter the average hourly wage you pay for shop employees. If you are self employed, set this number to $0. $ 25.00
34
Fabrication Labor Hourly CostYour average employee's hourly wage plus $15/hr to account for tool wear/tear + consumables $ 40.00
35
Install/Wiring Hourly CostYour average employee's hourly wage plus $5/hr to account for low amounts of tool wear and consumables $ 30.00
36
CNC Hourly CostYour average employee's hourly wage plus $35/hr to account for CNC table wear/tear. $ 60.00
37
38
Powder Coat/Paint/Finish Cost
Surface Area
39
Flatbed
Base Model (Open Frame)
$ 925.00 133 sq. ft
40
Toolboxes (Pair) Add-on $ 100.00
41
Fenders Add-on $ 50.00
42
Side Rails (2 sides and tailgate) Add-on $ 150.00
43
Steel Deck Upgrade Add-on $ 250.00
44
Add 3 ft Length (Cab/Chassis) Add-on $ 100.00
45
Lumber Rack Add-on $ 250.00
46
47
Outsourced CNC Cutting Costs - Ignore this section If CNC cutting parts in house.
48
PartNotes Cost
49
SRW Flatbed Parts CNC CutCost of material/cutting for one set of SRW flatbed parts - 4'x4' area of 3/16 plate @ 30 min cute time. $ 325.00
50
Dually Flatbed Parts CNC CutCost of material/cutting for one set of SRW flatbed parts - 4'x6' area of 3/16 plate @ 40 min cute time. $ 375.00
51
Fenders CNC CutCost of material/cutting for one set of fenders - 2'x4' area of 3/16 plate @ 15 min cute time. $ 135.00
52
Light Brackets/Fuel Plates CNC Cut
Cost of material/cutting for light brackets & fuel plate/bezel. 1 sq ft of 12 guage plate @ 10 min cut time. $ 10.00
53
54
Purchasing CNC Parts from HQ - Ignore this section if CNC cutting parts in house OR outsourcing locally outsourcing CNC cutting.
55
Input Notes Cost/Hr.
56
Cost of SRW Base Parts from HQ 1 Set per flatbed $ 550.00
57
Cost of DRW Base Parts from HQ 1 Set per flatbed $ 700.00
58
Cost of Fender Parts from HQ 1 Set per flatbed if requested by customer. $ 259.00
59
60
Lighting/Wiring/Misc
61
Product Cost/Unit Units Needed Total
62
Lighting Package/Mudflaps $ 519.00 1 $ 519.00
63
Lumber Mounting Hardware $ 0.22 100 $ 22.00
64
Switch $ 0.58 1 $ 0.58
65
Fuel Hose $ 18.00 1.5 $ 27.00
66
Wood Decking $ 18.98 12 $ 227.76
67
Trex Decking $ 24.00 12 $ 288.00
68
Stain $ 47.98 0.2 $ 9.60
69
Misc Items $ 75.00 1 $ 75.00
70
30" Toolboxes (Longbed) $ 268.99 2 $ 537.98
71
18" Toolboxes (Shortbed) $ 228.36 2 $ 456.72
72
24" Toolboxes (For Full Skirted) $ 234.99 2 $ 469.98
73
Tacoma 6 ft bed Toolboxes $ 253.82 2 $ 507.64
74
Gooseneck Ball Plate $ 140.93 1 $ 140.93
75
Strip LED Kit (Optional Add-on) $ 95.00 1 $ 95.00
76
D-Rings $ 2.53 depends on build $ 2.53
77
Grommets for 1" hole $ 0.50 depends on build $ 0.50
78
Grommets for 1.25" hole $ 0.93 1 $ 0.93
79
Bolt on Class 5 Reciever $ 332.00
1 - Cab/Chassis Builds Only
 $ 332.00
80
81
Enter your desired profit margin:40%
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100