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: 3027

.

+ 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

good

Agar ap ko smj ni a rhi tu ap mujhay cl kr skty ho office time mn 0345.7927293

This is the solution pls make like that. that solution we i provided above that is only for proof read carefully.

Attachments:

here is the solution

Attachments:

adnan zulfiqar plzz tell me that har scenario ka screen shoot ni lena kya??? apne just ak hi scenario ka screen shoot liya ha

nahi just have to take screenshot of scenario manger to of each scenario

zullfqar bhaiiii   xls file send kr skte hain

yeah lo

Attachments:

Awsome.......................

pahly app excel ki sheet mai value put karain jiss tarhan assignment file mai di gai hain

phir formula bar per jaa kar = ka sign day aur d9 and d10 ko  problem mai diya gay tarikay se select karain

phir enter press karian

jub app ka profit 160000 aa jaye tu

DATA tab__What if Analysis____scenario manager____Add button

than a dialog box will open enter the case no and than click on changing cell dialog box select the 60% values like 120 , 80 and ok

Add other case same like this but now add other value like 80 % in the dialog box and ok a new case enter in the scenario manager enter all one by one and your scenario will be copleted

than take a screenshot from it and insert it in word file

for Q no 2 only click on summary button and other sheet will be open than take a screen shoot of this sheet and insert it in word file

pahly app excel ki sheet mai value put karain jiss tarhan assignment file mai di gai hain

phir formula bar per jaa kar = ka sign day aur d9 and d10 ko  problem mai diya gay tarikay se select karain

phir enter press karian

jub app ka profit 160000 aa jaye tu

DATA tab__What if Analysis____scenario manager____Add button

than a dialog box will open enter the case no and than click on changing cell dialog box select the 60% values like 120 , 80 and ok

Add other case same like this but now add other value like 80 % in the dialog box and ok a new case enter in the scenario manager enter all one by one and your scenario will be copleted

than take a screenshot from it and insert it in word file

for Q no 2 only click on summary button and other sheet will be open than take a screen shoot of this sheet and insert it in word file

1. IN CELL D10 PUT FORMULA =C6*(1-D6) THEN ENTER.
2. IN CELL D9 PUT FORMULA =C6-D10 THEN ENTER.

## Latest Activity

Charming HaDi liked + + + Haniya + + +'s discussion Teacher Gave Him Homework
42 seconds ago
Charming HaDi liked +ıllıllı \$µǥąя ǥ€ɲɨµ\$ ıllıllı+'s discussion Fact
3 hours ago
3 hours ago
Charming HaDi liked + + + Haniya + + +'s discussion KUCH LOG
3 hours ago
3 hours ago
3 hours ago
3 hours ago
Charming HaDi liked + ! ! ! Ayesha ! +'s discussion subhan allah
3 hours ago
3 hours ago

1

2

3