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.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The two most important inventory-based questionsanswered by the typical inventory model are:a) when to place an order and the cost of the order.b) when to place an order and how much of an itemto order.c) how much of an item to order and the cost of the order.d) how much of an item to order and with whom theorder should be placed.
Penalty costs can be assessed only against the number of units of demand that cannot be satisfied, or against the number of units weighted by the amount of time thatan order stays on the books. Consider the following history of supply and demandtransactions for a particular part:Number of Items Demand duringMonth Received MonthJanuary 200 520February 175 1,640March 750 670April 950 425May 500 280June 2,050 550Assume that starting inventory at the beginning of January is 480 units.a. Determine the ending inventory each month. Assume that excess demands areback-ordered.b. Assume that each time a unit is demanded that cannot be supplied immediately,a one-time charge of $10 is made. Determine the stock-out cost incurred duringthe six months (1) if excess demand at the end of each month is lost, and (2) ifexcess demand at the end of each month is back-ordered.c. Suppose that each stock-out costs $10 per unit per month that the demandremains unfilled. If demands are filled on a first-come,…
Given 150 units of beginning inventory, a lead time of oneperiod, an ordering cost of $400 per order, and a holdingcost of $2 per unit per period, determine which lot sizing technique would result in the lowest total cost for the fol-lowing demand data. Period 1 2 3 4 5 6 7 8Gross Requirements 100 90 85 70 150 200 300 250
Banana Inc. a Company that markets skin care products . The annual demond is 2400 units and ordering cost is 10 per order . The holding cost per year is 0.30 .Amount of the working days of the is 250 days in a year , Lead time of the order is 2 days . a. What is the optimal order size? b. What is the optimal number of orders per year? c. What is the optimal number of days between orders? d. What is the annual inventory cost? e. If the lead time were 2 days, what would be the reorder point? f. For what value of ordering cost would 1000 units of order size be optimal? g. Determine how often the firm should order. h. Determine the size of each order ı. At what price should the firm order?
Rick Jerz is attempting to perform an inventory analysison one of his most popular products. Annual demand for thisproduct is 5,000 units; ca rrying cost is $50 per unit per year; ordercosts for his company typically run nearly $30 per order; and leadtime averages I 0 days. (Assume 250 working days per year.)a) What is the economic order quantity?b) What is the average inventory?c) What is the optimal number of orders per year?d) What is the optimal number of working days between orders?e) What is the total annual inventory cost (carrying cost+ ordering cost)?t) What is the reorder poi nt?
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
The EOQ model with quantity discounts attempts todetermine:a) the lowest amount of inventory necessary to satisfy acertain service level.b) the lowest purchase price.c) whether to use a fixed-quantity or fixed-period orderpolicy.d) how many units should be ordered.e) the shortest lead time
The purpose of EQQ is: A. measure the cost of ordering inventory B. to lower the level of inventory C. to determine the optimal amount of inventory to order D. to find the number of days before inventory needs to be reordered
Do all work in Excel with Formulas An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days. a. Find the optimal order quantity. b. What is the reorder point? c. How often should an order be placed? d. What is the cycle time?
please solve D,E and F (a) What is the expected jet fuel yearly average demand D? =4160 tons(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2(d) Given the EOQ, what is the total inventory ordering cost?(e) Given the EOQ, what is the total annual inventory cost?(f) What is the time between orders in weeks?
A company manufactures two products A and B. Each A requires two C’s and one D. Each D requires two F’s and one E, while each E requires one F. Each product B requires one D and two E’s. The table below shows data from the inventory records. ITEM ITEM ITEM ITEM DATA CATEGORY C D E F Lot - sizing rule Fixed Order Quantity = 220 Lot for Lot Fixed Order Quantity = 300 Period Order Quantity P = 2 Lead time 3 weeks 2 weeks 3 weeks 2 weeks Scheduled receipts 280 (week 1) None 300 (week 3) None Beginning inventory 25 0 150 600 The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5.Develop the material requirements plan (showing Gross requirements, Scheduled receipts, On hand inventory, Net requirements, and Planned-order release) for the next six weeks for items C, D, E and F.
What changes can you envisage in economic order quantity based planning when the demand for the item increases by 5%? A) The economic order quantity will come down by √(5%) B) The carrying cost will increase by 1/ √(5%) C) The total cost of the plan will go up by √(5%) D) The total cost of the plan will go up by 5%