Your firm uses the continuous review system to manage a product, and operates 52 weeks a year. The product has the following characteristics: Ordering cost $40 per order • Inventory-holding cost $5 per unit per year Leadtime = 4 weeks %3D Weekly demand is normally distributed with mean 200 and standard deviation 12. You want to satisfy a 95% probability of not running out of stock in any one ordering cycle. (Note! z 95=1.65) (a) What is the average demand during leadtime? units (b) What should be the safety stock? Answer with a whole number. units (c) What should be the reorder point? Answer with a whole number. units (d) What should be the order quantity? Answer with a whole number. units

Your firm uses the continuous review system to manage a product, and operates 52 weeks a year. The product has the following characteristics: Ordering cost $40 per order • Inventory-holding cost $5 per unit per year Leadtime = 4 weeks %3D Weekly demand is normally distributed with mean 200 and standard deviation 12. You want to satisfy a 95% probability of not running out of stock in any one ordering cycle. (Note! z 95=1.65) (a) What is the average demand during leadtime? units (b) What should be the safety stock? Answer with a whole number. units (c) What should be the reorder point? Answer with a whole number. units (d) What should be the order quantity? Answer with a whole number. 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

company sells 20,000 radios evenly throughout the year. The cost of carrying one unit of inventory for one year is P8, and thepurchase order cost per order is P32. What is the economic orderquantity
Demand during lead time for one brand of TV is normally distributed with a mean of 36 TVs and a standard deviation of 15 TVs. What safety stock should be carried for Dennis Yu's Appliance Outlet to provide a 90% service level? What is the appropriate reorder point? Use a Z standard deviation table as well What safety stock should be carried for a 90% service level? Safety stock =units (round your response to the nearest whole number). What is the appropriate reorder point? Reorder Point = units
An ophthalmologist's office operates 52 weeks per year, 6 days a week. It purchases disposable contact lenses for $11.70 per pair and sells for $50. The demand is 90 pairs per week. Order cost is $54 per order. Annual interest rate is 27%. Lead-time is 3 weeks. Standard deviation of weekly demand is 15 pairs. Given that 98% service-level. Clearly identify different types of stocks: cycle, safety and pipeline. a. Find a (Q, r) policy for this situation c. Find average service level (fill rate) of the policy (a) d. Find average backorder level of the policy (a) e. Find average inventory level of the policy (a)
Demand for a product is relatively constant at 5 units per day. Lead time for this product is normally distributed with a mean of 20 days and a standard deviation of 4 days. (a) What reorder point provides an 80 percent service level? (b) What reorder point provides a 90 percent service level? (c) If the lead time standard deviation can be reduced from 4 days to 1, what reorder point now provides 90 percent service? How much is safety stock reduced by this change?
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 350 units and a standard deviation of 15 units. It is purchased from a wholesaler at a cost of $25.00 per unit. The supply lead time is 7 weeks. Placing an order costs $55.00, and the inventory carrying rate per year is 15 percent of the item's cost. Your firm operates 6 days per week, 50 weeks per year. Refer to the standard normal table The table below shows the total area under the normal curve for a point that is Z standard deviations to the right of the mean. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.0 0.5000 0.5040 0.5080 0.5120 0.5160 0.5199 0.5239 0.5279 0.5319 0.5359 0.1 0.5398 0.5438 0.5478 0.5517 0.5557 0.5596 0.5636 0.5675 0.5714 0.5754 0.2 0.5793 0.5832 0.5871 0.5910 0.5948 0.5987 0.6026 0.6064 0.6103 0.6141…
The National Company uses 150,000 gallons of hydrochloric acid per month. The cost of carrying the chemical in inventory is 50 cents per gallon per year, and the cost of ordering the chemical is P150 per order. The firm uses the chemical at a constant rate throughout the year. What is the total ordering costs if the company will purchase at EOQ level? Format: 1,111.11 The National Company uses 150,000 gallons of hydrochloric acid per month. The cost of carrying the chemical in inventory is 50 cents per gallon per year, and the cost of ordering the chemical is P150 per order. The firm uses the chemical at a constant rate throughout the year. How many days does each order (at the EOQ level) will last? Use 360 days Format: 1
Company XYZ makes bicycles. XYZ produces 400 bicycles a month. They must buy tires from a supplier at a cost of $20 per tire. The inventory holding cost rate is 15% and ordering costs $50 per order. Part i) Let’s assume that there is no shortage inventory allowed. Calculate optimal annual order quantity Calculate annual total inventory cost ^already have the answer for this one. Just input the whole question so it would make more sense. Part ii) Let’s assume that shortage inventory is allowed. With that being said, we know that the shortage cost per unit of item is $5 per year. <<this is the one that I am stuck on. Calculate optimal annual order quantity Calculate annual total inventory cost Hint: Each bicycle has two tires.
An SKU costing $10 is ordered in quantities of 500 units; annual demand is5200 units, carrying costs are 20% and cost of placing an order is $50.Calculate1. Average inventory2. Number of orders placed per year3. Annual Inventory carrying cost4. Annual Ordering cost5. Annual total cost
A retail outlet sells a seasonal product for $10 per unit. The cost of the product is $8 per unit. All units not sold during the regular season for half the retail price in an end-of-season clearance sale. Assume that the demand for the product is uniformly distributed between 200 and 800. a. What is the recommended ordering quantity? b. What is the probability of a stockout using your order quantity in (a)? c. To keep customers happy and returning to the store later, the owner feels that stockouts should be avoided if at all possible. What is your recommended order quantity if the owner is willing to tolerate a 0.15 probability of stockout? d. Using your answer to (c), what is the goodwill cost you are assigning to a stockout?
The demand rate for a product is 100 units per month. Each time an order is placed, a fixed cost of $40 is incurred. The purchase price for the product is $12 and its selling price is $20. The inventory holding cost rate is 20% per year. If the order lead time is 4 months, what is the reorder level of the (s, Q) policy?
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. (B) Economic Order Quantity 1. How much would the total inventory related (ordering plus carrying) costs be if the economic order quantity wasfollowed (excluding safety stock)? (D) Cost-Benefit Analysis: If ABC maintains its current inventory policy for the year,1. How much would the entity save it followed the reorder point and economic order quantity models?…
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. 18. Explain what would happen to the ordering cost, carrying cost and total inventory-related costs if the entity doesnot follow the economic order quantity based on the previous numbers