Attachment 1-RFP 693JF725R000016-Pricing Spreadsheet Student Health Insurance Plan (SHIP).xls

Sheet1

Page &P of &N

XDO_METADATA

<xsl:value-of select="/QUOTE/PROMPT/XXIB_QUOTE_TAA_WAIVER"/> <xsl:text>&#xA;</xsl:text> </xsl:if> <xsl:if test="/QUOTE/HEADER/SHOW_TAA = 'Y'"> <xsl:value-of select="/QUOTE/PROMPT/XXIB_QUOTE_TAA_MSG"/> <xsl:text>&#xA;</xsl:text> </xsl:if>

<xsl:if test="/QUOTE/P_HDR_ATTCH = 'Y'"> <xsl:for-each select="/QUOTE/HEADER/HEADER_ATTACHMENT/HEADER_ATTACHMENT_ROW"> <xsl:value-of select="SHORT_TEXT"/> <xsl:if test="not(position()=last())"> <xsl:text>&#xA;</xsl:text> </xsl:if> </xsl:for-each> </xsl:if>

<xsl:value-of select="TAA"/> </xsl:if> XDO_?LINE_COMMENT? <xsl:if test="/QUOTE/P_LINE_ATTCH = 'Y'"> <xsl:for-each select="G_LINEATTACHMENT"> <xsl:value-of select="LINE_SHORT_TEXT"/> <xsl:if test="not(position()=last())"> <xsl:text>&#xA;</xsl:text> </xsl:if> </xsl:for-each> </xsl:if>

<xsl:when test="/QUOTE/P_SUBTOT_PC = 'Y'">Subtotal (Selling Price): </xsl:when> <xsl:otherwise>Subtotal: </xsl:otherwise> </xsl:choose> XDO_?TAX_TEXT? <xsl:text>Tax: </xsl:text> <xsl:if test="/QUOTE/HEADER/SHOW_TAX_MESSAGE = 'Y'"> (Applicable Sales Tax will be added to invoice, and Purchaser will be responsible for such tax, unless a valid exemption or resale certificate is on file and current.)</xsl:if> XDO_?TAX_VAL? <xsl:choose> <xsl:when test="(/*/*/*/*/QUOTE/HEADER/HZPUI_ACCOUNT/HZPUI_ACCOUNT_ROW/PROFILE_CLASS_NAME='Commercial') or (/*/*/*/*/QUOTE/HEADER/HZPUI_ACCOUNT/HZPUI_ACCOUNT_ROW/PROFILE_CLASS_NAME='Prime') or (/*/*/*/*/QUOTE/HEADER/HZPUI_ACCOUNT/HZPUI_ACCOUNT_ROW/PROFILE_CLASS_NAME='Default')"> <xsl:value-of select="/*/*/*/*/QUOTE/HEADER/TAXES_TOTAL"/></xsl:when> <xsl:otherwise>0.00</xsl:otherwise> </xsl:choose> XDO_?CHARGES_TEXT? <xsl:if test="/QUOTE/P_SHOW_CHARGES = 'Y'"> <xsl:value-of select="'Charges: '"/> </xsl:if> XDO_?CHARGES_VAL? <xsl:if test="/QUOTE/P_SHOW_CHARGES = 'Y'"> <xsl:value-of select="/QUOTE/HEADER/CHARGES_TOTAL"/> </xsl:if>

<xsl:when test="/QUOTE/HEADER/SHOW_TAX_MESSAGE = 'Y'"> <xsl:value-of select="/QUOTE/HEADER/TAXES_TOTAL"/> </xsl:when> <xsl:otherwise>0.00</xsl:otherwise> </xsl:choose> XDO_?TRADEIN_CREDIT_TERMS? <xsl:choose> <xsl:when test="/QUOTE/HEADER/HEADER_CTC_TOTAL != 0">Trade-in Credit Terms: This quote contains a credit for trade-in equipment by specific line item and includes a total credit amount referenced herein. The equipment offered for trade-in shall be returned within 75 days of the new equipment being delivered in accordance with the instructions provided at time of new product delivery. In the event the customer representative does not return the trade-in equipment within 75 days, Iron Bow Technologies will invoice the customer and the customer agrees to pay said invoice for the amount of credit contracted with this quote and awarded to Iron Bow Technologies under subsequent delivery order($). Extensions to the 75 day term may be available and must be requested and approved in writing at least 15 days prior to the date the equipment is due to be returned.</xsl:when> </xsl:choose> XDO_?CONTRACT_INFO? <xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'CONTRACT INFO'"> <xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> XDO_?COMPANY_INFO? <xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'COMPANY INFO'"> <xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> <xsl:if test="not(/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW/ARTICLE_NAME='COMPANY INFO')">Tax ID: 26-1615129 Unique Entity ID: Q2M4FYALZJ89

DUNS+4: 82-7714507-0000

Cage Code: 55RC1 </xsl:if> XDO_?REMIT_EFT? <xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'REMIT EFT'"> <xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> <xsl:if test="not(/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW/ARTICLE_NAME='REMIT EFT')">For EFT:

Iron Bow Technologies, LLC c/o PNC Bank, N.A.

ABA: 031207607

Account: 8026304877 </xsl:if> XDO_?REMIT_CHECK? <xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'REMIT CHECK'"> <xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> <xsl:if test="not(/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW/ARTICLE_NAME='REMIT CHECK')">For Checks:

Iron Bow Technologies, LLC PO Box 826474 Philadelphia, PA 19182-6474 </xsl:if> XDO_?MESSAGES? <xsl:text>* The sale of any item and/or services quoted herein is governed by the Iron Bow terms and conditions available at https://ironbow.com/terms-and-conditions The foregoing terms and conditions of sale are fully incorporated by this reference as a material part of this quote. Customer agrees to fully incorporate this quote and quote number by reference as part of Customer's purchase order to Iron Bow.</xsl:text> <xsl:for-each select="/QUOTE/HEADER/MESSAGES"> <xsl:if test="MESSAGE = 'XXIB_EXPORTLANGUAGE'"> <xsl:text>* </xsl:text><xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each>

<xsl:if test="/QUOTE/HEADER/SHOW_UID_TAGGING = 'Y'">

* Unless otherwise noted within the quotation, UID tagging and registration services will not be provided. Please contact your Inside Sales Representative if you would like to have UID tagging and/or registration services included in your quotation.

</xsl:if>

* All returns of both commercial and customized products or product configuration are subject to the supplier and/or original equipment manufacturers Return Materials Authorization (RMA) policy.

<xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'QUOTE INFO'"> <xsl:text>&#xA;</xsl:text><xsl:text>* </xsl:text><xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> <xsl:if test="not(/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW/ARTICLE_NAME = 'QUOTE INFO')">

* This quote is valid for 30 days from the date issued.

</xsl:if> <xsl:for-each select="/QUOTE/HEADER/CONTRACT_ARTICLE/CONTRACT_ARTICLE_ROW"> <xsl:if test="ARTICLE_NAME = 'CONTRACT FOOTER'"> <xsl:text>&#xA;</xsl:text><xsl:text>* </xsl:text><xsl:value-of select="TEXT"/> </xsl:if> </xsl:for-each> <xsl:text>&#xA;</xsl:text> <xsl:text>&#xA;</xsl:text> <xsl:if test="/QUOTE/HEADER/SHOW_MSA = 'Y'">This quote is governed by the Master Agreement Terms and Conditions, between Iron Bow Technologies and Navy Federal Credit Union (NFCU), executed 03/28/2013.</xsl:if> <xsl:if test="/QUOTE/HEADER/HEADER_DFF/HEADER_DFF_ROW/HEADER_ATTRIBUTE6='Healthcare'">For Iron Bow manufactured products and related services, please refer to Iron Bow’s MEDiC and CLINiC Limited Warranty, Licensing, and Return Policies, and the IronCare &amp; Managed Care Terms and Conditions, which can be found at the following link: https://ironbowhealthcare.com/legal/</xsl:if> <xsl:text>&#xA;</xsl:text> <xsl:text>&#xA;</xsl:text> <xsl:text>** PROPRIETARY &amp; CONFIDENTIAL ** This document and any referenced links or supplemental documentation is confidential and/or proprietary and intended solely for the named entity within this quote. Unauthorized use, copying, distribution, or disclosure is prohibited. If you received this document in error, please notify the referenced Iron Bow personnel via phone or email.</xsl:text> XDO_?CHARGE_SUBTYPE_NAME? <xsl:choose> <xsl:when test="HEADER_CHARGE_AMOUNT = 0"> <xsl:value-of select="''"/></xsl:when> <xsl:otherwise><xsl:value-of select="CHARGE_SUBTYPE_NAME"/></xsl:otherwise> </xsl:choose> XDO_?ADJUSTED_AMOUNT? <xsl:choose> <xsl:when test="HEADER_CHARGE_AMOUNT = 0"> <xsl:value-of select="''"/></xsl:when> <xsl:otherwise><xsl:value-of select="HEADER_CHARGE_AMOUNT"/></xsl:otherwise> </xsl:choose>

<xsl:value-of select="/QUOTE/HEADER/G_INTERNALORG/ORGANIZATION_INFO_2"/><xsl:text>, </xsl:text> <xsl:value-of select="/QUOTE/HEADER/G_INTERNALORG/ORGANIZATION_INFO_3"/><xsl:text>&#xA;</xsl:text> <xsl:value-of select="/QUOTE/HEADER/G_INTERNALORG/ORG_INFO_CITY"/><xsl:text>, </xsl:text> <xsl:value-of select="/QUOTE/HEADER/G_INTERNALORG/ORG_INFO_REGION"/><xsl:text> </xsl:text> <xsl:value-of select="/QUOTE/HEADER/G_INTERNALORG/ORG_INFO_POSTAL_CODE"/>