Cs507 Assignment 5% Solution Of Neutral Detergent For Wool

CS507 - Information Systems Assignment No. 2 Solution and Discussion Spring 2017 Due Date: May 27, 2017 

Assignment No.2


Semester Spring 2017
Information System– CS507

Total Marks: 20

Due Date:26/05/2017


Please read the following instructions carefully before solving & submitting assignment:

  1. 1.     The assignment will not be accepted after due date.
  2. 2.     Zero marks will be awarded to the assignment that does not open or the file is corrupt.
  3. 3.     The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
  4. 4.     Don not send or attach Excel file.
  5. 5.     Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
  6. 6.     Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at CS507@vu.edu.pk

Do not post queries related to assignment on MDB.


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___

JR4Gl) В конце концов один из них объяснил Беккеру то, что тот уже и сам понял. Эта абракадабра представляла собой зашифрованный текст: за группами букв и цифр прятались слова. Задача дешифровщиков состояла в том, чтобы, изучив его, получить оригинальный, или так называемый открытый, текст.

0 thoughts on “Cs507 Assignment 5% Solution Of Neutral Detergent For Wool”


Leave a Comment

Your email address will not be published. Required fields are marked *