CS507 - Information Systems Assignment No. 2 Solution and Discussion Spring 2017 Due Date: May 27, 2017
Semester Spring 2017
Total Marks: 20
Please read the following instructions carefully before solving & submitting assignment:
For any query about the assignment, contact only at CS507@vu.edu.pk
Do not post queries related to assignment on MDB.
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)
ENG301 Assignment No 3 Fall 2017Dear Students, Here you can read or Download ENG301 - Business CommunicationAssignment No 3 Solution and Discussion of Semester Fall 2017. Assignment Due Date is 02 February, 2018. Total Marks are 20. Lectures covered in this Assignment are from Lecture No 23 to Lecture No 37. ENG301 Assignment Solution File has been added. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions.
|ENG301 Assignment No 2 Solution and discussion Fall 2017|
ENG301 Assignment Instructions:
- Upload your assignments in a proper format, i.e. MS word file. Corrupt files will be awarded zero marks.
- The assignments should be zoomed in at 100%.
- Please avoid plagiarism; plagiarized work will be marked zero.
- After the due date, the assignments submitted via email would not be entertained.
- Please avoid submitting copied assignments; otherwise, such a case would be referred to the discipline committee.
- The font color should be preferably black and font size 12 Times New Roman.
ENG301 Assignment Question No 1:As the Sales Director of Sapphire & Co., write a circular letter to introduce your new Allama Iqbal Town branch to your customers.
ENG301 Assignment Question No 2:Match the special terms for meetings in column A with their definitions in column B and write the correct definitions in column C.
Special terms for Meetings and Committee :
|ENG301 Assignment Question No 2 - Special terms for Meetings and Committee|
ENG301 Assignment No 3 Solution Fall 2017You can see the Sample Preview of ENG301 Assignment No 3 Solution provided by (Virtual Study Solutions) below. Click on Download Button to Download Solution File in Your PC. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us below for Updates.
ENG301 Assignment Solution Sample Preview
|ENG301 Assignment No 3 Solution Fall 2017 Sample Preview|