A supplier's price schedule is: Order Quantity Price per Unit 0–99 $50 100 or more 45 If ordering cost is $16 per order, annual holding cost is 20 percent of the purchase price, and annual demand is 1,800 items, what is the best order quantity? Step 1: 2DS EOQ45.00 H 2DS EOQ50.00 H Step 2: 1,800 76 C76 (50x 0.2)+ 2 (16)+ 50(1,800) = $90,759 76 C100 = The best order quantity is units.

A supplier's price schedule is: Order Quantity Price per Unit 0–99 $50 100 or more 45 If ordering cost is $16 per order, annual holding cost is 20 percent of the purchase price, and annual demand is 1,800 items, what is the best order quantity? Step 1: 2DS EOQ45.00 H 2DS EOQ50.00 H Step 2: 1,800 76 C76 (50x 0.2)+ 2 (16)+ 50(1,800) = $90,759 76 C100 = The best order quantity is units.

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

Daily demand for a certain product is normally distributed with a mean of 100 and a standarddeviation of 15. The supplier is reliable and maintains a constant lead time of 5 days.The cost of placing an order is $10 and the cost of holding inventory is $0.50 per unit peryear. There are no stockout costs, and uni lled orders are i lled as soon as the order arrives.Assume sales occur over 360 days of the year.Your goal here is to i nd the order quantity and reorder point to satisfy a 90 percentprobability of not stocking out during the lead time.a. What type of system is the company using?b. Find the order quantity.c. Find the reorder point.
A company stocks an SKU with a weekly demand of 600 units and a lead time of4 weeks. Management will tolerate one stockout per year. If sigma for the lead timeis 100 and the order quantity is 2500 units, what is the safety stock, the averageinventory, and the order point?
Based on an EOQ-type ordering criterion, what costmust be taken to zero if the desire is to have an orderquantity of a single unit?
The following information relates to the forthcoming period:-Order costs = $25per orderHolding costs = 17% of purchase priceAnnual demand = 16,000 unitsPurchase price = $17 per unitOrder quantity = 650 unitsRequired:-What are the total annual costs of inventory?
Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma.Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
Please do not give solution in image format thanku A mail-order house uses 16,820 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity boxes b. Determine the number of orders per year.
Edwarldo’s Manufacturing uses 2,400 units of a product per year on a continuous basis. The product Carrying Cost are $60 per year and Ordering Cost are $250. It takes 20 days to receive a shipment after an order is placed and the firm requires a safety stock of 8 days of usage in inventory. Show Computations and Explanations. A. Calculate the Economic Order Quantity (round up the answer to the nearest whole unit) (Format: 111) B. Calculate the Total Cost per year to order and carry this item. (Format: 1,111) C. Their supplier has notified the company that if they increase their order quantity by 58 units, they will give the company a discount. Calculate the Dollar Discount that the company will have to at least give to Edwarldo’s Manufacturing to be indifferent. (Format: 111)
In a hardware warehouse, the independent demand for a commonly used bolt is 500 units per month. The ordering cost is $30 per order placed. The carrying cost is 25 percent per year, and each unit costs $.50.a. According to the EOQ formula, what lot size should this product have?b. How often should this product be purchased?c. A quality team has found a way to reduce ordering costs to $5. How will that change the lot size and the frequency of purchasing for this product?
Banana Inc. a Company that markets skin care products . The annual demond is 2400 units and ordering cost is 10 per order . The holding cost per year is 0.30 .Amount of the working days of the is 250 days in a year , Lead time of the order is 2 days . a. What is the optimal order size? b. What is the optimal number of orders per year? c. What is the optimal number of days between orders? d. What is the annual inventory cost? e. If the lead time were 2 days, what would be the reorder point? f. For what value of ordering cost would 1000 units of order size be optimal? g. Determine how often the firm should order. h. Determine the size of each order ı. At what price should the firm order?
Fursan Inc. needs 310 kgs of a material per month (four weeks). It costs RO 10 to make and receive an order, and it takes 14 work days to receive it. The annual holding cost is 15 % of purchase price. The price RO 1 per kg. The company is operating 6 days per week. At what level of inventory in Kgs should the company be placing orders? Round-up to the nearest integer Select one: a. 200 b. 175 c. 181 d. 188
A component used in a manufacturing facility is ordered from an outside supplier. Because the component is used in a variety of end products, the demand is high. Estimated demand (in thousands) over the next 10 weeks is The components cost 65 cents each and the interest rate used to compute the holding cost is 0.5 percent per week. The fixed order cost is estimated to be $200. (Hint: Express h as the holding cost per thousand units.) a. What ordering policy is recommended by the Silver–Meal heuristic? b. What ordering policy is recommended by the part period balancing heuristic? c. What ordering policy is recommended by the least unit cost heuristic? d. Which method resulted in the lowest-cost policy for this problem?
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. The annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. f.) If orders must be in integer multiples of 1000 gallons, how much should be ordered to minimize ordering and holding costs PER GALLON? g) A 3% purchase price discount is given if orders are for 8000 gallons or more. What would total annual costs (purchasing, ordering, and holding)be using this discount?