We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ 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
How to Add New Discussion in Study Group ? Step By Step Guide Click Here.
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.
A 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)
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
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?
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.
3. Add a scenario by clicking on Add.
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.
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.
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 ?
|Case||Heighest Price Sold||Total Profit|
|%||Number of Computer||Unit Profit||Profit|
|Heighest Price Sold||60%||120||1000||120,000|
|Heighest Price Sold||70%||140||1000||140,000|
|Heighest Price Sold||80%||160||1000||160,000|
|Heighest Price Sold||90%||180||1000||180,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
Ossammmm bhayia.... :) nice job thanks.... GOD bless u.
Ans tu thek h lekin sonerios kahn se set kren
Please Discuss here about this assignment.Thanks
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>>
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.
Or visit this link
Please Click on the below link to see…