SRS – Global Tender
HCL INFOSYSTEMS Page 1
Software Requirement Specification of Global Tender
Version No: 2.0
AUTHOR/ OWNER REVIEWED BY APPROVED BY
NAME Ranjith kolla Akhaya Biswal Akhaya Biswal
DESIGNATION Author Project Manager Project Manager
SIGNATURE
SRS – Global Tender
HCL INFOSYSTEMS Page 2
Table of Contents
1.1 Process Flow Diagrams ................................................................................................. 3
1.2 Functional Requirements – Global Tender ..................................................................... 5
1.3 Functional Requirements – NIT Header Creation(Global Tender).................................. 5
1.3.1 Functional Requirements – Item Creation(Global Tender) .................................... 7
1.3.2 Functional Requirements – Add Vender(Global Tender) ....................................... 8
1.3.3 Functional Requirements – Eligibility Criteria(Global Tender) ............................... 8
1.3.4 Functional Requirements – Special Condition and Checklist(Global Tender) ....... 9
1.3.5 Functional Requirements – Technical Specifications(Global Tender) ................. 10
1.3.5.1 Technical Specification (Other than QCBS) .............................................. 10
1.3.5.2 Technical Specification for QCBS (Evaluation Criteria) ............................. 11
1.3.6 Functional Requirements - Attaching Documents (Global Tender) ..................... 12
1.3.7 Functional Requirements - Sign and Publish (Global Tender)............................. 13
1.4 Bidding Procedure – Vendors (Global Tenders) ............................................................ 14
1.4.1 Payment Submission (Optional) .......................................................................... 14
1.4.2 Techno-Commercial Bid ....................................................................................... 15
1.4.3 Financial Bid ......................................................................................................... 15
1.4.4 Rate Submission Process – Indigenous Offer and Foreign Currency Offer.......... 15
1.5 Tender Box Opening ...................................................................................................... 20
1.5.1 Ranking and Tabulation........................................................................................ 22
1.5.2 PDF formats of Techno-Commercial & Financial Offers and Tabulations ............ 25
1.5.3 Sample Data Files ................................................................................................ 26
1.6 Annexure A – Formulae and Calculations ...................................................................... 27
SRS – Global Tender
HCL INFOSYSTEMS Page 3
1.1 Process Flow Diagrams
Global Tendering NIT:
SRS – Global Tender
HCL INFOSYSTEMS Page 4
Rate Submission:
Vendor User Login Search Tenders / Inbox Submit payment Details
TDC/EMD can be
paid in
INR/USD
Enter Bid
Submit Offer
(Rate Submission)
Submit offer
Dropdown box will be
provided with these two
options.Currency
FOB Rate/Unit
Unconditional Discount on FOB (If any) (%)
Packing on FOB (%)
Insurance on FOB (%)
Transit Freight on FOB (%)
Other Charges Type (If Any)
Other Charge Amount/Unit
Agency Commission
Country of Origin etc
TBO:
SRS – Global Tender
HCL INFOSYSTEMS Page 5
1.2 Function Requirements – Global Tender
Global Tenders are the tenders which will be published internationally for the vendors
who want to participate in the tendering process worldwide. For these tenders vendors
can submit their offer in the currency of either their own country or any other country.
The process of creation of Global Tenders is similar to the tender creation process for
other non global types except for the task of Vendor selection. The complete process of
Global Tendering is divided into following sections:
NIT Creation
Bidding Process
Tender Box Opening (TBO)
1.3 Functional Requirements - NIT Header Creation (Global Tender)
This section “NIT Creation” refers to the NIT Header creation part which is similar to the
non global tender’s NIT Header creation process except that in case of Global Tenders it
would include one flag “Whether Global tender?” which can be enabled or disabled to
indicate whether this tender is a Global Tender or not. Once the “Whether Global
tender?” flag is checked/enabled all the options in “Tender Type” drop down wi ll change
to Global Tender types e.g. Global Open, Global Limited etc and now the TDC and EMD
payments can be made in INR and USD both.
NIT Header Creation will follow the same procedure as per mentioned in SRS RFQ.
Exception is that while creating “Global Tenders”, a check box for Global Tenders will be
selected by the user. Once the “Global Tenders” field has been selected/checked, few
fields like Tender Types will be changed by default. Tender Types like
Open/Limited/Single will be changed as Global Open/Global Limited/Global Single.
Please refer to SRS RFQ for the procedure to create NIT Header.
Data Table – NIT Header
The additional fields added in the NIT Header Creation form for global tenders are
provided in the table given below.
Field Name Field
Description
Field Type Size Validation / Conditions
SRS – Global Tender
HCL INFOSYSTEMS Page 6
Whether Global
tender?
Flag to be
checked if Tender
is a Global
Tender
Checkbox 1 On Selection of Global
Tender corresponding
Tender Types for the
Global Tender would be
filtered.
Tender Type Type of tender Dropdown
box
1 In Case of global tender
the options will be Global
limited, Global open and
Global Single.
Tender Document
Cost
Tender Document
Cost in Indian
Rupees (INR) or
US Dollars (USD)
Textbox 10 Optional for all tenders.
This field will accept 2
decimal place values.
Earnest Money Earnest Money
Deposit in Indian
Rupees (INR) or
US Dollars (USD)
Textbox 10 Optional for all tenders
and this field will accept
2 decimal place values.
SRS – Global Tender
HCL INFOSYSTEMS Page 7
1.3.1 Functional Requirements – Item Creation (Global Tender)
Item Creation in Global Tenders will have two more fields as “Port Consignee” and
“Ultimate Consignee”. These fields are mandatory to be filled up by the user. Other steps
for Item Creation are same as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information regarding Item Creation procedure.
Data table - Item Creation
SRS – Global Tender
HCL INFOSYSTEMS Page 8
The additional fields added in the Item Creation form for global tenders are provided in
the table given below.
1.3.2 Functional Requirements - Add Vendors (Global Tender)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Add Vendors” procedure.
The information captured in the Vendor details form is provided in the table given below
Field Name Field
Description
Field Type Size Validation /
Conditions
Port
Consignee
Port Consignee Textbox 50 Mandatory.
Quantity Quantity Textbox Mandatory
SRS – Global Tender
HCL INFOSYSTEMS Page 9
Field Name Field Description Field
Type
Size Validation / Conditions
Vendor Name To enter the search
criteria for vendor
account
Textbox 15 Minimum 3 characters
should be entered.
Search Vendor Button to initiate
vendor search for
given criteria.
Button On click of search button
will generate a pop up with
vendor list for the search
criteria entered. Then,
Selected vendors will be
added in vendor details
layer.
Delete Button to delete the
already added
vendors.
Link Selected vendors / trade
groups can be deleted
from the tabular form.
Exit Button to Exit from
NIT Creation.
Button It will exit from NIT
Creation interface.
1.3.3 Functional Requirements - Eligibility Criteria (Global Tender)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Eligibility Criteria” procedure
The information captured in the Check List form is provided in the table given below.
Field Name Field Description Field
Type
Length Validation / Conditions
Description Description Text
Area
1000 Mandatory
Save Button to save the
Eligibility Criteria
Button On Click of link data would
rest in Database and
displayed in the tabular form.
SRS – Global Tender
HCL INFOSYSTEMS Page 10
Reset Button to clear all the
field values.
Button It will reset the input field
values to default.
Exit Button to Exit from
NIT Creation.
Button It will exit from NIT Creation
interface.
Edit Link to edit the
selected Eligibility
Criteria.
Link It will enable all the fields for
editing the selected Eligibility
Criteria.
Update Button to update
Eligibility Criteria
values.
Button Eligibility Criteria which is
already added in the list can
be updated with this action.
After publishing the tender,
Button label will be changed
to ‘Sign & Submit’.
Delete Link to delete
Eligibility Criteria.
Link This is used for deleting
Eligibility Criteria from the list.
1.3.4 Functional Requirements - Special Conditions and Checklist (Global Tender)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Special Conditions and Checklist” procedure
The information captured in the Check List form is provided in the table given below.
Field Name Field Description Field
Type
Length Validation / Conditions
Description Description Text
Area
1000 Mandatory
Save Button to save the
check list
Button On Click of link data would
rest in Database and
displayed in the tabular
form.
Reset Button to clear all the Button It will reset all the checklist
SRS – Global Tender
HCL INFOSYSTEMS Page 11
field values. values to default.
Exit Button to Exit from
NIT Creation.
Button It will exit from NIT
Creation interface.
Edit Link to edit the
selected checklist.
Link It will enable all the fields
for editing the selected
checklist.
Sign &Submit Sign and Submit Button Sign & Submit
Delete Link to delete
checklist.
Link This is used for deleting
checklist from the list.
Default checklist for every Unit will be populated by Unit administrator.
1.3.5 Functional Requirements - Technical Specifications (Global Tender) (Other
than QCBS)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Technical Specifications” procedure.
The information captured in the Technical Specifications form is provided in the table
given below.
1.3.5.1 Technical Specifications (Other than QCBS)
Field Name Field Description Field
Type
Length Validation / Conditions
Description Description Text Area 2000 Mandatory
Sign &Save Button to save the
Technical
Specifications
Button On Click of link data would
rest in Database and
displayed in the tabular
form.
Reset Button to clear all the
field values.
Button It will reset all the technical
specification values to last
saved values.
Exit Button to Exit from
NIT Creation.
Button It will exit from NIT Creation
interface.
SRS – Global Tender
HCL INFOSYSTEMS Page 12
Edit Link to edit the
selected Technical
Specification.
Link It will enable all the fields for
editing the selected
Technical Specification.
Sign &Update Button to update
Technical
Specification values.
Button Technical Specification
which is already added in
the list can be updated with
this action.
After publishing the tender,
Button label will be changed
to ‘Sign & Submit’.
Delete Link to delete
Technical
Specification.
Link This is used for deleting
Technical Specification from
the list.
1.3.6 Functional Requirements - Attaching Documents (Global Tender)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Attaching Documents” procedure
The information captured in the Attach Documents form is provided in the table given
below.
Field Name Field Description Field
Type
Size Validation / Conditions
File Description File Description Textbox 300 Mandatory, In case if the
original file name is selected
the File Description will be
mandatory
Sign &Upload Button to upload the
file
Button Uploads the selected file at
the server directory
After publishing the tender,
Button label will be changed
to ‘Sign & Submit’.
Exit To exit from the NIT
Creation interface.
Button It will exit from the NIT
creation User interface.
SRS – Global Tender
HCL INFOSYSTEMS Page 13
Reset Button to clear all the
field values.
Button It will reset all the attach
document values to default.
Delete This will delete
uploaded document
data from the
database.
Link It will delete the document
data from the database.
1.3.7 Functional Requirements - Sign and Publish (Global Tender)
Follow the same procedure as per mentioned in SRS RFQ. Please refer to SRS RFQ for
information/screenshot regarding “Sign and Publish” procedure
The information captured in Publish tender form is provided in the table given below.
Field Name Field Description Field
Type
Size Validation / Conditions
Attach
Certificate
Button to attach the
encryption certificate.
Button At least one item and one
Eligibility Criteria need to be
added for attaching public
key of encryption certificate.
Sign & Submit Button to attach the
signature certificate
and publish NIT.
Button After attaching public key of
encryption certificate, Sign &
Submit button will be
enabled. After signing with
private key of digital signature
certificate, tender status will
change to issued/published.
Exit To exit from the NIT
Creation interface.
Button It will exit from the NIT
creation User interface.
1.4 Bidding Procedure – Vendors (Global Tenders): “Bidding” deals with the vendors
who want to participate in bidding for a particular tender. For successful bidding,
vendor should execute 3 steps to completion.
1.4.1 Payment Submission (Optional) – TDC/EMD amount can be paid by the Vendor
as per specified in the tender. During the payment of TDC and EMD, vendors will have
the options of selecting TDC/EMD. TDC can be paid either in INR or USD. However,
EMD may be acceptable in other currencies also.
Submit Tender Document Cost
SRS – Global Tender
HCL INFOSYSTEMS Page 14
1.4.2 Techno-Commercial Bid – Vendors are required to submit their techno-
commercial offer for the tender against whom they have made TDC/EMD payments.
This process is similar to the process defined for other types of non global tenders.
Please refer to SRS Bid for more information regarding the Techno-Commercial Bid.
1.4.3 Financial Bid – This third step requires vendors to submit their financial rates for
the tender against which they have made the TDC/EMD payments. All bidders will have
options to submit their bid as an Indigenous Bid or as a Foreign Currency Bid. On
selecting the option to submit the Bid as an Indigenous Bid, the Rate Submission Page
will be exactly like the one used in other types of Non-Global Tenders except Consignee
which will be shown as Ultimate Consignee in label as well as value. In case the user
opts to submit his offer as a Foreign Currency Bid, the Rate Submission Page will be as
shown below with some additional fields which have been described in data table.
Revision of previously submitted offers will be possible but vendors can revise their
original offers in the same, Foreign Currency or Indigenous format, in which the original
offer was submitted. However while submitting Alternate offer, they can choose from
Foreign Currency or Indigenous bid irrespective of original offer. Rate page will only
show the Port Consignees which were entered by the user in the NIT Creation page
against individual Consignees. Also the quantities entered for all individual consignees in
the tender against a selected Port Consignee will be added and displayed in the
Financial Bid Submission page. E.g. If a tender has 5 consignees and out of these 5, 3
consignees have been associated with one Port Consignee and left 2 with another Port
SRS – Global Tender
HCL INFOSYSTEMS Page 15
Consignee then during Financial Bid Submission, the vendors will get to see 2 Port
Consignees against which they will submit their Financial Bids. Also the Item Quantities
for individual Consignees associated with the same Port Consignee will be added up
and shown as Tendered Quantity in the Financial Bid Submission page. Also at the time
of Financial Bid Submission for Foreign Currency Bid, the vendors will get the option to
submit their rate for an item in any foreign currency which is available through a list of
drop down on the Rate Submission age. Submission of a bid in any currency which is
not there in the list will not be possible. This list of available currencies will be created,
managed and maintained through DCC. The total value per item will be calculated in the
same currency in which the vendor has submitted his offer.
Financial Bid Interface
In order to complete the bidding process, the Vendor participating in the bidding
procedure requires submitting all the mandatory details like Eligibility, Terms and
Conditions, Attach Documents, Checklist, and financial offer. Same procedure
follows as per SRS BID. Please refer to SRS BID for more information regarding the
procedure to complete the bidding procedure.
1.4.4 Rate Submission Process – Indigenous Offer and Foreign Currency Offer
Indigenous Offer: The information added in the Rate Submission form for Indigenous
Offer in Global Tender will remain similar as found in the BID SRS. Please refer to SRS
BID for Data Table and other information regarding submission of an Indigenous Offer.
Financial Rate Page Indigenous Offer
SRS – Global Tender
HCL INFOSYSTEMS Page 16
Foreign Currency Offer: Few additional fields are found in the Rate Submission form
for Foreign Currency offer in Global Tender.
SRS – Global Tender
HCL INFOSYSTEMS Page 17
Financial Rate Page Foreign Currency Offer
Data table – Rate Submission Process (Foreign Currency Offer)
The additional fields added in the Rate Submission form for Foreign Currency Offer in
Global Tender are provided in the table given below.
Field Name Field
Description
Field
Type
Size Validation / Conditions
SRS – Global Tender
HCL INFOSYSTEMS Page 18
PL No.(Product
Code)
PL Number /
Product Code of
the Item being
bid upon
Label NA NA
Item Description Text description
of the item
being bid upon
Text Area NA Disabled / Read only
FOB Rate/Unit FOB Rate/Unit Textbox NA Mandatory; Valid value
between 0.01 to
99999999999.99
Unconditional
Discount on
FOB (If any) (%)
Unconditional
Discount on
FOB (If any) (%)
Textbox NA Non Mandatory; Validate for
a value from 0.01 – 99.99
Packing on FOB
(%)
Packing on FOB
(%)
Textbox NA Non Mandatory; Validate for
a value from 0.01 – 99.99
Port of
Shipment
Port from where
the items will be
shipped
Text Box 50 Mandatory; Size between 4 –
db column allowed
Mode of
Shipment
Mode through
which items will
be shipped
Drop
Down
NA Mandatory; Default – Air out
of available 4; By Air / By
Sea / Courier / Other;
Selecting “Other” pops a
window reminding user to
enter details in remarks field
Other Charges
Type (If Any)
Other Charges
Type (If Any)
Textbox NA Non Mandatory; Validate
value with a size between 4
and db column allowed
Other Charges
Amount/Unit
Other Charges
Amount/Unit
Textbox NA Non Mandatory; Validate for
a positive numeric value
Gross
Weight/Unit (in
KG)
Gross
Weight/Unit (in
KG)
Textbox NA Non Mandatory; Validate
entry for a value from 0.01 –
999999.00
Packing
Specifications
Packing
Specifications
Text Area NA Non Mandatory; Validate
entry for a size between 10
to db column size
SRS – Global Tender
HCL INFOSYSTEMS Page 19
Remarks Remarks Text Area 2000 Non Mandatory; Validate
entry for a size between 4 to
db column size
Port Consignee Port Consignee
for the Item
Label NA NA
Quantity as per
Tender
Quantity
required as
mentioned in
the tender
Text Field NA Disabled / Read Only
Quantity
Offered
Quantity Offered
by vendor
Text Field NA Mandatory; Default value
same as Quantity as per
Tender; Valid value must be
equal to or greater than the
default value
Net FOB Rate Net FOB
Rate = FOB –
Discount +
Packing + Other
Charges
Text Field NA Disabled / Read Only.
Transit Freight
Amount
Transit Freight
Amount
Textbox NA Non Mandatory; Default: “Not
Quoted” (grey color);
Validate for a value from 0.01
– 99999999999.99. On
clicking in the field, default
value disappears and if left
blank, same default value re-
appears. Typed characters to
appear blank
C & F Rate C & F Rate =
Net FOB +
Freight
Text Field NA Disabled / Read Only
Print Offer To print the offer
before
decrypting it for
submission over
internet
Button NA NA
Submit Offer Submit Offer
after decryption
Button NA NA
SRS – Global Tender
HCL INFOSYSTEMS Page 20
and signing
Reset Rest the whole
form to the
original settings
as it opened
initially
Button NA NA
1.5 Tender Box Opening: This section “Tender Box Opening” deals with Tender Box
Opening process through which the authorized tender box opening officials open the
tender box once
bidding is over. The process will remain similar like standard tender box opening process
for all other non global type of tenders for the initial steps of Authentication, Bid Data
Decryption, Sign and Acknowledge, as defined in SRS of “BID”. Once all bids are
decrypted, acknowledgment is signed, the Tender Status will change to “Tender Box
Opened – Tabulation Pending” and the “Summary of Offers” will be generated, which
will be available for all the authorized users and vendors to view. This summary will
contain offers of all the firms in the original currencies in which their Bids were
submitted. To create Ranking and Tabulation, authorized ECIL users have to proceed
further to the next step titled “Common Parameters for Ranking and Tabulation“ which
can be initiated by the system through action links available with the listed tender as
mentioned below:
Once the Tender Status has changed to “Tender Box Opened – Tabulation Pending”,
then the page with “List of Suppliers” will display two additional hyperlinks apart from the
ones that are available in the Non-Global tenders. Additional links that will appear are –
“View Summary of Financial Offers” and “Submit Common/Item-Wise Parameters”.
Common links that appear for both Global and Non-Global tenders are – links for
Financial Offer View and Verification, links for Techno-Commercial Offer View and
SRS – Global Tender
HCL INFOSYSTEMS Page 21
Verification, link to view Techno-Commercial Tabulation and a link to view Payment
Report.
On clicking “View Summary of Financial Offers”, a PDF with “Summary of Financial
offers” will be loaded to display to the user. On clicking “Submit Common/Item-wise
Parameters”, a page titled “Common Parameters for Ranking and Tabulation” will open
where the authorized ECIL users will have to enter values for various parameters that
are required for generating the ranking of the financial offers. This step would ask the
user for those common parameters which are independent of tendered items like
currency conversion rates for all those currencies in which the vendors have submitted
their offers, Date of Conversion etc, other charges like LC Charges, Port Handling and
Clearance Charges, Insurance Charges etc. For complete details of such charges and
all other related fields, please refer to the data table.
In case there is no offer in Foreign Currency, the system will behave similar to Non-
Global
Tenders Hence the input for “Common and Item-wise Parameters” will not be taken from
the ECIL User. Also the Summary of Offers will not be generated and shown. The status
of the tender will be changed to “Tender Box Opened” immediately after the Decryption
of All Indigenous Bids and final tabulations can be seen just as it is in Non-Global
Tenders.
Once Common Parameters for ranking have been provided as a first step, the next
step requires the user to enter specific parameter values for the tendered items and all
these values are specific to an item and may vary from an item to item. These item-wise
parameters are captured through a page titled “Item-wise Parameters for Ranking
and Tabulation” and are to be entered by an authorized ECIL user for all the tendered
items. On this page, list of items will be shown to the authorized user. An action icon
“Enter Item-wise Parameters” will be available against each item which can be clicked
by the user to enter the required parameters for that item. Once the user has entered the
parameters against a particular item, tool tip on this icon will change to “Update Item-
wise Parameters”. At the bottom a button “Proceed to Generate Financial Tabulation
Statement’ will be enabled once parameters against all the items have been submitted.
A checkbox “Use Same Values for Remaining Items” will also be available which can
be enabled to submit the entered values of an item’s parameters for all the remaining
items. However, the user still has action icon “Update Item-wise Parameters” available to
change the values of a particular item. Such item wise parameters comprise of Customs
Duty, Calculated Freight and Other Charges etc. For complete details of such charges
and all other related fields, please refer to the data table. A link to update previously
submitted values against Common Parameters will also be available and values
submitted against item wise parameters can also be updated for individual items, but
SRS – Global Tender
HCL INFOSYSTEMS Page 22
these updates in the parameter values can only be done till the Tabulation has not been
generated.
On clicking “Proceed to Generate Financial Tabulation Statement” button, the
rankings will be generated from the Total Amount per Item of all the bids which is
calculated after converting all the bid values into Indian Rupees (INR) in accordance with
the conversion rates and other parameter values provided in the previously mentioned
steps. Ranking which is generated is based on the Total Amount calculated in INR and
can be seen in tabulation statements. Parameter values now cannot be altered and will
be frozen permanently. This Financial Tabulation will be available to ECIL users only
and will not be made available to the vendors including those also who have participated
in bidding. However, Techno-commercial tabulations, summary of financial offers and
offers (techno-commercial and financial) will be available to the vendors as are available
in case of non-global tenders.
Functionality Access Control: This remains same as defined for all types of non global
tenders
Authorization: This remains same as defined for all types of non global tenders
1.5.1 Ranking and Tabulation: Few additional fields have been added in the
parameters for Ranking and Tabulation form for global tenders.
Data Table for same is provided below:
Data table – Common Parameters for Ranking and Tabulation
Field Name Field
Description
Field
Type
Siz
e
Validation / Conditions
Port Handling Charges (%) on CIF
Port Handling Charges (%) on CIF
Textbox Mandatory; Default blank;
Validate value between 0.01 to
99.99
Insurance
Charges (%) on
FOB + Freight
Insurance
Charges (%)
Textbox Mandatory; Default blank;
Validate value between 0.01 to
99.99
LC Charges (%)
on FOB
LC Charges Textbox Mandatory; Default blank;
Validate value between 0.01 to
99.99
Custom
Clearance
Custom
Clearance
Textbox Mandatory; Default blank;
Validate value between 0.01 to
SRS – Global Tender
HCL INFOSYSTEMS Page 23
Common Parameters for Ranking and Tabulation
Data Table – Item-wise Parameters for Ranking and Tabulation
The information added in the Parameters for Ranking and Tabulation form for global
tendering is provided in the table given below.
Charges (%) on
CIF
Charges (%) 99.99
Date of
Conversion
Date of
Conversion
Date Mandatory; Default Current
Date/Time; Should be less than
or equal to current date/time
Field Name Field Description Field
Type
Size Validation / Conditions
Custom Duty
(%) on
Assessable
Value
Custom Duty /
Charges on
Assessable Value.
Assessable Value
= FOB + Insurance
Textbo
x
NA Mandatory; Default blank;
Validate value between 0.01
to 99.99
SRS – Global Tender
HCL INFOSYSTEMS Page 24
Item-wise Parameters for Ranking and Tabulation
+ Freight +
Handling and
Clearance Charges
Calculated
Freight Charges
Calculated Freight
Charges
Dropdo
wn/
Textbo
x
NA List contains:
Lump sum/Unit;
Percentage on FOB Mandatory; Default blank;
Validate value between 0.01 –
999999.00
Other Charges
Type
Other Charges
Type
Textbo
x
NA Not Mandatory; Validate entry
for size between 2 and db
column allowed size;
Mandatory if Other Charges
Amount is entered
Other Charges
(%) on FOB
Other Charges
Amount Value
Textbo
x
NA Not Mandatory; Validate entry
for value between 0.01 –
99.99; Mandatory if Other
Charges Type is entered
Use Same
Values for All
Other Tender
Items
Used to indicate
that same values
can be used for
rest of the items of
tender
Checkb
ox
NA Non Mandatory, unchecked by
default.
SRS – Global Tender
HCL INFOSYSTEMS Page 25
Proceed to Generate Tabulations
1.5.2 PDF formats of Techno-Commercial & Financial Offers and Tabulations
Formats
Tabulation Formats Microsoft Office
Excel 97-2003 Worksheet
Summary of Offers Format Microsoft Office
Excel 97-2003 Worksheet
1.5.3 Sample Data Files
Type of PDF Attached Doc
Commercial Tabulation Commercial Tabulation.png
Tabulation of Technical
Specification & deviations. Tabulation of Technical Specification & deviations..png
SRS – Global Tender
HCL INFOSYSTEMS Page 26
Financial Offer (Item-wise) Financial Offer (Item-wise).png
Financial Tabulation (Item-
wise) Financial Tabulation (Item-wise).png
Summary of Offers (Item-Wise) Summary of Offers (Item-Wise).png
Financial Offer (Group-wise) Financial Offer (Group-wise).png
Financial Tabulation (Group-
wise) Financial Tabulation (Group-wise).png
Summary of Offers (Group-
wise) Summary of Offers (Group-wise).png
Financial Offer (Total-Value-
Wise) Financial Offer (Total-Value-Wise).png
Financial Tabulation (Total-
Value-Wise) Financial Tabulation (Total-Value-Wise).png
Summary of Offers (Total-
Value-Wise) Summary of Offers (Total-Value-Wise).png
1.6 Annexure A – Formulae and Calculations
Various calculations that go into generation of Tabulations and Displaying of various
values are summarized below for reference purpose.
Net FOB Quoted FOB Price Per Unit - Discount on FOB + Packing Charges +
Other Charges
C&F Price Net FOB + Freight ( If Transit Freight is not quoted, then take calculated
Freight Charges as entered in Item-wise parameters)
SRS – Global Tender
HCL INFOSYSTEMS Page 27
Insurance Charges To be calculated percentage on C&F e.g. if Insurance Percentage = 3%
and C&F = 100 Rupees then Insurance amount = 3 Rupees
CIF Price C&F + Insurance charges
Port Handling
Charges (PHC) Percentage of CIF i.e. (C&F + Insurance amount)
LC Charges Percentage of Net FOB.
Assessable Value Percentage of (CIF + PHC). Custom Clearance Charges (CCC) are not
included in this.
CCC Calculated on percentage of CIF.
LC percentage on Net FOB
OC As entered in Item-wise parameters.
Landed Cost Assessable Value + CD + CCC + OC + LC
Note No Freight charges to be included against Indigenous offers for
ranking purpose in tabulation.
Note Packing Charges are to be calculated on discounted FOB as done
on discounted basic for ingenious offer.
Note Custom Duty (CD) is percentage on assessable value.
Note/Additional Comments: Additional screenshots will be made available as per the
availability.