Please answer with detailed calculations , good formatting and explanations else a downvote will be given. Submit the solution only if the answer is 100% correct else skip for other tutor. otherwise wrong answer will be reported for unprofessionalism.

A gasoline mini-mart orders 24 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The mini-mart purchases the magazines for $1.55 and sells them for $3.88. Any magazines left over at the end of the month are donated to hospitals and other health care facilities. Modify the newsvendor example spreadsheet to model this situation. Use what-if analysis to investigate the nancial implications of this policy if the demand is expected to vary between 10 and 30 copies each month. a Click the icon to view the newsvendor example spreadsheet. Newsvendor model spreadsheet H Newsvendor Model The demand must be at least copies for the gasoline mini-mart to break even. (Type a whole number.) Data Selling price Cost Discount price Model 1 2 3 4 5 6 7 8 9 0 Demand Purchase Quantity Quantity Sold Surplus Quantity Prot The formula for the quantity sold is =M|N(B'11,B12). The formula for the surplus quantity is =MAX(O,B'12-B11). The formula for the prot is =B14'BS-B12'BS