Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Rafael turns to Michelle and asks, What order quantity do you recommend we use for this product? Remember, we only ship in case quantities.

image text in transcribedimage text in transcribedimage text in transcribed

1.

Rafael turns to Michelle and asks, What order quantity do you recommend we use for this product? Remember, we only ship in case quantities.

2.

Michelle reminds Rafael that the two companies are looking for ways to streamline the flow of product through the supply chain. One way to do so would be to ship only in tier quantities. If each order to the store was for a single tier, then the tier could be created in J&Js warehouse. The tier would then be shipped to Walmarts distribution center and immediately sent on from the distribution center to the supercenter. Rafael agrees that a tier quantity might help the rest of the supply chain, but he fears that it would be costly to order one tier at a time for this supercenter. Are Rafaels concerns justified?

3.

Putting aside the issue of ordering a single tier (which requires some more information to come to a resolution), Rafael wanted to raise another issue with Michelle. Looking at Figure 12.3, he points out that there are periods of time when demand looks like it is 50 percent higher than the average, and other times when demand is as much as 50 percent lower than the average. Given this variation in demand, he wonders if choosing a single order quantity (in cases) is a reasonable strategy. Or should it adjust its order quantity throughout the year? Making adjustments to the order quantity would be a hassle, especially given the number of products it manages and the number of stores it has, but if it needs to do that to save on costs, it will.

Michelle Sayer is Johnson & Johnson's Walmart account manager, meaning that she oversees 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 Ellwood 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 250 ml. Table 12.6 reports sales data for that product in one of Walmart's stores over a 30-week period, while Figure 12.3 displays the data in a graph. Table 12.7 provides data on demand, ordering costs, and holding costs for this product. TABLE 12.6 Weekly Sales of Listerine Cool Mint 250 ml at One Walmart Supercenter Week Sales Week Sales Week Sales 21 12 22 1 18 11 9 11 2 16 10 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 18 8 19 10 29 18 9 10 9 20 7 30 15 Figure 12.3 Weekly sales of Listerine Cool Mint 250 ml at one Walmart supercenter 20 18 16 14+ 12+ Sales (units) 10+ zato 8+ 6+ 4+ 2+ 0 o 5 10 15 20 25 30 35 Week TABLE 12.7 Information Regarding Demand, Ordering Costs, and Holding Costs for Listerine Cool Mint 250 ml Purchase price per unit $2.50 Annual holding cost percentage 25% Fixed ordering cost $6 Average weekly sales (units) 12.3 Units per case Cases per tier 24 Tiers per pallet 5 12 5 Michelle Sayer is Johnson & Johnson's Walmart account manager, meaning that she oversees 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 Ellwood 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 250 ml. Table 12.6 reports sales data for that product in one of Walmart's stores over a 30-week period, while Figure 12.3 displays the data in a graph. Table 12.7 provides data on demand, ordering costs, and holding costs for this product. TABLE 12.6 Weekly Sales of Listerine Cool Mint 250 ml at One Walmart Supercenter Week Sales Week Sales Week Sales 21 12 22 1 18 11 9 11 2 16 10 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 18 8 19 10 29 18 9 10 9 20 7 30 15 Figure 12.3 Weekly sales of Listerine Cool Mint 250 ml at one Walmart supercenter 20 18 16 14+ 12+ Sales (units) 10+ zato 8+ 6+ 4+ 2+ 0 o 5 10 15 20 25 30 35 Week TABLE 12.7 Information Regarding Demand, Ordering Costs, and Holding Costs for Listerine Cool Mint 250 ml Purchase price per unit $2.50 Annual holding cost percentage 25% Fixed ordering cost $6 Average weekly sales (units) 12.3 Units per case Cases per tier 24 Tiers per pallet 5 12 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management In The Public Sector Tools Applications And Cases

Authors: Xiaohu Wang

3rd Edition

0765636891, 9780765636898

More Books

Students also viewed these Finance questions

Question

What is a verb?

Answered: 1 week ago