Risk Scoring for assets
Ngân sách ₹1500-12500 INR
We are planning to come up with Risk Scoring for assets based on the controls failures (Controls could be anything like policy compliance , Asset management controls etc), These controls carry a score from 1-100 & they are categorized as Critical(90-100), High(70-89), Medium(40-69) and low(1-39) based on the score.
also each asset has business criticality on the scale of 5 , 5 being the highest and there are some requirements as well for e.g. for an asset even if there just one failed critical control and if the asset criticality (acs) of that asset is 5 then the final score should be in the critical range(850-1000).
The data we get is number of failed controls in each category and the average score in each category. In the attached excel file first sheet is the requirements i.e. if the acs is 5 and there are critical controls then the risk score should be critical etc
second sheet shows sample data where score_sev* is aggregate score of that category and sev*_count is count of controls failed in that category for e.g. score_sev5 is aggregate score of severity 5 and sev5_count is count of failed controls in severity 5 category.
the Risk column is the required risk score for e.g. 4 means the score should be in critical range i.e. between 850-1000, Sheet 3 has feature priority we are planning to use.
we are considering number of counts also in feature priority for two reason.
1. if there are two assets one with 1 critical control and acs as 5 and another with 10 critical controls with acs 5 then as per requirement both will have score in critical range but we want the second asset to have score higher than the first.
2. When we want to show risk reduction, when we fix issues which are currently failing then we should be able to see the reduction in score because now the count of failed controls have reduced.
looking for an equation or some approach which will calculate score based on all these features . This is little time bound so immediate help would be appreciated.
16 freelancer chào giá trung bình₹7231 cho công việc này
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Thêm
Hi, I am an ENL writer, I speak and writer fluent English grammar. I have read your project requirements and I assure you that I have over 7 years of expertise in this sector. I also do high quality papers with no plag Thêm
It can be hard to stand out from the crowd, but follow these tips to write an attention-grabbing bid
i am fulfill your project. contact me i am fulfill your project. contact me i am fulfill your project. contact me i am fulfill your project. contact me i am fulfill your project. contact me i am fulfill your project. c Thêm
I've a experience in excel entry and CFA level1 candidate which equip me with finance background as well. Keen to learn and broadens my knowledge.
“I believe I am the best candidate for this position because I have direct experience in many areas mentioned in the job description, including customer service and project leadership. Also, I’m passionate about the so Thêm
I have a experience of 15years. I worked as a office administrator. I worked as a research assistant.
Self-Motivated in support line of business with 167years of expertise in customer service and Internal customer service and offshore implementation and support analyst. Support maintain and enhance the ERP application Thêm
Dear Sir, I would be happy to help you in your project, as I'm professional in Excel and complicated formulas, and have a very good knowledge in Risk calculations based on my work background in project managements and Thêm
Gran experiencia en tareas administtativas dentro de importantes empresas. Capacidad de aprendizaje frente a nuevos desafíos. Conocomientos acorde a mis estudios universitarios.
I am a CFO with 20+ years of experience. I have the experience of handling 1X to 5X turnover company with almost all quarters profitable, AH. I am also a part of sore management team in taking all major operational, f Thêm
Hello there, I will deliver this project before time with Value added to your project. I am professionally working as Excel expert for last 7+ years. Also, I will provide assistance after project till you will achieve Thêm