Group Project Consider a supply chain with the three stages: Retailer, Distributor, and Manufacturer. The Retailer...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Group Project Consider a supply chain with the three stages: Retailer, Distributor, and Manufacturer. The Retailer faces period demand that is normally distributed with mean and standard deviation o. Assume that demands in different days are independent and identically distributed. Furthermore, assume that the Retailer uses a continuous review inventory policy and places an order QR with the Distributor whenever its inventory level reaches the reorder point ROPR. The Retailer's ordering lead time is LR periods, and will receive the full ordered quantity if the Distributor has sufficient inventory on hand; otherwise, the Distributor will send whatever they have in stock. Any unmet demand by the Retailer will be lost. The Distributor, in turn, also uses the continuous review inventory policy, and places an order Q with the Manufacturer whenever its inventory level reaches the reorder point ROPD. The Distributor's ordering lead time is LD periods, and it is assumed that the manufacturer will never run out of stock. Given that the supply chain needs to meet a cycle service level of CSL or product fill rate fr, what should the ordering policy be for both the Retailer and the Distributor that will meet the service level, while at the same time minimize their total inventory costs? In other words, for a specific CSL or fr, find QR, QD, ROPR, and ROPD; such that, the total inventory carrying cost and ordering costs are minimized. The inventory carrying costs per unit per period at the Retailer and Distributor are HR and HD respectively. It is assumed that HR > HD. This suggests that pushing inventory upstream the supply chain will be cheaper to carry, however, the lead time will be longer to meet the end consumers' demand. Finally, the ordering costs for the Retailer and Distributor are SR and SD respectively. Given the following: Average demand per period = 500 Standard deviation of demand per period o = 200 Retailer's holding cost per unit per period HR = 5 Distributor's holding cost per unit per period HD = 3.75 Retailer's ordering cost SR = 1000 Distributor's ordering cost S = 1500 Retailer's lead time LR = 2 Distributor's lead time LD = 2 Item fill rate fr = 98% Simulate the supply chain using Microsoft Excel to determine the inventory ordering policy for both the Retailer and Distributor that will minimize total supply chain cost. Group Project Consider a supply chain with the three stages: Retailer, Distributor, and Manufacturer. The Retailer faces period demand that is normally distributed with mean and standard deviation o. Assume that demands in different days are independent and identically distributed. Furthermore, assume that the Retailer uses a continuous review inventory policy and places an order QR with the Distributor whenever its inventory level reaches the reorder point ROPR. The Retailer's ordering lead time is LR periods, and will receive the full ordered quantity if the Distributor has sufficient inventory on hand; otherwise, the Distributor will send whatever they have in stock. Any unmet demand by the Retailer will be lost. The Distributor, in turn, also uses the continuous review inventory policy, and places an order Q with the Manufacturer whenever its inventory level reaches the reorder point ROPD. The Distributor's ordering lead time is LD periods, and it is assumed that the manufacturer will never run out of stock. Given that the supply chain needs to meet a cycle service level of CSL or product fill rate fr, what should the ordering policy be for both the Retailer and the Distributor that will meet the service level, while at the same time minimize their total inventory costs? In other words, for a specific CSL or fr, find QR, QD, ROPR, and ROPD; such that, the total inventory carrying cost and ordering costs are minimized. The inventory carrying costs per unit per period at the Retailer and Distributor are HR and HD respectively. It is assumed that HR > HD. This suggests that pushing inventory upstream the supply chain will be cheaper to carry, however, the lead time will be longer to meet the end consumers' demand. Finally, the ordering costs for the Retailer and Distributor are SR and SD respectively. Given the following: Average demand per period = 500 Standard deviation of demand per period o = 200 Retailer's holding cost per unit per period HR = 5 Distributor's holding cost per unit per period HD = 3.75 Retailer's ordering cost SR = 1000 Distributor's ordering cost S = 1500 Retailer's lead time LR = 2 Distributor's lead time LD = 2 Item fill rate fr = 98% Simulate the supply chain using Microsoft Excel to determine the inventory ordering policy for both the Retailer and Distributor that will minimize total supply chain cost.
Expert Answer:
Related Book For
Essentials Of Business Statistics Communicating With Numbers
ISBN: 9780078020544
1st Edition
Authors: Sanjiv Jaggia, Alison Kelly
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Consider a supply chain with the manufacturer, the retailer and end-users, using a buy-back contract, as below cost-benefit & demand forecasting details: F=$120,000 ; c=$30 ; w=$75 ; b=$50 ;...
-
A force of 24N is applied to a wrench which is 0.4m in length. If the force is applied at an angle of 15 degrees, find the torque in N-m. Round off to two decimal places.
-
Merchandise with a list price of $7,500 and a cost $7,000 is sold on account, terms 1/10, n/30, Prior to payment, merchandise with a list price of $1,000 and a cost of $800 is returned. The correct...
-
What are the three categories of cash flows reported on the cash flow statement? Discuss each and give an example of an inflow and an outflow for each category.
-
An investor with unit wealth maximizes the expected value of the utility function $U(x)=a x-b x^{2} / 2$ and obtains a mean-variance efficient portfolio. A friend of his with wealth $W$ and the same...
-
What is each shareholder's realized gain or loss? b. What is each shareholder's recognized gain or loss? c. What is each shareholder's basis in their stock? When does their holding period begin? d....
-
Using the Internet analyze a particular current event in finance (or economics) using at least three sources. You will summarize your current event or topic and support your viewpoints and...
-
TV Trends to Watch in 2021 In 2021, expect larger and cheaper 4K TVs, a new level of voice control, interaction with other smart products, and mini Led backlights to improve color contrast and...
-
Write executive report, the purpose of the report is to explain to the CEO of the hospital about the recruitment trip that we did , to submit to him the report , the purpose of the trip is to cover...
-
Please provide solutions with as much detail as possible: This problem pertains to kidney exchange with 0-1 preferences. Four patients are listed with I = (1, 2, 3, 4). Every patient has a donor who...
-
Ray works as a home health nurse and by choosing to take on more or fewer clients each week, he can work as many hours as he wants. Imagine Ray earns $12 an hour and has 60 hours a week to devote to...
-
The most widely used measure of break-even is accounting break-even. The accounting break-even point is simply the sales level that results in a zero-project net income. What do we need to determine...
-
Case 1 (First Price Auction): In this case, the winner of the object pays whatever she bids. Case 2 (Second Price Auction): In this case, the winner of the object pays whatever the other player bids....
-
The dynamic characteristics of viscoelastic material components can be approximately described by a model consisting of two springs and a viscous damper as shown in the figure on the right. Assume...
-
Jake puts 700 g of soup (soup = 5.2 J / (g C)) in a pan. The soup has a temperature of 14 C. He heats this with an ELECTRIC hotplate in 5.5 minutes to 93 C. A. Show with a calculation that +/- 288...
-
A company pledges their receivables so they may Multiple Choice Charge a factoring fee. Increase sales. Recognize a sale. Collect a pledge fee. Borrow money. Failure by a promissory notes' maker to...
-
Consider the following discrete probability distribution. a. Complete the probability distribution. b. Graphically depict the probability distribution and comment on the symmetry of the distribution....
-
A company has developed a new diet that it claims will lower ones weight by more than 10 pounds. Health officials decide to conduct a test to validate this claim. a. Is the manager of the company...
-
Assume that X is a Poisson random variable with = 1.5. Calculate the following probabilities. a. P(X = 1) b. P(X = 2) c. P(X 2)
-
Evaluate the shape factor \(\phi_{B}^{f}\) for strength-limited design in bending of a square box section of outer edge-length \(h=100 \mathrm{~mm}\) and wall thickness \(t=3 \mathrm{~mm}\). Is this...
-
Derive the expression for the shape-efficiency factor \(\phi_{B}^{e}\) for stiffness-limited design for a circular tube with outer radius \(5 t\) and wall thickness \(t\), loaded in bending (Fig....
-
Derive the expression for the shape-efficiency factor \(\phi_{B}^{e}\) for stiffness-limited design for a square box section of wall thickness \(t\), and height and width \(h_{1}=10 t\) bent about...
Study smarter with the SolutionInn App