Homework Help is Here – Start Your Trial Now!
Math
Statistics
The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 98 percent service probability. (Use Excel's NORMSINV() function to find the z value. 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 asked to reduce the safety stock of this item by 50 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) Service probability %

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 98 percent service probability. (Use Excel's NORMSINV() function to find the z value. 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 asked to reduce the safety stock of this item by 50 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) Service probability %

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
See similar textbooks
icon
Related questions
Topic Video
Question
The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 98 percent service probability. (Use Excel's NORMSINV() function to find the z value. 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 asked to reduce the safety stock of this item by 50 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) Service probability %
Transcribed Image Text:The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.10 per unit. a. Find the reorder point necessary to provide a 98 percent service probability. (Use Excel's NORMSINV() function to find the z value. 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 asked to reduce the safety stock of this item by 50 percent. If she does so, what will the new service probability be? (Use Excel's NORMSDIST() function to find the correct probability for your computed Z-value. Round "z" value to 2 decimal places and final answer to 1 decimal place.) Service probability %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
SEE MORE TEXTBOOKS