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:
Additional Line Item Costs
Users can add miscellaneous line item costs under the Material, Labor, and Overhead totals.