Risk Register: risks in the sales process (in excel templet)

Risk Identification/ Categorization

The present situation in a company is given what could be a cause for risk to take place

1. What risk can this situation cause?

2. What kind of effect will this risk have on a company?

3. What Risk type it is( Strategic, Tactical, Operational, Information, Reputation, Ethical )

4. What Risk Category it falls under Generic / strategic risks, Operational risks, Financial risks, GRC Risks or other

5. Which department or person in a company would be a risk owner

6. Hypothetically how often that could happen if the company owns 20 stores and has 20000 customers

Risk Log Risk Log steps week 3 Risk Identification/ Categorization Risk Assessment week 4 Class / Team Create date qualitative / quantitative analysis accept/ avoidance/controlling/transfer/ watch and monitor qualitative / quantitative analysis week 5 Last Change Date week 6 Risk management BPM To Be business processes Presentation/Exec Summary week 7 20 stores, 20000 customers can cause the risk: Present situation / Cause Risks which will have the Effects Risk_ID Risk Category Risk Owner (Department) Frequency, expected (Happens on average every X year or Y times a year) Sales contract process 00001 Using old profitability templates Cost spreadsheets are not 00002 automatically updated 00003 Cost prices are inflated A sales representative's 00004 assessment determines the risk profile. No formal creditworthiness 00005 assessment There aren't many rules when it 00006) comes to discounting. Each customer has a random set 00007 of conditions. Changes have to be made 00008 manually Risk_ID can cause the risk: Present situation / Cause Risks which will have the Effects Risk Category Risk Owner (Department) Frequency, expected (Happens on average every X year or Y times a year) Sales order process Stock levels are unknown when 000091 receiving an order Not knowing what other clients 00010 have already ordered/history of previous orders 00011 When taking an order, failing to check the client's credit limit Over the phone, a seles 00012 representative placed the order into the system manual. Sales order preparation and delivery Pickers discover that certain 00013 things requested are out of stock. When there is no replacement item, they often call the 00014 consumer and figure out a solution. Risk_ID can cause the risk: Present situation / Cause Risks which will have the Effects Risk Category Risk Owner (Department) Frequency, expected (Happens on average every X year or Y times a year) Invoicing process The financial condition of the 00015 majority of consumers is unclear. Payment terms and credit limits are determined by a customer's 00016 interaction with sales representatives. The invoice may contain 00017 numerous deliveries A single invoice cannot be 00018 generated automatically by the current ERP system. Someone in accounting has to 00019 consolidate all deliveries into a single invoice manually