Question: table [ [ Scenario Manager ] , [ , Scenario 1 , Scenario 2 , Scenario 3 , Scenario 4 , Scenario 5 ]

\table[[Scenario Manager],[,Scenario 1,Scenario 2,Scenario 3,Scenario 4,Scenario 5],[Demand Intercept,500,400,600,350,750],[Demand Slope,2.5,1.7,3.6,4.2,1.2],[Supply Intercept,50,0,25,0,0],[Supply Slope,3.5,1.2,4.5,3.4,5.6],[Price,,60.00,,75.00,,50.00,,45.00,80.00]]
(4)
in the following multiple choice questions.
8
1
2
Comments
Share
Analysis Tools
Group
Data Analysis
Ungroup
Solver
Atlas 3.0
Select the correct value for the "To value:" parameter in your goal seek analysis.
600
3.5
0
4.5
90
Select the correct value for the "By changing cell:" parameter in your goal seek analysis.
C11
C4
C5
C6
C10
C7
C13
C3
Atlas 3.0
What is the quantity demanded when the price is $60?
600
530
460
390
320
250
What isfthe quantity supplied when the price is $80?
90
180
270
360
450
 \table[[Scenario Manager],[,Scenario 1,Scenario 2,Scenario 3,Scenario 4,Scenario 5],[Demand Intercept,500,400,600,350,750],[Demand Slope,2.5,1.7,3.6,4.2,1.2],[Supply Intercept,50,0,25,0,0],[Supply Slope,3.5,1.2,4.5,3.4,5.6],[Price,,60.00,,75.00,,50.00,,45.00,80.00]]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!