# Question: Kenichi Kaneko is the manager of a production department which

Kenichi Kaneko is the manager of a production department which uses 400 boxes of rivets per year. To hold down his inventory level, Kenichi has been ordering only 50 boxes each time. However, the supplier of rivets now is offering a discount for higher-quantity orders according to the following price schedule, where the price for each category applies to every box purchased.

The company uses an annual holding cost rate of 20 percent of the price of the item. The total cost associated with placing an order is $80 per order. Kenichi has decided to use the EOQ model with quantity discounts to determine his optimal inventory policy for rivets.

(a) For each discount category, write an expression for the total cost per year (TC) as a function of the order quantity Q.

T (b) For each discount category, use the EOQ formula for the basic EOQ model to calculate the value of Q (feasible or infeasible) that gives the minimum value of TC. (You may use the analytical version of the Excel template for the basic EOQ model to perform this calculation if you wish.)

(c) For each discount category, use the results from parts (a) and (b) to determine the feasible value of Q that gives the feasible minimum value of TC and to calculate this value of TC.

(d) Draw rough hand curves of TC versus Q for each of the discount categories. Use the same format as in Fig. 18.3 (a solid curve where feasible and a dashed curve where infeasible). Show the points found in parts (b) and (c). However, you don’t need to perform any additional calculations to make the curves particularly accurate at other points.

(e) Use the results from parts (c) and (d) to determine the optimal order quantity and the corresponding value of TC.

T (f ) Use the Excel template for the EOQ model with quantity discounts to check your answers in parts (b), (c), and (e).

(g) For discount category 2, the value of Q that minimizes TC turns out to be feasible. Explain why learning this fact would allow you to rule out discount category 1 as a candidate for providing the optimal order quantity without even performing the calculations for this category that were done in parts (b) and (c).

(h) Given the optimal order quantity from parts (e) and ( f ), how many orders need to be placed per year? What is the time interval between orders?

The company uses an annual holding cost rate of 20 percent of the price of the item. The total cost associated with placing an order is $80 per order. Kenichi has decided to use the EOQ model with quantity discounts to determine his optimal inventory policy for rivets.

(a) For each discount category, write an expression for the total cost per year (TC) as a function of the order quantity Q.

T (b) For each discount category, use the EOQ formula for the basic EOQ model to calculate the value of Q (feasible or infeasible) that gives the minimum value of TC. (You may use the analytical version of the Excel template for the basic EOQ model to perform this calculation if you wish.)

(c) For each discount category, use the results from parts (a) and (b) to determine the feasible value of Q that gives the feasible minimum value of TC and to calculate this value of TC.

(d) Draw rough hand curves of TC versus Q for each of the discount categories. Use the same format as in Fig. 18.3 (a solid curve where feasible and a dashed curve where infeasible). Show the points found in parts (b) and (c). However, you don’t need to perform any additional calculations to make the curves particularly accurate at other points.

(e) Use the results from parts (c) and (d) to determine the optimal order quantity and the corresponding value of TC.

T (f ) Use the Excel template for the EOQ model with quantity discounts to check your answers in parts (b), (c), and (e).

(g) For discount category 2, the value of Q that minimizes TC turns out to be feasible. Explain why learning this fact would allow you to rule out discount category 1 as a candidate for providing the optimal order quantity without even performing the calculations for this category that were done in parts (b) and (c).

(h) Given the optimal order quantity from parts (e) and ( f ), how many orders need to be placed per year? What is the time interval between orders?

**View Solution:**## Answer to relevant Questions

Sarah operates a concession stand at a downtown location throughout the year. One of her most popular items is circus peanuts, selling about 200 bags per month. Sarah purchases the circus peanuts from Peter’s Peanut Shop. ...The demand for a product is 600 units per week, and the items are withdrawn at a constant rate. The setup cost for placing an order to replenish inventory is $25. The unit cost of each item is $3, and the inventory holding ...Reconsider the example used to illustrate the deterministic periodic-review model in Sec. 18.4. Solve this problem when the demands are increased by 1 airplane in each period. What is the effect on the amount of safety stock provided by the stochastic continuous-review model presented in Sec. 18.6 when the following change is made in the inventory system? (Consider each change independently.) (a) ...The Mountain Top Hotel is a luxury hotel in a popular ski resort area. The hotel always is essentially full during winter months, so reservations and payments must be made months in advance for week-long stays from Saturday ...Post your question