Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. Case Study II: J&J and Walmart Michelle is Johnson & Johnson's Walmart account manager, meaning that she observes all operational interactions between Walmart
4. Case Study II: J&J and Walmart Michelle is Johnson & Johnson's Walmart account manager, meaning that she observes all operational interactions between Walmart and Johnson & Johnson. The Walmart account is so important to J&J that Michelle actually lives in Bentonville, Arkansas, which is where Walmart's corporate headquarters is located. Rafael works for Walmart and is Michelle's main contact person. Rafael was concerned that Walmart was not purchasing as efficiently from J&J as it could, so he arranged for a meeting with Michelle to discuss their strategy. To focus the conversation, Rafael suggested they look at one product, Listerine Cool Mint 250ml. Table 1 reports sales data for that product in one of Walmart's stores over a 30-week period. Table 2 provides data on demand, ordering costs, etc. for this product. Table 1. Weekly sales of Listerine Cool Mint 250 ml at one Walmart Supercenter Week Sales Week Sales Week Sales 1 18 11 9 21 11 2 16 12 10 22 10 3 19 13 9 23 12 4 15 14 5 24 13 5 12 15 6 25 19 6 15 16 7 26 14 7 17 17 11 27 13 8 13 18 10 28 9 8 19 10 29 10 9 20 7 30 2225 18 18 15 Table 2. Information regarding demand, ordering costs, etc. for Listerine Cool Mint 250 ml Purchase price per unit Annual holding cost percentage Fixed ordering cost Average weekly sales (units) Units per case Cases per tier Tiers per pallet Lead time Service level $2.5 25% $6 12.3 12 24 5 4 weeks 95%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started