Question: PLEASE SHOW HOW TO DO IT AND THE WORK FOR IT ON EXCEL SHEET Lieutenant Commander Data is planning to make his monthly (every 30

PLEASE SHOW HOW TO DO IT AND THE WORK FOR IT ON EXCEL SHEET

Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolinear chips. The trip will take Data about five days. Before he leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of four per day (seven days per week) with a standard deviation of demand of three per day. He needs a 99 percent service probability. a. If he currently has 25 chips in inventory, how many should he order? (Use Excel's NORMSINVO) function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 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 a-level. Do not round intermediate calculations. Round "z" value to 2 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 blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please try to answer any of these that you can. No excel sheet is necessary 1. Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply...

Lieutenant Commander Data is planning to make his monthly ( every 3 0 days ) trek to Gamma Hydra City to pick up a supply of isolinear chips. The trip will take Data about four days. Before he...

Lieutenant Commander Data is planning to make his monthly (every 30 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...

Lieutenant Commander Data is planning to make his monthly ( every 3 0 days ) trek to Gamma Hydra City to pick up a supply of isolinear chips. The trip will take Data about four days. Before he...

Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolinear chips. The trip will take Data about one day. Before he leaves, he...

1. SCM 460-Purchasing & Material Management HW #5 on Inventory Management Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of...

Must be in excel. Please show formula for each box. will upvote thanks. Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of...

can you show me how to get the answer to this problem without using excel much thanks. i just wanna see how its worked out so i dont need to depend on excel later. Problem 11-16 (Algo) Lieutenant...

1. Lieutenant Commander Data is planning to make his monthly (every 30 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,...

What would be the impact on ROE & Debt Equity ratios if the company decides to cover the "external money needed" by raising debt? (In the space below calculate and write down the current ROE &...

Wild Adventure conducts tours of wildlife reserves around the world. The company recently purchased a lodge in Adelaide, Australia, securing a 4% mortgage from First Bank. In addition to monthly...

An ester was made by reacting methanol and butanoic acid. A small amount of concentrated sulfuric acid was added to a mixture of the reactants. The resulting mixture was heated under reflux for 30...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...