Complete the "Problem Solutions Matrix" spreadsheet using the data and information you collected...

Question

Complete the "Problem Solutions Matrix" spreadsheet using the data and information you collected through research and completion of the Stakeholder Analysis in Topics 2 and 3. In the Solution Design Matrix tab, you will address the solutions previously implemented and compare to the new proposed problem solution for addressing the problem within your organization. Be sure to consider the "Solutions Score" column number when documenting the solutions. Review how to score your solution in the directions on the spreadsheet.

When scoring your solutions, you must also consider the timeline for implementation, costs and benefits to key stakeholders and the greater good, potential roadblocks to implementation, and how you will measure and validate whether a solution is successful in addressing the problem. After all of these have been considered and the solutions have been scored, identify the top three most viable solutions and transfer them to the "Problems Solutions Matrix" Part 2 tab. You will then provide specific resources and data to support the problem-solving strategy and identify the best solution strategy as indicated in the spreadsheet.

bus-470-rs-problemsolutionsmatrix-2-kew5tjti.xlsx benchmark-data-collection-ljeb3uiz.doc stakeholder-analysis-fwwef1qi.doc

Shubham · Accepted Answer

Solutions Design Matrix
	Problem Solutions Matrix
	Directions:  You will use this matrix to record previous attempts to address the problem and proposed problem solutions. Complete the columns on the matrix as directed. For the "Previous Problem Solution/Proposed Problem Solution" column, include a detailed description of the solution, including the source of the solution. In the case of a previous solution, the source could be a manager interview, while the source for a proposed solution could be a link to an online reference article or resource.  All other columns must rank the specified element as it relates to the solution using a 1, 3, or 5, with 5 being the highest ranking. Note that the "Customer Importance" column is weighted at twice the value of the other categories, since the impact of a solution on customers if of utmost importance. For example, if the solution was very important to the customer experience, it would earn a 5.  If that same solution was only a 1 in efficiency and quality, then a 1 would be used in those two columns. If employees were somewhat satisfied with the solution and it was in the middle in terms of cost effectiveness, then both of those columns would be ranked as a 3. When calculated, the overall solution score would be 18. This number could then be used to compare the solution to others as a means of determining whether or not it should receive further consideration for implementation as a problem solving strategy. 
		Customer Importance	Efficiency	Quality	Employee Satisfaction	Cost Effectiveness	Solutions Score
	Previous Problem Solution	Rank each items as a 1, 3, or 5 with 5 as highest ranking.                                                                                       Note: Customer Importance is weighted more heavily than other categories.
	Increasing the duration and quality of training programs for call center representatives	4	2	3	3	2	14
	Providing access to updated online tools	1	1	1	3	3	9
	Creating a supportive work environment	3	4	3	4	2	16
	Hiring additional staff	4	4	5	3	1	17
	Conducting regular quality audits and assessments	3	2	3	2	3	13
	Proposed Problem Solution	Rank each items as a 1, 3,

Complete the "Problem Solutions Matrix" spreadsheet using the data and information you collected through research and completion of the Stakeholder Analysis in Topics 2 and 3. In the Solution Design...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment