1250 words in apa format with 3 references between the 4 questions............1. In a narrative format, discuss these firms from a strategic perspective. Information concerning recent changes in the firms is readily available online and should be accessed. Strategic issues should be discussed in “real time.”2. How has Fedex managed to maintain technical superiority (i.e., reliability, service, package tracking, etc.) in its industry? Can Fedex continue to do so in the future? Why or why not?3. Give examples of two prominent crises FedEx could face in the future. What steps should the company take to prepare for these crises? 4. Suppose you are the CEO of a start-up firm in the package delivery industry. You have plenty of capital to work with, but little infrastructure and no management team in place. What strategy would you pursue and why?Guidance for Unit 5 Hello everyone and welcome to Unit 5. We have made it to the final unit!Here are some points to help you in your Unit 5 COMPLETE assignment. Case Summary and the Narrative Format:The case summary is supposed to be on the Real time case assigned for the unit. In Unit 5, it is Real-Time Case 15: FedEx. . In other words, “these firms” refers only to FedEx. Remember to use the narrative format in your summary, and remember as well to gather (from the internet)and include real time information of strategic significance Case Analysis #1: The first question is very self explanatory. In the second question, you will analyze whether FedEx’s distinctive competence can be used for sustained competitive advantage. It will be a good idea to review what you read in Unit 1 about the Resource Based View and combine it with the SWOT analysis.Case Analysis #2: This is a very straightforward question on crisis management. Crisis management is one of the topics in your READ assignment for this unit. I will simply look at how well you integrate the concepts in your reading into your analysis, given the two crises you identify.Application: The application is about strategy formulation. Make sure you state clearly which strategy you would pursue at each level, that is, Corporate, Business Unit, and Functional. Please identify your strategies using the terms in the textbook. For example, under corporate level strategies, the alternatives are Growth, Stability, and Retrenchment. Under growth, the options are further divided into internal and external. It will be a good idea to review chapters 6, 7, 8, and 9 for correct terminology. Keep this essay concise and to the point. It is possible to write 30 pages or more just on this question, but you need to maintain the 200 to 400 word limit. Under the functional strategies, for example, limit your discussion to only one or two pertinent dimensions, not the whole cornucopia of functional strategies.

1Open the downloaded file go16_xl_ch07_grader_7g_hw.xlsx. Save the file as Lastname_Firstname_7G_Aquatics in your Excel Chapter 7 folder.02Click cell A2, and then insert a Recommended PivotTable by choosing the Blank PivotTable option in the lower left corner of the dialog box. Filter by the Month field. Use the Pool field as the row labels and the Item field as the column labels. Place the Amount field in the Values area. Close the PivotTable Fields list. Note, Mac users insert a PivotTable and then arrange the fields as indicated.103Format the values in the PivotTable using the Number category to display zero decimal places and the 1000 Separator.54Insert a slicer for the Pool field and for the Item field. Apply Slicer Style Light 4 and Slicer Style Light 6 to the slicers, respectively.Note: The style names may be Light Yellow, Slicer Style Light 4 and Light Green, Slicer Style Light 6, respectively, depending on the version of Office used.105By using the two slicers, filter the data to show, for the Tropics Pool, the total revenue for Spa Fees and Swim Lessons. Recall that you can use CTRL to select multiple filters in a slicer. Move the two slicers to the right of the filtered PivotTable, and then make a copy of this worksheet. Name the copied worksheet Tropics Pool.Note, Mac users, after creating and naming the sheet, on the PivotTable Analyze tab, click Filter Connections. Remove all check marks.66Display Sheet1 and clear the filters from the slicers and remove the slicers from the worksheet. Rename the sheet 2Q Revenue57Insert a PivotChart using the Stacked Column chart type. Move the chart to a new worksheet named 2Q Revenue ChartNote, Mac users select the range A4:G10 in the PivotTable. On the Insert tab, click Recommended Charts, and then click Stacked Column to make the chart. Move the chart to a new worksheet named 2Q Revenue Chart58Apply the Layout 3 chart layout and Chart Style 9. Add centered data labels, and then hide all of the field buttons on the chart. As the Chart Title, type 2nd Quarter Aquatics Program Revenue and then insert a custom footer with the file name in the left section.79Add a new worksheet to the workbook, and then import the Access database e07G_Pool_Supplies.accdb into the Data Model as a PivotTable Report using both tables in the database. Rename the sheet Supplies PivotTableNote, Mac users, import the data from the downloaded, comma-delimited text file Pool_Supplies.csv and then convert the data to a table with headers. Insert a PivotTable using the imported data. Rename the PivotTable sheet Supplies PivotTable510To create the PivotTable, place the Supplier field in the Columns area. Place the Item field in the Rows area, and the Quantity field in the Values area. Apply the Number format to the values in the PivotTable with zero decimals and the 1000 separator.511Insert a row above the PivotTable, if necessary, so that the PivotTable begins in cell A2. In cell A1, type Aquatics Program Purchases and then apply the Title cell style.512Click in the PivotTable, and then insert a 3-D Pie PivotChart. Move the chart to a new sheet with the name Aquatic Supplies ChartNote, Mac users continue to next step.913Modify the chart so that only the Supplier field displays in the Axis (Category) area. Remove any fields that display in the Legend (Series) area.Note, Mac users display the Field pane and remove Item field from the Row area. Move the Suppliers field to the Rows area. Select the range A3:B7 in the PivotTable. On the Insert tab, click Pie, and then click 3-D Pie to create a traditional chart. Move the chart to a new sheet with the name Aquatic Supplies Chart414Apply Style 7, remove the legend from the chart, and display only the Category Name and Percentage data labels positioned in the Center. Format the data labels by changing the font size to 12, the Font color to Black, Text 1, and then apply Bold.615Change the chart title to Aquatic Supply Purchases and then change the font size to 24. Hide all of the field buttons on the chart, and then insert a footer with the file name in the left section.1016Hide the Aquatics Revenue sheet. Select all the sheets and insert a footer in the left section that includes the file name, and then center the worksheet Horizontally on the page. Change the Orientation to Landscape and scale the Width to fit to 1 page.617Display the properties. As the Tags/Keywords, type aquatic revenue, supplies and as the Subject, type your course name and section #. Under Related People, be sure that your name displays as Author. Save your workbook.218Save and close the file, and then submit for grading.0Close