Spreadsheet: 165764d1341335465-how-to-remove-from-a-cell-bom-export-example
Sheet: MOProjectedCost

 | American Hydroponics
 |  |  | Date Scheduled: |  |  |  |  | 07/03/2012 |  |  |  |  |  |  | Location Group: |  |  |  |  | Main
 |  |  | Date Issued: |  |  |  |  |  |  |  |  |  |  |  | Date Fulfilled:
 |  |  | MO Total Cost: |  |  |  |  |  |  |  |  |  |  |  | $ 4,233.58
 | Note:
 | Work Orders
 | WO Num: |  |  |  |  | Status: |  |  | Pending |  |  | Qty: | 1 |  |  | Date Started: |  |  |  |  |  |  |  |  |  | Class: |  |  | None
 | BOM: | 93046 |  |  |  | Location: |  |  |  |  |  |  |  |  |  | Date Completed:
 | Assigned User(s):
 | Finished Goods
 |  |  |  | 93046 |  |  | 2012HL NFT System lipless |  |  |  |  |  |  | 1 |  |  | ea
 | Raw Good
 |  |  |  | Part # |  |  | Description |  |  |  |  |  |  | Needed |  |  |  |  |  |  |  |  |  | Unit Cost |  |  |  |  |  | Total Cost
 |  |  |  | 85092 |  |  | Brochure Trifold commercial |  |  |  |  |  |  | 1 |  |  | ea |  |  |  |  |  |  | $ 0.00 |  |  |  |  |  | $ 0.00
 |  |  |  | 87029 |  |  | Bucket Black 5 gal |  |  |  |  |  |  | 2 |  |  | ea |  | 14 |  |  |  | ea | $ 4.80 |  |  |  |  |  | $ 9.60
 |  |  |  | 87030 |  |  | Lid Bucket Black 5gal |  |  |  |  |  |  | 2 |  |  | ea |  | 19 |  |  |  | ea | $ 1.50 |  |  |  |  |  | $ 3.00
 |  |  |  | 88114 |  |  | [NAME] |  |  |  |  |  |  | 6 |  |  | ea |  | 9 |  |  |  | ea | $ 20.90 |  |  |  |  |  | $ 125.40
 |  |  |  | 99118 |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | ea |  |  |  |  |  |  | $ 250.00 |  |  |  |  |  | $ 250.00
 |  |  |  | 02085 |  |  | ChannelF High Hole |  |  |  |  |  |  | 16 |  |  | ea |  | 0 |  |  |  | ea | $ 14.53 |  |  |  |  |  | $ 232.51
 |  |  |  | 02086 |  |  | ChannelF Low Hole |  |  |  |  |  |  | 16 |  |  | ea |  | 0 |  |  |  | ea | $ 14.53 |  |  |  |  |  | $ 232.51
 |  |  |  | 02078 |  |  | Channel Drip Cap 10ft |  |  |  |  |  |  | 20 |  |  | ft |  | 1,254 |  |  |  | ft | $ 0.44 |  |  |  |  |  | $ 8.80
 |  |  |  | 02087 |  |  | ChannelN [NAME] |  |  |  |  |  |  | 8 |  |  | ea |  | 0 |  |  |  | ea | $ 18.10 |  |  |  |  |  | $ 144.77
 |  |  |  | 91110 |  |  | Table Frame 2012HL System |  |  |  |  |  |  | 1 |  |  | ea |  | 0 |  |  |  | ea | $ 321.74 |  |  |  |  |  | $ 321.74
 |  |  |  | 24057 |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | ea |  | 0 |  |  |  | ea | $ 79.81 |  |  |  |  |  | $ 79.81
 |  |  |  | 25095 |  |  | Plumbing 2012HL System |  |  |  |  |  |  | 1 |  |  | ea |  | 0 |  |  |  | ea | $ 101.48 |  |  |  |  |  | $ 101.48
 |  |  |  | 03022 |  |  | Reservoir 150gal |  |  |  |  |  |  | 1 |  |  | ea |  | 0 |  |  |  | ea | $ 157.54 |  |  |  |  |  | $ 157.54
 |  |  |  | 83139 |  |  | Pump Rio 32HF |  |  |  |  |  |  | 1 |  |  | ea |  | 0 |  |  |  | ea | $ 80.00 |  |  |  |  |  | $ 80.00
 |  |  |  | 80002 |  |  | Channel Scrub Brush |  |  |  |  |  |  | 2 |  |  | ea |  | 29 |  |  |  | ea | $ 12.81 |  |  |  |  |  | $ 25.61
 |  |  |  | 02082 |  |  | End Cap Channel with Window |  |  |  |  |  |  | 40 |  |  | ea |  | 3,354 |  |  |  | ea | $ 0.57 |  |  |  |  |  | $ 22.69
 |  |  |  | 30274 |  |  | [NAME]On #600 |  |  |  |  |  |  | 2 |  |  | ea |  | 53 |  |  |  | ea | $ 11.77 |  |  |  |  |  | $ 23.54
 |  |  |  | 54015 |  |  | Acid Tank 1gal with lid |  |  |  |  |  |  | 1 |  |  | ea |  | 9 |  |  |  | ea | $ 5.73 |  |  |  |  |  | $ 5.73
 |  |  |  | 83161 |  |  | [NAME] 30 |  |  |  |  |  |  | 1 |  |  | ea |  | 11 |  |  |  | ea | $ 96.19 |  |  |  |  |  | $ 96.19
 |  |  |  | 83015 |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | ea |  | 39 |  |  |  | ea | $ 67.36 |  |  |  |  |  | $ 67.36
 |  |  |  | 87200 |  |  | [NAME] |  |  |  |  |  |  | 350 |  |  | ea |  | 11,150 |  |  |  | ea | $ 0.08 |  |  |  |  |  | $ 28.00
 |  |  |  | 87018 |  |  | Oasis LC-1 1in #5225 Sheet |  |  |  |  |  |  | 40 |  |  | ea |  | 1,114 |  |  |  | ea | $ 4.38 |  |  |  |  |  | $ 175.07
 |  |  |  | 88030 |  |  | pH Down 10% 1gal |  |  |  |  |  |  | 4 |  |  | ea |  | 15 |  |  |  | ea | $ 13.45 |  |  |  |  |  | $ 53.80
 |  |  |  | 40002 |  |  | Labor for Production |  |  |  |  |  |  | 1 |  |  | hr |  |  |  |  |  |  | $ 25.00 |  |  |  |  |  | $ 25.00
 |  |  |  | 27012 |  |  | Float Valve |  |  |  |  |  |  | 1 |  |  | ea |  | 26 |  |  |  | ea | $ 4.71 |  |  |  |  |  | $ 4.71
 |  |  |  | 27028 |  |  | Float Valve Plumb Kit |  |  |  |  |  |  | 1 |  |  | ea |  | 2 |  |  |  | ea | $ 15.21 |  |  |  |  |  | $ 15.21
 |  |  |  | 85094 |  |  | Instructions 2012HL System |  |  |  |  |  |  | 1 |  |  | ea |  |  |  |  |  |  | $ 0.00 |  |  |  |  |  | $ 0.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WO Total: |  |  |  |  |  |  |  |  | $ 2,290.08