Analyzing Walmart Data

Analyzing Walmart Data

Underperformers

• Furniture
• Seasonal department

1. What is the On-Shelf Customer Availability (OSCA)?
2. What are the lost sales on monthly, weekly, yearly, and quarterly periods?

Internal factors	External factors
Client Feedback and Hand Items	Market prices
Cost of goods sold and Margins	Competition

Over-performers

• Jewelry
• Toys

1. What are the margins for goods sold daily?
2. What is the on-shelf customer availability?

Internal factors	External factors
Client feedback	Market prices
Comp units and comp units per basket	Competition

What customer feedback would be useful to you for understanding the under- and over-performance in these departments (categories)?

Customer feedback is an essential aspect in understanding both the under and over-performers. For the underperforming departments, customer feedback should help highlight issues that are not addressed by the current products or quality that Walmart is offering. The feedback should help identify elements that the clients do not like about the products in the two departments. This information provides an opportunity to improve the offerings and ensure customer needs are met. For over-performing departments, customer feedback will help management identify aspects that make Walmart the preferred store. Such information will enable the store to observe these aspects for continued satisfaction (Spawn, 2020).

Recommendations

To improve the underperforming departments, the store should seek to reduce lost sales. This is achievable by evaluating the OSCA data, which shows items that clients need but cannot find on the shelves. Providing these items is critical in ensuring that sales increase substantially. Most importantly, it is essential to adhere to the quality, brands, and preferences that the clients request or highlight in the feedback (Brackett, 2020). To take advantage of the over-performing departments, the store should adhere to the aspects that clients highlight as points of attraction for retention; at the same time, it is essential to increase the volume of goods for sale and market more to increase sales.

References

Brackett, J. (2020). How To Use Customer Feedback To Grow Your Business. Forbes.

Spawn, L. (2020). How to Use Customer Feedback to Your Advantage. CMS Wire.

ORDER A PLAGIARISM-FREE PAPER HERE

We’ll write everything from scratch

---

Review this example Comp Sales Report for a single Walmart store location:

• Comp Sales Report

Use course content and the example Comp Sales Report to complete the following:

Choose two departments that are under-performing in the YTD vs. Plan column.

1. 1. • Develop two questions you would ask the managers in these departments to help you understand the performance results.
      • Identify two internal or external factors you would look at to help you understand the performance results.

Choose two departments that are over-performing in the YTD vs. Plan column.

1. 1. • Develop two questions you would ask the managers in these departments to help you understand the performance results.
      • Identify two internal or external factors you would look at to help you understand the performance results.

What customer feedback would be useful to you for understanding the under- and over-performance in these departments (categories)?

Develop two specific recommendations for the store: one to take advantage of opportunities in the over-performing departments and one to improve performance in the under-performing departments.