Spreadsheet: 778913d1651435106-array-formula-help-across-tabs-quote-template-and-equipment-list
Sheet: Equipment

Labor: |  |  |  |  |  |  | Office: | GA |  |  |  | Tax: | Other - Tax |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
NOTES: |  |  |  |  |  |  |  |  | PROPOSAL LOG |  |  |  | Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day
 |  |  |  |  |  |  |  |  | Created By: |  |  |  | 2022-04-25 00:00:00 |  |  |  |  |  | Things to Check: |  |  |  |  |  |  | Y | GA
S | Speakers |  |  |  |  |  |  |  | Priced By: |  |  |  | 2022-04-25 00:00:00 |  |  |  |  |  | Footers |  |  |  |  |  |  | N
D | Displays |  |  |  |  |  |  |  | Engineered By: |  |  |  | 2022-04-25 00:00:00 |  |  |  |  |  | [NAME]
R | Racks |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  |  | Mark-Ups
P | Projectors |  |  |  |  |  |  |  | Modified By:
PR | ProAudio |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  |  | [NAME] Here::
H | Hardware |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  |  | (links to markup below)
RE | Rack Equipment |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  | 0.19 | Equipment Mark-up rate
C | Camera |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  | 0.65 | Special Equipment Mark-up rate
 |  |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  | 0.15 | Shipping Mark-up rate
 |  |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  |  | Travel Mark-up rate
 |  |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  | 1.17 | Prevailing Wage Labor Mark-up
 |  |  |  |  |  |  |  |  | Modified By: |  |  |  |  |  |  |  |  |  | Labor Mark-up rate
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
 |  |  |  |  |  |  |  |  | Modified By:
Rough Order of Magnitude
Client name here
ROM 200 Venue - 05/18/2021 | Client project |  |  |  |  |  |  | Our Cost: |  |  |  | Sale Price: |  |  |  | GPM per category |  |  |  | Gross Profit
Revision # |  |  |  |  |  |  |  | Equip | Union Labor | Labor | Misc | Equip | Union Labor | Labor | Misc | Equip | Union Labor | Labor | Misc | Profit | % Profit
2022-04-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Total Project Cost: |  |  |  | Total Project Price: |  |  |  |  |  |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR SUMMARY: |  | Rate | [NAME] | Sale |  | Cost | Sales $ |  |  |  |  |  | 800
 |  |  | AUDIO HARDWARE |  |  |  |  |  | A |  |  |  | 0.25 | Senior Director |  |  |  |  | 0 |  |  |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | Senior Consultant |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  | VIDEO HARDWARE |  |  |  |  |  | V |  |  |  | 0.25 | Senior Consultant/PM |  |  |  |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Project Manager |  |  |  |  |  |  |  |  |  |  |  |  | 250
 |  |  | CONTROL HARDWARE |  |  |  |  |  | C |  |  |  | 1.25 | Junior Project Manager |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Project Administrator |  |  |  |  |  |  |  |  |  |  |  |  | 800
 |  |  | LABOR |  |  |  |  |  |  |  |  |  | 1 | Engineer |  |  |  |  |  |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | Design Engineer 3rd Party Review |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  | PREVAILING WAGE LABOR |  |  |  |  |  |  |  |  |  | 0.6 | Programmer |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | DSP Programmer |  |  |  |  |  |  |  |  |  |  |  |  | 400
 |  |  | SHIPPING & HANDLING |  |  |  |  |  |  |  |  |  | 1.1 | Fabricator |  |  |  |  |  |  |  |  |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Field Supervisor |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  | TRAVEL |  |  |  |  |  |  |  |  |  | 1.165 | Field Technician |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | Draftsmen |  |  |  |  |  |  |  |  |  |  |  |  | 200
 |  |  | OPENING SUPPORT CONTINGENCY |  |  |  |  |  |  |  |  |  | 0.8 | Documentation
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.8 | Plotting Supplies
 |  |  |  |  |  | PROJECT SUB TOTAL |  |  |  |  |  |  | 0.15 | Prevailing Wage Labor |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | Subcontractor 2
 |  |  | SALES AND USE TAX |  |  |  |  |  |  |  |  |  | 0.15 | Subcontractor 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | Subcontractor 4
 |  |  |  |  |  | PROJECT GRAND TOTAL
Column1 | Manufacturer | Model | Description | qty | Column6 | Total | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22
 |  |  | H A R D W A R E |  |  |  |  |  | SHIP | COST | S,D,R,or P |  | Labor | [NAME] |  |  |  | Ship Total | Total Cost | %[NAME] | Special
AUDIO |  | Model | Description | qty | Each | Total
 | D&B AudioTechnik | Z1623.000 | 10AL-D Loudspeaker | 18 |  |  |  |  |  | 2534 | PR |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z1629.000 | 27A-SUB Subwoofer 15/12" | 6 |  |  |  |  |  | 3115 | PR |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z5413.000 | [NAME]. plates (2x) | 6 |  |  |  |  |  | 55.3 | H |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z5414.000 | [NAME] | 6 |  |  |  |  |  | 175 | H |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z5415.000 | [NAME] | 6 |  |  |  |  |  | 101.5 | H |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z5417.000 | 10AL Connector plates (2x) | 18 |  |  |  |  |  | 87.5 | H |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z1617.000 | 8S Loudspeaker | 8 |  |  |  |  |  | 1162 | PR |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z1619.000 | 10S-D Loudspeaker | 15 |  |  |  |  |  | 1995 | PR |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z2750.500 | D20 Amplifier US | 6 |  |  |  |  |  | 6482 | RE |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik | Z2770.500 | 30D Amplifier US | 6 |  |  |  |  |  | 5642 | RE |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | A |  |  |  | 0.35
 | D&B AudioTechnik |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | A |  |  |  | 0.35
 | CEI | Custom | Misc. Wires & Connectors |  |  |  |  |  |  |  |  |  | 0 |  |  | A |  |  |  | 0.35
VIDEO
 | Planar | EP5814K-T | 58" Touch Screen Display | 1 |  |  |  |  |  | 5249 | D |  | 1 |  |  | V |  |  |  | 0.25
 | Elo | 3243L | 32" Open Frame Touch Screen Display | 1 |  |  |  |  |  | 1200 | D |  | 1 |  |  | V |  |  |  | 0.25
 | Microsoft | Surface Pro 4 | Surface Mount Speaker-Black | 1 |  |  |  |  |  | 1799 | D |  | 1 |  |  | V |  |  |  | 0.25
 | Apple | iPad Pro | 12.9" iPad Pro | 1 |  | Column1 |  |  |  | 1275.87 | D |  | 1 |  |  | V |  |  |  | 0.25
 | CEI | Custom | Misc. Wires & Connectors |  |  |  |  |  |  |  |  |  | 0 |  |  | V |  |  |  | 0.25
CONTROL
 | Soloshot | Soloshot3 | PTZ tracking [NAME] | 1 |  |  |  |  |  | 900 | C |  | 1 |  |  | V |  |  |  | 0.65
 | AJA | U-TAP SDI | SDI to USB 3.0 | 1 |  |  |  |  |  | 345 | H |  | 1 |  |  | V |  |  |  | 0.25
 | 1 Beyond | Auto Tracker 2IP | Auto tracking camera System with IP control | 1 |  |  |  |  |  | 7410 | H |  | 1 |  |  | V |  |  |  | 0.25
 | CEI | Custom | Misc. Wires & Connectors |  |  |  |  |  |  |  |  |  | 0 |  |  | V |  |  |  | 0.25
CAFÉ
 | Soloshot | Soloshot3 | PTZ tracking [NAME] | 1 |  |  |  |  |  | 900 | C |  | 1 |  |  | V |  |  |  | 0.65
 | AJA | U-TAP SDI | SDI to USB 3.0 | 1 |  |  |  |  |  | 345 | H |  | 1 |  |  | V |  |  |  | 0.25
 | 1 Beyond | Auto Tracker 2IP | Auto tracking camera System with IP control | 1 |  |  |  |  |  | 7410 | H |  | 1 |  |  | V |  |  |  | 0.25
 | CEI | Custom | Misc. Wires & Connectors |  |  |  |  |  |  |  |  |  | 0 |  |  | V |  |  |  | 0.25
HEAD END SYSTEM
 | QSC | Core 110f | Audio DSP | 1 |  |  |  |  |  | 1800 |  |  | 2 |  |  | C |  |  |  | 0.25
 | QSC | 4.2Q | 4 [NAME] | 1 |  |  |  |  |  | 1350 |  |  | 2 |  |  | C |  |  |  | 0.25
 | QSC | 4.2Q | 4 [NAME] | 1 |  |  |  |  |  |  |  |  | 2 |  |  | C |  |  |  | 0.25
 | Origin | GENESIS Pro | Custom CPU for Configurator and Digital Signage | 1 |  |  |  |  |  | 3500 |  |  | 2 |  |  | C |  |  |  | 0.25
 | Middle Atlantic | QAR-12-20 | 12 RU Rack | 1 |  |  |  |  |  | 158.65 | R |  | 2 |  |  | C |  |  |  | 0.25
 | Middle Atlantic | SIDE-12-20 | Side Panel | 2 |  |  |  |  |  | 55.1 |  |  | 1 |  |  | C |  |  |  | 0.25
 | Middle Atlantic | PD-815SC-20 | Power Strip | 1 |  |  |  |  |  | 66.97 |  |  | 0.5 |  |  | C |  |  |  | 0.25
 | Middle Atlantic | EB1 | 1RU Blank Panel | 3 |  |  |  |  |  | 5.7 |  |  | 0.5 |  |  | C |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 0.25
 | CEI | Custom | Misc. Wires & Connectors |  |  |  |  |  |  |  |  |  | 0 |  |  | C |  |  |  | 0.25
EQUIPMENT RENTAL
 |  | lift | lift rental 2 lifts | 2 |  |  |  |  | 15 | 1200 |  |  | 3 |  |  | A |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | A |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  | Labor Days
 |  |  |  |  |  | HARDWARE SUBTOTAL
 |  |  | M I S C E L L A N E O U S |  |  |  |  |  |  |  |  |  | Cost Per |  |  |  |  |  | Total Cost | %[NAME]
FREIGHT
 | Shipping |  |  | LOT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25
TRAVEL
 | Airfare
 | Hotel
 | Per Diem
 | Local Transportation
 |  |  | LABOR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost | %[NAME]
DETAILED DESIGN |  |  |  |  | RATES
 |  |  |  | 4 | 100 | TOTAL |  |  | T
 |  |  |  | 5 | 100 |  |  |  | T
 |  |  |  | 2 | 125 |  |  |  | T
 |  |  |  | 4 | 125 |  |  |  | T
 |  |  |  | 0 | 100 |  |  |  | T
 |  |  | Lot | 0 | 50 |  |  |  | T
FABRICATION
 |  |  |  | 6 | 100 |  |  |  | T
 |  |  |  | 5 | 100 |  |  |  | T
 |  |  |  | 4 | 125 |  |  |  | T
 |  |  |  | 0 | 125 |  |  |  | T
 |  |  |  | 5 | 100 |  |  |  | T
 |  |  |  | 5 | 50 |  |  |  | T
 |  |  |  | 0
INSTALLATION
 |  |  |  | 0 | 100 |  |  |  | T
 |  |  |  | 4 | 100 |  |  |  | T
 |  |  |  | 4 | 125 |  |  |  | T
 |  |  |  | 4 | 125 |  |  |  | T
 |  |  |  | 4 | 100 |  |  |  | T
 |  |  |  | 4 | 50 |  |  |  | T
 |  |  |  | 4 | 100 |  |  |  | T
 |  |  |  | 4 | 100 |  |  |  | T
 |  |  |  | 4 | 125 |  |  |  | T
 |  |  |  | 0 | 125 |  |  |  | T
 |  |  |  | 0 | 100 |  |  |  | T
 |  |  |  | 0 | 50 |  |  |  | T
 |  |  |  | 0 | 125 |  |  |  | T
 |  |  | Lot | 0 | 100 |  |  |  | T
COMMISSIONING
 |  |  |  | 0 | 100 |  |  |  | T
 |  |  |  | 0 | 50 |  |  |  | T
 |  |  |  | 0 | 125 |  |  |  | T
 |  |  |  | 0 | 100 |  |  |  | T
OPENING SUPPORT CONTIGENCY
 |  |  |  | 0 | 100 |  |  |  | T
 |  |  |  | 0 | 50 |  |  |  | T
 |  |  |  | 0 | 125 |  |  |  | T
 |  |  |  | 0 | 100 |  |  |  | T
 | Airfare |  |  | 0 |  |  |  |  | T
 | Hotel |  |  | 0 |  |  |  |  | T
 | Per Diem |  |  | 0 |  |  |  |  | T
 | Local Transportation |  |  | 0 |  |  |  |  | T
 |  |  |  |  |  | LABOR SUBTOTAL