We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# Assignment No. 02,CS507, Due Date 26 may,2017

Assignment Statement

By using What-If Analysis tool in Excel, you can use several different sets of values in
one or more formulas to explore all the various results. What-If Analysis allows you to try out different values (scenarios) for formulas.

Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view different results.

Scenarios are managed with the Scenario Manager wizard from the What-If Analysis group on the Data tab.

Suppose you own a Computer store and have 200 computers in storage. You sell a certain % for the highest price of 1000Rs and a certain % for the lower price of 500Rs. If you sell 60% for the highest price, cell E11 calculates a total profit of 60 * 1000 + 40 * 500 = 160000.

What if you sell 70% for the highest price? And what if you sell 80% for the highest price? Or even 90%? Each different percentage is a different scenario.

Q No 1:

You are required to add 4 scenarios 60%, 70%, 80% and 90% by using Scenario Manager. After adding scenarios, take screenshot of the scenario manager and paste it here.    (Marks = 10)

Q No 2:

Take screenshot of scenario summary showing all the scenarios that you have added to the scenario manager and paste it here. (Marks = 10)

___The end___

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 3029

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Attachments:

### Replies to This Discussion

c lesson 10 lecture...

How to use Scenario Manager in Excel? :/
In Lectures, professor is not teaching how to use Excel's functions.
So, how we can use this?
Any guidance?

aslamulikum...

mjy ais assignment ki smj ni aa rahe ha plz step by step koye smjha skta hak ah assignment krni kaisy hain

easy ha just use excel in data click on what if and then scenario manager and make a scenario

Create Different Scenarios

But what if you sell 70% for the highest price? And what if you sell 80% for the highest price? Or 90%, or even 100%? Each different percentage is a different scenario. You can use the Scenario Manager to create these scenarios.

Note: You can simply type in a different percentage into cell C4 to see the corresponding result of a scenario in cell D10. However, what-if analysis enables you to easily compare the results of different scenarios. Read on.

1. On the Data tab, in the Forecast group, click What-If Analysis.

2. Click Scenario Manager.

The Scenario Manager dialog box appears.

4. Type a name (60% highest), select cell C4 (% sold for the highest price) for the Changing cells and click on OK.

5. Enter the corresponding value 0.6 and click on OK again.

6. Next, add 4 other scenarios (70%, 80%, 90% and 100%).

Finally, your Scenario Manager should be consistent with the picture below:

Note: to see the result of a scenario, select the scenario and click on the Show button. Excel will change the value of cell C4 accordingly for you to see the corresponding result on the sheet.

Scenario Summary

To easily compare the results of these scenarios, execute the following steps.

1. Click the Summary button in the Scenario Manager.

2. Next, select cell D10 (total profit) for the result cell and click on OK.

Result:

Conclusion: if you sell 70% for the highest price, you obtain a total profit of \$4100, if you sell 80% for the highest price, you obtain a total profit of \$4400, etc. That's how easy what-if analysis in Excel can be.

Sir g is ke complete working mil sakti ha kya ?

 Computer Unit 200 Heighest_Price_Unit 1000 Lower_Price_Unit 500 Case Heighest Price Sold Total Profit Case 1 60% 160,000 Case 2 70% 170,000 Case 3 80% 180,000 Case 4 90% 190,000 Manual Calculation % Number of Computer Unit Profit Profit Heighest Price Sold 60% 120 1000 120,000 Lower Price 40% 80 500 40,000 Total Profit 160,000 Heighest Price Sold 70% 140 1000 140,000 Lower Price 30% 60 500 30,000 Total Profit 170,000 Heighest Price Sold 80% 160 1000 160,000 Lower Price 20% 40 500 20,000 Total Profit 180,000 Heighest Price Sold 90% 180 1000 180,000 Lower Price 10% 20 500 10,000 Total Profit 190,000

Computer Unit 200
Heighest_Price_Unit 1000 Lower_Price_Unit 500

Case Heighest Price Sold Total Profit
Case 1 60% 160,000
Case 2 70% 170,000
Case 3 80% 180,000
Case 4 90% 190,000

Manual Calculation for Proof
% Number of Computer Unit Profit Profit
Heighest Price Sold 60% 120 1000 120,000
Lower Price 40% 80 500 40,000
Total Profit 160,000

Heighest Price Sold 70% 140 1000 140,000
Lower Price 30% 60 500 30,000
Total Profit 170,000

Heighest Price Sold 80% 160 1000 160,000
Lower Price 20% 40 500 20,000
Total Profit 180,000

Heighest Price Sold 90% 180 1000 180,000
Lower Price 10% 20 500 10,000
Total Profit 190,000

Ossammmm bhayia.... :) nice job thanks.... GOD bless u.

Ans tu thek h lekin sonerios kahn se set kren

Computer Unit 200
Heighest_Price_Unit 1000
Lower_Price_Unit 500
Case     Heighest Price Sold Total Profit
Case 1     60% 160,000
Case 2     70% 170,000
Case 3     80% 180,000
Case 4     90% 190,000
Manual Calculation % Number of Computer Unit Profit Profit Heighest Price Sold 60% 120 1000          120,000 Lower Price 40% 80 500            40,000 Total Profit          160,000 Heighest Price Sold 70% 140 1000          140000 Lower Price 30% 60 500            30,000 Total Profit          170,000 Heighest Price Sold 80% 160 1000          160,000 Lower Price 20% 40 500            20,000 Total Profit          180,000 Heighest Price Sold 90% 180 1000          180,000 Lower Price 10% 20 500            10,000 Total Profit          190,000

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

&

.... How to Find Your Subject Study Group & Join ....

## Latest Activity

46 minutes ago
مخلص posted a discussion

### Huawei Y7p and No Google Services.

1 hour ago
Rana Ali replied to Rana Ali's discussion Zaroori tha
3 hours ago
Rana Ali liked Rana Ali's discussion Zaroori tha
3 hours ago
Rana Ali posted a discussion

### Zaroori tha

3 hours ago
Rana Ali replied to Rana Ali's discussion EDU604 Assignment No 1Fall 2019 in the group EDU604 Comparative Education
3 hours ago
4 hours ago
6 hours ago
6 hours ago
6 hours ago
8 hours ago

1

2

3