ࡱ> BE  !"#$%&'()*+,-./0123456789:;<=>?@ADRoot Entry Fr4zCWorkbook~SummaryInformation(DocumentSummaryInformation8 ZO\pSymons, Jessica Ba==J$8X@"1Arial1Arial1Arial1Arial1QTahoma1QTahoma1Arial1Arial1Arial1Arial15Calibri1 5Calibri15Calibri145Calibri1 5Calibri15Calibri15Arial15Calibri1,85Calibri185Calibri185Calibri1 5Arial1>5Calibri145Calibri1<5Calibri1?5Calibri1h85Cambria15Calibri1 5Calibri15Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.0 ""#,##0.00 ""#,##0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + ) , *      P  P         `            a>        "   (@ @   (@@   (@   ( @   (@@   ( @   (@   (   (   (@   (@   (   (@ @   (@  (@@  (@  "8  "8  (@   ,   , "8@ @  "8@ @  "<@ @  "<@ @   (@  "8@  "8@   , @  "<@ @    "<@ @ "8@@ "8@ "8 @ "8@ @  "<@@  "<@  "< @  "8@ @  "<@  "<  "< @  "<@ @  "<  "<@  "< @  "<@ @  "<@@  "<@  "8  "8@@  "8 @  "<@@  "<@  "<@ @  "  "  "  " ||3*g}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}/ 00_)}(}0  00_)}A}1 a00_)[$ -}A}2 00_)[$ -}A}3 00_)?[$ -}A}4 00_)23[$ -}-}5 00_)}(}6  00_)}}7 ??v00_)̙[$ -##0.  }A}8 }00_)[$ -}A}9 e00_)[$ -}x}:00_)[$##  }}; ???00_)[$???## ???  ??? ???}-}= 00_)}U}> 00_)[$## }-}? 00_)}(}a 00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 F Followed Hyperlink   1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%64 Hyperlink   7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`G Tender Result,5fvf`@@jb(1)k3  @@  /*CriteriaScore*Quality points as a % of the highest scoreQuality Scores Price ScoresTotal tender price!Price point (lowest/actual x 100)Overall Scores Overall scoreOrder of tendersTotalsDecide upon criteraQGive each criteria a weighting dependent upon level of importance (see (a) below)dGive each supplier a score for each criteria dependent upon your view of their offer (see (b) below)>Calculate the weighted score for each supplier (see [c] below)QGive the supplier with the highest score a "points" figure of 100 (see (d) below)1List the different prices offered (see (f) below)QGive the supplier with the highest score a "points" figure of 100 (see (g) below)!Quality score x quality weightingPrice score x price weighting 0Calculate weighted quality score (see (i) below).Calculate weighted price score (see (j) below)YAdd together total weighted quality score plus total weighted price score (see (k) below)3Highest score is the winning offer (see (l) below) XCalculate the scores for the other suppliers as a % of the highest score (see (e) below)XCalculate the scores for the other suppliers as a % of the highest score (see (h) below)Quality (40% weighting)Price (60% weighting)Gwalia1st 2ndpart c)Pass1stPresentation & Interview Provider A Provider B Provider CPQQWritten QuestionsExample Tender - Scoring Matrix3rd2p3 45Ho7 w88|cc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vނβ5qx\P s6*+FC]\dzS\1 f˜!(B: Q}qCZ2 %u?E+zo^ͫɛW/_/hyB'~oӯ>O~ߌWu?/f fJ__ꏿ?iߗ0ç,OȱHQ7k_r:o7cf@Ht_o ogG'$ 8?NRx(hdžWE73:ഉ2ϵEU JÄzbq44o>d̳! Pbɇ 5df^ &=d)e٤3ڳ32Iz#1!7?3XhHHN!u?4 9Yʰ))dQUPDnx ۍ*{ڒю!pUf;w a6B][ۊfǭR٘j8XY;Zy5wtuH%GFuXYS/Z[א}nWqR]g{2W^Bjӑg9݀9n14cаE^ jRc0`R}ڈ{-JXh*'ItFf|!oB[ kO~q.~(fqnx@QnM U2طx[VWŦ5R3UzG;@ɔ~ NV@MNN@]J@]K@  aMKKKKKMN]] D EEED'Eb@"DDDD!F`@ DD!Y`@ DD! Y@`@ D D MKKKKKMN]] MKKKK%VY@&DDdD%_Y@&DDd%[Y@&DDd% `|X@ D DdMKKKKVMW]] U KKKKVMW]] BRX*bbbT^ 6!6"6#6$6%6&6'6(6)6*6 MKKKKKMN]] !D !EEF~ !x@!y~ !z A!z!b AbL A ! }| !}| !}| !}| "C "CCC%"gr@'D!D!d"h%"qY@'D!D!d"r%"`]tEW@'D!D!d%" `U@' D!D! d " ~~ "~~ "~~ "~~#MKKKKKKN]] $U$KKKKKKN]] %MKKKKKKN]] &O &OGH &sD@) D(&t &mD@) D(&n &ZD@ D( & `&lC@" D ( & || &|| &|| &|| 'P 'PIJ 'kf@) D"<'l 'oN@ D"<'p '`.L@" D"< ' `@J@) D" < ' {{ '{{ '{{ '{{(MKKKKKKN]] )D )EEF#)gk@" %&(,/)h#)iY@kE %&(,/)j!)`E]tQX@ D&D'!) `dM6V@ D& D'  ) {{ ){{ ){{ ){{ *D *EEF *c*d *e!*f *X * X) * || *|| *|| *||*j (   x  6y*XPP?  |$)]4@  IM7]t <(f) <  xx  6y*XPP? ) ]4@ 9jIXG&SX <(f) < xx  6y*XPP? (|+]4@ Ae4OͫSX <(k) <  xx  6аy*XPP? ! %S]4@ }YJDX <(k) < xx  6y*XPP? )|-)]4@ kJ @(&3 |X <(l) <  tixx  6y*XPP? " &c]4@ Sitq@^_(axX <(l) <  ?xx & 6y*XPP? !|%S]4&@ 蚤QnIyX 8<9(g) best price is given 100 points; lowest/actual x 100 <7 8 xx ' 6@y*XPP?  ]4'@ FK:G:X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 xx ) 6y*XPP? %|(]4)@ ifJAYX 8<9(i) quality score of ?? x 40% overall quality weighting <7 8xx * 6y*XPP?  "]4*@ `TOFE X 8<9(i) quality score of ?? x 40% overall quality weighting <.7 8xx , 6y*XPP? &|*]4,@ 3XG \;AX 8<9(g) best price is given 100 points; lowest/actual x 100 <7 8 xx - 6 y*XPP?  2 $S]4-@ 9^@Kf X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 xx h 6y*XPP? & U*]4h@ X-^Ccy X 8<9(g) best price is given 100 points; lowest/actual x 100 <37 8 !rmalcolm!rmalcolm"&rmalcolm"'rmalcolm&)rmalcolm&*rmalcolm',rmalcolm'-rmalcolm'hrmalcolm)rmalcolm)rmalcolm*rmalcolm*rmalcolm>@lcjc! !!  R***!!""&&''))**!!""&&''))** !!""&&''))** !! "" && '' )) """"&&!!!!****))))''&&''7ggD  Oh+'0HPd|  rmalcolmSymons, JessicaMicrosoft Excel@5gf@<@}M4z ՜.+,0 PX|  Vale of Glamorgan Council Tender Result  Worksheets F Microsoft Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObj l