Question: Lieutenant Commander Data is planning to make his monthly ( every 3 0 days ) trek to Gamma Hydra City to pick up a supply
Lieutenant Commander Data is planning to make his monthly every days trek to Gamma
Hydra City to pick up a supply of isolinear chips. The trip will take Data about two days. Before he
leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of Five
per day seven days per week with a standard deviation of demand of one per day. He needs a
percent service probability.
a If he currently has chips in inventory, how many should he order? Use Excel's NORMSINV
function to find the correct critical value for the given level. Do not round intermediate
calculations. Round value to decimal places and final answer to the nearest whole
number.
Number of chips
b What is the most he will ever have to order? Use Excel's NORMSINV function to find the
correct critical value for the given level. Do not round intermediate calculations. Round
value to decimal places and final answer to the nearest whole number.
Maximum order quantity
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
