Hi, would you please take a look at task 1 and help. The assignment task on the green block on the top right is what I am asked to do. I think I did it right, but the grading system seems not to catch my inputs as per the second screen shot. Would you take a look?

Task # Points Task Description Use Scenario Manager to compare the 5 scenarios on the SupphrAndDemand worksheet using cell C13 (SurplusfShortfall) as the outcome variable. Create a separate scenario for each of the scenarios outlined on the scenario manager table (cells E238}. Use Scenario 1, Scenario 2,..., Scenario 5 as the names for your scenarios. The changing cells for the scenarios will be cells C3117 of the supply and demand model. Use the values on the scenarios manager table for each of the scenarios you create. Run the scenario summary and select the scenario closest to the equilibrium point using the drop-down list in cell J10. [- 3] Scenario 1 changing cells should be $C$3: $C$7. [- 3] Scenario 2 changing cells should be $C$3: $C$7. [- 3] Scenario 3 changing cells should be $C$3: $C$7. [- 3] Scenario 4 changing cells should be $C$3: $C$7. [- 3] Scenario 5 changing cells should be $C$3: $C$7. [- 3] Scenario 1 values are not correct [- 3] Scenario 2 values are not correct [- 3] Scenario 3 values are not correct [- 3] Scenario 4 values are not correct [- 3] Scenario 5 values are not correct Lise goal seek to calculate the equilibrium point for the quantity supplied and the quantity demanded (allow the price to change in order for surplusfshortfall to equal zero}. Complete cells F13:F17 to report the elemenis of your Goal 2 24,132 Seek analysis and the resulting price. Note: if the values for cells C3:C6 were changed as part of your work on Task 1, you will want to change them back for this Task. The values should be: (23:600, (24:35, (25:0, and (26:45. [-8] The "Set Cell\" value is incorrect. - Saved to my Mac AutoSave ()OFF " What-IfAnalysisPractice-RO-Alberto_Tovela - Data Review Assignment Tasks len Home Insert Draw Page Layout Formulas View Assignment Tell me What-If Analysis Practice Use Scenario Manager to compare the 5 scenarios on the SupplyAndDemand worksheet using cell C13 (Surplus/Shortfall) as the outcome variable. Create a separate scenario for Submit View each of the scenarios outlined on the scenario manager table (cells E2:J8). Use Scenario 1, Instruction Task Guide Report Scenario 2,..., Scenario 5 as the names for your scenarios. The changing cells for the Sheet 1 scenarios will be cells C3:C7 of the supply and demand model. Use the values on the N Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? scenarios manager table for each of the scenarios you create. Run the scenario summary and select the scenario closest to the equilibrium point using the drop-down list in cell J10. [34 points] late * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. E3 + X V fx B C D E F G H I J K L M N 0 P Q R S T U V A Supply and Demand Model Scenario Manager W N Demand Intercept 500 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 The economic principles of supply and demand are important for Demand Slope 3.5 Demand Intercept 500 400 600 350 750 determining the market price for a particular product. The price for Supply Intercept Demand Slope 2.5 1.7 3.6 4.2 1.2 the product can also be used to determine the quantity of the 0 Supply Slope 4.5 Supply Intercept 50 0 25 0 product supplied and demanded in the market. The market price for 5.6 Price $ 100.00 Supply Slope 3.5 1.2 4.5 3.4 the product will be the price where the quantity supplied equals the Price $60 $75 $50 $45 $80 quantity demanded. Complete the tasks to explore the relationships Intermediate Calculations among price, quantity demanded, and quantity supplied for the 10 Quantity Demanded 250 Which scenario is closest to equilibrium (zero surplus/shortfall)? Scenario 4 product depicted on this worksheet. 11 Quantity Supplied 450 12 Goal Seel 13 Surplus/Shortfall 200 Set Cell: $C$3 14 To Value: 15 Scenario 1 By Changing Cells: $C$7 16 Demand Intercept 500 17 Demand Slope 2.5 Changing Cell Value @ Goal $75 18 Supply Intercept 50 Gunnlv and namand Curves 19 Supply Slope 3.5 Quantity Demanded Quantity Supplied Vertical (Value) Axis Major Gridlines 20 Price $ 60.00 Price Quantity Price Quantity 700 21 $0 600 0 600 Intermediate Calculations $5 582.5 $5 22 22.5 500 23 Quantity Demanded 350 $10 565 $10 45 24 Quantity Supplied 260 $15 547.5 $15 67.5 400 Quantity Demanded 25 $20 530 $20 90 300 -Quantity Supplied 26 Surplus/Shortfall -90 $25 512.5 $25 112.5 27 $30 495 $30 135 200 28 Scenario 2 $35 477.5 $35 157.5 100 29 400 $40 460 $40 180 Demand Intercept 30 Demand Slope 1.7 $45 442.5 $45 202.5 0 so $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 31 Supply Intercept $50 425 $50 225 1.2 $55 407.5 $55 32 Supply Slope 247.5 33 $60 270 Price $ 75.00 $60 390