Free Samples
MIS775 Decision Modelling For Business Analytics
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
MIS775 Decision Modelling For Business Analytics
0 Download6 Pages / 1,483 Words
Course Code: MIS775
University: Deakin University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Question:
Conceptual model is inappropriate is or not clearly outlined A vague conceptual model is represented which does not reflect clearly on the conceptual model, which contains several modelling errors. An appropriate conceptual model is presented and the decision inputs are identified. Relationships are mostly correctly defined. A clear presentation of conceptual model is presented and the decision inputs are identified. Relationships are mostly correctly defined. A very clear presentation of conceptual model provided. All decision inputs are modelled correctly in a clear way. A very clear presentation of conceptual model provided. All decision inputs are modelled correctly in a clear and innovative fashion Spreadsheet?based decision model Decision model is inappropriate is or not clearly outlined Few decision inputs are identified and briefly described. There are clear errors and omissions. Main decision inputs are produced to identify their relationships. There are a few errors and omissions. Main decision inputs are produced to identify their relationships. All decision inputs are modelled correctly in a clear way. A very clear presentation of decision model provided. All decision inputs are modelled correctly in a clear and innovative fashion which provides end users with an interactive interface which is easy to use. Scenario and sensitivity analysis reports are not included or is inappropriate Some of the possible scenarios and sensitivity analyses are considered and are presented, but not clearly.
Most of the important scenarios and important inputs are considered for the analysis. Most of the important scenarios and inputs are considered for the analysis and elaboration on them is presented clearly. 6 points All of the main scenarios and inputs are considered and they are justified in a clear way, and are presented in a compelling fashion. All scenarios and inputs are considered and they are fully justified in a clear way, and are presented in a compelling fashion. Stochastic model including choice of distributions Stochastic modelling is not included or is inappropriate Stochastic modelling is poorly implemented and analysed. Some effective stochastically modelling is used with poor choice of distributions. Some effective stochastically modelling is used with some elaboration on them. Stochastically modelling is used effectively; choice of distributions is justified. Stochastically modelling is used effectively; choice of distributions is fully justified.Simulated outputand risk analysis is not included or is inappropriate Unclear simulation outputs are presented. Unclear analysis of effect of input risks. Some analysis of simulation output are presented. It considers some relevant stochastic decision inputs and discusses to some effect the effect on output Reasonable analysis of simulation outputs is presented. It considers some of the main stochastic decision inputs and discusses risk on output Clear and Reasonable analysis of simulation output is provided with a comprehensive consideration of the main stochastic decision inputs, some discussion of the effect on output Clear and comprehensive analysis of simulation output is provided with comprehensive consideration of the main stochastic decision inputs, discussion of the effect on output.
Answer:
Number of Borrowers
2
Take Home MonthlySalary
$ 3,500.00
Fixed Inputs
Phone
$ 130.00
Electricity
$ 163.00
Gas
$ 52.00
Water and sewer
$ 93.00
Cable
$ 163.00
Waste removal
$ 151.00
Maintenance or repairs
$ 102.00
Insurance
$ 160.00
Medical
$ 66.00
Clothing
$ 191.00
Others
$ 65.00
Council Rates
$ 163.00
Cable TV
$ 198.00
Internet
$ 121.00
Decision Variables
Total Monthly Cost
$ 1,818.00
Max Monthly Payment Based on Income
$ 5,485.00
Loan amount required
$ 2,50,000.00
Financing (Stochastic)
Term of Mortgage (years)
20
Annual Interest Rate
4.00%
Calculated Variables
Total Interest Paid
$ 21,616.13
Actual tenure of Payment (Years)
4.13
Future Value of the Loan
$ 2,71,616.13
Loan Amount Based on Max Monthly Payment
$ 9,05,144.89
Scenario Summary
Current Values:
Scenario 1
Scenario 2
Scenario 3
Created by Windows User on 13-05-2018
Created by Windows User on 13-05-2018
Created by Windows User on 13-05-2018
Changing Cells:
$B$3
7506
7506
7506
7506
$B$23
$ 6,191.00
$3,500.00
$6,191.00
$6,191.00
$B$22
$ 1,647.00
$1,647.00
$2,000.00
$1,647.00
$B$29
0.04
0.04
0.04
0.05
Result Cells:
$B$33
20.00
20.00
20.00
20.00
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Final
Reduced
Cell
Name
Value
Gradient
$B$23
Max Monthly Payment Based on Income
$ 1,971.00
$ –
Final
Lagrange
Cell
Name
Value
Multiplier
$B$33
Actual tenure of Payment (Years)
20.00
0.00
Number of Borrowers
1
Take Home MonthlySalary
$ 3,500.00
Fixed Inputs
Phone
$ 68.00
Electricity
$ 177.00
Gas
$ 81.00
Water and sewer
$ 187.00
Cable
$ 163.00
Waste removal
$ 142.00
Maintenance or repairs
$ 166.00
Insurance
$ 177.00
Medical
$ 138.00
Clothing
$ 62.00
Others
$ 105.00
Council Rates
$ 66.00
Cable TV
$ 56.00
Internet
$ 165.00
Decision Variables
Total Monthly Cost
$ 1,753.00
Max Monthly Payment Based on Income
$ 1,971.00
Financing (Stochastic)
Term of Mortgage (years)
20
Annual Interest Rate
4.00%
Calculated Variables
Total Interest Paid
$ 1,47,781.92
Actual tenure of Payment (Years)
20.00
Future Value of the Loan
$ 4,73,040.00
Loan Amount Based on Max Monthly Payment
$ 3,25,258.08
Options
Annual Interest Rate
Take Home MonthlySalary
Total Monthly Cost
Max Monthly Payment Based on Income
1
10%
3932
2018
1914
2
5%
6548
1992
4556
3
7%
4612
1868
2744
4
9%
7017
2041
4976
5
9%
4877
2051
2826
6
10%
6722
2013
4709
7
8%
7536
2176
5360
8
4%
7094
1895
5199
9
8%
6060
2144
3916
10
6%
6680
1809
4871
11
5%
7249
2060
5189
12
6%
5825
2037
3788
13
9%
7591
1969
5622
14
8%
6679
1967
4712
15
8%
5726
2075
3651
16
8%
7185
1818
5367
17
8%
7479
2076
5403
18
8%
5718
1813
3905
19
5%
5972
2063
3909
20
7%
7699
1974
5725
21
4%
4953
1929
3024
22
6%
6106
1978
4128
23
7%
4552
2000
2552
24
6%
5472
1913
3559
25
10%
4083
2166
1917
26
9%
5501
1972
3529
27
9%
4692
2030
2662
28
10%
7672
1824
5848
29
4%
4619
2007
2612
30
6%
5143
1907
3236
31
5%
5869
1852
4017
32
5%
7047
1887
5160
33
6%
7274
2035
5239
34
9%
7675
2070
5605
35
6%
3717
2139
1578
36
8%
4759
2145
2614
37
7%
7143
1951
5192
38
8%
6483
1942
4541
39
9%
6866
2130
4736
40
5%
5724
1901
3823
41
4%
5068
2094
2974
42
5%
4987
1865
3122
43
6%
3679
2020
1659
44
7%
6932
2139
4793
45
7%
4592
2091
2501
46
8%
4892
2053
2839
47
10%
6362
1806
4556
48
10%
7784
2076
5708
49
10%
3755
2198
1557
50
5%
7179
2035
5144
Column1
Mean
7.36%
Standard Error
0.25%
Median
8.00%
Mode
8.00%
Standard Deviation
1.77%
Sample Variance
0.03%
Kurtosis
-0.66
Skewness
-0.53
Range
6.0%
Minimum
4.0%
Maximum
10.0%
Sum
3.68
Count
50
Observed Freq
NORMAL.PROB.CUM
NORMAL.PROB
Expected Freq
0
0.000163366
0.000163366
0.01
0
0.000465399
0.000302033
0.02
0
0.001230195
0.000764796
0.04
0
0.003019171
0.001788975
0.09
0
0.006884896
0.003865725
0.19
0
0.014601517
0.007716621
0.39
5
0.028831168
0.014229651
0.71
0
0.053071199
0.024240032
1.21
0
0.091216846
0.038145647
1.91
5
0.146670538
0.055453691
2.77
0
0.22114207
0.074471532
3.72
3
0.313532079
0.092390009
4.62
0
0.419417219
0.10588514
5.29
10
0.531521076
0.112103857
5.61
12
0.641164285
0.109643209
5.48
0
0.740228891
0.099064606
4.95
11
0.822914649
0.082685758
4.13
0
0.886670198
0.063755549
3.19
4
0.932083165
0.045412967
2.27
0
0.961965584
0.029882419
1.49
0
0.980130143
0.018164559
0.91
0
50
Take Home MonthlySalary
Total Monthly Cost
Max Monthly Payment Based on Income
Actual tenure of Payment (Years)
3500.0
1753.0
1971.0
9.28
3500.0
1874.0
1971.0
9.28
3500.0
1567.0
1971.0
9.28
3500.0
1854.0
1971.0
9.28
3500.0
1973.0
1971.0
9.28
3500.0
1619.0
1971.0
9.28
3500.0
1618.0
1971.0
9.28
3500.0
1582.0
1971.0
9.28
3500.0
1720.0
1971.0
9.28
3500.0
1804.0
1971.0
9.28
3500.0
1640.0
1971.0
9.28
3500.0
1893.0
1971.0
9.28
3500.0
1935.0
1971.0
9.28
3500.0
1691.0
1971.0
9.28
3500.0
1607.0
1971.0
9.28
3500.0
1729.0
1971.0
9.28
3500.0
1537.0
1971.0
9.28
3500.0
1826.0
1971.0
9.28
3500.0
1788.0
1971.0
9.28
3500.0
2140.0
1971.0
9.28
3500.0
1623.0
1971.0
9.28
3500.0
1563.0
1971.0
9.28
3500.0
1761.0
1971.0
9.28
3500.0
1755.0
1971.0
9.28
3500.0
1397.0
1971.0
9.28
3500.0
1687.0
1971.0
9.28
3500.0
1985.0
1971.0
9.28
3500.0
1824.0
1971.0
9.28
3500.0
1824.0
1971.0
9.28
3500.0
1814.0
1971.0
9.28
3500.0
1860.0
1971.0
9.28
3500.0
1471.0
1971.0
9.28
3500.0
1538.0
1971.0
9.28
3500.0
1891.0
1971.0
9.28
3500.0
1629.0
1971.0
9.28
3500.0
2053.0
1971.0
9.28
3500.0
1583.0
1971.0
9.28
3500.0
1925.0
1971.0
9.28
3500.0
1654.0
1971.0
9.28
3500.0
1832.0
1971.0
9.28
3500.0
1602.0
1971.0
9.28
3500.0
1956.0
1971.0
9.28
3500.0
1747.0
1971.0
9.28
3500.0
1790.0
1971.0
9.28
3500.0
1732.0
1971.0
9.28
3500.0
1593.0
1971.0
9.28
3500.0
1493.0
1971.0
9.28
3500.0
1822.0
1971.0
9.28
3500.0
1788.0
1971.0
9.28
3500.0
1887.0
1971.0
9.28
Actual tenure of Payment (Years)
BIN
FREQUENCY
4.0%
0
Mean
9.291
4.5%
0
Standard Error
0.369
5.0%
0
Median
8.089
5.5%
0
Standard Deviation
2.606
6.0%
2
Sample Variance
6.790
6.5%
4
Kurtosis
-1.176
7.0%
5
Skewness
0.585
7.5%
2
Range
8.478
8.00%
10
Minimum
5.810
8.50%
6
Maximum
14.289
9.00%
1
Sum
464.535
9.50%
2
Count
50
10.00%
0
10.50%
1
11.00%
1
11.50%
3
12.00%
2
12.50%
1
13.00%
2
13.50%
6
14.00%
0
14.50%
2
15.00%
0
0
Free Membership to World’s Largest Sample Bank
To View this & another 50000+ free samples. Please put
your valid email id.
Yes, alert me for offers and important updates
Submit
Download Sample Now
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
UploadUnique Document
DocumentUnder Evaluation
Get Moneyinto Your Wallet
Total 6 pages
PAY 4 USD TO DOWNLOAD
*The content must not be available online or in our existing Database to qualify as
unique.
Cite This Work
To export a reference to this article please select a referencing stye below:
APA
MLA
Harvard
OSCOLA
Vancouver
My Assignment Help. (2020). Decision Modelling For Business Analytics. Retrieved from https://myassignmenthelp.com/free-samples/mis775-decision-modelling-for-business-analytics/stochastic-decision.html.
“Decision Modelling For Business Analytics.” My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/mis775-decision-modelling-for-business-analytics/stochastic-decision.html.
My Assignment Help (2020) Decision Modelling For Business Analytics [Online]. Available from: https://myassignmenthelp.com/free-samples/mis775-decision-modelling-for-business-analytics/stochastic-decision.html[Accessed 19 December 2021].
My Assignment Help. ‘Decision Modelling For Business Analytics’ (My Assignment Help, 2020)
My Assignment Help. Decision Modelling For Business Analytics [Internet]. My Assignment Help. 2020 [cited 19 December 2021]. Available from: https://myassignmenthelp.com/free-samples/mis775-decision-modelling-for-business-analytics/stochastic-decision.html.
×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}
×
Thank you for your interest
The respective sample has been mail to your register email id
×
CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.
Account created successfully!
We have sent login details on your registered email.
User:
Password:
MyAssignmenthelp.com is one of the noted service providers that deliver essay help. We provide tailored essay assistance to make sure that student gets online essay help exactly in the way they want it to be written. We at MyAssigemnthelp.com have built teams of consultants, who readily attend every query related to help me writing my essay. We provide essay writing help in forms of tips and steps in order o assist students with tough essay assignments.
Latest Business Law Samples
div#loaddata .card img {max-width: 100%;
}
BU1112 Business Law
Download :
0 | Pages :
6
Course Code: BU1112
University: James Cook University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Part A
Issue:
Whether Stella is considered as an employee of PRX?
Rule:
The main difference between employee and independent contractor is stated below:
Employee entered into contract of service, but contractor entered into contract for services.
Employer exercise control over the employee but no control was exercised by employer on contractor. It is considered as traditional test which was developed in Zuijs v Wirth Bros(Zuijs…
Read
More
Tags:
Australia South Lake Management health finance management University of New South Wales
BSBWHS605 Develop Implement And Maintain WHS Management Systems
Download :
0 | Pages :
15
Course Code: BSBWHS605
University: Swinburne University Of Technology
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
Work Health and Safety Management System (WHSMS) is a collection of plans, tools, activities and processes. List 3 of these plans, tools, activities or processes and explain what they are,
The means, nitty gritty beneath, can be utilized whether the arranging procedure is straightforward or complex. They are:
Evaluating the current word related to wellbeing and security status including the ‘administration framework’ Lussier, R. N…
Read
More
Tags:
Australia Brisbane Management Work Health and Safety Management System (WHSMS University of Brisbane MBA
BUSN331 Business Law
Download :
0 | Pages :
3
Course Code: BUSN331
University: Centennial College
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Canada
Answers:
Introduction
In Alberta, the Residential Tenancies Act applies to all the people in this jurisdiction, who rent their space out (Alberta Queen’s Printer, 2016). Through this act, the rights and responsibilities of the landlords and tenants are brought forward (Landlord and Tenant, 2015).
Question 1
Before a tenant can move in the rented accommodation, the tenant and the landlord have to reach an agreement, with regards to the…
Read
More
Tags:
Australia Edmonton Humanities Management University of New South Wales Masters in Business Administration
LA1040 Contract Law
Download :
0 | Pages :
11
Course Code: LA1040
University: University Of London
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answer:
Introduction
A contract is an agreement between the parties which is enforceable legally in the courts. There are several provisions of law which governs how the terms related to the contract would operate. A contract consists of a set of provisions which are known as contractual terms. The weightage of such terms are not equal as one term may have a more significant consequence as compared to the other in relation to their brea…
Read
More
Tags:
United Kingdom London Economics Management University of London
TLAW202 Corporations Law
Download :
0 | Pages :
9
Course Code: TLAW202
University: Top Education Institute
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
1.
If any person wants to carry out his business in the form of a company, then, it is necessary that the registration or incorporation requirements of such country must be met. In Australia, the Corporation Act 2001 and the guidelines laid down by ASIC provides with the steps that must be accomplish in order to establish a corporate entity. (Malbon & Bishop, 2006).
A company is of great significance as it is treated as a …
Read
More
Next