Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 405 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 = 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 = units (round your response to the nearest whole number).A

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

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).
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 390 units. Ordering cost is $47; 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? EQQ = 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 = units (round your response to the nearest whole number).
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.)
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 405 units. Ordering cost is $46; 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).
the company expects to sell 19,200 units next year. it operates 360 days a year. annual carrying cost is P32 per unit ordering cost is P150. A. what is the length of an order cycle in days? (4 decimals) B. what is the total annual cost at EOQ? show solution
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.
Suppose that R&B Company has a soft drink product that shows a constant annual demand rate of 3600 cases. Ordering costs are $20 per order and holding costs are $0.77. Find the EOQ. Round to two decimal places. __________________ Find the order cost using the EOQ as the quantity. Round to two decimal places. _________________
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?
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?
RonaMart needs 1,000 coffee makers per year. The cost of each coffee maker is $78. Ordering cost is $100 per order. Carrying cost is $20 of unit cost. Lead time is 5 days. RonaMart is open 360 days/yr. What is EOQ model? How many times per year does the store reorder?
Please do not give solution in image format thanku Daily demand for Chandler's Footballs varies according to the normal distribution with a mean of 195 and a standard deviation of 12. The lead time is 3 days. If Chandler wants a 98.5% level of service, what should his reorder point be?
Demand (D) 85 tablets/week Working weeks per year 52 weeks Unit holding cost per year (H) $6 Order cost (S) $44/order Standard deviation of weekly demand (sd) 15 tablets Lead time (L) 2 weeks Desired cycle service level 95% If the pharmacist uses the continuous review (Q) system to control the inventory of the drug, what would be the order quantity and reorder point?

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