Concept explainers
Dan McClure owns a thriving independent bookstore in artsy New Hope, Pennsylvania. He must decide how many copies to order of a new book, Power and Self-Destruction, an exposé on a famous politician’s lurid affairs. Interest in the book will be intense at first and then fizzle quickly as attention turns to other celebrities. The book’s retail price is $20, and the wholesale price is $12. The publisher will buy back the retailer’s leftover copies at a full refund, but McClure Books incurs $4 in shipping and handling costs for each book returned to the publisher. Dan believes his demand
- a. Dan will consider this book to be a blockbuster for him if it sells more than 400 units. What is the probability that Power and Self-Destruction will be a blockbuster? [LO13-1]
- b. Dan considers a book a “dog” if it sells less than 50 percent of his mean forecast. What is the probability this exposé is a “dog”? [LO13-1]
- c. What is the probability that demand for this book will be within 20 percent of the mean forecast? [LO13-1]
- d. What order quantity maximizes Dan’s expected profit? [LO13-1]
- e. If Dan orders the quantity needed to achieve a 95 percent in-stock probability, what is the probability that some customer won’t be able to purchase a copy of the book? [LO13-2]
- f. Suppose Dan orders 300 copies of the book. What is Dan’s expected leftover inventory? [LO13-2]
- g. Suppose Dan orders 300 copies of the book. What are Dan’s expected sales? [LO13-2]
- h. Suppose Dan orders 300 copies of the book. What is Dan’s expected profit? [LO13-2]
- i. How many books should Dan order if he wants to achieve a 95 percent in-stock probability? [LO13-3]
a)
To determine: The probability that the book will be a blockbuster.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 400 units
Calculation of Z – value:
Using the Excel =NORMSDIST (2.5) function, the probability value is 0.99379.
Calculation of probability of being a blockbuster:
The probability that the book will be a blockbuster is 0.0062.
b)
To determine: The probability that the book will be a dog.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 50% of mean
= 100 units
Calculation of Z – value:
Using the Excel =NORMSDIST (-1.25) function, the probability value is 0.10565.
The probability that the book will be a dog is 0.1057.
c)
To determine: The probability that the demand of the book will be within 20% of the mean forecast.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Expected demand = within 20% of the mean forecast
Calculation of probability:
The expected demand value is said to be within 20% of the mean forecast. It means, the demand will be 20 % less or 20% more than the mean.
When sales is 20% less:
When sales is 20% more:
Using the Excel =NORMSDIST (-0.50) function, the probability value is 0.30854.
Using the Excel =NORMSDIST (0.50) function, the probability value is 0.69146.
The two probabilities are subtracted to identify the demand probability as shown below:
The probability that the demand of the book will be within 20% of the mean forecast is 0.3830.
d)
To determine: The order quantity that maximizes the profit.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Calculation of critical ratio:
Using the Excel =NORMSINV (0.6667) function, the value of Z using the round up rule is 0.5.
Calculation of order quantity that maximizes the expected profit:
The order quantity that maximizes the profit is 240 units.
e)
To determine: The probability that some customers won’t be able to purchase a copy of the book.
Explanation of Solution
Given information:
In-stock probability = 95%
Calculation of probability of some customers not able to purchase the book:
The in-stock probability is 95% which means 95% percent of customers are able to purchase the book. Therefore, the probability that the customers will not be able to purchase the book will be:
The probability that some customers won’t be able to purchase a copy of the book is 5%.
f)
To determine: The expected leftover inventory.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 300 units
Calculation of Z – value:
From the standard normal distribution table, using the roundup rule, the value of expected inventory distribution (I) for a Z-value of 1.3 is 1.3455.
Calculation of expected leftover inventory:
The expected leftover inventory is 107.64 units.
g)
To determine: The expected sales.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 300 units
Calculation of expected sales:
The expected sales is 192.36 units.
h)
To determine: The expected profit.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 300 units
Calculation of expected profit:
The expected profit is $108.32.
i)
To determine: The number of books that must be ordered to achieve an in-stock probability of 95%.
Explanation of Solution
Given information:
Retail price (RP) = $20
Wholesale price (WP) = $12
Shipping and handling cost (SC) = $4
Mean (M) = 200
Standard deviation (SD) = 80
Target sales (T) = 300 units
Calculation of order quantity:
The in-stock probability of 95% and the roundup rule corresponds to z- value of 1.70 from the standard distribution table.
The number of books that must be ordered to achieve an in-stock probability of 95% is $336 books.
Want to see more full solutions like this?
Chapter 13 Solutions
Loose-leaf For Operations Management, 1e
Additional Business Textbook Solutions
Business in Action (8th Edition)
Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
Operations Management: Processes and Supply Chains (12th Edition) (What's New in Operations Management)
Operations Management: Processes and Supply Chains (11th Edition)
Operations Management, Binder Ready Version: An Integrated Approach
Operations Management: Sustainability and Supply Chain Management (12th Edition)
- AAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3 e. Which alternative should be chosen based on the minimax regret criterion? f. Which alternative should be chosen using the expected monetary value (EMV) criterion? g. What is the expected value under perfect information (EVPI)? Show Workarrow_forwardAAA auto supply store sells snow tires which are ordered every Friday to meet next week's demand. The sales price for the most popular size is $50 per tire and its cost for AAA is $35. If too many tires are ordered AAA incurs an inventory carrying cost of $2 per tire. If AAA is out of stock, it forgoes the profits from missed sales. AAA has the option to order 100, 150, or 200 tires to meet next week's demand which can be either 100, 150, or 200 tires.Based on its historical demand distribution, assume that AAA Inc. has determined the followingprobability information: P(100) = 0.4, P(150) = 0.3, and P(200) = 0.3.a. Which alternative should be chosen based on the maximax criterion?b. Which alternative should be chosen based on the maximin criterion?c. Which alternative should be chosen based on the Lapalce criterion?d. Which alternative should be chosen based on criterion of realism with alpha = 0.7?e. Which alternative should be chosen based on the minimax regret criterion?f. Which…arrow_forwardA Mercedes dealer must pay $20,000 for each car purchased. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He considers the lawsuit to be behind schedule but estimates that if he is short on one car in one year he will lose $20,000 worth of future profits. Each time the dealer places an order for automobiles, the ordering cost adds up to $10,000. Determine the distributor's optimal ordering policy. What is the maximum deficit that will occur? What is the total annual cost?arrow_forward
- Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, “That’s life.” On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolatecovered shrimp in some boxes so that “You never know what you’ll get.” Quarterly demand (in boxes of chocolates) for the last 3 years follows: Quarter Year 1 Year 2 Year 3 1 2 3 4 3,000 1,700 900 4,400 3,300 2,100 1,500 5,100 3,502 2,448 1,768 5,882 Total 10,000 12,000 13,600 a. Use intuition and judgment to estimate quarterly demand for the fourth year.b. If the expected sales for chocolates are 14,800 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. Are any of the quarterly forecasts different from what you thought you would get in part (a)?arrow_forwardJAL Trading is a Hong Kong manufacturer of electroniccomponents. During the course of a year it requires container cargo space on ships leaving Hong Kong bound forthe United States, Mexico, South America, and Canada.The company needs 280,000 cubic feet of cargo space annually. The cost of reserving cargo space is $7000 and thecost of holding cargo space is $0.80/ft3. Determine howmuch storage space the company should optimally order,the total cost, and how many times per year it should placean order to reserve spacearrow_forwardGeox Ltd buys shoes from a supplier in Italy and sells them on to retailers in Australia. Geox Ltd currently uses an EOQ model to determine the number of shoes to send to order. The annual demand for shoes is approximately 45,600. The ordering cost is $55 per order. The annual cost of physically storing shoes is $8.75 per unit. The insurance on the inventory (shoes) cost is $4.25 per unit. The opportunity cost (annual ROI 25% x $30) is $7.50 per unit. The accountant of Geox Ltd, Richard Branson, recently attended a seminar on Just-in-Time (JIT) and is considering how the ideas of JIT differ from traditional techniques like EOQ and how they may help to manage inventory more efficiently. REQUIRED: A) Use the EOQ model to determine the optimal number of shoes per order. (show calculations) B) If it takes two weeks to receive an order, at what point should Geox Ltd reorder shoes? (show calculations) C) Geox Ltd has determined that demand may vary from the average by up to 25%. To handle…arrow_forward
- Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 The owner found out that: P(Low demand) = 1/3; P(Med demand) = 1/2; P(High demand) = 1/6. Which of the following decision is NOT true? A)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform a Laplace approach. B)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform the EMV approach. C)The EVPI is $2,000. D)The EVwPI is $31,500.arrow_forwardGrand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair. Based on the Price-Demand Relationship, what advice would you provide to the store manager to deal with this problem? Fancy Fashions sells jeans for $59 and sweaters for $39. To increase sales of jeans and sweaters, Fancy Fashions promotes this Product Price Bundle: “Buy a pair of jeans and a sweater for $98”. Will this Product Price Bundle will work well to increase the sales of jeans and sweaters?arrow_forwardA distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?arrow_forward
- A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $24.50 and Ch = $7.The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with ? = 25 and ? = 5. (a)What is the recommended order quantity? (Round your answer to the nearest integer.) (b)What are the reorder point and safety stock if the store desires at most a 4% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder pointsafety stock (c)If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.) How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.)arrow_forwardHayes Electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters: (a) Both ordering cost and carrying cost are 10% less than originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.arrow_forwardThe manager of Alaina’s Garden Center must make the annual purchasing plans for rakes, gloves, and other gardening items. One of the items the company stocks is Fast-Grow, a liquid fertilizer. The sales of this item are seasonal, with peaks in the spring, summer, and fall months. Quarterly demand (in cases) for the past 2 years follows: Quarter Year 1 Year 2 1 2 3 4 45 339 299 222 67 444 329 283 Total 905 1,123 If the expected sales for Fast-Grow are 1,850 cases for year 3, use the multiplicative seasonal method to prepare a forecast for each quarter of the year.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,