Question

In: Operations Management

Bold Bodybuilders, Inc. is a large sporting goods store. It has become the exclusive distributor of...

Bold Bodybuilders, Inc. is a large sporting goods store. It has become the exclusive distributor of the new bodybuilding equipment called Geni. After carrying the equipment for a year, Joe Sabatini, a manager of the supply chain, decided to analyze the company's inventory policy for Geni. On the basis of the past year's record, Joe has identified the following weekly demand data:

Weekly Demand Occurrence, Week

95 8

96 2

97 6

98 10

99 8

100 6

101 6

102 2

103 4

Total 52

The annual demand for Geni is considered to be 5,128 units, annual holding cost per equipment is $244, and ordering cost is $4,250 per order. The equipment price is $929 per unit. The new order is made when the inventory level in the store drops to a predetermined number of units on hand. Once the company orders Geni from the supplier, it will come to the store in about 3 weeks.

Questions (Please fill in your answer using the enclosed Excel answer template)

  1. Explain what inventory planning and ordering system you are going to use in this case and why.
  2. Identify the optimal order quantity and total annual inventory cost. Explain the insights of your results.
  3. What are the best safety stock and reorder point that guarantees with a probability of 99% that the store will not run out of stock of Geni equipment? Explain the insights of your results.

Solutions

Expert Solution

Answer a:

The type of inventory planning that would be used in this case is ‘economic order quantity’. Economic Order Quantity is a model used to calculate inventory stocking levels. Its main purpose is to help a company maintain a consistent inventory level of inventory and to reduce overall costs of inventory. EOQ uses variable annual usage amount, order cost and warehouse carrying cost.

Answer b:

Optimal order quantity or economic order quantity is given as:

Total annual inventory cost = purchase cost + ordering cost + holding cost

Purchase cost = $929

Ordering cost = $4250

Holding cost = $244

Thus,

Total annual inventory cost = $929 + $4250 + $244 = $5423

Answer c:

Now lead time = 3 weeks

Average weekly demand = (95+96+97+98+99+100+101+102+103)/9 = 99

Service level = 99% = 99/100 = 0.99

Z corresponding to 0.99 in normal distribution table = 2.58

Standard deviation = 4 (as can be seen from the weekly data by comparing each with average weekly demand)

Formula for reorder point is

Thus,

Reorder point = 99 (3) + 2.58 (4) (√3)

Reorder point = 297+17.87 = 314.87

Safety stock = 2.58 (4) (√3) = 17.87


Related Solutions

Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Overhead Item Expected Cost Cost Driver Maximum Quantity Setup Cost 489,600 Number of Setups 7,200 Ordering Cost 130,000 Number of Orders 65,000 Maintenance 920,000 Number of Machine Hours 80,000 Power 88,000 Number of Kilowatt Hours 440,000 Total predicted direct labor hours for next year is 42,500. The...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store...
Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Ridgeland Inc. makes backpacks for large sporting goods chains that are sold under the customers' store brand names. The Accounting Department has identified the following overhead costs and cost drivers for next year: Overhead Item Expected Costs Cost Driver Maximum Quantity Setup costs $244,800 Number of setups...
2. A large sporting goods store is placing an order for bicycles with its supplier. Four...
2. A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold...
A large sporting goods store is placing an order for bicycles with its supplier. Four models...
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. There are several conditions that the store needs to worry about. One of these is space to hold the inventory. An adult's bike needs two...
A large sporting goods store is placing an order for bicycles with its supplier. Four models...
A large sporting goods store is placing an order for bicycles with its supplier. Four models can be ordered: the adult Open Trail, the adult Cityscape, the girl's Sea Sprite, and the boy's Trail Blazer. It is assumed that every bike ordered will be sold, and their profits, respectively, are 30, 25, 22, and 20. The LP model should maximize profit. There are several conditions that the store needs to worry about. One of these is space to hold the...
Cost of Reworked Units Warren’s Sporting Goods Store sells a variety of sporting goods and clothing....
Cost of Reworked Units Warren’s Sporting Goods Store sells a variety of sporting goods and clothing. In a back room, Warren’s has set up heat transfer equipment to personalize T-shirts for Little League teams. Typically, each team has the name of the individual player put on the back of the T-shirt. Last week, Shona Kohlmia, coach of the Terrors, brought in a list of names for her team. Her team consisted of 12 players with the following names: Mary Kate,...
Benford Inc. is planning to open a new sporting goods store in a suburban mall. Benford...
Benford Inc. is planning to open a new sporting goods store in a suburban mall. Benford will lease the needed space in the mall. Equipment and fixtures for the store will cost $400,000 and be depreciated over a 5-year period on a straight-line basis to $0. The new store will require Benford to increase its net working capital by $375,000 at time 0. First-year sales are expected to be $1.2 million and to increase at an annual rate of 7...
(20 Marks) Homantin, Inc. is considering a project for opening a new sporting goods store in...
(20 Marks) Homantin, Inc. is considering a project for opening a new sporting goods store in a suburban mall. Homantin will lease the needed space in the mall. Equipment and fixtures for the store will cost $600,000. It is the accounting policy of the company to depreciate equipment and fixtures over a 5-year period on a straight-line basis with no residual value. However, the manager expects equipment and fixtures to be sold at $20,000 at the end of 5 years....
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store...
The ABC department store has three major product lines: hardware, clothing, and sporting goods. The store is considering dropping the clothing line because the income statement shows that it is operating at a loss. Note the income statement for these product lines below: Hardware Clothing Sporting Goods Total Sales $10,000 $15,000 $25,000 $50,000 Less: Variable costs $6,000 $8,000 $12,000 $26,000 Contribution Margin $4,000 $7,000 $13,000 $24,000 Less: Fixed costs Direct $2,000 $6,500 $4,000 12,500 Allocated $1,000 $1,500 $2,500 $5,000 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT