二쇱떇 臾쇳?湲?怨꾩궛湲?& ?됰떒媛 怨꾩궛湲??꾨꼍 媛?대뱶 (移댁뭅?ㅒ룹궪?깆쟾?먃룹퐫???꾨꼍 ???
移댁뭅?? ?쇱꽦?꾩옄, SK?섏씠?됱뒪 ??援?궡 ??뺤＜遺??誘멸뎅 二쇱떇(?뚯뒳?? ?붾퉬?붿븘), 媛?곸옄??鍮꾪듃肄붿씤)源뚯? 紐⑤뱺 醫낅ぉ??臾쇳?湲??쒕??덉씠?섏쓣 1珥?留뚯뿉 臾대즺濡??쒓났?⑸땲?? 蹂?怨꾩궛湲곕뒗 ?뱀젙 醫낅ぉ ?꾩슜???꾨땲硫? ?ъ옄?먭? 蹂댁쑀???꾩옱 ?됰떒媛? ?섎웾, 異붽? 留ㅼ닔 媛寃⑹쓣 ?낅젰?섎㈃ 蹂寃쎈릺??理쒖쥌 ?됰떒媛? 蹂몄쟾 ?덉텧 紐⑺몴媛瑜??ㅼ떆媛꾩쑝濡?怨꾩궛??二쇰뒗 ?ㅻ쭏????뚰겕 ?꾧뎄?낅땲??
?뱦 二쇱떇 臾쇳?湲?怨꾩궛湲?3?④퀎 ?쒖슜踰?
- 1?④퀎: ?꾩옱 蹂댁쑀 ?뺣낫 ?낅젰 - 移댁뭅?? ?쇱꽦?꾩옄 ??蹂댁쑀 以묒씤 二쇱떇???됯퇏 留ㅼ닔?④?(?됰떒媛)? 蹂댁쑀 ?섎웾???낅젰?⑸땲?? (?됰떒媛瑜?紐⑤Ⅸ?ㅻ㈃ ?곷떒 '?쨺 ?됰떒媛瑜?紐⑤Ⅸ?ㅻ㈃? (遺꾪븷留ㅼ닔 ?⑹궛)' 踰꾪듉 ?대┃)
- 2?④퀎: 異붽? 留ㅼ닔 ?뺣낫 ?낅젰 - ?꾩옱 ?쒖옣媛 ?먮뒗 紐⑺몴?섎뒗 異붽? 留ㅼ닔媛寃?/strong>怨?留ㅼ닔 ?섎웾(?먮뒗 異붽? ?ъ옄湲덉븸)???낅젰?⑸땲?? 醫낅ぉ 寃?됱갹???댁슜?섎㈃ ?ㅼ떆媛??쒖꽭媛 1珥?留뚯뿉 ?먮룞 ?곸슜?⑸땲??
- 3?④퀎: 寃곌낵 ?뺤씤 諛?蹂몄쟾 ?덉텧 ?쒕??덉씠??/strong> - ?덈줈 ??븘吏?理쒖쥌 ?⑹궛 ?됰떒媛, ?먭툑 ?뚮났 ?꾩슂 諛섎벑瑜?%), 洹몃━怨??④퀎蹂?諛섎벑 ???덉긽 ?먯씡???쒓컖??寃뚯씠吏 諛붿? ?쒕줈 ?뺤씤?⑸땲??
?㎜ 臾쇳?湲??됰떒媛 怨꾩궛 怨듭떇
?섑븰???됯퇏?④? ?곗텧 怨듭떇:
理쒖쥌 ?됰떒媛 = (湲곗〈 珥?留ㅼ닔湲덉븸 + 異붽? 留ㅼ닔湲덉븸) 첨 (湲곗〈 蹂댁쑀?섎웾 + 異붽? 留ㅼ닔?섎웾)
* 蹂몄쟾 ?덉텧 ?꾩슂 諛섎벑瑜?%) = ((理쒖쥌 ?됰떒媛 - ?꾩옱 二쇨?) 첨 ?꾩옱 二쇨?) 횞 100
?좑툘 臾쇳?湲?吏꾪뻾 ??二쇱쓽?ы빆 諛?遺꾪븷 留ㅼ닔 ?먯튃
- ?섎씫 異붿꽭 吏????鍮꾩쨷 怨쇰떎 二쇱쓽: 臾쇳?湲곕뒗 ?됰떒媛瑜???떠 ?덉텧???욌떦湲곗?留? 湲곗뾽 ?ㅼ쟻 ?낇솕濡??섎씫??吏?띾릺硫??먯떎 珥앹븸??湲됯꺽??遺덉뼱?⑸땲?? 泥좎????ъ쑀 ?먭툑 ?댁뿉?쒕쭔 ?댁슜?댁빞 ?⑸땲??
- ?좎슜?듭옄 諛?誘몄닔湲??덈? 湲덉?: 諛섎?留ㅻℓ(媛뺤젣 泥?궛) ?꾪뿕???덈뒗 ?덈쾭由ъ????섎씫?μ뿉??移섎챸?곸엯?덈떎. 諛섎뱶???꾧툑?쇰줈留?吏꾪뻾?섏꽭??
- ?쇰낫?섏튂 吏吏??遺꾪븷 留ㅼ닔(1:2:3 鍮꾩쑉): ?쇱떆?????먭툑???ｌ? 留먭퀬, 二쇱슂 吏吏?좊쭏??鍮꾩쨷???섎젮媛??遺꾪븷 留ㅼ닔瑜??곸슜?댁빞 媛???④낵?곸쑝濡??됰떒媛瑜???텧 ???덉뒿?덈떎.
?뱤 二쇱떇 臾쇳?湲?怨꾩궛湲??묒? ?⑥닔 諛??섏떇 ?꾨꼍 媛?대뱶
?묒?(Excel)?대굹 援ш? ?ㅽ봽?덈뱶?쒗듃?먯꽌 吏곸젒 臾쇳?湲?怨꾩궛湲곕? 援ы쁽?????ъ슜?섎뒗 ?쒖? ?섏떇怨??묒? ?⑥닔?낅땲?? ?곷떒??[?뱤 ?묒? 怨꾩궛???ㅼ슫濡쒕뱶 (.xlsx)] 踰꾪듉???꾨Ⅴ硫??꾨옒 ?섏떇??100% ?먮룞 ?낅젰???묒? ?뚯씪??利됱떆 臾대즺濡??ㅼ슫濡쒕뱶諛쏆븘 ?됰떒媛 愿由??쇱?濡??쒖슜?섏떎 ???덉뒿?덈떎.
- 2??遺꾪븷 留ㅼ닔 湲곕낯 ?됰떒媛 ?묒? ?섏떇:
=(B2*C2 + B3*C3) / (C2+C3)(B?? 留ㅼ닔?④?, C?? 蹂댁쑀?섎웾) - ?ㅽ쉶李?臾댄븳) 遺꾪븷 留ㅼ닔 ?묒? ?⑥닔:
=SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)(SUMPRODUCT ?⑥닔濡?媛以묓룊洹??④? 利됱떆 ?곗텧) - ?먭툑 ?뚮났 蹂몄쟾 ?덉텧 紐⑺몴 諛섎벑瑜??섏떇:
=(?좉퇋?됰떒媛 - ?꾩옱媛) / ?꾩옱媛 * 100
?뮕 二쇱떇 臾쇳?湲?怨꾩궛湲?臾대즺 ?뱀빋 & ?⑹뼱 珥앹젙由?
'臾쇳?湲?? 二쇨?媛 ?섎씫?덉쓣 ??異붽? 留ㅼ닔瑜??듯빐 ?꾩껜 蹂댁쑀 二쇱떇???됯퇏?④?瑜???텛?? ?ъ옄 湲곕쾿?낅땲?? ?④?媛 ??븘吏硫??먯씡遺꾧린???꾨떖???꾩슂??諛섎벑??씠 ?덈컲 ?댄븯濡?以꾩뼱??땲??
?깆뒪?좎뼱 ?ㅼ튂 ?놁씠 ?ㅻ쭏?명룿 釉뚮씪?곗? 硫붾돱??[???붾㈃?? 異붽?]瑜??꾨Ⅴ硫?1珥?留뚯뿉 ?ㅻ쭏?명룿 ?깆쑝濡??ㅼ튂?섏뼱 ?몄젣??愿묎퀬 ?놁씠 臾대즺濡?諛붾줈 ?ㅽ뻾?⑸땲??