A company stocks an item that is consumed at the rate of 30 units each day. Every time an order is placed for new supply, $ 120 must be paid. A unit inventory held in stock for one week will cost $ 0.14. What is the total annual cost if the order quantity is 200 more than EOQ? What is the optimum number of orders (rounded to the closest integer) that the company has to place each year? Assume that the company has a standing policy of not allowing shortages in demand.

A company stocks an item that is consumed at the rate of 30 units each day. Every time an order is placed for new supply, $ 120 must be paid. A unit inventory held in stock for one week will cost $ 0.14. What is the total annual cost if the order quantity is 200 more than EOQ? What is the optimum number of orders (rounded to the closest integer) that the company has to place each year? Assume that the company has a standing policy of not allowing shortages in demand.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

A firm experiences demand with a mean of 100 units perday. Lead time demand is normally distributed, with a meanof 1,000 units and a standard deviation of 200 units. It costs$6 to hold one unit for one year. If the firm wants to meet90% of all demand on time, what will be the annual cost ofholding safety stock? (Assume that each order costs $50.)
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
A product is ordered once each year, and the reorder point without safety stock (dL) is 100 units. Inventory carrying cost is $10 per unit per year, and the cost of a stockout is $50 per year. Given the following demand probabilities during the reorder period, how much safety stock should be carried? DEMAND DURING REORDER PERIOD PROBABILITY 0 .1 50 .2 ROP 100 .4 150 .2 200 .1
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?What quantity discount should the manufacturer offer the retailer in order to minimize the total supplychain costs? Under this quantity discount, what are the new retailer and manufacturer costs? Does theretailer choose to use the quantity discount? PLEASE SHOW ALL CALUCALTIONS/EXCEL MODEL
A firm experiences demand with a mean of 100 units per day. Lead time demand is normally distributed with mean 1000 units and standard deviation 200 units. It costs $6 to hold one unit for one year. If the firm wants to meet 90% of all demand on time, what is the expected annual cost of holding safety stock? Assume that each order costs $50.
The best quantity to order One of the formulas for inventorymanagement says that the average weekly cost of ordering, payingfor, and holding merchandise iswhere q is the quantity you order when things run low (shoes,TVs, brooms, or whatever the item might be); k is the cost ofplacing an order (the same, no matter how often you order); c isthe cost of one item (a constant); m is the number of items soldeach week (a constant); and h is the weekly holding cost per item(a constant that takes into account things such as space, utilities,insurance, and security). Find dA>dq and d2A>dq2.
Rocky Mountain Tire Center sells 20,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year.The purchase price is $20 per tire if fewer than 500 tires are ordered, $18 per tire if 500 or more-but fewer than 1,000- tires a re ordered, and $17 per tire if I ,000 or more tires areordered.a) How many tires should Rocky Mountain order each time it places an order?b) What is the total cost of this policy?
Parasol Systems sells motherboards for personal computers. For quantities upthrough 25, the firm charges $350 per board; for quantities between 26 and 50,it charges $315 for each board purchased beyond 25; and it charges $285 eachfor the additional quantities over 50. A large communications firm expects torequire these motherboards for the next 10 years at a rate of at least 140 peryear. Order setup costs are $30 and holding costs are based on an 18 percentannual interest rate. What should be the size of the standing order?
An automotive warehouse stocks a variety of parts that are sold at neighborhood stores. One particular part, a popular brand of oil filter, is purchased by the warehouse for $1.50 each. It is estimated that the cost of order processing and reciept is a $100 per order. The company uses an inventory carrying charge based on 28 percent annual interest rate. The monthly demand for the filters follows a normal distribution with mean 280 and a standard deviation 77. Order lead time is assumed to be 5 months. Assume that if a filter is demanded when the warehouse is out of stock, then the demand is back-ordered and the cost assessed for each back-ordered demand is $12.80. Determine the following quantities: a. The optimal values of the order quantity and the reorder level. b. The average annual cost of holding, setup, and stock-out associated with this item assuming that an optimal policy is used. c. Evaluate the cost of uncertanity for this process. That is, compare the average annual cost…
A company has a chance to reduce their inventory ordering costs by placing larger quantity orders using the discount schedule below. What should their optimal order quantity be if this company purchases this single inventory item with an e-mail ordering cost of $4, an annual holding cost rate (per unit) of 2% of the price/unit, and an annual demand of 10,000 units? Order quantity (units) Price/unit ($) 0 to 2,499 1.20 2,500 to 3,999 1.00 4,000 or more 0.98
A company has an annual demand of 2500 units. The cost to place an order to replenish inventory is SR18.75 per order, and annual inventory holding cost per unit is SR1.5. On average, delivery of an order takes 3 working days (Lead time). Assume the store is open 250 days per year. What is the optimal order size? What is the optimal number of orders per year? What is the optimal number of days between orders? What is the Reorder Point (ROP)? What is the Reorder Point (ROP) with 2 days safety stock.