Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.PARAMETERItem costOrder costAnnual holding costAnnual demandAverage weekly demandStandard deviation of weekly demand.Lead time.Service probabilityOptimal order quantityReorder pointunitsunitsVALUE$12.00$194.00/order21% of item cost24,700 units494 /week20 units2 week95%a. Determine the order quantity and reorder point. (Use Excel's NORMSINV() function to find your z-value and then round that z-value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers to the nearest wholenumber.) b. Determine the annual holding and order costs. (Do not round any intermediate calculations. Round your final answers to 2decimal places.)Holding costOrdering costc. Assume a price break of $55 per order was offered for purchase quantities of 2,000 units per order. If you took advantage of thisprice break, how much would you save annually? (Do not round any intermediate calculations (including number of setups peryear). Round your final answer to 2 decimal places.)Annual savings

Inventory management refers to the process of overseeing and controlling the flow of goods and…

Answered: Given the following information,…

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

Classify the items in a warehouse inventory using the ABC method, where Group A contributes 80%, Group B contributes 15%, and Group C contributes 5% to the total inventory value Product Code Annual Demand Pick List Frequenscy Weighted Volume Weighthed Percentage Comulative Weight Percentage ABC Category A001 20000 2200 A002 19000 1700 A003 7800 700 A004 9840 1400 A005 16000 1300 A006 12000 2000 A007 9950 400 A008 10500 1700 A009 8200 515 A010 4700 258 A011 5100 367 A012 8800 800 A013 8900 711 A014 15000 1900 A015 7900 350 A016 9620 2000 A017 8800 550 A018 25000 2000 A019 9950 380 A020 10500 1100
Alpha Products, Inc., is having a problem trying to control inventory. There is insufficient time to devote to all its items equally. The following is a sample of some items stocked, along with the annual usage of each item expressed in dollar volume. ITEM ANNUAL DOLLAR USAGE ITEM ANNUAL DOLLAR USAGE a S 30, 100 k S 1,700 b 27,000 120,000 c 93,000 m 111,000 d 1,400 n 3,000 e 1,800 o 500 f 30,000 p 114, 000 g 1,600 q 2,600 h 2,500 г 28,000 i 3, 200 s 2, 800 j 1,500 t 3, 100 a. Suggest a system for allocating control time? multiple choice ABC analysis Cycle counting b. Specify where each item from the list would be placed.
A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days) when a salesperson visits from one of the pharmaceutical companies. Tetracycline is one of its most prescribed antibiotics, with average daily demand of 2,000 capsules. The standard deviation of daily demand was derived from examining prescriptions filled over the past three months and was found to be 800 capsules. It takes f ive days for the order to arrive. University Drug would like to satisfy 99 percent of the prescriptions. The salesperson just arrived, and there are currently 25,000 capsules in stock.How many capsules should be ordered?
Paulin’s muffler shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information table to determine the optimal inventory target level (or order-up to level). Annual demand 3,910 mufflers ordering cost $75 per order S/D of daily demand 6 mufflers/wk. day service probability 87% Item cost $ 27.00 per muffler lead time 2 wk. Days Annual holding cost 36 % of item value wk. Days 230 per year Review period 18 working days What is the optimal target levels (order up to levels) use excels NORMSINVI() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round value 2 decimal places and final answer to the nearest whole number If the service probability is 90%, the optimal target level will increase, decrease or…
Kabel Market store sells electric cable. The demand for cable is normally distributed. The inventory related information at Kabel Market is as follows: Average Annual Demand = 16,900 meters Standard deviation of weekly demand = 28 meters Cable selling price = AMD 640.00 per meter Ordering cost = AMD 1,250.00 per order Lead time = 5 weeks Annual inventory-holding cost estimate = 2.5% of the cable selling price Required service level = 95% Kabel Market works 52 weeks a year. Note: The approximate z values are: for 0.9 ≈ 1.28, for 0.92 ≈ 1.405, for 0.95 ≈ 1.645, for 0.98 ≈ 2.05. Suppose the bar management practices the fixed-QUANTITY ordering system with the use of the economic order quantity. Answer the following questions: (i) How many meters of cable they order from the supplier each time? (ii) When do they place an order? (iii) What is the safety stock?
The Allianz Company produces a specialty wood furniture product, and has the following information available concerning its inventory items: Relevant ordering costs per purchase $550 order Relevant carrying costs per year for each package: Required annual return on investment Required other costs per year 17% $7 Annual demand is 30,000 packages per year. The purchase price per package is $53. Which of the following statements is true of Allianz's EOQ system costs? O At EOQ, the annual relevant ordering costs is exactly the half of annual relevant carrying costs. O At EOQ, the annual relevant carrying costs is exactly the half of the annual relevant total costs. O At EOQ, the annual relevant carrying costs is higher than the annual relevant ordering costs. O At EOQ, the annual relevant carrying costs is equal to the annual relevant total costs.
Reorder Point Ordering: Average demand per day () is 25 units, with a std. dev. of (od) 15 units. Lead time (LT) is 49 days. Find demand during lead time (DDL), safety stock (SS) and reorder point (ROP ) for 4-sigma (z = 4). DDL= 500 units, SS = 1225 units, ROP = 1645 units DDL= 1,645 units, SS=420 units, ROP = 1225 units DDL= 1,225 units, SS = 420 units, ROP = 1645 units DDL= 0 units, SS = 1225 units, ROP = 420 units DDL= 420 units, SS = 1645 units, ROP = 420 units
Please do not give solution in image format thanku Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $1 per order, and carrying costs are 40 cents per roll a year. Lead-time is three days. a) Ignoring the demand uncertainty (i.e., looking only at average values), find the economic order quantity (EOQ) and the reorder point (ROP). b) Consider now the uncertainty. The order quantity remains the same. If the target is to have a 99% annual service level, what should be the ROP
For many firms, inventory usage is not uniformthroughout the year but instead follows some seasonal pattern. Can the EOQ model be used in thissituation? If so, how?

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