Determine the weekly order quantity

Assignment Help Operation Management
Reference no: EM132273408

Question 1:

For the next eight-week planning period, the daily demand is forecast to be exactly 200 unit with no uncertainty. Only for Q1, there are 80 units left over from the previous period, which ended on a Sunday. The supplier is willing to deliver a constant amount of units every Monday morning, on time.

Management mandates a 100% target fill rate. Determine the weekly order quantity that that gives the highest inventory turns and explain in detail the method used to find it.

Question 2 :

For Q2, the leftover inventory from the previous period is zero. Also, the daily demand is no longer constant, but normally distributed with a mean of 150 units and a standard deviation of 50 on weekdays. On weekends, the mean is 330 and the standard deviation is 70.

In cell H10, you can find the weekday function to use throughout your worksheet with the appropriate parametes. Since the delivery quantity and times (every Monday morning) have to be the same as in Q1 and the demand is now random, the system may stock out. Only for Q2, when the system stocks out, any unsatisfied demand is backordered and satisfied as soon as new inventory comes in the next Monday.

Simulate 500 eight-week runs and compute the average fill rate and average inventory turns. Just for this model, because of the backorders, the fill rate is defined as the number of on-time sales divided by the total demand. Show your work and, most importantly, describe in your own words.

sample mean 150
sample standard deviation 50
random demand #####

Question 3 :

The daily demand and delivery time are the same as in Q2. The lead time is two days, so the orders are placed every Saturday morning. The retailer has the flexibility to change the order quantity as needed over time, so it decides to use the OUL system. Using a 1,000-run simulation, find the order-up-to level that meets a target service probability of 80% while minimizing the inventory turns. Comment.

Question 4 :

The daily demand is uniformly distributed between 150 and 250, every day. The lead time is the same as in Q3. The retailer has the flexibility to order when needed, and it can check inventory regularly. However, it has to order always the same quantity from the supplier, a full truckload of 800 units.

So, it decides to adopt the ROP system. Using a 1,000-run simulation, find the minimum reorder point that meets a target service probability of 80%. Comment.

Question 5:

Simulate only one eight-week-period run of a ROP system with the same constant ROP level found in Q4, and the daily demand distribution of Q2. Supply is ordered if the night before inventory reached or went below the ROP for the first time. Ask if in doubt about what Excel formula to use, IF alone may not suffice.

Supply is delivered first thing in the morning two days later. Hence, it could be useful to have two separate columns for supply ordered and supply delivered. The order quantity should be that found in Q1. 500 units are left over from the last day of the previous period, which was a Sunday. Please, compute the fill rate and the inventory turns, and comment your work.

Reference no: EM132273408

Questions Cloud

Describe what you found interesting regarding given topic : Describe how you will apply that learning in your daily life, including your work life. Describe what may be unclear to you, and what you would like to learn.
Discuss the authors presentation of information in article : Research Project is a current events journal where students connect course material with current affairs.
Administrative overhead units : You are the new CFO of a teenage pregnancy counseling clinic. You have four administrative overhead units:
In what sense or under what conditions might idea be true : In Part I of the assignment (due Week 2), you will first read a book excerpt about critical thinking processes: "The Believing Game and How to Make Conflicting.
Determine the weekly order quantity : Simulate 500 eight-week runs and compute the average fill rate and average inventory turns.
Swot analysis-industry analysis and competitor analysis : “Where are we now as a company?” SWOT Analysis, Industry Analysis, Competitor Analysis.
The process of conducting needs assessment : How would you begin the process of conducting a needs assessment? (Training and Development)
Explain the mental health commitment standards : Post an explanation of those emerging issues in the mental health care arena that the policymakers address and those that are in need of policy advocacy.
Discussion about the existential therapy : Choose two of the 6 propositions outlined in Chapter 6 related to the human conditions according to existential therapy and how you would apply these.

Reviews

Write a Review

Operation Management Questions & Answers

  Estate developer is planning to build apartment building

A real estate developer is planning to build an apartment building specifically for graduate students on a parcel of land adjacent to a major university.

  Investigating potential fraud without causing large morale

Assume that you were the Internal Fraud Investigation Manager for Computer Apple Company.

  Career professionals and political appointees

Discuss the role that career professionals and political appointees played in the decision making process.

  Airline deregulation act

Before it was replealed by the 1978 Airline Deregulation Act, which airline benefited most from Mutual Aid Pact payments and why?

  Contributing to facilitating growth of decision support and

Which of the following developments is NOT contributing to facilitating growth of decision support and analytics?

  Create the cumulative distribution graph

Create the cumulative distribution graph showing actual relative to theoretical, and comment on the degree of normalcy of the data.

  What types of positions in what types of industries

What types of positions in what types of industries might each of the eighteen inventories be used to assess?

  Describe the implications to the retailer and manufacturer

Describe the implications to the retailer, manufacturer, and broader supply chain.

  Difference between a unilateral and a bilateral contract

What is the difference between a unilateral and a bilateral contract ? Explain the concept of promissory estoppels.

  Administrative worker be better motivated by equity theory

Why would an administrative worker be better motivated by the Equity Theory?

  Great uncertainty or little precedent for a decision

The use of _____ is important when there is great uncertainty or little precedent for a decision

  Are quality management practices similar in manufacturing

Are quality management practices similar in manufacturing and service companies? How do they differ? Explain your answers.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd