4. (Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rateper period of 0.02. The additional data for this product is given below:PeriodDemand (units)Fixed Cost (S/order)(i)(ii)17510020110365100Assuming no backordering is allowed, answer the followings:(a) Check whether the demand is lumpy or not.(b) Apply the following heuristics on the problem given above.Period Order Quantity440105590100Silver-Meal(iii) Part-Period Balancing(c) Which of the solutions obtained in part (b) do you select?(d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for eachare on the network.(e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventorylevels, and the minimum sum of the ordering and inventory carrying costs.

This question asked us to (a) check if the demand is lumpy or not. (b) Apply three heuristics:…

(Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rate per period of 0.02. The additional data for this product is given below: Period Demand (units) Fixed Cost (S/order) 75 100 2 0 110 3 65 100 Assuming no backordering is allowed, answer the followings: (a) Check whether the demand is lumpy or not. (b) Apply the following heuristics on the problem given above. (i) Period Order Quantity (ii) 4 5 40 90 105 100 Silver-Meal (iii) Part-Period Balancing (c) Which of the solutions obtained in part (b) do you select? (d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for each are on the network. (e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventory levels, and the minimum sum of the ordering and inventory carrying costs.

(Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rate per period of 0.02. The additional data for this product is given below: Period Demand (units) Fixed Cost (S/order) 75 100 2 0 110 3 65 100 Assuming no backordering is allowed, answer the followings: (a) Check whether the demand is lumpy or not. (b) Apply the following heuristics on the problem given above. (i) Period Order Quantity (ii) 4 5 40 90 105 100 Silver-Meal (iii) Part-Period Balancing (c) Which of the solutions obtained in part (b) do you select? (d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for each are on the network. (e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventory levels, and the minimum sum of the ordering and inventory carrying costs.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

A large distributor of oil-well drilling equipment operated over the past two years with EOQ policies based on an annual holding cost rate of 22%. Under the EOQ policy, a particular product has been ordered with a Q* 80. A recent evaluation of holding costs shows that because of an increase in the interest rate associated with bank loans, the annual holding cost rate should be 27%. a. What is the new economic order quantity for the product? b. Develop a general expression showing how the economic order quantity changes when the annual holding cost rate is changed from I to I
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 200 units and a standard deviation of 16 units. It is purchased from a wholesaler at a cost of $12.50 per unit. You are using a continuous review system to control this inventory. The supply lead time is 4 weeks. Placingan order costs $50, and the inventory carrying rate per year is 20 percent of the item’s cost. Your firm operates 5 days per week, 50 weeks per year.a. What is the optimal ordering quantity for this item?b. How many units of the item should be maintained as safety stock for 99 percent protection against stockouts during an order cycle?c. If supply lead time can be reduced to 2 weeks, what is the percent reduction in the number of units maintained as safety stock for the same 99 percent stockout protection?d. If through appropriate sales promotions, the demand variability is reduced so that the standard deviation of weekly…
Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
The “how much to order” decision always has an influence on the followingcosts except: A. Annual purchasing costs.B. Annual carrying costs.C. Annual procurement costs.D. Total annual inventory costs.
The following information relates to the forthcoming period:-Order costs = $25per orderHolding costs = 17% of purchase priceAnnual demand = 16,000 unitsPurchase price = $17 per unitOrder quantity = 650 unitsRequired:-What are the total annual costs of inventory?
Kendi Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. A. Calculate the EOQ. B. Determine the Average Level of Inventory. (Note: Use a 365-day year to calculate daily usage.) (Format: 111.11) C. Determine the Reorder Point. (Format: 11.11)
Petromax Enterprises uses a continuous review inventorycontrol system for one of its SKUs. The following informationis available on the item. The firm operates 50 weeks in a year.Demand = 50,000 units>yearOrdering cost = $35>orderHolding cost = $2>unit>yearAverage lead time = 3 weeksStandard deviation of weekly demand = 125 unitsa. What is the economic order quantity for this item?b. If Petromax wants to provide a 90 percent cycle-servicelevel, what should be the safety stock and the reorder point?
Cheryl Druehl has asked you to help her determinethe best ordering policy for a new product. The demand for thenew product has been forecasted to be about I ,000 units annually.To help you get a handle on the carrying and ordering costs,Cheryl has given you the list of last year's costs. She thought thatthese costs might be appropriate for the new product. She also told you that these data were compiled for 10,000 inventoryitems that were carried or held during the year. You havealso determined that 200 orders were placed last year. Your job as a new opera tions management graduate is to help Cheryl determinethe economic order quantity for the new product.
A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $26.50 and Ch = $7. The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with ? = 25 and ? = 5. (a) What is the recommended order quantity? (Round your answer to the nearest integer.):________ (b) What are the reorder point and safety stock if the store desires at most a 6% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder point:________ safety stock:________ (c) If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.):________ How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.):________
Add two (2) new customers, two (2) old customers and two (2) new POS transactions. SalesID InvoiceNo TransDate Item Description Color Size qty Price StoreID YearID Brand Name Address CurrID YEARVAL 82605 10828 06-Dec-09 8720400000227 REGULAR CIGARS 1 21.74 TCS 2009 HENRI WINTERMANS Yetty BDS 2009 47075 45036325 26-Aug-08 POSTCARDS POSTCARDS 1 1.4 CS 2008 Guenna BDS 2008 4590 60007295 14-Jan-08 3707-11-6 BLOUSES BLK/MLT L 1 586 CC 2008 GOTTEX Yankee CORAL REEF HOTEL USD 2008 4599 60007301 15/1/2008 3007-319-18 PANTS CORAL XS 1 200 CC 2008 CUT LOOSE Quigly YEARWOOD RD BLK ROCK USD 2008
It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 × 14 BSW. A perpetual inventory system has been used, so you examine this as well as other records and come up with the following data: Cost per tire $35 each Holding cost 20 percent of tire cost per year Demand 1,000 per year Ordering cost $20 per order Standard deviation of daily demand 3 tires Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. Determine the order quantity. Note: Round your answer to the nearest whole number. Determine the reorder point. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the…
(a) Ignoring taxation, calculate the optimum order level of inventory over a one-year planning period using the EOQ model. (b) Estimate the level of safety inventory that should be carried by Toyzrfun Ltd. (c) If Toyzrfun Ltd were to be offered a quantity discount by its suppliers of 1% for orders of 30 000 units or more, evaluate whether it would be beneficial for the company to take advantage of the quantity discount. Assume for this calculation that no safety inventory is carried. (d) Estimate the expected total annual costs of inventory management if the EOQ had been (i) 50% higher, and (ii) 50% lower than its actual level. Comment upon the sensitivity of total annual costs to changes in the EOQ.