Question: THIS HAS TO BE DONE USING CPLEX OR AMPL ONLY Problem 1 A bottling plant uses approximately 4,000 plastic bottles per day (normally distributed), while

THIS HAS TO BE DONE USING CPLEX OR AMPL ONLY

Problem 1

A bottling plant uses approximately 4,000 plastic bottles per day (normally distributed), while daily usage has a standard deviation of 58. Order lead time is 3 days (constant). What is the average demand during lead time for this item? 12,000 What is the standard deviation of demand during lead time for this item? Round your answer to the nearest two decimal points. Show all your work. 100.46 If I use an order point system, what reorder point (ROP) would result in 100 units of safety stock? 12,100 What is the predicted service level using that ROP value? What ROP value is needed to provide 99% predicted service level? How much safety stock is associated with this policy?

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!

SET A: One of the questions in a study of marital satisfaction of dual-career couples was to rate the statement, "I'm pleased with the way we divide the responsibilities for childcare." The ratings...

Detailed answers needed. 1. Let Xi,.... Xio be a random sample from a normal population with mean / and standard deviation 4. Let X be the sample mean and suppose X = 48. Find a 95% confidence...

Introduction Quality Resorts Hotel Group is a quoted company that owns and operates 50 luxury hotels in the country of Italy. Quality Resorts head office is located in Italy's capital city. Italy is...

Need stakeholder analysis, swot analysis and pestle analysis for the below case study- Bella Beverages Inc. 1 Bella Beverages Inc. Overview Bella Beverages Inc. (BB) is a Canadian company traded on...

Type or paste question here Case 1-3 Coke and Pepsi-----Answers given below Discussion questions not that one given in the above case study: Discuss how Coca Cola and PepsiCo were influenced by the...

PLEASE answer it as a Report style-Not Essay, and please answer as many details as possible. ( each question, I need close to a full page TT) 4. Key success factors. Please identify the relevant...

Identify the major participants (i.e., suppliers, buyers, competitors, substitutes and potential new entrants) in the carbonated soft drink industry? Cola Wars Continue: Coke and Pepsi in 2010 For...

key macro environmental trends? Cola Wars Continue: Coke and Pepsi in 2010 For more than a century, Coke and Pepsi vied for "throat share" of the world's beverage market. The most intense battles in...

Coke and Pepsi Learn to Compete in India CASE 1-3 THE BEVERAGE BATTLEFIELD In 2007, the president and CEO of Coca-Cola asserted that Coke has had a rather rough run in India, but now it seems to be...

Please read the case and then answer the questions that is provided after the case in bullet points: THE BEVERAGE BATTLEFIELD In 2007, the president and CEO of Coca-Cola asserted that Coke has had a...

The FEMO theory (Problem 11.14) of conjugated molecules is rather crude and better results are obtained with simple Huckel theory. (a) For a linear conjugated polyene with each of N carbon atoms...

The following 2010 information is available for Cornwall Industries: average assets invested $7,200,000; revenues, $26,400,000; and expenses, $24,600,000. a. Calculate return on investment. b....

In which statement and fund does a government list capital assets

What is an example of constructive feedback? provide reference