Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolineal chips. The trip will take Data about three days. Before he leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of twelve per day (seven days per week) with a standard deviation of demand of two per day. He needs a 99 percent service probability. a. If he currently has 20 chips in inventory, how many should he order? (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.) Number of chips b. What is the most he will ever have to order? (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.) Maximum order quantity

Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hydra City to pick up a supply of isolineal chips. The trip will take Data about three days. Before he leaves, he calls in the order to the GHC Supply Store. He uses chips at an average rate of twelve per day (seven days per week) with a standard deviation of demand of two per day. He needs a 99 percent service probability. a. If he currently has 20 chips in inventory, how many should he order? (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.) Number of chips b. What is the most he will ever have to order? (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.) Maximum order quantity

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Define Accessory equipment?
Which of the following requires organizations to gather information about customer needs, share that information throughout the entire firm, and use that information to help build long-term relationships with customers? Question 14 options: Marketing concept Sales orientation Customer relationship marketing Customer relationship management Marketing orientation
Please do not give solution in image formate thanku. Analyse three benefits and two disadvantages of Pick and Pay changing its middle market brand name to Pick and Pay Quali Save.
What are the: • problem recognition, • information search • alternatives evaluation • purchase decision • post-purchase evaluation in simple terms? Expound each.
Explain Delphi Method?
mention examples of soap company slogans
Explain 3 Prerequisite Programmes in yogurt plan. (Personal hygiene, Training, allergen control programme)
Packaging is part of:* Product usage in cert ain cases Product tangibles Brand image All options
So how would stores use the right scents to tempt shoppers to spend?
What is the purpose of classifying items into groups, as the ABC classii cation does?
Create a COVID-19 exit strategy for students
Why is it important to separate beverage cost information by bartender?