Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Bike & Ski Co. has two stores in Western Mass: one in E. Longmeadow and one in Easthampton. The two stores stock identical items

The Bike & Ski Co. has two stores in Western Mass: one in E. Longmeadow and one in Easthampton. The two stores stock identical items that are delivered directly to their location from various suppliers. The stores are considering leasing a warehouse facility in Holyoke to consolidate their inventory and place joint orders from suppliers. Let’s help them understand whether a common warehouse location would be cost effective by analyzing the cost associated with two products:

Product 1: Best-Selling Junior Bike

o E. Longmeadow store weekly demand is ~ N(µ=20, s=4)

o Easthampton store weekly demand is ~ N(µ=20, s=3).

o Consider demand at the two stores is independent.

The following parameters are seen by both stores:

o Replenishment lead time in weeks: L=2 weeks

o Fixed shipping cost of replenishment: $300 (trucking cost)

o Cost per bike: $100 o Price bike is sold at: $150

o Holding cost per bike is 20% of its value per year

Product 2: Specialty Skis Imported from Sweden

o E. Longmeadow store weekly demand is ~ Poisson(l=0.4)

o Easthampton store weekly demand is ~ Poisson(l=0.6).

o Consider demand at the two stores is independent.

The following parameters are seen by both stores:

o Replenishment lead time in weeks: L=5 weeks (ocean shipping)

o Fixed cost of replenishment: $100 o Cost per ski set: $1000

o Price skis are sold at: $1800 o Holding cost per ski set is 30% of its value per year § This is higher than the holding cost rate for bikes because of the risk of obsolescence for this fashion, high-end product

Question 1: How many of each item should each location order at a time and when should they reorder if they want a 99% cycle (Type I) service level? What is the resulting fill rate for each of the products and locations? Use the Type II service level approximation to calculate the fill rate in the case of normal demand, and the actual fill rate for the Poisson demand case.

Question 2: What would these decisions change if the two locations consolidate the inventory into the new warehouse?

Question 3: What are the annual savings in fixed ordering costs and inventory costs associated with the consolidation?

Question 4: How would the decisions change if a 95% service level is deemed sufficient? What if 90%? What are the resulting fill rates?

Question 5: What service level would you recommend? Assume that customers are not willing to wait.

Question 6: Assume now that the replenishment lead time for junior bikes in weeks is a random variable L~ N(µ=2, s=0.1). What should be the ordering decisions then?

Question 7: How would your decisions change if the Swedish supplier stops charging fixed costs for ordering and shipping? That is, the only cost is $1000 per unit ordered.

Step by Step Solution

3.21 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

QUESTION 1 To find the number of each item to order we need to use the following equation X ZC1 12ZC Where X is the number of units to order Z is the number of standard deviations to cover the desired ... 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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions

Question

2. Which animal species would have the longest axonspg109

Answered: 1 week ago