Annual demand for a product is 16,120 units; weekly demand is 310 units with a standard deviation of 55 units. The cost of placing an order is $145, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.55 per unit. a. To provide a 90 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Reorder point____________ units ? b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) Service probability___________%

Annual demand for a product is 16,120 units; weekly demand is 310 units with a standard deviation of 55 units. The cost of placing an order is $145, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.55 per unit. a. To provide a 90 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Reorder point__ units ? b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.) Service probability_%

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Problem 20-22 (Algo)

a. To provide a 90 percent service probability, what must the reorder point be? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

Reorder point____________ units ?

b. Suppose the production manager is told to reduce the safety stock of this item by 80 units. If this is done, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round your answer to the nearest whole number.)

Service probability___________%

Management principles, work activities, and methods involved in the production of a product. Topics covered under production management are job production, batch production, mass production, and recent trends.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Thomas Kratzer is the purchasing manager for theheadquarters of a large insurance company chain with a centralinventory operation. Thomas’s fastest-moving inventory item hasa demand of 6,000 units per year. The cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. The aver-age ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per year?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f ) What is the total annual inventory cost, including the cost ofthe 6,000 units?
EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity.
Annual demand for a product is 13,000 units; weekly demand is 250 units with a standard deviation of 40 units. The cost of placing an order is $100, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.65 per unit. To provide a 98 percent service probability, what must the reorder point be? Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number. Suppose the production manager is told to reduce the safety stock of this item by 100 units. If this is done, what will the new service probability be? Note: Use Excel's NORM.S.DIST() function to find the correct probability for your computed z value. Round z value to 2 decimal places and final answer to the nearest whole percent.
EOQ, reorder point, and safety stock Alexis Company uses 916 units of a product per year on a continuous basis. The product has a fixed cost of $60 per order, and its carrying cost is $3 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity. a. Alexis' EOQ is units. (Round to the nearest whole number.)
Daily demand for product sample kits is normally distributed with a mean of 35 units and a standard deviation of 4. Supply is virtually certain with a lead time of 9 days. The cost of placing an order is $20, and annual carrying costs for one kit is 25 percent. The price of one kit is $12.50. Assume a year has 365 days.If a 99% service level is desired, what is average inventory on hand? If demand had no variation, what would the reorder point be?
Inventory Management Reorder The ToyWorld company produces toys out of plastic ordered from an outside supplier. ToyWorld's daily demand for plastic is normally distributed with a mean of 7,800 pounds and a standard deviation of 1,050 pounds. Lead time is 16 days. (Use the Formula Sheet Z table to determine Z values.) What is the service level if ToyWorld reorders when the plastic inventory reaches 134,586 pounds?
Problem 20-36 (Algo) Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 3,910 mufflers Ordering cost $ 75 per order Standard deviation of daily demand 6 mufflers per working day Service probability 87 % Item cost $ 27.00 per muffler Lead time 2 working days Annual holding cost 36 % of item value Working days 230 per year Review period 18 working days a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level_________________ b. If the…
Paulin’s muffler shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information table to determine the optimal inventory target level (or order-up to level). Annual demand 3,910 mufflers ordering cost $75 per order S/D of daily demand 6 mufflers/wk. day service probability 87% Item cost $ 27.00 per muffler lead time 2 wk. Days Annual holding cost 36 % of item value wk. Days 230 per year Review period 18 working days What is the optimal target levels (order up to levels) use excels NORMSINVI() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round value 2 decimal places and final answer to the nearest whole number If the service probability is 90%, the optimal target level will increase, decrease or…
Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs, are forcing GGIL, to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such a shortage costs. Table 10 is a random sample of 20 GGIL's items. Table 10. Annual Usage by Value of a sample of GGIL's Inventory Item Number Annual Usage ($) Item Number Annual Usage ($) 1 10,600 11 2,750 2 14,000 12 1,400 3 4,000 13 3,200 4 16,000 14 2,500 5 8,100 15 110,000 1,800 16 14,800 7 84,000 17 9,500 8. 890 18 1,700 9 940 19 3,700 10 94,000 20 12,500 a) What would you recommend GGIL to do to cut back its labor cost? (Illustrate using an ABC plan). b) Item 18 is critical to continued operations at GGIL. i. How would you recommend it be classified? ii. Give the reason(s) for your answer.
The Petroco Company uses a highly toxic chemical in one of its manufacturing processes. It must have the product delivered by special cargo trucks designed for safe shipment of chemicals. As such, ordering (and delivery) costs are relatively high, at $2,600 per order. The chemical product is packaged in 1-gallon plastic containers. The cost of holding the chemical in storage is $50 per gallon per year. The annual demand for the chemical, which is constant over time, is 2,000 gallons per year. The lead time from time of order placement until receipt is 10 days. The company operates 310 working days per year. Compute the optimal order quantity, the total minimum inventory cost, and the reorder point.
The company uses cooking oil in its business. The usage of cooking oil is normally distributed with an average of 30 gallons per week and a standard deviation of four gallons per week. The manager asked you to help him decide how to reorder cooking oil in order to achieve a service level of 97.5 percent . Lead time is nine days. a) If cooking oil can be ordered as needed, what reorder point should be used? Answer in 2 decimal places.b) If a fixed interval of 20 days is specified, how much safety stock should the company carry. Answer in 2 decimal places.
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA