Concept explainers
Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a
a. If an ROP model is used, what ROP would be consistent with the desired service level? How many days of supply are on hand at the ROP, assuming average demand?
b. If a fixed-interval model is used instead of an ROP model, what order size would be needed for the 90 percent service level with an order interval of 10 days and a supply of 8 gallons on hand at the order time? What is the probability of experiencing a stockout before this order arrives?
c. Suppose the manager is using the ROP model described in part a. One day after placing an order with the supplier, the manager receives a call from the supplier that the order will be delayed because of problems at the supplier's plant. The supplier promises to have the order there in two days. After hanging up, the manager checks the supply of walnut fudge ice cream and finds that 2 gallons have been sold since the order was placed. Assuming the supplier's promise is valid, what is the probability that the dairy will run out of this flavor before the shipment arrives?
a)
To determine: The reorder point and days of supply on hand.
Introduction: Reorder point is the point at which the firm has to replenish its inventory in order to avoid shortages or any lag in production.
Answer to Problem 21P
Explanation of Solution
Given information:
Formula:
Calculation of Reorder point and number of days of supply:
Using z-factor table, the z value corresponds to 0.90. The closest value of probability is 0.8997 which corresponds to z = 1.28.
Reorder point is calculated by multiplying 21 with
Number of days of supply is calculated by dividing 9 with the ratio of 21 and 7 which yields 3 days of supply on hand at ROP.
Hence, the reorder point and days of supply on hand is 9 gallons and 3days.
b)
To determine: The probability of experiencing stock out before the order arrives.
Introduction: Safety stock refers to the quantity of additional or extra stock which are maintained to mitigate the risks and uncertainty which arises due to fluctuation in supply and demand.
Answer to Problem 21P
Explanation of Solution
Given information:
Formula:
Calculation to determine the probability of stock out before arriving of the order:
Using z-factor table, the lead service level is 0.8577.
The risk of stock out is calculated by finding the z-factor from using the ROP of 8, mean demand of 21 and standard deviation of 3.5 and lead time of
For z=1.07, the corresponding value from z-factor table is 0.8577. The probability to find the risk of stock out is difference between 1 and 0.8577 which gives 14.23%.
Hence, the probability of experiencing stock out before the order arrives is 14.23%.
c)
To determine: The probability of stock out situation.
Introduction: Safety stock refers to the quantity of additional or extra stock which are maintained to mitigate the risks and uncertainty which arises due to fluctuation in supply and demand.
Answer to Problem 21P
Explanation of Solution
Given information:
Calculation to determine the probability of stock out situation:
The ROP is 9 gallons (refer equation (1)) and 2 gallons had been sold after placing order. Stock after day 1 of placing order is the difference between 9 and 2 which is 7 gallons.
Using z-factor table, the lead service level is 0.7019.
The risk of stock out is calculated by finding the z-factor from using the ROP of 7, mean demand of 21 and standard deviation of 3.5 and lead time of
For z = 0.53, the corresponding value from z-factor table is 0.7019. The probability to find the risk of stock out is difference between 1 and 0.7019 which gives 29.81%.
Hence, the probability of experiencing stock out is 29.81%.
Want to see more full solutions like this?
Chapter 13 Solutions
Operations Management
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardFranklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All of their products are engineer-to-order and so the company never knows exactly what components to purchase for a tool until a customer places an order. However, the company believes that weekly demand for a few components is fairly stable. Component 135.AG is one such item. The last 26 weeks of historical use of component 135.AG is recorded below. Week Demand Week Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 137 136 143 136 141 128 149 136 134 142 125 134 118 14 15 16 17 18 19 20 21 22 23 24 25 26 131 132 124 121 127 118 120 115 106 120 113 121 119 Use OM Explorer’s Time Series Forecasting Solver to evaluate the following forecasting methods. Start error measurement in the fifth week, so all methods are evaluated over the same time interval. Use the default settings for initial forecasts.i. Naïve (1-Period Moving Average)ii. 3-Period Moving Averageiii. Exponential Smoothing,…arrow_forward
- Weekly Average Demand 698 Standard deviation of (weekly) demand 35 Setup cost ($) 1750 Procurement cost ($) 290 Holding cost /unit/week ($) 1 In the provided table, you will find details about the demand and inventory levels of the "Galaxy Explorer" drone, a best-selling product at a department store. The store is open for 42 weeks in a year. The store manager placed an order in the beginning of week 13, and he expects to receive the orders in the beginning of week 15. On average, how many units of "Galaxy Explorer" drone should the store manager expect to sell while waiting for the order to arrive? (Do not round your intermediate calculations. Round your final answers to the nearest whole number. Only enter a number. Do not enter any unitsarrow_forward8b) 7,000 drivers from Barrie drive southbound 5 days a week to see a billboard ad on Highway 400 (You cannot see the billboard going north). If we assume there are 200,000 total people in Barrie, what would the GRP per week for the billboard be for the target market of "the entire city of Barrie"?arrow_forwardA firm uses a one-week periodic review inventory system. A two-day lead time is needed for any order, and the firm is willing to tolerate an average of one stock-out per year.a. Using the firm’s service guideline, what is the probability of a stock-out associated with each replenishment decision?b. What is the replenishment level if demand during the review period plus lead-time period is normally distributed with a mean of 60 units and a standard deviation of 12 units?c. What is the replenishment level if demand during the review period plus lead-time period is uniformly distributed between 35 and 85 units?arrow_forward
- Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 24 gallons per week and a standard deviation of 3.5 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.)Use Table B and Table B1. a-1. If an ROP model is used, what ROP would be consistent with the desired service level? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) ROP gallons a-2. How many days of supply are on hand at the ROP, assuming average demand? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Days b-1. If a fixed-interval model is used instead of an ROP model, what order size would be needed for the 90 percent service level with an order interval of 7 days and a supply of 8 gallons on hand at the order time? (Do not round intermediate…arrow_forwardDemand for devil’s food whipped-cream layer cake at a local pastry shop can be approximatedusing a Poisson distribution with a mean of six per day. The manager estimates it costs $9 to prepare each cake. Fresh cakes sell for $12. Day-old cakes sell for $9 each. What stocking level isappropriate if one-half of the day-old cakes are sold and the rest thrown out?arrow_forwardGreat Harvest bakery distributes an average of 1,000 breads per day to local stores and restaurants. This demand is normally distributed with a standard deviation of 95 breads per day. The baking firm who makes the bread requires a 3-day lead time. The manager of Great Harvest expects a 96% service level to satisfy high customer expectations. Refer to the standard normal table N 0.38 0.50 0.67 75 1.28 0.84 80 1.41 1.04 85 1.56 Pr(Z) 1.65 65 1.75 69 2.33 90 92 94 95 96 2.06 98 99 a) The reorder point = enter your response here breads (round your response to the nearest whole number). b) The safety stock = enter your response here breads (round your response to the nearest whole number).arrow_forward
- Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?arrow_forwardProblem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.45 a copy. You sell a copy of San Pedro Times for $1.40. Daily demand is distributed normally with mean = 340 and standard deviation = 68. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) 8 Answer is complete but not entirely correct. Optimal order quantity 0.05 b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) * Answer is complete but not entirely correct. Probability 3 X %arrow_forward7. SBS Juices sell orange juice. Every morning (7am) the manager has to decide on the amount (liter) of juice to make for customers arriving between 8am and 9am. Demand for the juice follows a normal distribution with a mean of 20 liters per day and a standard deviation of 5 liters per day. Price per liter is $48.067, material cost per liter is $40, and salvage value per liter is $10. What is the optimal level of juice to make each morning to maximize expected profit?arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning