Please answer the question and also complete the excel part! Thanks!

A B C D E F G H 1 J K L M N 0 P Q News vendor Model Profit Demand 1 2 3 4 1 Newsvendor Model 1 Newsvendor Model 3 Data 3 Data 4 Selling price $ 18.00 5 Selling price 18 Cost $ 12.00 Cost 12 7 Discount price $ 0.00 7 Discount price 9 8 8 9 Model 9 Model 10 10 11 Demand 4111 12 Purchase Quantity 44|| 12 Purchase Quantity 44 13 13 14 Quantity Sola 41|| 14 Quantity Sold -MIN(B11,812) 15 Surplus Quantity 31 15 Surplus Quantity -MAX(O B12-811) 16 16 17 Profit 5 237.00 17 Profit =B14B5+015-07-312-08 Purch Demand 41 Question 2 1 /1 pts 5 Data . 5 Regular price 5 Cost Discount price 3 e Model 0 1 Demand 2 Purchase Quantity 3 4 Quantity Sold at Full Price 5 Surplus Quantity 6 7 Regular Revenue 8 Discount Revenue 9 Total costs 0 Profit 1 2 3 4 5 5 6 7 8 9 0 1 1 2 3 4 5 5 6 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The gasoline mini-mart purchases the magazines for $1.50 and sells them for $4.00. 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 on worksheet Minimart. Create a one-way data table to investigate the financial implications of this policy if the demand is expected to vary between 1 and 30 copies each month. How many must be sold to at least break even? Hint: You should set up a Newsvendor model similar to the above example, and then use a one-way data table in the highlighted area to figure out the profit for variaous demand. The lowest demand at which the profit turns positive is the answer you are looking for