Proposal DesignerProposal Designer

The Designer is where the details of the items being proposed to your customer are displayed. Here you can modify details about each item as well as view the profitability of the job.

The designer is broken into three primary sections, and we’ll address each of them here on this page.

Proposal Header

The standard navigation elements are available at the top of each design. Of note are:

  • Customer and Proposal Name – these come from the Info tab on the Details screen
  • Ref Number – the system-generated identification number of this proposal
  • Options button – the Options button houses many ways to control the data you see in the designer and we’ll detail those on the Designer Options part of the manual.
  • Add Products button – the Add Products button opens a window where you select what to add to the proposal. Read the details about this button on the Add Products part of the manual.

Proposal Body

There is a lot of information here, but basically, you’ll see the parts that have been added to the proposal as well as the location and group where they are installed. Items are organized as follows:

  • The Black Header shows the location where products have been designated to be installed.
    • The header bar will show the location name and the sub-total price for all items in that location.
    • If there are three locations (rooms) on a proposal, you’ll see three black bars.
    • A black bar with no location name indicates that the location field has been left blank on items added to the proposal.
  • The Blue Bar indicates the equipment group. These could be product groupings (usually these are things like Display Devices or Music Systems).
    • The sub-header will show the group name and the sub-total price for the items in that grouping.
    • Typically there will be multiple groups of equipment in each location. But iPoint will only display the number of groups associated with a specific location. So if location one has 3 groups and location two has 6 groups, you’ll see the appropriate number of blue sub-header bars displayed under each location.
  • The items will be displayed in the gray section under each header. More on line items in just a bit.

Note: It is important to state that the location and group header bars can be reversed, placing groups before locations or locations before groups. This order is determined using the Options button.

In front of each line, you may see one of the following icons:
– The arrow in front of a line or header will expand or collapse the details of that section. When the arrow is pointing to the right, any sub-sections or accessories will be hidden from view.
– Click on the arrow to make it point downward, revealing the sub-sections or accessories for the parent item.

– A blue dot indicates that the item is a parent or primary item
– An orange dot indicates that the product is an accessory to a parent.
An item can have a single layer of accessories underneath it. Accessories are helpful because they can be hidden in a customer’s printed proposal. Hiding accessories (or collapsing them on the designer) will move the cost and price into the parent item, so the math will always be accurate!

Designer Body
Designer Body

OK, let’s look at the individual line for an item. After the indicator icons described above you’ll see:

  • Manufacturer – the name of the company who makes the item
  • Item Name – what is the item called? This can be different from the Manufacturer Part Number.
  • Description – this is the Sales Description
  • Quantity – how many of this item are you selling?
  • UoM – the Unit of Measure (e.g. Each, Foot, Pair)
  • Unit Cost – the amount paid to the vendor
  • Margin – the percent of profitability for the line item
  • Unit Price – the price charged to the customer for one unit
  • Ext Price – the Unit Price multiplied by the Quantity
  • Labor Phase – jobs are completed in phases. This specifies the phase where the part is installed as well as determining the labor rate to charge for installation.
  • Hours – the length of time needed to install the part
  • Rate – the dollar per hour charged for the labor phase
  • Ext Labor – the Hours multiplied by the Rate
  • Ext All – the sum of the Ext Price and Ext Labor for that line
  • – the note icon indicates a custom note has been added to the item in the Item Details popover.
  • Part Tax – a check in this box indicates that the part is taxable and will be included in the sales tax calculation. Clear the check box to make the part non-taxable.
  • Lab Tax – a check here means the labor is taxable and is included in the sales tax calculation. Clear the check box to make the labor non-taxable.
  • Select – This is a toggle button, click it once to select the line (highlighting it gray). Click it again to deselect it (removing the gray highlight). Select multiple line items to apply bulk process using the Options button.

Note: When first added to a proposal, these fields will be taken from the Item Master in the Items module. Modifying these fields here on the proposal modifies that line only and has no effect on the master item in the item database.

Several of the fields on an item line are customizable with the correct permissions. Either click in the field to change it or use the Item Popover described below.

Line Item Text Color

There are some text color indicators that you need to be aware of before we jump into more details.

Items listed in purple indicate that the item is a Package. A Package is a grouping of individual items. The Package line is not an item itself. Every package should have accessories, so you’ll find they have indented parts with an orange dot in front of it. Packages are useful for things like a pre-wire drop that includes wire, fittings, inserts, and plates. You don’t necessarily want each of those parts visible to your customers, but you do want them to see that they have a pre-wire drop.

Items listed in grey indicate that they are marked as hidden and won’t print on the customer’s proposal. The hidden item’s cost, price, and time will be included in the parent item on the printed proposal.

Items listed in orange are optional. These items are displayed for the customer to see pricing but are not included in location or group sub-totals. Additionally, they are excluded from sales tax calculations and don’t appear in the total price of the proposal.

When a particular field is highlighted in red that is an indication that you are losing money on that item!


Item Hover InformationItem Hover Information

Item Hover Information

Hover the mouse over a product’s name or manufacturer to see additional details:

  • Manufacturer: The manufacturer name
  • Product: The product name
  • Part Number: The item’s part number
  • Category: The item’s category, such as Display Device, Security, Amplifiers, Speakers, Wire, etc.
  • Type: The item’s type, such as Ceiling Mount, Digital, Wall Mount, Surround, etc.
  • Created On: The date this product was added on
  • Created By: The user who added this product
  • Modified On: The date this product was modified on
  • Modified By: The user who modified this product
  • Record Number: The number this product is in the Design
  • Parent Item: The name of the parent product (if this item is an accessory)

Designer Item PopoverDesigner Item Popover

Item Popover

Click on any item in the designer to reveal a popover window with TONS of information and things you can do. In fact, there is so much here, that we are going to redirect you to another page of the manual.

Head over to the Product Details Popover page to learn the power of this tiny window!

.
.
.
.
.
.


Item Options for a Parent ItemItem Options for a Parent Item

Moving Line Items

We already discussed the blue dot preceding each item earlier in this section. But that dot isn’t just a pretty indicator. It also has some pretty powerful options available! Click the blue dot to reveal an options window where you can:

  • Make Accessory – this will cause the item you have clicked to become an accessory of the parent above it. If the item directly above the blue dot is already an accessory, then the item becomes an accessory of the next available parent item.
  • Move Up – click this button to move the item up one position in the proposal. So if that TV is in position #6, clicking this button will move it to position #5. Be aware that moving a parent item will take the accessories with it!
  • Move to Line – when you click the bullseye button, a bullseye will appear in front of every parent item on the proposal. Click one of the new bullseyes to move that item to a particular location. Once the parent (and it’s accessories) have been moved, the bullseyes will disappear. Hope you had a good aim!
  • Move Down – bet you can figure this one out on your own. For a hint, this works just like Move Up except it … well … moves the item down!

.
.
.
.
.
.
.
.

Item Options for an Accessory ItemItem Options for an Accessory Item

Move Accessories

Parent Items aren’t the only items that can have all the fun! Accessories have an Options button of their own! And yes, because they are accessories, their power is slightly different.

  • Make Parent – this button promotes the child to a parent. Call it Item Graduation, if you will. And once promoted, the item has all the rights and responsibilities of a fully grown item!
  • Move Up – this button will move the accessory up a line. Just remember, that the accessory will have to stay with its parent.
  • Move Down – going down! Yup, this button will move an accessory down one line.

Tip: If you want to make an accessory part of a different parent, do this.

  1. Select the accessory and Make Parent
  2. Move the item under the new parent.
  3. Clik the blue dot and then choose Make Accessory
    Easy Peasy!

Proposal Footer

Proposal Designer FooterProposal Designer Footer

At the bottom of the designer is a powerful bit of information that helps turn you into a money-making, engineering marvel, powerhouse system designer! Check out these details.

Numbers

The numbers tab displays financial details about the proposal and takes into account costs, modifiers, and customer pricing.

*Cost Section * (left section)

  • Parts Cost – the total cost of all items on the proposal
  • Labor Cost – the total of expense for all labor (both individual labor lines and associated labor on parts)
  • Total Cost – the sum of Parts Cost and Labor Cost
  • Margin – the percentage of each parts dollar that you keep as profit
  • Markup – how much were parts and labor increased over cost
  • Profit – the total amount of cash you are making on this sale
  • GDP – the Gross Daily Profit is the total profit divided by the number of labor hours multiplied by 8 (hours in the day). This shows how much profit you’ll make in an 8 hour day because of this proposal.

Modifiers Section (center portion)

The center section of numbers display the amounts added to the proposal due to the modifiers that were set on the Details > Info section of the Proposal. The nine categories might be named something other than our description if your company has customized them. The modifiers will display the name, the percentage assigned to that modifier, and the corresponding dollar value.

Pricing Side (right section)

  • Labor Hours – how much time has been specified on the job, either through time allocated from a part or from a labor hour line item
  • Labor Cost – what is the cost of the labor? This utilizes the burdened rate entered for each labor phase in settings multiplied by the number of hours
  • Labor Amount – is the total price of all labor phases listed in the designer. This total also includes the Labor Time Modifier (from the top of modifiers section) and the Labor Rate Override (from the Proposal Details > Options > Labor)
  • Labor Margin – is the percentage of each labor dollar you keep as profit
  • Labor Time Mod% – this is the rate that labor time is being modified as defined in Modifiers > Labor Tiem >
  • Parts – is the subtotal of all the items in the proposals. This amount also includes the value of any modifier that adjust quantity, unit price, margin override, or parts discounts.
  • Labor is the total of all labor lines. This includes the value of any modifier that adjusts quantity, unit price, labor rate, margin override, and discounts.
    • Note: the two Global Modifiers, Misc Parts, Project Management, and Custom Modifiers 1&2 are not included in either the Parts or Labor subtotals.
      6 modifiers not included in the parts and labor subtotals
  • Subtotal – this value is everything on the proposal excluding sales tax.
  • Sales Tax – the tax rate is displayed along with the amount of sales tax charged. Any item or part checked as taxable will be used in the calculation of the tax amount.
  • Grand Total – the total price for this proposal. (Subtotal plus Sales Tax)

Engineering

The Engineering tab summarizes the engineering data taken from every part. These engineering details are entered on the Item Details > Engineering of each item. If all items have engineering details, this tab provides information about power consumption, the heat created, as well as inputs and outputs for a variety of fitting types.

Mix

The Mix tab provides a percentage breakdown of:

  • Equipment – all the parts and materials sold
  • Bulk Parts – any part marked Bulk on the Item Details. This is typically wire, conduit, and similar bulk product. Bulk Parts are not included in the Equipment percentage above.
  • Labor – shows the percentage of the job that is labor for installation.

Commissions

The Commissions tab will display any person who is receiving a commission for this proposal.
Commission button   The green percentage sign in front of a user’s name indicates there is a commission calculation applied
No Commission   The gray percentage sign indicated no commission will be applied for that user.

Click on a commission indicator to open the commission details for that employee. With correct permissions, these can be edited from this screen.


Keyboard ShortcutsKeyboard Shortcuts

Shortcuts

As you become familiar with the Proposal Designer, you may want to speed up your processes by utilizing one of these nifty keyboard shortcuts. Each of these shortcuts are visible from the Filemaker menu called Shortcuts!

  • Ctrl+Shift+X – Expand all line items
  • Ctrl+Shift+Z – Collapse all line items
  • Ctrl+Shift+S – Select all line items
  • Ctrl+Shift+U – De-Select all line items
  • Ctrl+Shift+Backspace – Delete selected items
  • Ctrl+Shift+P – Open the Client Proposal for printing
  • Ctrl+Shift+R – Open the Reports tab
  • Ctrl+Shift+L – Open the Options > Locations tab
  • Ctrl+Shift+G – Open the Options > Groups tab
  • Ctrl+Shift+H – Close the Options window and go back to Designer home
  • Ctrl+Shift+E – Go to end or last line of the Design
  • Ctrl+Shift+Q – Clear all Options > Filters
  • Ctrl+Shift+B – Change font format to Bold
  • Ctrl+Shift+I – Change font format to Italic
  • Ctrl+Shift+F – Remove font formatting
iPoint Version: 9.1013
Last modified: 19 Oct 2020

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.