(EOQ calculations) A downtown bookstore is trying to determine the optimal order quantity for a popular novel just printed in paperback. The store feels that the book will sell afour times its hardback figures. It would, therefore, sell approximately 4,000 copies in the next year at a price of $1.50. The store buys the book at a wholesale figure of $1.Costs for carrying the book are estimated at $0.10 a copy per year, and it costs $20 to order more books.a. Determine the EOQ.b. What would be the total costs for ordering the books 1, 4, 5, 10, and 15 times a year?c. What questionable assumptions are being made by the EOQ model?a. What is the economic order quantity (EOQ)?copies (Round to the nearest whole number.)GULD

Answered: (EOQ calculations) A downtown bookstore…

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

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
A sporting goods company has a distribution center that maintains inventory of fishing rods. The fishing rods have the following demand, lead time, and cost characteristics: Average demand = 130 units per day, with a standard deviation of 12 units Average lead time = 12 days with a standard deviation of 1 day 250 days per year in the business year Unit cost = $28 Desired service level = 97.5% Ordering cost $53 Inventory carrying cost = 25% a. What is the standard deviation of demand during lead time? b. How many fishing rods should the distribution center carry to provide the desired service level? c. What is the EOQ? d. What is the average cycle stock?
United Airlines has an agreement to buy jet fuel from Exxon. The goal is to minimize total cost (i.e., ordering cost + holding cost). The annual demand for fuel is 201,000 barrels. Exxon charges United $3740 to process each order. United incurs a holding cost of $20 per barrel. When purchasing using the EOQ (from last question), what is the order cycle time (days between orders) for United? Note: round your answer to the nearest 1 decimal place. For example, answer like 12.3 Answer: Check
The Petroco Company uses a highly toxic chemical in one of its manufacturing processes. It must have the product delivered by special cargo trucks designed for safe shipment of chemicals. As such, ordering (and delivery) costs are relatively high, at $2,600 per order. The chemical product is packaged in 1-gallon plastic containers. The cost of holding the chemical in storage is $50 per gallon per year. The annual demand for the chemical, which is constant over time, is 2,000 gallons per year. The lead time from time of order placement until receipt is 10 days. The company operates 310 working days per year. Compute the optimal order quantity, the total minimum inventory cost, and the reorder point.
A store has collected the following information on one of its products:Demand = 4,500 units/year Standard deviation of weekly demand = 12 units Ordering costs = $40/order Holding costs = $3/unit/year Cycle-service level = 90% (z for 90% = 1.28) Lead-time = 2 weeks Number of weeks per year = 52 weeks a. If a firm uses the continuous review system to control the inventory, what would be the order quantity and reorder point?
A restaurant uses 5,000 quart bottles of ketchup each year. The ketchup costs $3.00 per bottle and is served only in whole bottles because its taste quickly deteriorates. The restaurant figures that it costs $10.00 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes 3 weeks for an order to arrive. The restaurant operates 50 weeks per year. The restaurant would like to use an inventory system that minimizes inventory cost. The restaurant has figured that the most economical order size or EOQ is approx. 409 (rounding up the decimals). Suppose that things have become uncertain and that customer demand is no more constant. Customer demand is now normally distributed with mean being the same as given in the problem description and standard deviation = 30 units per week. The supply source is still very reliable and as a result the lead time is constant. Find out the safety stock needed to achieve 95% customer service level. O 55 65 075 85 None of…
David's Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold's accountant, Irving Wu, recommendsan annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance. How many salamis should Gold have on hand when he phones his brother to send another shipment?
David’s Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold’s accountant, Irving Wu, recommends an annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance.a. How many salamis should Gold have flown in and how often should he order them?b. How many salamis should Gold have on hand when he phones his brother to send another shipment?c. Suppose that the salamis sell for $3 each. Are these salamis a profitable item for Gold? If so, what annual profit can he expect to realize from this item? (Assume that he operates the system optimally.)d. If the salamis…
Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs, are forcing GGIL, to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such a shortage costs. Table 10 is a random sample of 20 GGIL's items. Table 10. Annual Usage by Value of a sample of GGIL's Inventory Item Number Annual Usage ($) Item Number Annual Usage ($) 1 10,600 11 2,750 2 14,000 12 1,400 3 4,000 13 3,200 4 16,000 14 2,500 5 8,100 15 110,000 1,800 16 14,800 7 84,000 17 9,500 8. 890 18 1,700 9 940 19 3,700 10 94,000 20 12,500 a) What would you recommend GGIL to do to cut back its labor cost? (Illustrate using an ABC plan). b) Item 18 is critical to continued operations at GGIL. i. How would you recommend it be classified? ii. Give the reason(s) for your answer.
A golf specialty wholesaler operates 50 weeks per year. Management is trying to determine an inventory policy for its 1-irons, which have the following characteristics: > Demand (D) = 2,000 units/year > Demand is normally distributed > Standard deviation of weekly demand = 2 units > Ordering cost = $30/order > Annual holding cost (H) = $5.00/unit > Desired cycle-service level = 85% > Lead time (L) = 4 weeks Refer to the standard normal table for z-values. a. If the company uses a periodic review system, P should be 3.87 weeks. (Enter your response rounded to the nearest whole number.) T should be units. (Enter your response rounded to the nearest whole number.)
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
The amount of denim used daily by the Southwest ApparelCompany in its manufacturing process to make jeans isnormally distributed with an average of 4000 yards ofdenim and a standard deviation of 600 yards. The lead timerequired to receive an order of denim from the textile mill is a constant 7 days. Determine the safety stock and re-order point if the company wants to limit the probability of a stockout and work stoppage to 5%.

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