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

AL f. Newsvendor Model A 0 E F H 1 1 K M N 0 P R 5 T w X Y 2 AA AR AC 1 New vendor Machal 2 3 Data 4 4 S Selling price Cost 2 Discount price Meen Sid dev 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 5 R 9 101 : 9 Model 10 3 11 Demand 4 12 Purchase Quantity 13 6 14 Quantity Sold 7 15 Surplus Quantity 16 17 Profit 15 19 Question 2 2 1 pts 20 21 22 A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies between 10 and 30 copies each month. The mini-mart purchases the 23 magazines for $1.50 and sells them for $100. Any magazines left over at the end of the month are dated to tell her health ciltlex Use the Minimart spreet to model this siluulin. Ilmiy bus orci quality ang simulan will 100 Ls. 26 27 Hint 20 28 1. Set up the Newwendur model first 2B 21 29 Z. USE RAND(I to generate a random demand between 10 and 30 in 11. 22 30 3. Set up the two-way datatable. The cutout call of the datatable should reference profit 17, with the row input [17:4C7) represent the purchase quantity (B12) Ibetween 10 23 and 30 to match the demand, and the column input are simulation number 1 10 100 which will NOT be used as input in the datatable. So the row input cel should be 812 while the column input cel should point to any empty cell in the sheet 76 30 After the simulation is set up using the data sble, calculate the mean and std de for 27 27 35 each purchase and lower the 100 profit in each column) 28 36 5. Highlight the purchase that leads to the highest sverge profit 29 37 30 BB 31 39 32 33 41 sc 2 35 36 37 25 38 26 39 47 40 41 29 31 32 11 24 AL f. Newsvendor Model A 0 E F H 1 1 K M N 0 P R 5 T w X Y 2 AA AR AC 1 New vendor Machal 2 3 Data 4 4 S Selling price Cost 2 Discount price Meen Sid dev 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 5 R 9 101 : 9 Model 10 3 11 Demand 4 12 Purchase Quantity 13 6 14 Quantity Sold 7 15 Surplus Quantity 16 17 Profit 15 19 Question 2 2 1 pts 20 21 22 A gasoline mini-mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies between 10 and 30 copies each month. The mini-mart purchases the 23 magazines for $1.50 and sells them for $100. Any magazines left over at the end of the month are dated to tell her health ciltlex Use the Minimart spreet to model this siluulin. Ilmiy bus orci quality ang simulan will 100 Ls. 26 27 Hint 20 28 1. Set up the Newwendur model first 2B 21 29 Z. USE RAND(I to generate a random demand between 10 and 30 in 11. 22 30 3. Set up the two-way datatable. The cutout call of the datatable should reference profit 17, with the row input [17:4C7) represent the purchase quantity (B12) Ibetween 10 23 and 30 to match the demand, and the column input are simulation number 1 10 100 which will NOT be used as input in the datatable. So the row input cel should be 812 while the column input cel should point to any empty cell in the sheet 76 30 After the simulation is set up using the data sble, calculate the mean and std de for 27 27 35 each purchase and lower the 100 profit in each column) 28 36 5. Highlight the purchase that leads to the highest sverge profit 29 37 30 BB 31 39 32 33 41 sc 2 35 36 37 25 38 26 39 47 40 41 29 31 32 11 24