hello, can someone help me to calculate the optimal amount of pipeline (in-transit) inventory with the following information: average customer demand: 100 units, Standard deviation of customer demand: 10 units, supplier lead time: 9 days, desired service level (order fill rate): 98.5%, and z score for 98.5: 2.17? thank you!

hello, can someone help me to calculate the optimal amount of pipeline (in-transit) inventory with the following information: average customer demand: 100 units, Standard deviation of customer demand: 10 units, supplier lead time: 9 days, desired service level (order fill rate): 98.5%, and z score for 98.5: 2.17? thank you!

MARKETING 2018

19th Edition

ISBN:9780357033753

Author:Pride

Publisher:Pride

Chapter15: Retailing, Direct Marketing, And Wholesaling

Section15.1: L.l.bean: Open 24/7, Click Or Brick

Problem 3VC

See similar textbooks

Similar questions

ROP for constant demand and variable lead time. The motel in the preceding example uses approximately 600 bars of soap each day, and this tends to be fairly constant. Lead time for soap delivery isnormally distributed with a mean of six days and a standard deviation of two days. A service level of90 percent is desired.a. Find the ROP.b. How many days of supply are on hand at the ROP?
Draw the PLC chart/diagram and briefly explain each stage by giving an example. Discuss the extra 3Ps for ‘Services’ on Al Bustan Palace Hotel expansion strategy
MINICASE: FEDERAL EXPRESS Federal Express provides an excellent example of an organization (and an entrepreneur) that opened up an unrealized market opportunity and began a new industry. It has been claimed that the ‘greatest business opportunities arise when you spot things your customer didn’t have a clue they needed until you offered it to them.’ The idea behind FedEx is simple. It is to provide a speedy and reliable national and international ‘overnight’ courier service for letters and parcels based upon air cargo. FedEx rightly claim to have invented the concept of overnight delivery, creating a whole new market where previously there was none. The company had a peripheral but significant role in the film Castaway, which featured Tom Hanks as a FedEx manager who survived the crash of a FedEx airplane only to spend several years marooned on a desert island. He held on to one of the packages from the plane and finally succeeded in delivering it. FedEx is, however, unusual in a…
B15. The restaurant uses 24 bottles of wine to operate and it has 3 bottles in hand. Calculate the Desired Ending Inventory (DEl) if the number of days in the delivery period is 2 and the safety factor is 10%. Using the Periodic Order Method, calculate the number of bottles that the restaurant should order.
FarmBox is a company who grow and distribute fresh food produce directly to customers via an online ordering platform, based in Cheshire, UK. The company started in 2019 and began as a family run business that was staffed by 4 family members plus two farmhands, with the use of one delivery van.As the Covid pandemic struck in 2020 the business experienced unexpected rapid growth with orders tripling almost overnight, whilst the firm has the product to meet the demand of customers, investment wasneeded in equipment and more importantly, the number of staff needed to increase immediately if productivity was to remain effective.To address this the owner placed an online advert for farmhands requiring CV’s to be emailed to the business. Candidates that FarmBox were interested in took part in a 20 minute online video interview that aimed to determine their skills and suitability and then successful candidates began work once they were able to evidence that they were free of the Covid virus.…
A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. LaPlaya Mfg. Order Size (Q) 30,000 60,000 Price per Unit (P) Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: $14.38 $13.55 Oversight Cost per Unit (0) $0.00 $0.37 $ LA GA $ LA tA a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 480,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 30,000 units 60,000 units tA Transport Cost…
As a logistics specialist, you are responsible for meeting customer demand. One of your customers places orders for you to supply four products by the end of October. You have limited capacity for raw material and other facilities. You are required to satisfy customer demand by manufacturing the products and/or buying from a supplier. After consulting with the production department, you obtained the following information. Product A Product B Product C Product D Order quantity 2000 3500 1500 2500 Hours required on machine X per unit 2 4 5 3 Hours required on machine Y per unit 4 3 6 2 Raw material in kilos 5 1 4 6 Time needed for Packaging per unit 36 minutes 30 minutes 45 minutes 24 minutes Available monthly hours per month: 8,000 on machine X, 6000 on machine Y, and 3,000 hours for packaging. Purchased items from your supplier are already packaged. Available raw material per month: 5,000 kilos…
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. LaPlaya Mfg. Order Size (Q) 44,000 88,000 Price per Unit (P) Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: $15.14 $14.08 Oversight Cost per Unit (0) $0.00 $0.47 LA tA tA tA a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 440,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 88,000 units $ tA $ LA Transport Cost per Unit…
Write short notes on- EOQ, ABC system, cycle service level.
No written by hand solution The questions below refer to the following SAME paragraph: Suppose a retailer Mojo, holds safety stock for an item to accommodate a 98% service level with uncertain demand. There are two supply options: Supplier X taking 5 days to deliver replenishments, and Supplier Y taking 3 days to replenish. Both suppliers charge the same price for the item. Ignoring differences in fixed order costs, the retailer should choose: Group of answer choices Supplier X Option Y only if the critical ratio is less than 0.9 Option X only if the critical ratio is greater than 0.9 Supplier Y
Hau Lee Furniture, Inc spends 55% of its sales dollars in the supply chain and finds its current profit of $15,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment Hau would ike to improve the profit line to $20,000 so he can obtain the bank's approval for the loan Current Situation Sales $100,000 $55,000 (55%) $15,000 (15%) Cost of material Production costs Fixed cost $15,000 (15%) Profit $15,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $20,0007 What is the cost of material with a $20,000 profit? A decrease of% in matenial (supply-chain) costs is required to yield a profit of $20,000, for a new material cost of S (Enter your response for the percentage decrease to one decimal place and enter your resporise for the new matenal cost as a whole number.)