Spreadsheet Modeling and Decision Analysis
Sensitivity Report A sensitivity report of the analysis described above was created and can be found in Appendix E. The solution is not degenerate because there are no zero values in the allowable increase or allowable decrease columns of the constraints in the Sensitivity Report. All of the constraints affect the optimal solution. The solution is unique because there are no zero values in the allowable increase or allowable decrease columns in the decision variables section of the Sensitivity Report. This shows that there are no other combinations of production levels that will optimize this solution.

Decrease the Price of Whole If MNC were to decrease the price of the Whole product by $0.25, the optimal solution would change. This decrease in price would cause Whole’s contribution margin to fall to $0.79 and the optimal profit to fall to $439.76, a $100.00 difference. These calculations can be found in Appendix G. The production levels, however, would not change. This is because, as can be seen in the Sensitivity Report, there is an allowable increase of $0.36 and an allowable decrease of $0.31 in the price of Whole. Because $0.25 falls within this range, this change in price would not affect the production levels of the optimal solution.

...A critical review of spreadsheet modelling The usage of spreadsheet applications, while incredulously recent-sounding, has been perhaps one of the most archetypal examples of computerization of business processes. Conceived by Dr. Richard Mattessich in 1961, an implausible half a century prior, electronic spreadsheets have outphased conventional paper forms of bookkeeping by promising accountants the privilege of partial accounting automation and in...

...Introduction
An electronic, or computerized spreadsheet, can be defined as a software application which displays multiple cells that together make up a grid consisting of rows and columns, each cell containing alphanumeric text, numeric values or formulas which performs the calculation processes (Bessant, 2003; Stroman, Wilson, and Wauson 2004 and Power n. d.). It has been extensively employed ranging from the field of business and financial community to engineering,...

...Strayer university |
Problem Solving & SpreadsheetModeling |
CIS331 |
12/16/2012 |
This paper talks about the problem solving process along with examples, as well as one of more commonly used modeling and analytical techniques, i.e. spreadsheetmodeling. It also talks about its dependency, its uses, disadvantages and well as explores ways to better this very new, but powerful technique. |...

...Distribution Chart, we found that x = 0.84
Therefore,
0.84 = (40 – TE) / 2.37
1.994 = 40 - TE
TE = 38 weeks
3) Using the expected activity time as the normal times and the following crashing information, determine activity crashing decisions and revised activity schedule for the warehouse expansion project.
Activity Crashed Activity Time Cost ($)
(weeks) Normal Crashed
A 4 1,000 1,900
B 7 1,000 1,800
C 2 1,500 2,700
D 8 2,000...

...Q.5 Solution
Bill Denomination (X)
Number of Bills (f)
X*f
X2*f
$1
520
520
520
$5
260
1,300
6500
$10
120
1,200
12000
$20
70
1,400
28000
$50
29
1,450
72500
$100
1
100
10000
Total
1000
5,970
129520
a.
b.
c. The probability that a bar containing $50 or $100 bill is purchased is 30 / 1000 = 0.03
Hence customer have to buy 100 bars of soap, so that he or she has purchased three bars containing a $50 or $100 bill.
d. Given n=1000, E(X) = 5.97, SD(x) =...

...DecisionAnalysis Page 1 of 4
DecisionAnalysis
Donna L. Christian, Strayer University Winter Quarter (MAT 540) Instructor: Mune Lokesh March 11, 2012
DecisionAnalysis Page 2 of 4
In business today, many decision-making situations occur under conditions of uncertainty. The demand for a product can be one number this week and double that number next week or vice versa. There...

...DECISIONANALYSIS ASSIGNMENT 1
Case Problem 1: Planning Advertising Campaign
EXCEL sensitivity report for the Flamingo Grill case problem:
Managerial Report
Question 1:
Data given for Flamingo Grill case problem:
Total budget = $279000
Advertising media | Exposure rating per ad | New customers per ad | Cost per ad ($) | HJ consultant limit application to |
Television | 90 | 4000 | 10000 | 10 |
Radio | 25 | 2000 | 3000 | 15 |
Newspaper | 10 |...

...DECISIONANALYSIS
Definition: A systematic procedure based on thinking patterns used to make choices in the hopes that they are good ones. It involves considering the Elements of a good choice and weighing them against your MUSTS/WANTS and any risks before making a final decision: The book is full of mumbo jumbo on this, but it isn't rocket science. We do some decisionanalysis almost every time we take a course of...

1579 Words |
5 Pages

Share this Document

Let your classmates know about this document and more at StudyMode.com

## Share this Document

Let your classmates know about this document and more at StudyMode.com