Please read the Walmart case study carefully to complete this assignment(Provided). You should mainly use
the Walmart case study. However, you are strongly encouraged to do some research about
Walmart’s operations to answer the questions. Please refresh your understanding of the six key
operations management (OM) functions (listed below for your convenience):
Forecasting, Project Management, Quality Management, Process Design, Inventory Management ,Supply Chain Management
Question 1:
Walmart is known for offering “Every Day Low Prices” to its customers. One way it is able to do
this is by focusing on efficiency and automation in its supply chain operations. How does
Walmart’s focus on efficiency and automation in their supply chain operations allow them to
offer everyday low prices while still hitting their financial targets? (100-150 words)
Question 2:
“Walmart delegated the pricing and merchandising decisions to store managers who reacted
quickly to changes in local market conditions.”
Assume that you are the store manager of a Walmart, and you would like to introduce multiple
new high-end apparel items to the customers in your store.
Describe any interactions you would have with the regional managers at Walmart Finance,
Marketing, and HR as you get ready for the introduction of those items in your store. For what
issues would you need their help and support? (200 – 250 words).
Question 3:
Assume that you are now the advisor to the Executive Vice President and Chief Operating
Officer for Walmart U.S., Chris Nicholas. In this role, you are responsible for providing
recommendations in all aspects of Walmart’s U.S. Store Operations and Supply Chain. This
includes but is not limited to strategy, innovation, automation, store operations, inventory
management, distribution center and fulfillment center operations, and last-mile delivery
capability. Your objective is to assist in boosting in-store sales and profit over the next three
years. Pick two out of six OM functions and provide operational recommendations to Chris
Nicholas for those functions. (250 – 300 words)
Background for question 4:
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.
Question 4:
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.
Guidelines-
• The assignment should be prepared as a Word document, 3-4 pages
• The document should be double-spaced, use font size 12.
• Add any appendices or references at the end of the Word document
• Your reference sources, in addition to the base case and question sets, should be online sites
and articles, Bloomberg terminals, your Integrated Semester textbooks, PowerPoint slides
Microsoft Excel is needed, Include the calculations in the answer
Mainly use the provided Walmart USA – Case Study pdf
In text cite the case study in your answers
