5. The demand for a product is 200 units per week, and the items are withdrawn at aconstant rate. The setup cost for placing an order to replenish inventory is RM80. Theunit cost of each item is RM30, and the inventory holding cost is RM26 per item peryear.(i). Assuming shortages are not allowed, calculate the size of the order and thetime the order should be made.(ii). If shortages are allowed but cost RM2 per item per day, identify how often toorder and what size the order should be.

The EOQ model implies steady demand and inventory depletion at a constant pace until it reaches…

Answered: The demand for a product is 200 units…

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

Suppose that the EOQ is 100, average annual demand is1,000 units, and the lead time demand is a random variablehaving the distribution shown in Table 15.a What value of SLM1 corresponds to a reorder pointof 25?b If we wanted to attain a 95% value of SLM1, whatreorder point should we choose?c If we wanted an average of at most two stockouts peryear, what reorder point should we choose? Lead TimeDemand Probability10 16 15 14 20 14 25 112 30 14
A company has an annual demand of 16,000 products. The products cost $2 each. Ordering and transport costs amount to $200 per order. The annual cost of holding one product in stock is estimated to be $1.20 . Assume that the company adopts the EOQ as its order quantity and it has to have half of the EOQ as inventory on hand when an order is placed. How many weeks does it take for an order to be delivered to the company? (1 year = 52 weeks) A) PPE may be credited by 2 million dollarsB) Revaluation OCI may be credited by 3,3 million dollarsC) Accumulated depreciation may be debited by 4 million dollarsD) Accumulated depreciation may be credited by 1,3 million dollarsE) Other (Please Specify)
The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of I = 27% per year. Determine (b) the order frequency,
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?
Problem 20-39 (Algo) CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper $ 0.84 per pound up to 2,499 pounds $ 0.83 per pound for orders between 2,500 and 4,999 pounds $ 0.81 per pound for orders 5,000 pounds or greater Annual demand 54,000 pounds per year Holding cost 25 percent per unit per year of the price of the copper Ordering cost $ 30 Which quantity should be ordered? Quantity_____________pounds
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,…
CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper $ 0.79 per pound up to 2,999 pounds $ 0.78 per pound for orders between 3,000 and 5,999 pounds $ 0.76 per pound for orders 6,000 pounds or greater Annual demand 50,000 pounds per year Holding cost 20 percent per unit per year of the price of the copper Ordering cost $ 30 Which quantity should be ordered?
An organization manufactures supplies for landscaping companies which has an annual demand of 16,000. The cost of storing each unit is $2.5/year and $50 to make an order. Say the company has 300 days of annually, answer the following questions: a. What is the optimal order quantity? b. How many orders in a year? c. How many days between orders? d. How much is the total inventory cost?
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 annual demand, ordering cost, and the annual inventory carrying cost rate for a certain item are 600 units, Quantity 1 to 49 50 to 249 250 and up Price $5.00/unit $4.50/unit $ 4.10/unit $20/order and 30% of item price, respectively. (a) Assume the discounts applied to all the units in the order, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost. (b) Assume the discounts applied to the units are incremental, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost.
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?
Malburn Construction Ltd. Manufactures and distributes window frames. The company uses 600,000metal strips in producing the frames for the year. Each strip cost $15, the storage cost is 10% of the costprice and $180 is required to make an order. Suppose Malburn Construction has acquired the necessary capital investments such that the metal stripcould be produce at its own factory at a rate of 800,000 metal strips per annum. Calculate:(i). the economic batch order quantity (ii). the number of runs per year. (iii). the length of the cycle in days (iv). the run time in days (v). the effective replenishment per year (vi). the peak inventory level (vii). the annual storage cost (viii).the annual ordering cost

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS