QuoteCQ: How to Use the Summary Module

The Summary tab for any quote displays advanced formulas and information crucial for the final quoting process.

What can I do in the Summary tab?

  • Add markup costs

  • Adjusting calculated values

  • Adding additional costs

  • Add a Quote note

  • Add a Summary note

  • Publish your final quote

  • Export your quote report

  • Mark your quote as sent

To better understand the calculations on the summary page, please review the below:

The first part of the summary table displays the breakdowns by the following categories: Materials, Labor, Overhead, Misc Cost, Unit Price, and NRE.

View a spreadsheet containing the formulas HERE.

Summary Table Definitions

  • Material Sub Total
    • Material Lead Cost = (Lead Qty * line item Unit Price) / QTY
    • Material Attrition Cost = (Attr Qty * line item Unit Price) / QTY
    • Material Adjustment Offset = (QTY Adjusted * Unit Price) / QTY
  • Material Total: Materials Sub Total + Material Markup

  • Labor Total: Labor Sub Total + Labor Markup

  • Labor Hours: The total of direct and setup labor inputs from the Labor Tab.

  • Labor Rate: Labor Total / Labor Hours

  • Overhead Total: Total labor time inputs * Total Overhead Activity Rate for each Overhead Driver

    • SGA: (Material Sub Total + Labor Sub Total) * Activity Rate

    • Labor Overhead: (Labor Hrs * Activity Rate)

  • Misc Cost: Any miscellaneous cost can be manually entered in this section

  • Unit Price: Material Total + Labor Total + Overhead Total

  • NRE: Non reoccurring expense will be displayed

Totals: This section of the summary page displays all of the totals for each quote.

  • Total Revenue: Unit Price * Quantity
  • VAR: (Unit Price with Commission - (PCB Total + Material Total)) * QTY
  • VAR %: VAR / Total Revenue
  • Extended PCB Cost: PCB Sub Total * QTY
  • PCB Markup %: (PCB Markup $ / Total Revenue) * 100
  • PCB Markup $: PCB Markup * QTY
  • Material Markup: Derived from the input in the top of the summary table
    • Material Markup %: (Material Markup * Qty) / Total Revenue
    • Material Markup $: Material Markup * Qty
    • Extended Material Cost $: Material Sub Total * Qty
  • Extended Labor Cost: Labor Sub Total * Qty
  • Labor Hours: Labor Assembly Hours * Qty
  • Labor Rate: Labor Total / (Labor Hours / Qty)
  • Labor Minutes: Labor Hours * 60
  • Labor Markup: Derived from the input in the top of the summary table
    • Labor Markup %: Labor markup $ / Total Revenue
    • Labor Markup $: Labor Markup * Qty
  • Material and Labor Markup %: (PCB Markup + Material Markup + Labor Markup) / Total Revenue
  • Material and Labor Markup $: PCB Markup $ + Material Markup $ + Labor Markup $
  • Gross Profit $: Material Markup $ + PCB Markup $ + Labor Markup $
  • Gross Profit %: (Unit Price with commission - (PCB Sub Total + Material Sub Total + Labor Sub Total )) * Requested Qty
  • Commission Markup $: Total Markup $ (referred to as sales tax or commission) / Total Revenue
  • Commission Markup %: Total Markup (referred to as sales tax or commission) * Qty
  • Purchase Orders: Total number of suppliers being quoted on the Material Costing tab
  • Shipping Expense: Shipping expense from each vendor summed by the specific vendor. As an example, 7 suppliers, each supplier has $30 in shipping = $210 Shipping Expense.
  • Exclude Excess: Material Excess that is excluded from the total cost on Summary or Material Costing tab.

Note: You are able to enter negative values in a cell throughout the Summary tab.

Summary tab Actions and Options

Notes

To the right side of the Summary page, you have the option to leave a NOTE for internal use, or you can leave a note in the final quote.

  • Quote Note = Displayed in the final quote sent to customers
  • Summary Note = For internal use

Actions

Above the 'Quote Note', you have the Action button. Under Action you can select:

  • Mark as Sent: Gives you the option to change the quote status after being sent (you need to publish before you can Mark as Sent).
  • Quote history: Allows you to view previous changes in the quote (quotes under the same REV)
  • Publish history: Shows when the quote was previously published.
  • Send: Gives you the ability to send different versions of the quote out to your customer (i.e. Detailed report, Exception report, etc..).
  • Reports: Lets you download a report of the quote.
  • Mark as Sent: Gives you the option to change the quote status after being sent (you need to publish before you can Mark as Sent).
  • Quote history: Allows you to view previous changes in the quote (quotes under the same REV).

You also have:

  • Reset calculations: Resets any changes made to the Summary.
  • Submit: Submit the work done in the Summary tab.
  • Save: Lets you save the work done in the Summary tab (if you don't want to submit at that moment).
  • Publish: Gives you the green light to send the quote to your customers.

Adjust the Values

Users can fine-tune the costs on the Summary tab pulled from the Material Costing and Labor tabs by directly editing the values:

  1. Double click into the cell you would like to adjust.
  2. When the modified cost is higher than the actual cost, the number will display in green:
  3. Modified costs that are lower than the actual costs will display in orange:

Additional Line Item Costs

Users can add miscellaneous line item costs under the Material, Labor, and Overhead totals.

  1. Under any section, click Add Cost.
  2. Click the "Name" cell to label the line item cost.
  3. Click into the related cost cell to set the value:

Note: You can use the 3 vertical dots to delete any additional line item costs: