The Haskell Opera House is trying to decide on how many copies of a book to purchase at the start of the upcoming selling season. The book retails at $28.00. The publisher sells the book to Haskell Opera House at $20.00. Haskell Opera House will dispose of all of the unsold copies of the book at 50% off the retail price, at the end of the season. Haskell Opera House estimates that demand for this book during the season is Normal with a mean of 1000 and a standard deviation of 250. Suppose Haskell Opera House wants to maximize its expected profits from the sale of this book. How many copies should it order from the publisher? Data is also available in the Excel sheet. Show your work on the excel file, 60.12 55 78.34 102 Inputs Average demand Standard deviation Unit costs Sales price Disposal value Inventory holding costs 1000 250 $28 $20 50% of retail price $20 Salvage value Cost of understocking Cost of overstocking Outputs Optimal cycle service level Optimal lot size The Haskell Opera House is trying to decide on how many copies of a book to purchase at the start of the upcoming selling season. The book retails at $28.00. The publisher sells the book to Haskell Opera House at $20.00. Haskell Opera House will dispose of all of the unsold copies of the book at 50% off the retail price, at the end of the season. Haskell Opera House estimates that demand for this book during the season is Normal with a mean of 1000 and a standard deviation of 250. Suppose Haskell Opera House wants to maximize its expected profits from the sale of this book. How many copies should it order from the publisher? Data is also available in the Excel sheet. Show your work on the excel file, 60.12 55 78.34 102 Inputs Average demand Standard deviation Unit costs Sales price Disposal value Inventory holding costs 1000 250 $28 $20 50% of retail price $20 Salvage value Cost of understocking Cost of overstocking Outputs Optimal cycle service level Optimal lot size