Chat with us, powered by LiveChat The Quantitative Strategic Plan Matrix (QSPM) is a high-level strategic management approach for evaluating possible strategies. This Matrix provides an analytical method fo - Writingforyou

The Quantitative Strategic Plan Matrix (QSPM) is a high-level strategic management approach for evaluating possible strategies. This Matrix provides an analytical method fo

Instructions for Part 6 are attached

The Quantitative Strategic Plan Matrix (QSPM) is a high-level strategic management approach for evaluating possible strategies. This Matrix provides an analytical method for comparing feasible alternative actions. Further, it helps the organization prioritize the strategies that they would like to pursue. You are required to write a one-page narrative with scholarly sources regarding your thoughts and definition of conducting a quantitative strategic plan matrix.

List the organization’s internal and external key factors, which are from your IFE and EFE matrices. The two strategies described in Part 5 should be evaluated based on the IFE and EFE matrices, as this requires subjective decisions by the student. 

Use the two strategies from Part 5 to analyze and determine the attractiveness score (AS). This defines how the factors influence the strategy and can give vital information for any organization when making high-level decisions between strategies. You will assign the weight for each of these key factors, which are identical from the IFE and EFE matrices. The internal factors must equal 1.00 and the external factors must equal 1.00.  The range is determined on a Likert scale of 0 to 4: 0=not relevant, 1= least attractive, 2=possibly attractive, 3=reasonably attractive, 4=highly attractive. Then multiply the weight times the attractiveness score (AS) to obtain the total attractiveness score (TAS). Based on the two strategies, the score that is higher would be more attractive as a strategic alternative or critical factor for the organizational leaders to choose that strategy over the other.  This also involves reflection and evaluation.

Once you have determined your selected strategy, based on total attractiveness scores, write a narrative why you feel this selection (with high TAS) would be beneficial to your organization as well as other stakeholders, community, etc. However, explain why the second alternative (with low TAS) could also be beneficial. Not all business models, surveys, spreadsheets, are 100% valid or reliable. Based on your expert opinion, describe which strategy is more important.

In addition to submitting , please upload your QSPM Excel spreadsheet for Part 6.

Review SRP current template for additional guidelines regarding the requirement of page length and number of scholarly current sources for this Part.

 

Read ME

START

Free Excel Student Template
Dear Student,
By using this Template, you hereby agree to the Copyright terms and conditions. This Template should save you considerable time and allow for your presentation to be more professional. Do not mistake this Template for doing all of the work. Your assignment is to analyze and present strategies for the next three years. You will still need to do the research and enter key internal and external information into the Template. The Template does not gather or prioritize information. It does however assimilate information you enter in a professional way and does many calculations for you once that critical information is entered. Best of luck, with your project.
INSTRUCTIONS FOR TEMPLATE
1 Please read all Template instructions below carefully before you start each new section of this Template. Only type in the green boxes unless otherwise noted. Please read the Read ME tab at the bottom of Excel before you start.
INSTRUCTIONS FOR EXTERNAL AUDIT
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1. To perform an External Audit, enter ten opportunities and ten threats. For purposes of this Template, it is vital you have ten of each, no more, no less.
2. After entering ten opportunities and ten threats, enter the weight you want to assign to each factor. Be sure to check the bottom of the "Enter Weight Below" column, to make sure your entire column sums is equal to 1.00
3. After entering in the weights, then enter in a corresponding rating in the "Enter Rating Below" column. The coding scheme is provided below.
1 = "company's response to the external factor is poor"
2 = "company's response to the external factor is average"
3 = "company's response to the external factor is above average"
4 = "company's response to the external factor is superior"
Enter Weight Below Enter Rating Below
Enter Ten Opportunities Below
1. International Labor 0.06 2
2. Strong Economy 0.04 3
3. Acquisition 0.03 1 EFE Matrix
4. Reduced Foreign Manufacturing 0.02 4
5. Electric Vehicles 0.05 3
6. Autonomous Vehicles 0.05 3
7. Domestic Investments 0.04 4
8. Flex Fuels 0.02 2
9. Government Investment 0.01 2
10. Strong Reputation 0.03 2
Enter Ten Threats Below Enter Weight Below Enter Rating Below
1. Ride Sharing 0.06 1
2. Poor Economy 0.04 3
3. Strong Competition 0.30 2
4. Poor Reputation 0.05 2
5. Leadership 0.03 3
6. Technology Changes 0.04 3
7. Carbon Footprint 0.03 1
8. Foreign Financial Markets 0.02 2
9. Changing Market Share 0.03 1
10. Product Development 0.05 3
1.00
Instructions for Competitive Profile Matrix (CPM)
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1. To perform the CPM, enter in twelve critical success factors. You may use some of the ones listed below if you like but try to use ones that are more pertinent to your company. For example, if your case is Delta Airlines, having a) on time arrival b) extra fees c) frequent flyer points, etc may be better choices than the canned ones below. For purposes of this Template, it is vital you have twelve factors no more, no less.
2. After entering in twelve critical success factors, enter in the weight you want to assign each one. Be sure to check the bottom of the "Enter Weight Below" column, to make sure your sum weight is equal to 1.00
3. After entering in your weights, type the name of your company and two other competitors in the corresponding boxes.
4. After entering in the weights and identifying your company and two rival firms, then enter in a corresponding rating in the "Enter Rating Below" column for each organization. DO NOT ASSIGN THE COMPANIES THE SAME RATING, TAKE A STAND, MAKE A CHOICE. The coding scheme is provided below.
Enter Rating Below Enter Rating Below Enter Rating Below
CPM Matrix Enter Weight Below General Motors Ford Fiat/Chrysler
Advertising 0.07 1 3 4
Added Product Features 0.05 4 2 1
Customer Service 0.08 3 3 4
Store Locations 0.03 3 4 3
Variety of Products 0.07 3 2 4
Skilled Workforce 0.13 4 4 1
Brand Recognition 0.09 4 3 4
Customer Loyalty 0.07 2 3 2
Market Share 0.12 4 3 1
Product Quality 0.17 4 3 3
Global Expansion 0.06 2 2 3
Price Competitiveness 0.06 3 2 3
1.00
1 = "major weaknesses"
2 = "minor weaknesses"
3 = "minor strength"
4 = "major strength"
INSTRUCTIONS FOR INTERNAL AUDIT
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1. To perform an Internal Audit, enter in ten strengths and ten weaknesses For purposes of this Template, it is vital you have ten of each, no more, no less.
2. After entering in ten strengths and ten weaknesses scroll down the page and enter in the weight you want to assign each one. Be sure to check the bottom of the "Enter Weight Below" column, to make sure your sum weight is equal to 1.00
3. After entering in the weights, then enter in a corresponding rating in the "Enter Rating Below" column. The coding scheme is provided below. Reminder weaknesses must be 1 or 2 and strengths must be 3 or 4
1 = "major weaknesses"
2 = "minor weaknesses"
3 = "minor strength"
4 = "major strength"
Enter Weight Below Enter Rating Below
Enter Ten Strengths Below
1.
2.
3.
4.
5.
6.
7.
8. IFE Matrix
9.
10.
Enter Ten Weaknesses Below Enter Weight Below Enter Rating Below
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
0.00
INSTRUCTIONS FOR COMPANY WORTH
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1. To perform the company worth, enter in corresponding financial information you are prompted for in the boxes to the right and press enter. Everything is calculated automatically and posted into the matrix.
2. Hints are provided below on where to find any particular information. If you wish to enter data for a competitor or a company you plan to acquire, scroll over. If acquiring a competitor, this value would constitute a large portion of your "amount needed" in the EPS/EBIT Analysis. Top competitor or who you wish to acquire.
Stockholders' Equity Net Income Stockholders' Equity Net Income
Stockholders' Equity – Can be found near bottom of Balance Sheet. It might be called total equity.
Net Income – Can be found on the Income Statement. It might be called net earnings or net profits.
Share Price – Can be found on Yahoo Finance.
EPS – Can be found on Yahoo Finance.
Shares Outstanding – www.money.msn.com. Company Worth
Share Price EPS Share Price EPS
Shares Outstanding Shares Outstanding
INSTRUCTIONS FOR SWOT
1 Click on the SWOT Hyperlink to the right and add your SO,WO,ST, and WT Strategies. Click Here to View SWOT
INSTRUCTIONS FOR BCG and IE Matrix
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1. The Template allows for a two, three, or a four division company. (If the company has more than 4 divisions, combine the divisions with the least amount of revenue and mention the adjustment to the class during your presentation.) <You will have to read the Annual Report to find this information> It is quite okay to do a BCG/IE for BOTH geographic and by product revenues/profits. To develop BCG and IE matrices, Step 1: enter in the corresponding profits you are prompted for in the boxes (for the corresponding divisions) below. Also, change the division name to match your case (The 2 division example is for domestic and international.) Pie slices are automatically calculated and labeled. In the example profits were 500 million and 800 million. Do not put a M or B to signal million or billion. If you can not find profit information, estimate this and explain to the class during your presentation. At a bare minimum, have the appropriately sized circles (even if you do not use pie slices). However, an educated profit estimation is more prudent if divisional profits are not reported.
BCG Matrix
2. After finishing Step 1, click on the BCG hyperlink to the right (Step 2, once there click on the pie slices. Here you can adjust the size of the circles (which represent revenues). Move the "pies" into the quadrant you desire. Don't worry about the "light green warning" when adjusting the pies.