The annual demand for sugar at a local soft drink company is normally distributed with a mean of 800 tons and a standard deviation of 25 tons. The sugar sells for OMR 500 each ton, and the annual inventory holding cost rate is 10%. Ordering costs are OMR5 per order. The delivery time for sugar is 5 working days. Assume that there are 250 working days in a year. 1. Determine the optimal order quantity. 2. What size of safety stock should the company keep at a service-level of 90%? 3. Suppose they keep 8 extra tons in inventory as a safety stock. What is the service-level obtained?

The annual demand for sugar at a local soft drink company is normally distributed with a mean of 800 tons and a standard deviation of 25 tons. The sugar sells for OMR 500 each ton, and the annual inventory holding cost rate is 10%. Ordering costs are OMR5 per order. The delivery time for sugar is 5 working days. Assume that there are 250 working days in a year. 1. Determine the optimal order quantity. 2. What size of safety stock should the company keep at a service-level of 90%? 3. Suppose they keep 8 extra tons in inventory as a safety stock. What is the service-level obtained?

Name: The annual demand for sugar at a local soft drink company isnormally
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: The annual demand for sugar at a local soft drink company isnormally distributed with a mean of 800 tons and a standarddeviation of 25 tons. The sugar sells for OMR 500 each ton, andthe annual inventory holding cost rate is 10%. Ordering costs areOM

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

Custom Computers, Inc. assembles custom home computersystems. Th e heat sinks needed are bought for $12 each and areordered in quantities of 1300 units. Annual demand is 5200 heatsinks, the annual inventory holding cost rate is $3 per unit, andthe cost to place an order is estimated to be $50. Calculate thefollowing:(a) Average inventory level(b) Th e number of orders placed per year(c) Th e total annual inventory holding cost(d) Th e total annual ordering cost(e) Th e total annual cost
The annual demand for sugar at a local soft drink company is normally distributed with a mean of 800 tons and a standard deviation of 25 tons. The sugar sells for OMR 500 each ton, and the annual inventory holding cost rate is 10%. Ordering costs are OMR5 per order. The delivery time for sugar is 5 working days. Assume that there are 250 working days in a year. 1. Determine the optimal order quantity. 2. What size of safety stock should the company keep at a service-level of 90%? 3. Suppose they keep 8 extra tons in inventory as a safety stock. What is the service-level obtained? 4. Evaluate the fill rate Beta for a safety stock of 5 tons. 5. What is the expected number of units short per year? 6. Compare the level of safety stock for each policy =Beta=0.95.
9. A local retailer anticipates an annual demand 12000 units of a product. The retailers allows shortages for that product, and these shortages are backordered at a rate of 3 OMR per unit backordered. The cost of ordering is 300 OMR whereas , the annual holding cost is 1 OMR per unit. The retailer operates 300 days per year . What is the optimal backorder (shortage ) level in units? Round -up to the nearest integer a. 633 b. 1550 C. None is correct d. 860 e. 775 f. 895
Dave's Sporting Goods sells Mountain Mouse freeze-dried meals. Dave's uses a continuous review system to manage meal inventories. Suppose Mountain Mouse offers the following volume discounts to its customers: 1−950 meals: $6.50 per meal 951 or more meals: $4.50 per meal. Annual demand is 2,900 meals, and the cost to place an order is $23. Suppose the holding cost is $1.50 per meal per year. How many meals should Dave's order at a time? Part 2 Dave's Sporting Goods should order ______ meals at a time to take advantage of the lower cost per unit. (Enter your response rounded to the nearest whole number.)
The sales of a popular mouthwash at Merkle Pharmacies over the past 6 months have averaged 1,800 cases per month resulting in 21,600 cases per month, which is the current order quantity. Merkle’s cost is $14.00 per case. The company estimates its cost of capital to be 10 percent. Insurance, taxes, breakage, handling, and pilferage are estimated to be approximately 5 percent of item cost. Thus, the annual inventory-holding costs are estimated to be 15 percent of item cost. The cost of placing an order is estimated to be $36.00 per order regardless of the quantity requested in the order. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. 1. What is the minimum-cost economic order quantity? Round your answer to the nearest whole number. fill in the blank 2 cases 2. What is the annual ordering cost based on the minimum-cost economic order quantity? Use the rounded EOQ value in your…
Custom Computers, Inc. assembles custom home computer systems. The heat sinks needed are bought for $12 each and are ordered in quantities of 1300 units. Annual demand is 5200 heat sinks, the annual inventory holding cost rate is $3 per unit, and the cost to place an order is estimated to be $50. Calculate the following: (a) Average inventory level (b) The number of orders placed per year (c) The total annual inventory holding cost (d) The total annual ordering cost (e) The total annual cost
Millennium Liquors is a wholesaler of sparkling wines. Its most popular product is theFrench Bete Noire, which is shipped directly from France. Weekly demand is 45 cases.Millennium purchases each case for $120, there is a $300 fixed cost for each order(independent of the quantity ordered), and its annual holding cost is 25 percent.a. What order quantity minimizes Millennium’s annual ordering and holding costs?b. If Millennium chooses to order 300 cases each time, what is the sum of its annualordering and holding costs?c. If Millennium chooses to order 100 cases each time, what is the sum of the orderingand holding costs incurred by each case sold?d. If Millennium is restricted to ordering in multiples of 50 cases (e.g., 50, 100, 150, etc.),how many cases should it order to minimize its annual ordering and holding costs?e. Millennium is offered a 5 percent discount if it purchases at least 1000 cases. If itdecides to take advantage of this discount, what is the sum of its annual…
A product is made-to-stock. Annual demand is 60,000 units. Each unit costs $4.00 and theannual holding cost rate = 25%. Setup cost to produce this product is $300. Determine:1. Economic order quantity and2. Total inventory costs for this situation.
1. David and Beth Sheba run a health food store. Their top selling item is called Heavenly Kelp. The annual demand for this is 3200 units, and demand is constant throughout the year. The cost of placing an order is $100, while the holding cost per unit per year is $4. How many orders per year should be placed if they wish to minimize their total cost ? If you want to be eligible for partial credit, give an idea as to how you arrived at that number?
Rafiki Bar uses 10,000 cases of millet beer monthly. One case costs Shs.5,000. Holding cost is 30% of the cost of a case p.a while ordering cost is Shs.100,000 per order. The firm works 360 days in a year while lead time is 6 days. Required: ii. Determine the days between orders and the reorder point iii. Determine the total cost of the inventory policy iv. Suppose actual holding cost turns out to be 15% instead of 30% and the inventory policy above is implemented for a year, determine the cost of prediction error if every other parameter estimate turns out as predicted.
4 In the EOQ model, determining the optimal order quantity requires us to ______. a increase number of orders along with quantity ordered at any time b strike a balance between quantity and quality of materials ordered c strike a balance between ordering and holding costs d increase number of orders depending on the volume discounts provided 6 The total cost in the EOQ is ______. a insensitive to minor deviations in the order quantity from the EOQ amount b sensitive to minor deviations in the order quantity from the EOQ amount c insensitive to major deviations in the order quantity from the EOQ amount d sensitive to deviations in the order quantity from the EOQ amount by more than 20% 7 Sales and operations planning deal with ______ decision-making. a strategic b tactical c operational d weekly
Each year, Y Company purchases 20,000 units of an item that costs P 640 per unit. The cost of placing an order is P 480, and the cost to hold the item in inventory for one year is P 150. What is the average inventory level, assuming that the minimum inventory level is zero? 2.Determine the total annual ordering cost and the total annual holding cost for the item if the EOQ is used.