MAS - Strongarm Designs Inc. - GS28F010GA

READ ME FIRST

INSTRUCTIONS FOR MODIFICATIONS

Submit Price Proposal Template(s), A and B-changes (Δ) or EPA

Tab A: Include all offerings. On this tab, include the data for ALL of your GSA offerings as though your modification request was already approved. This should be the entire universe of items. The purpose of this is to compare the current submission to the last approved and fully conformed copy of your contract up to the last modification's effective date. By populating this tab for all modifications, you will no longer need to keep extra spreadsheets for auditors or Industrial Operations Analysts (IOAs), or wonder what’s on your contract. All of the information on this sheet, once approved by your contracting officer, will be on your contract. Use the Products with Discount sheet if you are using a discount. Use the Products with Markup if you use “margin” or “markup” instead of “discount” for GSA pricing.

Note for Non-TDR: If your Basis of Award customer is NOT the same as your Most Favored Customer, you will need to change the headings to match that fact.

Note: If you have a large catalog of items, your excel file size cannot exceed 100MB (approximately 100,000 lines). Split your Price Proposal Template into multiple files to ensure your file does not exceed 100MB.

Tab B-changes (Δ): Include ONLY the items impacted by the modification. On this tab, provide the items to be modified (e.g. products to be added or deleted, updates to products, etc.). Use the Price with Markup if you use “margin” or “markup” instead of “discount” for your pricing to GSA. If you are requesting a price change (increase or decrease), use the Economic Price Adjustment (EPA) Tab.

Note for Non-TDR: If your Basis of Award customer is NOT the same as your Most Favored Customer, you will need to change the headings to match that fact.

EPA - Discount/Markup/OS4 Tabs: Use these tabs when requesting a price increase or price decrease of any kind. You must still fill out tab A with your universe of offerings. Use the Products with Discount sheet if you are using a discount. Use the Products with Markup if you use “margin” or “markup” instead of “discount” for GSA pricing.

Note for Non-TDR: If your Basis of Award customer is NOT the same as your Most Favored Customer, you will need to change the headings to match that fact.

Where column A is labeled "Award (At time of award)/Modification No./New/Change" or "New/Change", for each row, enter one of the following:

Enter "Award" if the item was awarded at the time your contract was awarded Enter the "Modification Number" (e.g. PS-0018) if the item was awarded or subsequently changed by approved modification after award of the contract Enter "New" if the item is being requested as a new item to be added to the contract by modification request (Includes Add SIN and Add Product) Enter "Change" if the item is being requested to be changed by modification request (Includes Product Descriptive Changes, Part Number Change, EPA Increase, and EPA Decrease)

Note: If there is a modification already in process at the time of a secondary modification request, you will have to note that there is a modification pending on the PPT

Freight Terms Select One

Government (GSA) Select One

ACRONYMS:

UOI: Unit of Issue (select from dropdown menu; for a list of UOI data elements and descriptions, visit https://www.gsaadvantage.gov/advantage/information/page.do?keyName=UNIT_DEFINITIONS)

COO: Country of Origin (Must be 2 character abbreviation; select from dropdown menu)

SIN: Special Item Number

IFF: Industrial Funding Fee

IFF CALCULATION EXAMPLE:

Product List Price=$100 GSA % Discount (exclusive of the .75% IFF): 10% Discount Price offered to GSA (excluding IFF): $90.00 Discount Price offered to GSA (including IFF): $90.00/0.9925=$90.68

Commercial List Price=$100 Dealer Cost = $80 Dealer markup(%) (excluding IFF) : 10% Markup Price Offered to GSA (excluding IFF): $88 Markup Price Offered to GSA (including IFF): $88/0.9925 = $88.66

PRICE PROPOSAL TEMPLATE

This document must be completed and submitted with your modification request.

Complete all tabs relevant to your modification request.

Note: All offered items, including options and accessories, must be listed in this Price Proposal Template, with all applicable columns completed. Option and/or accessories that can be used on more than one piece of equipment/machinery/product, but use a single part number regardless of what equipment it is paired with, should be listed only once in this template, with the list of the equipment it is compatible with provided in the Product Description.

If TDR is Applicable: Most Favored Customer (MFC) information does not have to be provided; therefore, columns P, Q, and R should be left blank. For the EPA tabs, columns Q, R, S, T, and U should be left blank.

IT CDM SINs only: Complete Columns X through AB

For Vendors utilizing a Discount: complete the "PRODUCTS WITH DISCOUNT" tab. All formula examples are shaded in gray.

For Vendors utilizing a Markup: complete the "PRODUCTS WITH MARKUP" tab. All formula examples are shaded in gray.

NOTE: This tab does not apply for offers with Information Technology Category SINs.

OS4 SINs only: Use the OS4 tabs only for products offered under this SIN. All formula examples are shaded in gray.

Vendors may also offer a combination of markups and discounts based on existing commercial practices, utilizing both tabs.

PRODUCTS WITH DISCOUNT (A)

Sheet1

PRODUCTS WITH DISCOUNT (B-Δ)

EPA - DISCOUNT

PRODUCTS WITH MARKUP (A)

PRODUCTS WITH MARKUP (B-Δ)

EPA - MARKUP

Sheet2

PRODUCTS WITH A DISC OS4 (A)

PRODUCTS WITH A DISC OS4 (B-Δ)

EPA - PRODUCTS WITH A DISC OS4

GLOSSARY

Enter the "Modification Number" (e.g. PS-0018) if the item was awarded or subsequently changed by approved modification after award of the contract Enter "New" if the item is being requested as a new item to be added to the contract by modification request Enter "Change" if the item is being requested to be changed by modification request

Example:

List Price = $100.00 GSA Discount (exclusive of IFF): 10% Discount Price Offered to GSA excluding IFF: $90.00 Discount Price Offered to GSA (including .75% IFF) This is the price offered to GSA, with the GSA discount, that includes the 0.75% Industrial Funding Fee (IFF).

IFF Calculation Example:

List Price = $100.00 GSA Discount (exclusive of IFF): 10% Discount Price Offered to GSA excluding IFF: $100*(1-.10) = $90.00 Discount Price Offered to GSA including IFF: $90.00/0.9925 = $90.68 Markup Price Offered to GSA (excluding .75% IFF) This is the price offered to GSA, with the GSA discount, that does not include the 0.75% Industrial Funding Fee (IFF).

Example:

List Price = $100.00 GSA Markup (exclusive of IFF): 10% MarkupPrice Offered to GSA excluding IFF: $100*(1+.10) = $110.00 Markup Price Offered to GSA (including .75% IFF) This is the price offered to GSA, with the GSA markup that includes the 0.75% Industrial Funding Fee (IFF).

IFF Calculation Example:

List Price = $100.00 GSA Discount (exclusive of IFF): 10% Markup Price Offered to GSA excluding IFF: $100*(1+.10) = $110.00 Markup Price Offered to GSA including IFF: $110.00/0.9925 = $110.83

Example:

New Commercial List Price: $2,500 Current Commercial List Price: $2,000 Percentage change in commercial list price: 25% ($2500-$2000/$2000 = $500/$2000 = 25%).

New MFC Price The New MFC (Most Favored Customer) Price is the new commercial list price with the markup or discount offered to most favored customers.

Example of Discount:

New Commercial List Price: $2,500 Discout offered to MFC: 15.00% New MFC Price: $2,125 ($2,500*(1-.15) = $2,125)

Example of Markup:

New Commercial List Price: $2,500 Markup offered to MFC: 15.00% New MFC Price: $2,875 ($2,500*(1+.15) = $2,875)

% Change in MFC Prices The percentage change in MFC price is the percentage difference between the New MFC Price and the Current MFC Price.

Example:

New MFC Price: $1,500 Current MFC Price: $1,000 Percentage Change in MFC Price: 50% ($1500-$1000/$1000 = $500/$1000 = 50%) Proposed GSA Price (excluding IFF) Proposed GSA Price excluding IFF is calculated by taking the commercial list price of the product and deducting the proposed GSA discount or adding the proposed GSA markup percentage.

Example of Discount:

New Commercial List Price: $2,500 Discout offered to MFC: 15.00% Proposed GSA Price: $2,125 ($2,500*(1-.15) = $2,125)

Example of Markup:

New Commercial List Price: $2,500 Markup offered to MFC: 15.00% Proposed GSA Price: $2,875 ($2,500*(1+.15) = $2,875) Proposed GSA Price (including IFF) Proposed GSA Price including IFF is calculated by taking the commercial list price of the product and deducting the proposed GSA discount or adding the proposed GSA markup percentage and then adding the Industrial Funding Fee of 0.75% (0.0075).

Example of Discount:

New Commercial List Price: $150 Proposed GSA Markup (excluding IFF): 10% Proposed Price (excluding IFF): $165 Industrial Funding Fee: $166.23 ($165/.9925 = $166.25)

Example of Markup:

New Commercial List Price: $150 Proposed GSA Markup (excluding IFF): 10% Proposed Price (excluding IFF): $165 Industrial Funding Fee: $166.23 ($165/.9925 = $166.25) Percentage change in GSA Prices Percentage Change in GSA Price (including IFF) is the percentage change from Proposed GSA Price (including IFF) and Current GSA Price (including IFF).

Example:

Proposed GSA Price (w/ IFF): $1250 Current GSA Price (w/IFF): $1000 % Change in GSA Price (w/IFF): 25% ($1250-$1000/$1000 = 250/1000 = 25%)

ISO CODE KEY