Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual demand for this product is 5,000 units; carrying cost is $50 per unit per year; order costs for his company typically run nearly$30 per order; and lead time averages 10 days. (Assume 250 working days per year.)a) The economic order quantity is units (round your response to the nearest whole number).b) The average inventory is units (round your response to the nearest whole number).c) The optimal number of orders per year isorders (round your response to the nearest whole number).d) The optimal number of working days between orders isdays (round your response to two decimal places).e) The total annual inventory cost (carrying cost + ordering cost) is S (round your response to two decimal places).f) The reorder point isunits (enter your response as a whole number).

Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

Answered: Rick Jerz is attempting to perform an…

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

Please do not give solution in image formate thanku Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas's fastest-moving inventory item has a demand of 5,900 units per year. The cost of each unit is $98, and the inventory carrying cost is $11 per unit per year. The average ordering cost is $31 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 118 units. (This is a corporate operation, and there are 250 working days per year). A) What is the EOQ?B) What is the average inventory if the EOQ is used?C) What is the optimal number of orders per year?D) What is the optimal number of days in between any two orders?E) What is the annual cost of ordering and holding inventory?F) What is the total annual inventory cost, including cost of the 6,100 units?
The annual demand of a product is 27.098; the holding cost, h, is $2.46 per unit per year, and the ordering cost, S, is $213 per order. Currently the manager orders 2.583 every time she orders; what is the annual ordering cost, SC?
A. Determine the order quantity. B. Determine the reorder point.
Gentle Ben's Bar and Restaurant uses 7,200 quart bottles of an imported wine each year. The effervescent wine costs $9 per bottle and is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $25 each time an order is placed, and holding costs are 40 percent of the purchase price. It takes six weeks for an order to arrive. Weekly demand is 144 bottles (closed two weeks per year) with a standard deviation of 40 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 99 percent service probability. a. What is the economic quantity for Ben to order? b. At what inventory level should he place an order?
Southern Markets, Inc. is considering the use of ABCanalysis to focus on the most critical SKUs in its inventory.Currently, there are approximately 20,000 different SKUswith a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and thetotal annual dollar usage for A items, B items, and C itemsat Southern Markets, Inc.? b. The following table provides a random sample of the unitvalues and annual demands of eight SKUs. Categorizethese SKUs as A, B, and C items.
EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 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. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity.
Palin’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 in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 2,750 mufflers Ordering cost $ 35 per order Standard deviation of daily demand 6 mufflers per working day Service probability 76 % Item cost $ 28.00 per muffler Lead time 4 working days Annual holding cost 22 % of item value Working days 275 per year Review period 21 working days a. What is the optimal target level (order-up-to level)? If the service probability requirement is 93 percent, the optimal target level will: Increase Decrease Stay the same
If EOQ = 289 units, S = $100, and H = $1 per unit per month, what approx. annual demand (D) level would the EOQ model best fit? Pick the closest answer option. EOQ = Sq root of [(2D*S)/H] D = annual demand in units S = cost of placing 1 order; H = cost of holding 1 unit of that item in inventory for 1 year 3596 units 3540.00 units 5011 units 4510 units
Inventory tracking is concerend both ith the quantity and the location of the goods in inventory. Select one: a. True. b. False.
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.
Blue Wave corp will need 275,000 units of raw materials next year. The purchase price of the raw materials per unit is 950. The ordering cost for each order is 2,000, while the carrying cost is 30% of the average inventory value. Calculate:a. The most economical order quantity (EOQ)b. How many times should the company order in a year?c. How many days should the company place an order once (1 year = 365 days)?
Sunrise Garden Center buys 425 bags of fertilizer per month for feeding and weeding lawns. The ordering cost is $15.00. Holding cost is $0.10 per bag per year. a. How many bags should Sunrise order at a time? Sunrise should order bags at a time. (Enter your response rounded to the nearest whole number.) b. What is the time between orders? The time between orders is months. (Enter your response rounded to one decimal place.)

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