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 four days. Before he leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of nine 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 alevel. 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
