data analytics question and need a reference to help me learn.
TEXTBOOK_PDF < the textbook for this course! use as a reference to the pepsi case needed for this quesion. Assignment instructions: This assignment will be submitted to Turnitin™. INSTRUCTIONS Up until now you have been working on the parts used to conduct strategic analysis. They may have seemed somewhat unrelated to each other, but now you must put all the parts together to create a comprehensive strategic analysis. This assignment requires you show competency in all the concepts and tools you have worked with in this course. You will be graded on how well you use those tools, not on getting Submit a full written case analysis of Pepsi using the EXACT format in the How To Write a Case Analysis module. It should be somewhat similar to the Sanderson Farms example, but that analysis was done at the graduate level. Your analysis will not be quit as comprehensive. The Pepsi case is near the end of the textbook. Use the information from the textbook as much as possible for your internal analysis, not current information on Pepsi. You may have to use current information for your external analysis. Your grade will be determined not on what specific strategy you come up with for Pepsi (there is no "correct" one), but how well you develop a new mission, vision, IFE, EFE, your SWOT, and use the tools to analyze it. Submit as a word document. DO NOT SUBMIT THE TEMPLATE OR ANY PORTION OF IT! The template is in excel and D2L has a hard time displaying mixed formats. You can use the template to help determine your information, but you must copy and paste it into a word document or create our own tables and drawings. Your submission should be crafted like you work for the company and is your report to the CEO. Your promotion and big raise depend on the quality of your work. The pepsiCo case starts at page 588 within the textbook the required format is below within the provided docs file. its important to follow that please do! 🙂 Requirements: MENTIONED IN DETAILS ABOVE^^ How to write a comprehensive written analysis. While the steps are listed separately, they are really tied together and rely on each other. Information from one step needs to be used in subsequent ones. For example, after doing the financial ratio analysis, two to four of the most significant S or W must be carried down and made part of the IFE. That is the reason you do ratio analysis. The same goes for all the steps. It is like building a pyramid, using the information you create to build on the next layer until you reach the point at the top which is the strategy. Put your name and date on the top of the page. State the company name State their existing mission statement (if it exists). Remember, they may call it something else. Rewrite mission statement (or write one if none existed). Try to use all 9 components. Be sure to indicate each component with ( ) right after that component appears in the mission statement. Follow the examples in tables 2/6 and 2-7. Explain why your mission statement is better. State their existing vision statement (if it exists). Remember, they may call it something else. Rewrite vision statement and explain why yours is better. Determine and state the company’s strategy from the case information in the textbook, not what it currently actually is this year. Construct a table listing all 22 financial ratios. Conduct a financial ratio analysis determining as many of the ratios as you can for as many years as you have data in the textbook. Determine the same ratios for the company industry, competitor, and/or the S&P 500. Analyze the data to determine if the ratio is showing a strength, weakness, or neutral and show your resulting analysis in your final column by an S, W, or N. Separately list which strengths or weakness are significant and explain why they are significant. You need to have at least four that you will include in step 10, but you can have more. List each of the following internal components and explain any strengths and weaknesses under each one. Each one must be its own separate paragraph. You cannot just say something like “They have good management.” You must explain why it is good. You may not be able to find information on all of these in the textbook, but you will be able to find some of them. Identify those you will include in your IFE. Use numerical data as much as possible: Culture Management Marketing Finance/Accounting other than already noted in your financial ratio analysis Production/operations Research and Development Management Information Systems Value Chain Other including any distinctive competitive advantage Construct an Internal Factor Evaluation Matrix with 10 each of strengths and weaknesses using your results from steps 8 and 9 plus other financial or other internal information from the case. See my examples on D2L. Identify and discuss the company’s industry and major competitors. This should be a least 150 words, double spaced, 12 point Times New Roman for the industry and at least another 250 words for the competitors. Do not limit yourself to just one competitor. Construct a Competitive Profile Matrix. Include at least eight critical success factors peculiar to this company’s industry and one competitor – more competitors if possible. List each of the following external factors and explain any threats or opportunities under each one, identifying those you will include in your EFE. Each one must be its own separate paragraph. You cannot just say the economy is bad or good. You must explain why. Use numerical data as much as possible: Economic Cultural Social Demographic Geographic Technological Political Legal Governmental Natural environment Competition (including any competitive advantage or weakness) Construct an External Factor Evaluation Matrix with 10 threats and 10 opportunities using your results from steps 12 and 13. Remember, SWOT opportunities are NOT about doing anything like buying a competitor. They are about things the company cannot control, like unemployment is going up or down. Construct your SWOT matrix per figure 6-3 using all ten of each strength, weakness, threat, and opportunity from you IFE and EFE. Show each of your possible SO, WO, ST, and WT strategies (not strategy types) with the appropriate combinations. You must have at least two each SO, WO, ST and WT strategies. It should use the format from figure 6-3, but with your factors and your strategies. You must use the same factors from your IFE and EFE. Create a table of all 11 strategy types. Match each of your possible strategies with the correct strategy type. You will not have a strategy for each strategy type. Create, show, and explain a SPACE matrix for your company. Analyze which of your possible strategies are suggested by the matrix. Show all your work, including the factors you used for each of the four axis. You can use the template, but you must show the factors you used besides the graph. Create and show an IE matrix and state specific suggested strategy types. Analyze which of your possible strategies are suggested by the matrix. It is not correct just to identify the types that the matrix shows. You must show which of YOUR SPECIFIC strategies are indicated. Create and show a GSM explaining your reasoning for the positions on the axis points, and state specific suggested strategies. Analyze which of your possible strategies are suggested by the matrix. It is not correct just to identify the types that the matrix shows. You must show which of YOUR SPECIFIC strategies are indicated. Choose a least two of your specific strategies (not strategy types). Using them construct and show a QSPM. You must use two of your suggested strategies from step 15 and explain why you chose those strategies. Make and explain a recommendation for a new strategy. You must explain why It is a good strategy to follow. Your explanation should be at least 150 words and explain how the strategy will affect the entire company. This strategy must match their mission and vision you created at the start. It must also flow from all the other steps in a logical fashion. Compare your recommendation to the strategy the company is actually following today. This will require an internet search. This is rarely the same as your recommendation.