Using the Bacardi website, develop both EFAS and IFAS table using an excel file. Also including both environmental and internal scanning process and what factors you consider and why will typed in MS word file.

To develop an EFAS (External Factor Analysis Summary) and IFAS (Internal Factor Analysis Summary) table using the Bacardi website and Excel:

1. Open Microsoft Excel on your computer.

2. Visit the Bacardi website (www.bacardi.com) and navigate to their "About" or "Investor Relations" section. Look for information that relates to their external and internal factors.

3. Create a new Excel file and label the first sheet as "EFAS."

4. In the EFAS sheet, create columns with the following headers: Factors, Weight, Rating, Weighted Score, Comments.

5. Identify relevant environmental factors (opportunities and threats) that impact Bacardi's operations by referring to information on the Bacardi website. Fill in these factors in the "Factors" column.

6. Assign weights to each factor based on their relative significance. These weights should add up to 1 (or 100%). Assign higher weights to factors that have a greater impact on Bacardi's business. Enter these weights in the "Weight" column.

7. Rate each factor from 1 to 5, with 5 indicating the highest impact on Bacardi's operations and 1 indicating the lowest impact. Enter these ratings in the "Rating" column.

8. Multiply the weight of each factor by its rating to obtain the weighted score. Enter these scores in the "Weighted Score" column by using the following formula: =Weight x Rating.

9. Add any comments or explanations regarding the factors or their ratings in the "Comments" column.

10. After completing the EFAS table, create a new sheet in Excel and label it as "IFAS."

11. In the IFAS sheet, create columns with the following headers: Factors, Weight, Rating, Weighted Score, Comments.

12. Identify relevant internal factors (strengths and weaknesses) that impact Bacardi's operations by referring to the information on the Bacardi website. Fill in these factors in the "Factors" column.

13. Assign weights to each factor similar to the EFAS table. These weights should also add up to 1 (or 100%). Enter these weights in the "Weight" column.

14. Rate each factor from 1 to 5, with 5 indicating the highest impact on Bacardi's operations and 1 indicating the lowest impact. Enter these ratings in the "Rating" column.

15. Multiply the weight of each factor by its rating to obtain the weighted score. Enter these scores in the "Weighted Score" column using the formula: =Weight x Rating.

16. Add any comments or explanations regarding the factors or their ratings in the "Comments" column.

17. Once you have completed both the EFAS and IFAS tables, you can save the Excel file.

Additionally, you mentioned creating an MS Word file to include the environmental and internal scanning processes. In this document, you can explain the following:

Environmental Scanning Process:
1. Define the purpose of environmental scanning: understanding the external factors that affect an organization's performance.

2. Explain the steps involved in environmental scanning:
a. Gathering information about the industry, market, and competitors.
b. Monitoring political, economic, social, technological, legal, and environmental factors (known as PESTLE analysis).
c. Analyzing trends, opportunities, and threats.
d. Identifying factors that could impact Bacardi's business in the future.

Internal Scanning Process:
1. Define the purpose of internal scanning: identifying an organization's strengths and weaknesses.

2. Explain the steps involved in internal scanning:
a. Gathering information about Bacardi's resources, capabilities, and internal processes.
b. Assessing its financial health and performance.
c. Analyzing its marketing, operations, human resources, and other functional areas.
d. Identifying Bacardi's core competencies and areas for improvement.

By following these steps and explanations, you can develop both the EFAS and IFAS tables using an Excel file while creating an accompanying document in MS Word to describe the environmental and internal scanning processes.