Get documents about "How Can I Increase My Gross Operating Profit - Excel
W
Description
How Can I Increase My Gross Operating Profit document sample
Document Sample
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
Please send back this form ( version EXCEL + version PDF) to … (see Contract Notice published: CDROM + paper version)
0. Contract Notice ID
Publication number:
Date of publication:
Subject:
Interest of your Company in this tender (only if lots are specified in the Contract Notice)
If not, please comment on the reason
Lots Interest by your Company?
(shortage in capacity / not in portfolio / not competitive / ...)
1 YES/NO
2 YES/NO
3 YES/NO
… … …
Contact for additional communication regarding your candidature:
Name: Tel:
Job title: Mobile:
Language(s): Fax:
Address: E-mail:
Has your Company participated tenders for the product / service concerned for Elia in the past? YES/NO
If Yes … Reference Number of Contract Notice:
Date (mm/yy):
EXLUSION EXCLUSION PARAMETERS (see Conditions of Participation)
Please provide the Frequency Rate (*) for the past five years:
Y-1 Y-2 Y-3 Y-4 Y-5
#DIV/0!
Please enter the last published Frequency Rate (*) of the concerned sector (NACE) in Belgium. Normally, (enter NACE from
(enter rate)
this value has been given by Elia in the Contract Notice. If not, please enter 'not given' Contract Notice)
In case the NACE code mentionned in the Contract Notice is not (or little) relevant for your business,
(enter NACE)
please enter the most relevant NACE code in which your Company is involved
(*) Frequency Rate Formula: total number of accidents multiplied by 1.000.000 over total number of man hours worked
(Encyclopaedia of Occupational Health and Safety of the International Labour Office)
Does your Company confirm the permanent presence of a foreman on the site during the execution of works who masters …
the Dutch language when asked for (Dutch speaking regions) YES/NO
the French language when asked for (French speaking regions) YES/NO
Enclosed?
Documents to be enclosed: * Sworn Statement (signed!) YES/NO
1. Company ID (Company = Legal entity !)
Company name (Legal entity):
Head office: Adress: Tel:
Fax:
E-mail:
Website:
VAT registration number:
Registrated in Belgium? YES / NO if applicable, registration number:
Start of Company?
Ownership:
Quoted on Stock Exchange? YES / NO
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 1/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
Please send back this form ( version EXCEL + version PDF) to … (Name) + paper version)
(see Contract Notice published: CDROM (Activities)
Ultimate Parent Company:
Subsidiairies:
Affiliated Companies:
(Name) (% of Shares)
Main Shareholders + % Shares:
Enclosed?
Documents to be enclosed: * Chart showing legal structure (Parent Company, Subisidary Companies, main Shareholders / Divisions) YES/NO
* Certificate proving registration as a Belgian Contractor YES/NO
2. Company Information - ALL PRODUCTS / SERVICES
2.1. Organisation Capacity - all products / services
What are the main business activities of your Company:
Most important customer references per segment in last five years
% of total
Products/ Services turnover (last Type of contract
Year) Name Customer + Country Sector annual value
contract periode
Enclosed?
Documents to be enclosed: * Organisation chart showing main business units YES/NO
* Organisation chart showing main functional responsibilities YES/NO
2.2. Financial Information - all products / services
On level of the "legal entity" for products/ services concerned
End of financial year?
Please indicate the year, referred to by " Y " in this document (Y = year?)
REMARK: Elia will not accept cross-references to documents in attachment. The ratios has to be calculated in sheet "FIN RATIOS" and be repeated in
the table below !!!
last Year (Y-1) Y-2 Y- 3 Comments
Liquidity Ratio
Solvency
Rentability
Pre-Tax Profit (in kEUR)
Netto Profit (in kEUR)
Net Capital (in kEUR)
last Year (Y-1) Y-2 Y- 3 Comments
outside Benelux
Turnover EU
Benelux
(in kEUR)
outside EU
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 2/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
On level of the Please send back this form ( version EXCEL + version PDF) to …
"consolidated group" (if different from above) (see Contract Notice published: CDROM + paper version)
last Year (Y-1) Y-2 Y- 3 Comments
Liquidity Ratio
Solvency
Rentability
last Year (Y-1) Y-2 Y- 3 Comments
outside Benelux
Turnover EU
Benelux
(in kEUR)
outside EU
Enclosed?
Documents to be enclosed: * Balance Sheets past 3 years YES/NO
* Calculation Sheet with the financial ratio's proving the financial solvability (past 3 years) YES/NO
* Profit and Loss Accounts past 3 years YES/NO
2.3. References - all Products / Services
Most important customers / references in the last five years for all products / services in the same or comparable business as Elia
Period
Name Customer + Country Specify Project Type of contract Annual Value
Contract
% turnover with 3 largest customers, all products / services , all sectors
Name Customer + Country Sector Product / Service % This Year % Y -1 % Y -2 % Y -3
References in Belgium, all products / services , all sectors
Name Customer + Country Sector Product / Service Value Last Year
2.4. Evolution/ changes in your Company - all products / services
Evolutions/ changes during last five years / planned in future? (all products/ services) Comments
Change of legal status? YES/NO
Change of ownership YES/NO
Mergers / joint-ventures / acquisitions? YES/NO
Human resources? YES/NO
Factory closing or production shifts? YES/NO
Others
Investments (last five years / planned) + type of investment
2.5. Sworn Statement
Enclosed?
Documents to be enclosed: * Sworn Statement (signed!) YES/NO
* Certificate issued by the competent authority that proves the fulfillment of the obligations relating the payment of social security contributions
YES/NO
in accordance with the legal provisions
* Certificate issued by the competent authority that proves the fulfillment of the obligations relating the payment of taxes in accordance with
YES/NO
the legal provisions
* A recent Certificate of non bankruptcy YES/NO
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 3/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
3. Company - to …
Please send back this form ( version EXCEL + version PDF)PRODUCT/ SERVICE AREA SUBJECT (see Contract Notice published: CDROM + paper version)
TO CONTRACT NOTICE
3.1 Organisation capacity - only products / services concerned by the Contract Notice!
Sales of products / services concerned, delivery in Belgium:
Direct / Respresentative (delivery in Belgium)? YES/NO
If Yes, name of company?
If Yes, prepared to work directly with customer? YES/NO
Country of sales department / representative:
Contact person:
Number of people in office:
Language(s):
Annual sales by this sales office / representative:
Partnerships / joint ventures (for products / services concerned by this tender)? YES / NO
If Yes, please provide details
Is your Company affiliated or associated with any other company associated with the products / services
YES / NO
concerned?
If Yes, please provide details
Does the Group include another Firm (subsidiaries/affiliated Companies) whose Sector of Activity is similar
YES / NO
to the Products / Services covered by this Questionnaire?
If Yes, please provide details
Do you outsource activities (subcontracting) / components?
Share of this product / service
Product / Service Name Supplier Country Supplier in total Cost Price of the
product / service
Human resources involved for the product / service concerned by this tender:
Y-1 Y-2 Y-3
Total number of … : (in total, for all businesses, all countries) (permanent) (temp) (permanent) (temp) (permanent) (temp)
Blue Collars (production people):
White Collars (office people):
Total number of … : (only concerned service in Belgium)
Blue Collars:
==> How many shifts?
==> Languages (in case of direct contact with
people of Elia / Elia Engineering)
White Collars:
==> Languages (in case of direct contact with
people of Elia / Elia Engineering)
Comments:
3.2. Financial Information - only products / services concerned by the Contract Notice!
Turnover of your Company (legal entity), in kEUR:
Actual Year Last Year
Y-2 Most important countries
(budget) (Y-1)
outside Benelux
EU Benelux
Belgium
outside EU
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 4/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
3.3. version PDF) - only
Please send back this form ( version EXCEL + Referencesto … by Contract Notice Notice!
products / services concerned (see the Contract published: CDROM + paper version)
Most important customers / references in the last five years for the product/ service concerned and in the same or comparable business as Elia
Period
Name Customer + Country Specify Project Type of contract Annual Value
Contract
Most important customers / references in the last 5 years for the product/ service concerned but in other business (sector)
Period
Name Customer + Sector + Country Specify Project Type of contract Annual Value
Contract
Have you had any contracts terminated for poor performance in the last five years, or any contracts where damages have been claimed by the contracting authority? YES / NO
Has your Company ever had to pay financial penalties levied in respect of a failure to perform to the terms of a contract? YES / NO
Enclosed?
Documents to be enclosed: * List of references for products involved (similar achievements) during past 3 years YES/NO
* Letters of recommendation YES/NO
3.4. Evolution/ changes in your Company - only products / services concerned by the Contract Notice!
Evolutions for this type of product / service (last five years / plans in future)? Comments
New factories? YES/NO
Innovation in product / service? YES/NO
Evolution or shifts in capacity? YES/NO
Joint-ventures / acquisitions? YES/NO
Others … YES/NO
Investments (last five years / planned) + type of investment
4. QUALITY
ISO 9000 : 2000 certification? YES/NO
if yes: valid from until
if no: had one in the past? YES/NO
planning to obtain? YES/NO
Other certification by accredited independent assessment organisation:
certificate, organisation, period of validity
If you have a non certificatied quality system, please provide details
If you manufacture / work / provide to specific International, European or National Standards, please provide details
What kind of checks are carried out when the product (product area involved) leaves the factory where it is manufactured?
Are the tests achieved by the supplier or by a laboratory? Which laboratory? Is this laboratory accredited?
Have you completed long-term or in service-tests?
What test reports can you provide?
Maintenance on Product: supplied by your Company or provided by other parties?
Enclosed?
Documents to be enclosed: * Copy of ISO-900* Certificate or any other equivalent-level certification in the field concerned YES/NO
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 5/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
5. Please send back this form ( version EXCEL + version PDF) to … SAFETY (see Contract Notice published: CDROM + paper version)
Please make sure the questions regarding "Frequency Rate" and "Language" are answered in the paragraph "Exlusion Parameters"
Which safety KPI's other then the Frequency Rate are monitored in your Company. Please specify and provide the statistics for the past five years.
Y-1 Y-2 Y-3 Y-4 Y-5
Does your Company have internal qualified health and safety expertise? YES/NO
Does the company appeals to external qualified health and safety expertise YES/NO
Does your Company analyse/manage safety of the subcontractors during …
- Prequalification. If "Y", please specify YES/NO
- Allocation of contract / order. If "Y", please specify YES/NO
- Execution of work. If "Y", please specify YES/NO
- other … , please specify
Does the Company publish an annual safety action plan? YES/NO
Are audits of the health & safety aspects conducted and recorded? YES/NO
Does your Company apply a dynamic iterative safety improvement system? (PlanDoCheckAct - Deming) YES/NO
Is this system applied to accident events? YES/NO
Is this system applied to incident events? YES/NO
Are the workers involved in this system? YES/NO
Does your Company have one of following safety management systems?
* BeSaCC YES/NO
* VCA YES/NO
* OHSAS YES/NO
* others YES/NO
If not yet, is your Company engaged on this moment to obtain one of these? Please specify YES/NO
Does your Company have a written statement of health and safety policy? YES/NO
Enclosed?
Documents to be enclosed: * Safety Organisational Chart YES/NO
* Copy of BeSaCC, VCA, OHSAS certificate or any other equivalent-level certification in the field concerned YES/NO
6. ENVIRONMENT
ISO 14001 certification? YES/NO
if yes: valid from until
if no: had one in the past? YES/NO
planning to obtain? YES/NO
Does your Company have a written environmental policy? YES/NO
Does your Company publish an annual environmental report? YES/NO
Enclosed?
Documents to be enclosed: * Copy of ISO-14001 Certificate or any other equivalent-level certification in the field concerned YES/NO
7. ADDITIONAL INFORMATION
Remarks ELIA / BEL
The information supplied will be treated as strictly confidential.
The information sheet must be signed by a responsible position in the Company to guarantee the truthfulness of the information supplied.
Elia reserves the right to verify any of the given data and to request additional data
Remarks Candidate
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 6/14
Name of the Company who wants to participate this tender (candidature): (please enter Company Name)
8. Please send back this form ( version EXCEL + version PDF) to … DECLARATION (see Contract Notice published: CDROM + paper version)
I declare that to the best of my knowledge, the answers submitted in this PQQ are correct.
Form completed by …
Name:
Function:
Phone Number:
E-mail:
Signature
Form completed on …
Date:
1365733e-5f36-4bfd-87be-9d92f7214bf0.xls 7/14
A. Example of presentation of Annual Reports
RECLASSIFIED BALANCE SHEET - FINANCIAL CRITERIA - ASSETS
Ref.
No. Description
1 + Intangible assets*
2 +
3 -
4 + =
5 + Tangible assets in course of construction*
6 +
7 +
8 +
9 + =
10 = FIXED ASSETS
11 +
12 +
13 +
14 + =
15 +
16 +
17 +
18 +
19 +
20 +
21 +
22 + =
23 = ASSETS
NOTE
24 (1) - of which : land and buildings
25 (1) - of which : plant and machinery
26 (2) - net of devaluation
27 (3) - net of accounts for work in progress
28 (4) - net of devaluation
RECLASSIFIED BALANCE SHEET - FINANCIAL CRITERIA - LIABILITIES AND NET CAPI
Ref.
No. Description
29
30
31
32
33 +
34
35
36
37
38
39 +
40
41 -
42
43 + =
44 +
45 +
46 + =
47 +
48 +
49 +
50 +
51 +
52 + =
53 = PERMANENT CAPITAL
54 +
55 +
56 +
57 +
58 +
59 + =
60 + Tax debts (Debts for taxation) *
61 + Other creditors*
62 + Other liabilities*
63 = TOTAL CURRENT LIABILITIES
64 LIABILITIES
65 Net of work in progress
RECLASSIFIED PROFIT AND LOSS ACCOUNT - ADDED VALUE AND ITS DESTINATION
RECLASSIFIED PROFIT AND LOSS ACCOUNT - ADDED VALUE AND ITS DESTINATION
Ref.
No. Description
66 + Turnover (Net sales) *
67 + Increase (decrease) work in progress,
finished/unfinished goods
68 + Capitalization of tangible assets
69 + State contributions (or similar)
70 Product of the financial year( = ref 66 + ref 67 +
ref 68 +ref 69)*
71 - Purchases
72 Increase/decrease raw materials, consumables and
goods
73 - External charges for services
74 Operating added value( = ref 70 -ref 71 ref 72 -
ref 73)*
75 - Cost of labour
76 Gross operating profit( = ref 74 - ref 75)*
77 - Depreciation (tangible assets)
78 - Devaluation of current assets
79 - Provisions for liabilities and charges
80 Net operating profit( = ref 76 - ref 77 - ref 78 - ref
79)*
81 + Other income/charges
82 + Capitalization of intangible assets
83 - Amortization of intangible assets
84 Current profit before financial items( = ref 80 +
ref 81 + ref 82 - ref 83)*
85 + Financial income (interest receivable etc.)
86 - Financial losses
87 Current profit before financial charges( = ref 84
+ ref 85 - ref 86)*
88 - Financial charges (interest payable etc.)
89 Current profit( = ref 87 - ref 88)*
90 Profit/Loss on sale of fixed assets
91 Extraordinary items
92 Profit/loss before taxation( = ref 89 ref 90 ref
91)*
93 - Taxation
94 = PROFIT/LOSS AFTER TAXATION( = ref 92 - ref
93)*
* According to fourth Council directive of July 1978 based on art. 54 (3) (g) of the Treaty of Rome on the annual accounts of certain types o
NCIAL CRITERIA - ASSETS
n
Tangible assets
Depreciation and devaluation
Net tangible assets (1) *
tion*
Investments (long term) in companies (2)
Financial debtors and other investments
Trade and other debtors (falling due after one year)
Fixed financial assets*
Payments on account
Raw materials and consumables
Work in progress and finished goods (3)
Stocks (inventories) *
Trade debtors (4) *
Financial debtors (4) *
Other debtors
Other assets*
Financial assets (short term investments)
Cash at bank and in hand
Liquid assets*
Current assets
EET - FINANCIAL CRITERIA - LIABILITIES AND NET CAPITAL
Description
+ Share capital
+ Other paid in capital by shareholders
+ Share premium account
- Called up share capital not paid
= Paid in capital*
+ Revaluation reserve
+ Reserves deriving from fiscal laws
+ Other reserves
- Own shares
+ Capitalized state contributions (similar)
= Réserves*
Profit/Loss after taxation
Proposed dividends
Profit (loss) to reserves
NET CAPITAL*
Provisions for liabilities and charges
Provisions for pensions and similar
Total provisions*
Debenture loans (due after one year)
Long term financial creditors (due to shareholders)
Long term financial creditors (due to banks)
Other long term financial creditors
Long term trade creditors and other long term liabilities
Consolidated creditors*
Short term financial creditors (banks and similar)
Other short term financial creditors
Short term financial creditors (within one year) *
Short term trade creditors
Payments received on account
Trade creditors*
S
) of the Treaty of Rome on the annual accounts of certain types of companies (OJEC L222/11 of August 1978).
Date:
Company: Gelieve de gele velden in te vullen in Euro
Definition and calculation of financial ratio's (according to Belgian GAAP) Veuillez remplir les cellules jaunes en Euro
Fill in the yellow cells in Euro
Nederlands Français English
Year N = 200x ?
Ratio's Year N Ratio's Year N-1 Ratio's Year N-2
Liquiditeit Liquidité Liduidity
Current Ratio
Beperkt Vlottende Activa / Actifs Circulants Restreints / Limited Current Assets /
Vreemd Vermogen op Korte Kermijn Dettes à Court Terme Short-term Liabilities
"Beperkte" Vlottende Activa Actifs Circulants "restreints" "Limited" Current Assets 0€ 0€ 0€
3 (*) voorraden en bestellingen in uitvoering stocks et commandes en cours d'excécution stock and contracts in progress
+ 40/41 vorderingen op ten hoogste één jaar créances à un an au plus amounts receivable within one year
+ 50/53 geldbeleggingen placements de trésorie Short-term investments
+ 54/58 liquide middelen valeurs disponibles Cash and cash equivalents
+ 490/1 overlopende rekeningen comptes de régularisation accruals and deferred income
Vreemd Verm. op Korte Termijn Dettes à Court Terme Short-term Liabilities 0€ 0€ 0€
42/48 schulden op ten hoogste één jaar dettes à un an au plus amounts payable within one year
+ 492/3 overlopende rekeningen comptes de régularisation accruals and deferred income
Solvabiliteit Solvabilité Solvency
Degree of financial Eigen Vermogen / Capitaux Propres / Equity /
independance Balanstotaal Total du Bilan Total Balance Sheet
Aangepast eigen vermogen Capitaux propres adaptés Adjusted shareholders' equity 0€ 0€ 0€
10/15 eigen vermogen capitaux propres equity
- 20 oprichtingskosten frais d'établissement formation expenses
- 21 immateriële vaste activa immobilisations incorporelles intangible assets
+ 170 achtergestelde leningen emprunts subordonnés subordinated debentures
Aangepast balanstotaal Total du bilan adapté Adjusted total balance sheet 0€ 0€ 0€
20/58 totaal der activa total de l'actif total assets
- 20 oprichtingskosten frais d'établissement formation expenses
- 21 immateriële vaste activa immobilisations incorporelles intangible assets
Rentabiliteit Rentabilité Efficiency
Efficiency Winst na Belastingen / Bénéfice de l'exercice / Profit after Taxes /
Eigen Vermogen Capitaux Propres Shareholders Equity
Winst na belastingen= Bénéfice de l'exercice profit after taxes 0€ 0€ 0€
70/67 of 67/70 winst of verlies na belastingen bénéfice/perte de l'exercice profit after taxes
Aangepast eigen vermogen= Capitaux propres adaptés Adjusted shareholders' equity 0€ 0€ 0€
10/15 eigen vermogen capitaux propres equity
- 20 oprichtingskosten frais d'établissement formation expenses
- 21 immateriële vaste activa immobilisations incorporelles intangible assets
