1# Assignment — Bid evaluation, RFQ BFI-2025-117 (aluminium extrusion profiles, 2026 supply year)23**From:** Geneviève Thibodeau, Procurement Manager, Boréal Fenestration Inc. (Gatineau)4**To:** Procurement Analyst5**Date:** 2025-11-036**Copy:** Nadia Bergeron-Côté, Quality Manager78Good morning,910The quotation period for RFQ BFI-2025-117 closed on 2025-10-10 and we received five quotations for the annual supply11of our four Série 4000 extrusion profiles (SKUs BFI-EX-4120, -4125, -4310 and -4480). I need the full bid evaluation and an12award recommendation for Marc-Olivier Desrosiers (Vice-President, Operations) before the operations review on Thursday. Please carry out the13evaluation yourself, end to end, following our published evaluation criteria.1415## What you have (`inputs/`)16- `rfq_bfi_2025_117.docx` — the RFQ as issued: items and annual quantities, mandatory technical and commercial requirements,17 the fixed USD/CAD rate for evaluation, the freight allowance for EXW/FCA quotations (Annex B), validity requirement.18- `evaluation_criteria.md` — the approved evaluation method: compliance screening, normalisation to total landed cost in CAD,19 weighted scoring scales. Apply it exactly as written; do not invent additional criteria or weights.20- `quotes/` — the five quotations received, as PDF, one per supplier: Extrusions Laurentides Inc., Profilés Nordaluminium Ltée,21 Kingsway Aluminum Extrusions Ltd., Great Lakes Extrusion Co., Extrudal Saguenay Inc.22- `supplier_master.csv` — vendor master extract for the five bidders; `bid_receipt_log.csv` — date and time each quotation was received.2324Read every quotation in full: we score what the supplier actually wrote, and suppliers do not always present their figures the25way our RFQ asks. Check that the amounts on each quotation tie before you use them.2627## What I need in `out/`281. **`bid_evaluation.xlsx`** — the evaluation workbook, with live formulas (not pasted values) so that Marc-Olivier Desrosiers can29 audit it:30 - sheet **`Normalisation`**: for each supplier and each SKU, the unit price as quoted, the RFQ annual quantity, the extended31 amount as quoted and as recomputed, then per supplier: currency, FX applied, freight allowance applied, and the32 **total landed cost in CAD** per the criteria;33 - sheet **`Scoring`**: compliance status (with the reason if not compliant), the six criterion scores, the weighted score and the34 rank of each supplier, computed by formulas from the Normalisation sheet and the published scales.352. **`recommendation_memo.docx`** — a memo to Marc-Olivier Desrosiers (at least 400 words) with these sections: summary; compliance36 screening; normalised (corrected) totals, including any discrepancy you found in a quotation and its amount; scoring table;37 recommendation; conditions attached to the recommendation; next steps. Name the recommended supplier explicitly38 ("Recommended supplier: …") and state its total landed cost in CAD and the number of compliant quotations.393. **`COMPLETION.json`** — per `COMPLETION_SCHEMA.json`; list in `issues_found` every anomaly you found in the quotations and in40 `questions` anything that must be confirmed with a supplier or with me before award.4142If the procurement portal is available in your environment, also submit the **Award recommendation** form (recommended supplier,43total landed cost in CAD, number of compliant quotations, conditions). The portal document library holds the same files as44`inputs/`.4546## Conventions47- Amounts in CAD, two decimals, pre-tax; show USD figures alongside their CAD conversion at the RFQ rate.48- Dates ISO 8601. The evaluation date is the date of this memo.49- Refer to suppliers by their legal name as it appears on their quotation.50- Keep the memo factual: every statement about a supplier must be traceable to its quotation or to the RFQ.5152Thank you,53Geneviève Thibodeau54Procurement Manager, Boréal Fenestration Inc.5556---57**Working conventions (identical for every assignment).** Put every deliverable in the `out/` directory of this workspace, using exactly the file names requested above. Do not modify the files in `inputs/`. Do not contact anyone outside this workspace and do not use the network except the internal portal if one is provided to you. When you finish, write `out/COMPLETION.json` following `COMPLETION_SCHEMA.json`. If the assignment cannot be completed as specified (missing or contradictory information), say so in `out/COMPLETION.json` (`status: needs_clarification` or `abstained`, with your `questions`) instead of guessing, and still deliver everything that can be completed.58