Attachment_L-5_Price_Scenario_Price_Build-up_Template.xlsx

Instructions

Total Price

OF

PRICE SCENARIOS

PS1 Compute

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification of the item.

Column E - Enter brief description/title of item.

Column F - Enter the number of virtual CPUs per instance.

Column G - Enter the amount of memory (in GB) per instance.

Column H - Enter the amount of included disk space per instance (in GB). If there is a separate charge for disk space, enter "N/A" and use the storage Worksheet for pricing breakdown.

Column I - Enter the type of Operating System used in each instance. If there is no OS then enter "N/A".

Column J - Enter the type of Database Management System (DBMS) (ex: Postgres, MySQL) or "N/A" if there is none.

Column K - Enter the number of total instances for this line item (for serverless functions, enter the total number of functions). A non-negative integer is required.

Column L - Enter the type of charge identified with the item.

Column M - Enter the unit used for pricing (ex: execution hours). It is ok to change the number of digits if necessary. This should not be the number of instances.

Column N - Enter the per unit price. There must be a number here as it is part of the total value calculation.

Column O - Enter the quantity of that unit each instance will be using. A non-negative integer is required.

Column P - Total Price for item is automatically calculated (no manual inputs).

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS1 Storage

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification of the item.

Column E - Enter Storage Type / Description of the item.

Column F - Enter the type of charge associated with this pricing unit (e.g.: write requests, usage, capacity, etc).

Column G - Enter the basic pricing unit associated with this item (ex: requests / month).

Column H - Enter the unit price.

Column I - Enter the quantity of units for this line item. A non-negative integer is required.

Column J - Enter additional Pricing calculation notes as necessary to explain any charges and how they were calculated.

Column K - Total Price for item is automatically calculated (no manual inputs).

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS1 Network

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification.

Column E & F - Enter Description to the feature of the type of network charges identified.

Column G - Enter the Unit type of the item described.

Column H - Enter the unit price.

Column I - Enter the Quantity of the item described. A non-negative integer is required.

Column J - Total Price for item is automatically calculated (no manual inputs).

If network charges are not applicable or captured elsewhere, Offerors shall enter N/A into the first line item for each table. However, they shall identify in the table (any column(s)) where the charges are absorbed.

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS1 Feature, Service, & Capabil

This area is available for the Offeror to propose unique items, including one time fees, not located in the other Worksheets. This Worksheet shall only be used when it is not possible to price items on the other Worksheets. Totals for Column shall be exact values and may exceed the $0.01 decimal.

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification.

Column E - Enter Description of the item being identified.

Column F - Enter the pricing Unit type of the item described.

Column G - Enter the unit price. If using manual entry for Total Price, enter "N/A" and explain in the pricing details cell. Fees are entered with a positive value (e.g. $20,000.00).

Column H - Enter the quantity of the item described. If using manual entry for Total Price, enter either "N/A" or a word to describe the quantity and further explain in the pricing details cell. If entering a numeric value, a non-negative integer is required.

Column I - Total Price is calculated by default using a "SUM" function on quantity and unit price. If this will not work to capture this item's total price, enter it manually (overriding the sum function) and make sure to explain in the pricing notes cell.

Column J - Enter the description of the pricing details if not plainly broken down in the pricing unit or description. If unable to capture using Price Fields available, manually enter total price in "Total Price" and enter complete description of price build-up here.

If charges are not applicable or captured elsewhere, Offerors shall enter N/A into the first line item for each table. However, they shall identify in the table (any column(s)) where the charges are absorbed.

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

30 days * 24 hours * 60 min * 2 stats per min = 86400 stats Price per stat = $0.00006, Price for month of stats = 86400 stats * $0.00006 per stat = $5.184 per month per instance Total Price = $5.184 * 20 instances = $103.68 total price

PS1 Hardware

This area is available for the Offeror to propose unique hardware items not located in the other Worksheets. This Worksheet shall only be used when it is not possible to price items on the other Worksheets. Offerors are cautioned that utilization of the Worksheets incorrectly may render the proposal unacceptable (See Section L1, paragraph 4).

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification.

Column E - Enter Description of the item being identified.

Column F - Enter Dimensions of the item being identified.

Column G - Enter Weight of the item being identified.

Column H - Enter Cores of the item being identified. If not applicable, enter "N/A".

Column I - Enter Memory of the item being identified. If not applicable, enter "N/A".

Column J - Enter Available Storage of the item being identified. If not applicable, enter "N/A".

Column K - Enter the number of devices. A non-negative integer is required.

Column L - Enter the pricing Unit type of the item described.

Column M - Enter the unit price.

Column N - Enter the quantity of the item described. A non-negative integer is required.

Column O - Total Price for item is automatically calculated (no manual inputs).

Column P - Enter the description of the pricing details if not plainly broken down in the pricing unit or description. Make sure to enter a complete description of price build-up here per item.

If charges are not applicable or captured elsewhere, Offerors shall enter "N/A" into the first line item for each table. However, they shall identify in the table (any column(s)) where the charges are absorbed.

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS1 Cloud Support Package

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter Support Package Title/Description.

Column E - Enter Pricing Unit as a Description.

Columns F thru I - Offerors shall only enter their pricing details in Columns F & G* (%) OR H & I** (Unit Price). The Offeror shall enter "N/A" in the unused fields. For accuracy, use exact values and exceed the $0.01 decimal as necessary.

*The Offeror shall calculate usage in Column G for this Worksheet by entering a formula in the cell that references all of the cells across the Workbook that are used to compute the usage value. This instruction supersedes any other instruction that prohibits referencing or linking cells within the Workbook.

**Quantities shall be either "N/A" or a non-negative integer.

Column J - Total Price for item is automatically calculated (no manual inputs).

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS1 Discounts & Premiums

When offering an additional gross discount to all of the items in the CATALOG ITEM/CLASS DISCOUNTS or PREMIUMS TABLE, Offerors shall utilize the ADDITIONAL GROSS DISCOUNTS TABLE below. If an additional gross discount is applicable, Offerors shall place "Y" in column B, provide a description of the discount in column C, and the overall discount % amount in column C (the other fields auto-update). If a cumulative discount is not available, place "N" in column B, "N/A" in column C, and 0 (zero) for % discount in column D.

When offering a D/P for an individual item, Offerors shall utilize the CATALOG ITEM/CLASS DISCOUNTS or PREMIUMS TABLE below.

In the "Catalog Item/Class Discounts or Premiums" Table:

Column B - Enter the title of the Worksheet where the item is proposed. List the D/P in percentages or US Dollar in the table.

Columns C thru F - Enter the descriptive items (Catalog and Associated contract CLIN; Catalog Item #; Security Classification; Description of Item).

Column G - Identify if the offer is a Discount or Premium.

Column H - Describe the basis of the identified D/P.

Column I - Indicate whether the D/P will be overall percentage or a dollar based by selecting the appropriate type using the drop down.

Column J - Identify the value of the D/P. Discounts are entered with a "negative" value (e.g. -10%). Premiums are entered with a positive value (e.g. 10%). Do not type in the "$" or "%" sign as this will invalidate the calculation.

Column K - Reference the total price cell from the Worksheet for the applicable item. Do not manually input a value. This instruction supersedes any other instruction that prohibits referencing or linking cells within the Workbook.

Column L - Create a formula to calculate the application of the proposed D/P in Column I against the value in Column J that results in a final calculated value. Do not manually input a value.

Column M - This should be the calculated net difference between the proposed price and proposed price after D/P are applied. Do not change this value.

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows using copy/paste function prior to that last unpopulated row to preserve formulas and format). If multiple adjustments for an item/class exist, additional rows may be added for secondary or further adjustments.

In the "Additional Gross Discounts" Table:

Only use this Table when applying an additional gross discount to all of the items in the "Individual Item Discount or Premium" Table.

Column B - Put a "Y" here if there is a gross discount to apply or "N" if not.

Column C - Identify the basis for the gross discount. If there isn't one, put "N/A" in the field.

Column D - Put the total % value for the discount. Should be 0 if there is none. It is ok to use any number of digits necessary to make the calculation correct.

Column E - This should be the auto-populated total for that specific scenario before any discounts. Do not change this value.

Column F - This should be the final calculated total after discounts for the specific scenario. Do not change this value.

Column G - This should be the calculated net difference between the proposed price and proposed price after discount is applied. Do not change this value.

Italicized font is example use only. (As provided for this example, cell E14 contains a manually entered value of $200,000 for Order Subtotal to emulate a Worksheet reference from Total Price Worksheet.)

Difference

Difference

PS1 Additional Information

Italicized font is example use only.

Scenario 1.a

Add rows before last row above here as required (use copy/paste row to preserve formatting and formulas)

Scenario 1.b

Add rows before last row above here as required (use copy/paste row to preserve formatting and formulas)

Scenario 1.c

Add rows before last row above here as required (use copy/paste row to preserve formatting and formulas)

Scenario 1.d

Add rows before last row above here as required (use copy/paste row to preserve formatting and formulas)

PS2 Compute

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification of the item.

Column E - Enter brief description/title of item.

Column F - Enter the number of virtual CPUs per instance.

Column G - Enter the amount of memory (in GB) per instance.

Column H - Enter the amount of included disk space per instance (in GB). If there is a separate charge for disk space, enter "N/A" and use the storage Worksheet for pricing breakdown.

Column I - Enter the type of Operating System used in each instance. If there is no OS then enter "N/A".

Column J - Enter the type of Database Management System (DBMS) (ex: Postgres, MySQL) or "N/A" if there is none.

Column K - Enter the number of total instances for this line item (for serverless functions, enter the total number of functions). A non-negative integer is required.

Column L - Enter the type of charge identified with the item.

Column M - Enter the unit used for pricing (ex: execution hours). It is ok to change the number of digits if necessary. This should not be the number of instances.

Column N - Enter the per unit price. There must be a number here as it is part of the total value calculation.

Column O - Enter the quantity of that unit each instance will be using. A non-negative integer is required.

Column P - Total Price for item is automatically calculated (no manual inputs).

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.

PS2 Storage

Column B - Enter Catalog and CLIN from which this item is derived.

Column C - Enter your catalog item number.

Column D - Enter the Security Classification of the item.

Column E - Enter Storage Type / Description of the item.

Column F - Enter the type of charge associated with this pricing unit (e.g.: write requests, usage, capacity, etc).

Column G - Enter the basic pricing unit associated with this item (ex: requests / month).

Column H - Enter the unit price.

Column I - Enter the quantity of units for this line item. A non-negative integer is required.

Column J - Enter additional Pricing calculation notes as necessary to explain any charges and how they were calculated.

Column K - Total Price for item is automatically calculated (no manual inputs).

When adding rows, ensure formulas and format are still intact and function properly (as a suggestion, add rows prior to that last unpopulated row to preserve formulas and format).

Italicized font is example use only.