Quoting

Quoting methodology and notes

TOOL BOXES
Straightforward for standard boxes.

Customs require additions and modifications w/in the sheet.

Passwords are in the usual location

Modding:
 * BOM Sheet
 * Powder coat costs go here (outside and additional)
 * In line @ top- removable back, etc- can add 5% instead of calculating an add'l panel + weld
 * Yellow cells in BOM sheet
 * Overrides- unprotect sheet for those over 99"-
 * Enter 2-digit size, unprotect sheet > Data > Data Validation > Clear all
 * Redneck:
 * Unprotect sheet
 * Panel size calcs- Door stiffener: -1 to end of formula
 * Welded stiffeners in door: -1 to weld formula
 * Margins: 18/20/22.5/25
 * Produce separate sheet
 * Tank boxes:
 * 3.5 shelves & markup add'l 5% to get cost
 * Customs- 1 = 2@35, 2 = 2@30
 * Door kits: Put in a box w/that door and add up the following:
 * Door labor
 * Door mat'l
 * Door assy mat'l
 * Divide by reciprocal of margin (ex .65 for 35%)
 * Utili- Alum Z
 * 41.42 for handle
 * Enter M box & change stuff, change to Z @ top, change handle size
 * Backpacks & tongue boxes get quoted in old sheets
 * Std qtys, 'normal' boxes- 5 @ 2 margin
 * High quantities: 25 & above get next margin down.

FAB
Methodology below, by resource_id

Check in quote data sheet for requotes

Print all active quote sheets if you want all, sub # + 1 for individual sheets

To use tool:
 * Retrieve
 * Make changes to subs
 * Pull up sub/top, make changes
 * Add info to data sheet
 * Change next
 * Add info to data sheets
 * When done: Replace Quote in Data File

Laser
Setups: Adjustments:
 * Mild steel 14ga & thinner: .1
 * 12ga-7ga: .2
 * 1/4": .25
 * heavier than .25": .4
 * 1/8 al: .25
 * .190 al: .4
 * SS: .35


 * 95% of quantities 250 or less
 * 90% of quantities 251-400
 * greater than 400: 85%

Shear
Setup- .2

2 people

Anything wider than 12'- don't use shear

Shear handling

AL-check Jeff's sheet (shear/turret/press)

Turret
Rate calculation:


 * 2 seconds for tool changes

Tool notes:
 * 1 second per hit
 * 20sec per repo
 * Don't forget to add post-repo tool changes!
 * Load & Unload part- never less than 10 sec (each), adjusted up for size
 * Ex: 17 x 95 1/2" part would get 20 sec L&U
 * Standard tools: .25 setup.
 * Setups requiring tool swaps: .35 setup
 * 10ga & up gets 1" square, not 2"

Press Brake
Considerations: To calculate:
 * Part size
 * Number of setups
 * 22 seconds to load/unload total (17x95 10ga ss reference)
 * Standard stroke- 8 seconds
 * standard punch/die setup .2
 * special/offset die setup .35
 * crossbreak setup .35
 * OFFSET stroke- 10sec/stroke
 * 1/4 flatface bumper = 2 on bumper bender, 2 on press. 10ga = 1 person on the press

Wing bender
Write the second section of your page here.

Weld
Mig steel = 6"/min

Mig alum = 4"/min

Tig = 3"/min

Powder Coat
T:\Powder.xls - there are sheets for available colors in the same folder for spray to waste.


 * To create new, copy the old sheet & rename for color, entering specific gravity and the cost/lb of powder.

Uses area of part in square inches and an 8" hook spacing (this has changed w/new line)

Long parts (72" +)- leave more than 3 empty hooks between parts

Can it be double hung?

The sheet gives you cost per part, w/o markup

Assembly
Multiply x SIX to get adjusted rates.

Metal Finish
Write the second section of your page here.

Drill
Write the second section of your page here.

Band Saw
Write the second section of your page here.