tory Management 1my instructorZO Points: 0 of 1KMatthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 400 units. Ordering cost is $40; holding cost is $5 per unit per year.a) To minimize the total cost, how many units should be ordered each time an order is placed?EOQ = units (round your response to the nearest whole number).2WSX#3E20D$4CRF%5VTG6Part 1 of 2MacBook ProBYH&7NUJ8DIIIM(9KDDDOV10LcommandF 10P:Clear all;F11option{[+?1Check answerF12}Save1deletereturnA

EOQ is determined with following formula EOQ = 2*Annual demand*Carrying costHolding cost

Answered: Matthew Liotine's Dream Store sells…

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

Thomas Kratzer is the purchasing manager for theheadquarters of a large insurance company chain with a centralinventory operation. Thomas’s fastest-moving inventory item hasa demand of 6,000 units per year. The cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. The aver-age ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is acorporate 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 the cost ofthe 6,000 units?
Sunrise Garden Center buys 375 bags of fertilizer per month for feeding and weeding lawns. The ordering cost is $10.25. 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.)
Given Information Service Level - 95% (z value= 1.6649) Order Cost - $125Order Cycle (weeks) - 4, 5, 6, 7, 8Lead Time (weeks) - 2 weeksOperating Time - 52 weeks Standard deviation = 69.3237 Variable Holding Cost - 12.019% Fixed Holding Cost - 1,659,317.307 COMPUTE FOR ECONOMIC ORDER QUANTITY (EOQ) PER ORDER CYCLE. THANK YOUUUUU
40) PLEASE HELP WITH THIS! Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The effervescent wine costs $3 per bottle and Is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 100 bottles (closed two weeks per year) with a standard devlation of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 95 percent service probability. b. At what inventory level should he place an order? Note: Use Excel's NORM.S.IN( function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number.
weekly demand for hamleys (a famous toy brand) at a toy store is normally disrtibuted with a mean of 250 and a standrd devaiton of 150.Ther toy store is opened 7 days a week.The toy store owner continoulsy monitors the inventory .Hamleys takes 2 weeks to fill an order with a standard devaiton of 4 days. 1] how much inventory should the sotre carry at the reorder point. 2] how much inventory would that be at the reorder point if the cycle service was increased to 98%?
Given Information Service Level - 95% (z value= 1.6649) Order Cost - $125Order Cycle (weeks) - 4, 5, 6, 7, 8Lead Time (weeks) - 2 weeksOperating Time - 52 weeks Standard deviation = 69.3237 Variable Holding Cost - 12.019% Fixed Holding Cost - 1,659,317.307 QUESTION: Compute for annual variable holding cost. Formula Given: (EOQ/2) x (Unit cost x Percentage Value of Inventory)
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
Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 3,000 rolls. The cost per roll is $1,000, and the annual holding cost is 28 percent of the cost. Each order costs $75. Part 2 a. How many rolls should Yellow Press order at a time? Yellow Press should order enter your response here rolls at a time. (Enter your response rounded to the nearest whole number.) Part 3 b. What is the time between orders? (Assume 200 workdays per year.) The time between orders is enter your response here days. (Enter your response rounded to one decimal place.)
Discount-Mart, a major East Coast retailer, wants todetermine the economic order quantity (see Chapter 12 for EOQformulas) for its halogen lamps. It currently buys all halogenlamps from Specialty Lighting Manufacturers in Atlanta. Annualdemand is 2,000 lamps, ordering cost per order is $30, and annualcarrying cost per lamp is $12. a) What is the EOQ?b) What are the total annual costs of holding and ordering(managing) this inventory?c) How many orders should Discount-Mart place with SpecialtyLighting per year?
Weekly Mean of 25. Weeklly standard Deviation is 7. Ordering cost per order is $20. cost per ballon is $5. Store uses a 20% annual holding cost. Lead time is 3 weeks. Working days per year are 300 days. Acceptable probability is 10%. What is the annual demand for above? ___________ What is the Annual ordering cost O? ____________
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 400 units. Ordering cost is $38;holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? EOQ = enter your response here units (round your response to the nearest whole number). b) If the holding cost per unit was $6.00 instead of $5, what would the optimal order quantity be? New EOQ = enter your response here units (round your response to the nearest whole number).

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