Question: No EXCEL please! show formulas. 5.The operations manager at a chemical company that produces insecticide for use in commercial applications is attempting to set a

No EXCEL please! show formulas.

No EXCEL please! show formulas. 5.The operations

5.The operations manager at a chemical company that produces insecticide for use in commercial applications is attempting to set a safety stock level for a key ingredient that is used in their most powerful product. She believes that demand during lead time for this ingredient is normally distributed based on past data. In addition, she believes that future use is accurately depicted by these historical demand-during- lead-time data (in gallons): 55, 75, 75, 70, 80, 60, 50, 70, 60, and 85. She estimates the standard deviation of demand during the lead time to be 8.5 gallons. a. b. What is the average demand during the lead time for this key ingredient? What is the safety stock the company needs to provide a 95% service level? What is the order point the company should use? o

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!

Can you do it on excel spreadsheet? Or written clearly step by step because this is my third time and it is written not so clear. Thank you! MBA612 - Homework Assignment - H2-B Chapter 9Forecasting...

Can you please write it clear? Step by step? Because I posted this 4 times and I don't understand. And write numbers, i.e., 2 ( a), 2 ( b), etc. Thanks! MBA612 - Homework Assignment - H2-B Chapter...

MBA612 - Homework Assignment - H2-B Chapter 9Forecasting and Demand Planning You must show all formulas, calculations, and circle correctanswers. PROBLEMS 1. Using the data shown below, compute the...

" The operations manager at a chemical company that produces insecticide for use in commercial applications is attempting to set a safety stock level for a key ingredient that is used in their most...

Material cost is 78 Please do the Mixed plan only Background: Your company has just acquired a new subsidiary that manufactures two products-Clodhopper and Clodbuster. The Clodhopper is intended for...

Clodhopper Clodbuster Background: Your company has just acquired a new subsidiary that manufactures two products-Clodhopper and Clodbuster. The Clodhopper is intended for the general consumer market...

A manufacturer of small appliances purchases plastic handles for coffeepots from an outside vendor. If a handle is cracked, it is considered defective and must be discarded. A large shipment of...

Explain the differences among styles, fashions, and fads and give an example of each.

Which of the following will most likely harm the reputation of a multinational enterprise ( MNE ) ? Principal - agent problems cause an MNE to merge with another MNE. Thereased compettition causes an...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...