The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 25% of the acquisition cost per year. Determine (a) The optimal order quantity. (b) The order frequency. (c) The annual holding and setup cost

The soft goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placing an order has been estimated to be $12.00. The store uses an inventory carrying charge of 25% of the acquisition cost per year. Determine (a) The optimal order quantity. (b) The order frequency. (c) The annual holding and setup cost

Name: 5. The soft goods department of a large department store sells 175 un
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: 5. The soft goods department of a large department store sells 175 units per month of acertain large bath towel. The unit cost ofa towel to the store is $2.50 and the cost ofplacing an order has been estimated to be $12.00. The store uses an invento

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

At Dot Com, a large retailer of popular books, demand isconstant at 20,400 books per year. The cost of placing anorder to replenish stock is $35, and the annual cost of holdingis $6 per book. Stock is received 5 working days after an orderhas been placed. No backordering is allowed. Assume 250working days a year.a. What is Dot Com’s optimal order quantity?b. What is the optimal number of orders per year?c. What is the optimal interval (in working days) betweenorders?
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
Suppose that the EOQ is 100, average annual demand is1,000 units, and the lead time demand is a random variablehaving the distribution shown in Table 15.a What value of SLM1 corresponds to a reorder pointof 25?b If we wanted to attain a 95% value of SLM1, whatreorder point should we choose?c If we wanted an average of at most two stockouts peryear, what reorder point should we choose? Lead TimeDemand Probability10 16 15 14 20 14 25 112 30 14
The soft goods department for AMG sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. The organization uses an inventory carrying charge of 27% of the unit cost per year. Determine the optimal order quantity, the order frequency, and the annual holding and setup cost Item Annual Demand Unit Cost A211 800 R9 B390 100 R90 C003 450 R6 D100 400 R100 E707 85 R2000 F660 250 R320 G473 500 R75 H921 100 R75
An online retailer sells 1,500 t-shirts per year. The cost of the t-shirts to the store is $3.00 and the cost of placing an order is $15 per order. It cost $0.60 per t-shirt per year for the retailer to hold the t-shirts. The retailer sells the t-shirts for $9.99. Determine (a) the optimal order quantity, (b) the order frequency (c) the annual holding and setup cost.
1.An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. Theannual demand is approximately 1,400 batteries. The supplier pays $32 for each batteryandestimates that the annual holding cost is 30 percent of the battery's value. It costs approximately$25 to place an order (managerial and clerical costs). The supplier currently orders 140batteriesper month. Determinetheordering, holding, andtotal inventory costs forthe currentorderquantity. Determine the economic order quantity (EOQ). How many orders will be placed per year using the EOQ? Determine the ordering, holding, and total inventory costs for the EOQ. Howhas ordering cost changed? Holding cost? Total inventory cost?
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…
The manager of a hardware store decides to use theEOQ with shortages model to determine the orderingpolicy for tape measures. Using economic considerations,the manager determines that she should usean order quantity of Q 5 30 and have a maximumshortageof b 5 3. The lead time for her supplier todeliver an order is L working days, where there are sixworking days in a week. (Essentially, you can ignoreSundays.) The weekly demand is for 20 tape measures.What reorder point should the manager use ifL 5 3; if L 5 5; if L 5 10? (Hint: The manager shouldplan her orders so that the inventory level is 2b whenan order arrives.)
1 A company carries 10 items in stock, each with an economic order quantity of$20,000. Through a program of component standardization, the 10 items are reducedto 5. The total annual demand is the same, but the annual demand for each item istwice what it was before. In Chapter 10, we learned that the economic order quantityvaries as the square root of the annual demand. Since the annual demand for eachitem is now doubled, calculate:a. The new EOQ.b. The total average inventory before standardization.c. The total average inventory after standardization.
XYZ company is determining the inventory policy for product A which has annual demand distributed as Normal (500, 120). The value of each item is $25. The fixed ordering cost per order is $200. The lead time from supplier of an order is stochastic with mean 4 weeks and standard deviation 2 weeks. The company calculates the holding cost by using an interest rate of 25%. a) Determine the (Q, R) values if the company desires to use a Type 1 service level of 98%. b) Determine the (Q, R) values if the company desires to use a Type 2 service level of 95%. c) Determine the (Q, R) values if the company desires to use a shortage cost of $6.74 per unit of unsatisfied demand.
3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $12 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $1 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 15 pounds. a) What is the cost of underestimating demand for each pound? b) What is the overage cost per pound? c) How many pounds of oyster should she order each day? d) What is the stockout risk for this order size?
The demand for a clothing brand is shown in the table below. The cost per order is about $4000. Cost of each unit of clothing = $5. Carrying cost percentage = 25% per item per 5 months. The analysis period = 5 month duration. Month Demand 1 400 2 300 3 200 4 400 5 500 a. Using this data, compute the solutions using the Lot for Lot and Periodic Order Quantity heuristics? Which of these heuristics would perform better and why? b. Assuming that the demand follows a normal distribution with the mean and variance from the data given above, determine the optimal order should be greater or lesser than the single period EOQ model.