The facility manager for the buildings on the campus of a company that designs video games is considering the inventory policy for hand sanitizer. Apply the EOQ model to thefollowing quantity discount situation for which D-600 units per year, C. $45, and the annual holding cost rate is 20%. (Round your answers to the nearest integer)Discount CategoryDiscount (%) Unit Cost$10.0012Order Size100 or moreWhat order quantity do you recommend?09₁9₂Since Q, is over0 to 9903$9.70its limit of 99 units, Q, cannot beOrder QuantityQ₁-789₂-79xx

Find the given details below: Annual Demand (D)600Ordering cost (S) $ 45Per…

Answered: The facility manager for the buildings…

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

Andy's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year to assemble Uediracs for sale. Tegdiws are used at a relatively constant rate but the use of Widgets vary with demand. Andy wants to improve his inventory management system and use either a "P" system or a "Q" system. What are the advantages and disadvantages of each system in this application and what information is needed to choose between them?
A daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.14 per unit and sells for $1.55 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with µ = 150 and σ = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.) What happens to the coffee shop's order quantity as the rebate is reduced? The higher rebate ---Select--- ▾ the quantity that the coffee shop should order.
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. Annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. d) If order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost?
A store sells university coffee mugs. Daily demand is 25 mugs with a standard deviation of 4 mugs per day. Each mug costs $7.85. Ordering costs are $11. The carrying costs are $2 per year. The store is open 250 days per year. Lead time is 6 days with a standard deviation of 1.6 days. Desired service level is 98%. Calculate the EOQ (round your answer to the nearest whole number) 2. CAREFUL! YOUR NUMBERS HAVE CHANGED A store sells university logo hats. Daily demand is 22 hats with a standard deviation of 4 hats per day. Each hat costs $7.85. Ordering costs are $12. The carrying costs are $1 per year. The store is open 250 days per year. Lead time is 4 days with a standard deviation of 1.6 days. Desired service level is 98%. Calculate the ROP with safety stock.
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?
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?
A computer products store stocks color graphics monitors, and the daily demand is normally distributed with a mean of 1.6 monitors and a standard deviation of 0.4 monitor. The lead time to receive an order form the manufacturer is 15 days. Q 17.1- Determine the reorder point that will achieve 98 % service level.
Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year the mean weekly demand for a special type of tubing was 186 packages of this tubing with a standard deviation of 13 packages of tubing. The lead time for receiving this tubing from the supplier is 1.5 weeks. Peter would like to maintain a 95% service level and places an order for 750 packages every time an order is placed. d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99% service level)? e) If the carrying cost per year is $0.50/unit/year - what is the additional cost associate with the 99% service level compared to 95% service level (i.e. cost of safety stock at 99% level - cost of safety stock at 95% service level)?
Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,200 units. Southeastern estimates its annual holding cost for this item to be 323 per unit. The cost to place and process an order from the supplier is $73. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order quantity? units (round your response to the nearest whole number). b) What are the annual holding costs? $ (round your response to the nearest whole number) c) What are the annual ordering costs? S (round your response to the nearest whole number). d) What is the reorder point? units (round your response to the nearest whole number).
A company has been approached by their supplier who would be willing to offer a discount of 5% on orders over 500 units. Information regarding current inventory costs is as follows: Holding cost per unit per annum 10% of purchase price Ordering costs = $2 per order Annual demand = 15,000 units Purchase price 200 units Identify which option is better for the company. $15 per unit Current EOQ quantity = = =
kai
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…

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