Purchase Solution

Supply Chain & Inventory Management

Not what you're looking for?

Ask Custom Question

Supply Chain Management exercise questions

1. Mike Johnson went back to work in his family business after graduating. The family business, Johnson Bicycles, is a bike shop that specializes in high quality bikes. They carried a full line of bikes, ranging from touring bikes to mountain bikes and aimed to be the premiere, full service bike shop.

Currently, Johnson Bicycles has three retail outlets that it stocks individually (and hence manages inventory separately for each location). Mike thinks that the operation is big enough to take advantage of scale economies and wants to investigate the possibility of consolidating inventory at a centralized distribution point. Mike thinks that centralizing inventory should lead to a substantial reduction in inventory costs.

The basic idea would be to stock the bikes centrally (excluding the token display model) and expedite delivery to the stores on an as needed basis. He figured if the principal of aggregation would work for the series 200 bike, then it should provide costs savings for all styles of bikes. Table 1, below, shows last year's sales history for the model 200 series at each retail location.

Series 200 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Std Dev Total
Outlet 1 9 5 15 10 12 5 3 12 23 12 8 5 5.5 119
Outlet 2 10 10 30 12 22 15 17 30 11 14 12 15 7.1 198
Outlet 3 12 22 5 15 14 23 10 4 9 15 3 5 6.7 137
Total Sales 31 37 50 37 48 43 30 46 43 41 23 25 8.9 454

As can be seen, monthly sales varied, but generally, sales remained fairly constant from year to year. Mike estimated it cost $65 every time the company placed an order for a given model at each location. The supplier's lead time is a hefty two months, but fortunately it has been constant over time. Historically, they've stocked to a 98% service level. Each bike model cost $75 per bike and Mike figures that holding cost to be 25% of the purchase price on an annual basis. With their high service level, there was naturally, a lot of extra safety stock in inventory. Mike knew every additional unit of safety stock (recall safety stock is any inventory held in excess of average demand) added directly to the total cost of inventory in the form of added holding cost. That is, total cost is equal to the cost of ordering plus the cost of holding inventory, where the cost of holding inventory is equal to the cost of holding average inventory plus safety stock.

a. Using the s, S model, what are the order quantities, reorder points, and total annual inventory costs associated with inventory management of the Series 200 line of bikes at each location?

b. What would be the order quantity, reorder point, and total annual inventory cost for a consolidated plan where bikes are stored at a central distribution center?

c. Would you recommend switching to centralized inventory management? What other factors besides costs should Mike consider?

Please see attached for full question.

Purchase this Solution

Solution Summary

This is a discussion of Supply Chain & Inventory Management for a fictitious company called Johnson Bicycles.

Purchase this Solution

Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.