Develop a Quantitative Strategic Planning Matrix for your company.
You need to know how a QSPM works.
The company is Office Depot.
Everything is provided. You will essentially just be assigning an attractive score. From there the TAS will automatically be filled through the formula.
The answer should simply be a table or spreadsheet. I have provided all other information.
I have provided what the final table should look like. Final product should look exactly like these tables, but with the AS and TAS filled in with numbers. All strengths, weaknesses, opportunities and threats must stay.
Your main task is to assign the attraciveness scores based on improving the company and the strategies.
Step 1: You will need to choose the two strategies for top row of the QPSM. The options for the first strategy is either 1. Increase online and curbside promotional offers to increase total sales or 2. Expanding physical and mobile stores internationally. (CHOOSE ONLY 1).
The second strategy is automatically “Prophlatically close stores and redirect revenue to online retail.”
Step 2: The weights I’ve already provided for each. Use weights I provided in the example tables.
Step 3: Most important step. DETERMINE THE ATTRACTIVENESS SCORES (AS), defined as numerical values that indicate the relative attractiveness of each strategy considering a single external or internal factor. Attractiveness Scores (AS) are determined by examining each key external or internal factor, one at a time, and asking the question, “Does this factor affect the choice of strategies being made?” If the answer to this question is yes, then the strategies should be compared relative to that key factor. Specifically, AS should be assigned to each strategy to indicate the relative attractiveness of one strategy over others, considering the particular factor. The range for AS is 1 = not attractive, 2 = somewhat attractive, 3 = reasonably attractive, and 4 = highly attractive. By “attractive,” we mean the extent that one strategy, compared to others, enables the firm to either capitalize on the strength, improve on the weakness, exploit the opportunity, or avoid the threat. Work row by row in developing a QSPM. If the answer to the previous question is no, indicating the respective key factor has no effect on the specific choice being made, then do not assign AS to the strategies in that set. Use a dash (or 0 if using the template) to indicate that the key factor does not affect the choice being made. Note: If you assign an AS score to one strategy, then assign an AS score(s) to the other—in other words, if one strategy receives a dash (or 0)—then all others must receive a dash (or 0) in a given row.
Step 4: With the use of a simple formula in the tabel The TAS should be calculated by multiplying the weight by the AS
Step 5: COMPUTE THE SUM TOTAL ATTRACTIVENESS SCORE. Add TAS in each strategy column of the QSPM. The Sum Total Attractiveness Scores (STAS) reveal which strategy is most attractive in each set of alternatives. Higher scores indicate more attractive strategies, considering all the relevant external and internal factors that could affect the strategic decisions. The magnitude of the difference between the STAS in a given set of strategic alternatives indicates the relative desirability of one strategy over another.
If a particular factor affects one strategy, but not the other, it affects the choice being made, so AS scores should be recorded for both strategies. Never rate one strategy and not the other. Note also in table 6-5 that there are no consecutive 1s, 2s, 3s, or 4s across any row in a QSPM; never assign the same AS score across a row. Always prepare a QSPM working row by row. Also, if you have more than four strategies in the QSPM, then let the AS scores range from 1 to “the number of strategies being evaluated.” This will enable you to have a different AS score for each strategy. These are all important guidelines to follow in developing a QSPM.
FYI the #REF on the table screenshot should be “Experienced workforce”
