(Newsboy model) Needless Markup (NM), a famous "high-end" department store, must decide on the quantity of a high-priced woman's handbag to procure in Spain for the coming Christmas season. The unit cost of the handbag to the store is $28.50 and the handbag will sell for $150.00. Any handbags not sold by the end of the season are purchased by a liquidator for $10.00 each. In addition, the store accountants estimate that there is a cost of $0.40 for each dollar tied up in inventory, as this dollar invested elsewhere could have yielded a gross profit. Assume that this cost is attached to unsold bags only.

Optimal Purchase Qty: 203

Q2)What is the expected cost of mismatch under the optimal purchase quantity? What is the optimal expected profit?

how do we work out in excel?