The annual demand, ordering cost, and the inventory carrying cost rate for a certain itemare D = 960 units, S= $5/order, and I= 20% of item price. Current price is $19.2 per unit(without any discount). Price is established by the following quantity discount schedule.What should the order quantity be in order to minimize the total annual cost? Show yourworkOrder Quantity 1 to 50 51 to 100PriceNo discount 20% discount 40% discounto,101 and upWhat should the order quantity be in order to minimize the total annual cost? Show yourwork.D-960S-551-20%CURRENT PRICE-19.20

Find the Given details below: Given details: Annual Demand (D) 960 Units Ordering cost (S)…

Answered: The annual demand, ordering cost, and…

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

The sales of Whole Care mouthwash at Jen's of Michigan over the past six months have averaged 2,000 cases per month, which is the current order quantity. Jen's of Michigan's cost is $12.00 per case, and ordering cost is $38. The company estimates its cost of capital to be 12 percent. Insurance, taxes, breakage, handling, and pilferage are estimated to be approximately 6 percent of the item cost. Lead time is 3 days, and considering weekends and holidays, Tom's of Maine operates 250 days per year. Based on the above information please answer the following questions What is EOQ? What is the cost reduction? What is the reorder point? What is Time between Orders (TBO)?
The sales of Whole Care mouthwash at Tom's of Maine over the past six months have averaged 2,000 cases per month, which is the current order quantity. Tom's of Maine's cost is $12.00 per case, and ordering cost is $38. The company estimates its cost of capital to be 12 percent. Insurance, taxes, breakage, handling, and pilferage are estimated to be approximately 6 percent of the item cost. Lead time is 3 days, and considering weekends and holidays, Tom's of Maine operates 250 days per year. Based on the above information please answer the following questions a) What is EOQ? b) What is the cost reduction? c) What is the reorder point? d) What is Time between Orders (TBO)?
Daily demand for product sample kits is normally distributed with a mean of 35 units and a standard deviation of 4. Supply is virtually certain with a lead time of 9 days. The cost of placing an order is $20, and annual carrying costs for one kit is 25 percent. The price of one kit is $12.50. Assume a year has 365 days.If a 99% service level is desired, what is average inventory on hand? If demand had no variation, what would the reorder point be?
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?
B). As an inventory manager, you must decide on the order quantity for an item. Its annual demand is 679 units. Ordering costs are $7 each time an order is placed, and the holding cost is 10% of the unit cost. Your supplier provided the following price schedule. Quantity Price per Unit 1 - 100 $5.65 101 - 350 $4.95 351 or more $4.55 What ordering-quantity policy do you recommend?
The annual demand, ordering cost, and the annual inventory carrying cost rate for a certain item are 600 units, Quantity 1 to 49 50 to 249 250 and up Price $5.00/unit $4.50/unit $ 4.10/unit $20/order and 30% of item price, respectively. (a) Assume the discounts applied to all the units in the order, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost. (b) Assume the discounts applied to the units are incremental, what should the order quantity be in order to minimize the average annual cost? Also, show the minimal average annual cost.
A material manager adopts the policy to place an order for a minimum quantity of 500 of a particular item in order to avail a discount of 10 percent. It was found from the company records that for last year 8 orders were placed each of size 200 Nos, ordering cost is ksh 500 per order. Inventory carrying charges at 40 per cent cost unit is ksh 400. (a) Show whether the purchase manager is justified in his decision (b) What is the effect of this decision on the company
Explain the relationship between the annual ordering cost and the ordering size. Why is there a need to compute for the Economic order quantity?
Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
Apply the EOQ model to the following quantity discount situation in which D=500 units per year, C0=$40, and the annual holding cost rate is 20%. What order quantity do you recommend? Discount Category Order Size Discount (%) Unit Cost 1 0 to 99 0 $10 2 100 or more 3 $9.70
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.16 per unit and sells for $1.75 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.)
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.17 per unit and sells for $1.75 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 a = 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.

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