33242 ences PA 13-1 (Algo) Dan McClure owns a thriving independent bookstore.. 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 $26, and the wholesale price is $16. The publisher will buy back the retailer's leftover copies at a full refund, but McClure Books incurs $6 in shipping and handling costs for each book returned to the publisher. Dan believes his demand forecast can be represented by a normal distribution with a mean of 225 and a standard deviation of 80. Use Table 13.4. Note: If a part of the question specifies whether to use Table 13.4, or to use Excel, then credit for a correct answer will depend on using the specified method. a. Dan will consider this book to be a blockbuster for him if it sells more than 375 units. Using Table 13.4 and the round-up rule, what is the probability that Power and Self-Destruction will be a blockbuster? Note: Round your answer to 4 decimal places. Probability b. Dan considers a book a "dog" if it sells less than 50 percent of his mean forecast. What is the probability this expose is a "dog"? Use Excel. Note: Round your answer to 4 decimal places. Probability c. Use Table 13.4 and the round-up rule to determine the probability that demand for this book will be within 20 percent of the mean forecast. Note: Round your answer to 4 decimal places. 1227 Probability d. Using Table 13.4 and the round-up rule, calculate the order quantity that maximizes Dan's expected profit. Note: Do not round intermediate calculations. Round to the nearest whole number. Order quantity e. If Dan orders the quantity needed to achieve a 94% in-stock probability, then what is the probability that some customer won't be able to purchase a copy of the book? Note: Enter your answer as a percentage rounded to the nearest whole number. Probability %