The file's text, extracted by GovTribe without its formatting.
CLIN 1 PM
| | | | | | | | | OFFERED PRICE | | | | TOTAL COST | | | |
| Item Code | Description | Object Class Code | | | HQ | Line total | PM Interval | Base Year cost (Euro) | OY1 Cost (EURO) | OY2 Cost (EURO) | OY3 Cost (EURO) | Base Year cost (Euro) | OY1 Cost (EURO) | OY2 Cost (EURO) | OY3 Cost (EURO) | OY4 Cost (EURO) |
| ADR | Contract management (monthly) | | | | | 1 | 12 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| BE | Gutters and Downspouts | | | | | 1 | 2 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| EB | Electronic Key Box | | | | | 2 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| EF | Distribution Panels, Electrical | | | | | 8 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| EH | Insect Light, UV | | | | | 1 | 2 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| EJ | Lightning Arrestor | | | | | 1 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| EK | Exit Lights (per store x) | | | | | 15 | 12 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| FB | Fire Extinguishers (portable & wheeled, DeCA owned only) | | | | | 5 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| GE | Ventilation System (stores after 2007) | | | | | 5 | 6 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| HD | Heating System | | | | | 2 | 4 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| HI | Split Unit Air Conditioning | | | | | 3 | 6 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| HL | Multisplit Unit Air Conditioning with up 4 inside units (includes indoor & outdoor units) | | | | | 2 | 6 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| LA | Lighting, Outside | | | | | 2 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| LD | Lighting, Interior (offices, bathrooms & technical rooms) | | | | | 3 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| ML | Ladders, All (stocking, etc. mobile only) | | | | | 8 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| SH | Dispensers, Various | | | | | 1 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| SN | Ice Maker | | | | | 1 | 4 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| SX | Water Heater, Electric | | | | | 2 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| TA | Kitchen Unit (including Appliances) | | | | | 3 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| TK | Electrical Isolation Test (mobile electrical devices, "E check" only, i.e. BGV A3) | | | | | 200 | 1 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| TO | Facility Walk Through (visual inspection) (record & report to store staff) | | | | | 1 | 4 | | | | | € 0 | € 0 | € 0 | € 0 | ERROR:#REF! |
| XX | Miscellaneous items for inventory variation | 1 | 1 | DeCA Fixed amount | | 1 | 0 | DeCA fixed amount | | | | € 1,500 | € 1,500 | € 1,500 | € 1,500 | € 1,500 |
| Total | € 1,500 | € 1,500 | € 1,500 | € 1,500 | ERROR:#REF! |
| Enter the cost to preform 1 PM check on one of the inventory items in the yellow cells | | | | | | |
| The Excel will calculate the annual cost, using number of items on inventory type and number of PM/year | | | | | | |
CLIN 2 UM-EM
| CLIN 2 UM/EM | | | | | | | | | |
| Work Hours | | | | | | offer total | | | |
| Euro/Hour | | | | | Labor | | | |
| Base | OY1 | OY2 | OY3 | Est of hours | Base | OY1 | OY2 | OY3 |
| Normal hours rate | | | | | 200 | 0 € | 0 € | 0 € | 0 € |
| After hours rate | | | | | 10 | 0 € | 0 € | 0 € | 0 € |
| Materials | Per Cent | | | | | Materials | | | |
| Base | OY1 | OY2 | OY3 | Est of material | Base | OY1 | OY2 | OY3 |
| Handling rate | | | | | 10,000 € | 10,000.00 € | 10,000.00 € | 10,000.00 € | 10,000.00 € |
| Enter as whole number (10 for 10%) | | | | | | | | |
UM/EM total 10,000.00 € 10,000.00 € 10,000.00 € 10,000.00 €
| Enter hourly rates for normal work hours in row 7 |
| Enter hourly rates for after hours work in row 8 |
| Enter material handling rate in row 12, use whole number % |
| All white cells will |
CLIN 3 RBR
Values are DeCA estimate
| Repair by Replacement | Base | OY1 | OY2 | OY3 |
| DeCA estimate | 3,000.00 € | 3,000.00 € | 3,000.00 € | 3,000.00 € |
Summary
| Summary |
| All values are imported from other tabs |
| CLIN 1 PM | | | | | | | PM | | | |
| | | | | | | Base | OY1 | OY2 | OY3 |
| From other tab | | | | | | | 1,500.00 € | 1,500.00 € | 1,500.00 € | 1,500.00 € |
| CLIN 2 UM/EM | | | | | | | | | | |
| Work Hours | | | | | | | offer total | | | |
| Euro/Hour | | | | | | Labor | | | |
| Base | OY1 | OY2 | OY3 | OY4 | Est of hours | Base | OY1 | OY2 | OY3 |
| Normal hours rate | 0 | 0 | 0 | 0 | ERROR:#REF! | 200 | 0 € | 0 € | 0 € | 0 € |
| After hours rate | 0 | 0 | 0 | 0 | ERROR:#REF! | 10 | 0 € | 0 € | 0 € | 0 € |
| Materials | Per Cent | | | | | | Materials | | | |
| Base | OY1 | OY2 | OY3 | OY4 | Est of material | Base | OY1 | OY2 | OY3 |
| Handling rate | 0 | 0 | 0 | 0 | ERROR:#REF! | 10,000 € | 10,000.00 € | 10,300.00 € | 10,609.00 € | 10,927.27 € |
UM/EM total 10,000.00 € 10,300.00 € 10,609.00 € 10,927.27 €
| Optional CLINS | | | | |
| Repair by Replacement | Base | OY1 | OY2 | OY3 |
| DeCA estimate | 3,000.00 € | 3,000.00 € | 3,000.00 € | 3,000.00 € |
| Base | OY1 | OY2 | OY3 |
| Contract total | 14,500.00 € | 14,800.00 € | 15,109.00 € | 15,427.27 € |
| Total | 59,836.27 € |
| 64,319.33 € |
| Make no entries here |
| All values are from other tabs |