I am including pictures of the five categories for you to choose from. 1. The te

I am including pictures of the five categories for you to choose from.
1. The textbook authors discuss a variety of financial ratios, and divide them into five categories. Choose three categories and calculate a financial ratios from each category for Walmart for the last two fiscal years (2021 and 2022). Make sure to select ratios that you think opening a new supercenter will affect, and explain your reasoning. Identify a competitor of Walmart, calculate the same ratios for that competitor, and contrast the results for the two companies over the two most recent years. Explain why you selected this competitor. Describe how the decisions made by management, marketing and operations functions of the company can impact, and hopefully improve, these financial ratios.
2. Background: Monitoring daily sales is a critical aspect of retail operations for Walmart. As one of the largest retail chains in the world, Walmart places significant emphasis on this practice for several reasons: By monitoring sales, the store can identify fast-moving and slow-moving items and adjust inventory levels accordingly. Furthermore, tracking daily sales allows each store to evaluate its performance on a daily basis. This data helps the store management identify trends, patterns, and potential issues in sales and customer behavior. Finally, analyzing daily sales data helps in generating sales forecasts for future periods. Accurate sales forecasts are vital for planning promotions, setting staffing levels, and making inventory purchase decisions. You are given the daily sales of a Walmart store from May 26 to June 29 in Sales_Data.xlsx dataset. Forecast the daily sales from June 30 to July 6. Make sure your forecasts include any adjustments for trend and seasonality. Draw a line chart of your data. Calculate the seasonality indexes. What do the seasonality indexes tell you? What are the forecasted sales amounts, after including any adjustments for trend and seasonality from June 30 to July 6. How will Walmart use your forecasts in planning and managing store operations for the week of June 30th? (100 – 150 words). Note: The data on the Excel file is dynamic and changes every time you hit a key on the keyboard or when you reopen the file. Please copy the entire dataset, paste it as “Values” on a separate sheet, and work on the data on the new sheet. This will allow you to work on static data.