(Answered) Please provide all calculations preferably in excel1 a

Management Studies

Please provide all calculations, preferably in Excel.

1. A large toy company Müttel currently allows toy retailers to place orders with delivery in 2 weeks. The Gigantic Pocket Monster (Gipokmon) is a new toy that Müttel has introduced. Demand per week for the toy at one of their stores is estimated to be normally distributed with a mean of 25 units and standard deviation of 5 units. Assume TOYS-are-MINE uses the order-up-to model to plan orders and deliveries to this store.

a. Suppose TOYS-are-MINE uses an order-up-to level of 20. After receiving their delivery for this week, they have 2 units on-hand. Last week's order was for 5 units. How many units will they order this week?

b. Again, suppose they use an order-up-to level of 20 for this store. On average, how many units will this store have on-order?

c. Suppose an order-up-to level of 90 is established. What is the resulting instock probability?

d. Suppose an order-up-to level of 100 is established. What would be the expected end-of-period on-hand inventory of Gipokmons?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92827077
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 imagine you overhear two of your colleagues talking and

1. Imagine you overhear two of your colleagues talking and one says to the other, “Companies should use investment entry modes whenever possible because they offer the greatest control over business operations.” Do you a ...

Don engaged in the business of installing underground

Don, engaged in the business of installing underground telephone lines, ordered three reels of underground cable from Pat to be delivered at Don’s place of business. Pat delivered reels of aerial rather than underground ...

We are getting less than 40 hours of work from a large

We are getting less than 40 hours of work from a large number of our KC-based EMPLOYEES. The parking lot is sparsely used at 8 a.m.; likewise at 5 p.m. As managers—you either do not know what your EMPLOYEES are doing; or ...

Think of a product that you consumeuse on a regular basis

Think of a product that you consume/use on a regular basis if there was no quality control. what would it look like in terms of safety, customer satisfaction, consistency/rehability, and meeting your expectations? Pick o ...

Abc company is currently considering using one of several

ABC Company is currently considering using one of several suppliers for a new part. For the part, ABC Company's upper specification limit (USL) is 12.6 centimeters (cm) and its lower specification limit (LSL) is 9.9 cent ...

1 what would be the most critical crucial role that a

1. What would be the most critical crucial role that a bidder should know in terms of what's best for that bidder? 2. What is meant by the term ‘total rewards’? If you were a manager of people, or HR professional, what w ...

What are some of the issues that canadian companies need to

What are some of the issues that Canadian companies need to consider when pondering foreign acquisitions and mergers? Research the internet and find a company that may have this type of issue or has a history of a merger ...

Employment tests hiring and promotion "Employment Tests, Hiring and Promotion

"Employment Tests, Hiring and Promotion Decisions". Please respond to the following: Using the e-Activity, choose two (2) of the following employment tests: drug tests, medical examinations, polygraphs or honesty tests ...

Identify your biggest fear about public speaking develop a

Identify your biggest fear about public speaking. Develop a plan to gain confidence and overcome your fear, then explain how you’ll implement your plan. What is your definition of “ethical public speaking”? Find an examp ...

1 twenty-five engine mounts are sampled each day and found

1. Twenty-five engine mounts are sampled each day and found to have an average width of 3 inches, with a standard deviation of 0.2 inches. What are the control limits that include 95.45% of the sample means? 2. Several s ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert