This is the operations managment intrigrated assignmnet for the Walmart Case study attached below are two documents, the first document is a pdf of the Walmart Case Study the second document is another pdf with the full outline and prompt of the assignment overall. All the information needed is in the two attached documents. To find the prompt click the Integraated semester assignment document and scroll down until you see oeprations assignment everthing needed is in there. There is a exel file that is also needed for the assignments completion as well that has to be attached with the final product. Thank you.
OPERATIONS ASSIGNMENT:
Please read the Walmart case study carefully to complete this assignment. 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) discussed in the
course:
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)
5
Question 4:
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.
Question:
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.
