Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
7. Consider the following decision table, which Joe Blackburn has developed for Vanderbilt Enterprises:
States of Nature
Decision Alternatives
Probability:
0.35
0.25
0.40
Low
Medium
High
A
$35
$80
$65
B
$85
$50
$70
C
$55
$70
$75
D
$70
$85
$65
E
$70
$75
$85
Part 2
The alternative that provides Blackburn the greatest expected monetary value
(EMV
LOADING...
)
is
▼
D
E
A
B
C
The EMV for this decision is
$_______(enter your answer as a whole number).
1. Create a risk profile for a particular area of interest.
2. Choose a commodity for which you want to create a risk profile.
3. List five possible risks that could have an impact on the commodity's production capacity.
4. Use a Venn diagram to perform a qualitative risk assessment, indicating the likelihood percentage, category, frequency, severity, and RHC score for each risk identified.
5. Create a risk heat map or chart using the risks from the Venn diagram.
6. Summarize the prioritized areas briefly and offer some recommendations for risk reduction.
An automatic machine is used to fill cans with coffee. The nominal weight of each can is 16.0 oz. The standard deviation of the fill weight is known to be 0.10 oz. Cans are automatically inspected, and all underfilled cans are rejected. The selling price of a can of coffee is $3. Underfilled cans can be sold for $1.75. The cost of the coffee $0.10 per ounce. Determine the optimum mean target level for the filling machine
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A Harvard student heard from a friend at UCLA, who had recently taken an excellent real estate finance and investments course, that a “conforming” mortgage loan would likely provide her with the lowest possible interest rate on the home loan for the $1 million condo she was planning to buy on Wilshire Boulevard in Westwood. For a home loan to be a “conforming” mortgage loan, it would: Require that she have a DSCR or FICO score lower than the minimums currently required by Fannie Mae and Freddie Mac for such loans Have an LTV ratio that is higher than the ratio currently approved by Fannie Mae and Freddie Mac Have to comply with the underwriting guidelines for loans that Fannie Mae and Freddie Mac can buy at the time of loan origination Have to exceed the $1,089,300 maximum loan limit currently permitted by Fannie Mae and Freddie Mac for home loans in high cost areas like Los Angelesarrow_forwardAndrew Thomas, a sandwich vendor at Hard Rock Cafe's annual Rockfest, created a table of conditional values for the various alternatives (stocking decision) and states Of nature (size Of crowd ) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forwardLetz Products has two decisions to make, with the second decision dependent on the outcome of the first. The company intends to build a new plant. Letz has the option of conducting its own marketing research survey for which the results will either be positive or negative. The information from this survey could help it decide whether to build a large plant, to build a small plant, or not to build at all. Letz recognizes that although such a survey will not provide it with perfect information, it may be extremely helpful. Using figure 1 – explain to your client (Letz) what the above decision tree shows. You are required to show all working.arrow_forward
- A company is researching the effectiveness of a new website design to decrease the time to access a website. 32 website users were randomly selected, and their time (in seconds) to access the website with the old and new designs were recorded. The summary statistics for the two sets of data are given in Table Q3-1, and the test results are given in Table Q3-2 and Q3-3. Apply an appropriate hypothesis testing method to test whether the new website design can decrease the time to access the website at the significance level of 5%.arrow_forwardThe company is considering whether or not they should drill the land. The cost of drilling is estimated to be $4 million. The company believes there are three possible findings after drilling the land: dry, wet and gushing. The probabilities for these outcomes are 0.5, 0.3 and 0.2, respectively. If the land is found to be dry, it obviously offers no profit. If the land is wet, it brings a potential profit of $10 million. If gushing, the potential profit from the land is $30 million. Answer the following questions, Q1 and Q2. Q1: Draw a decision tree to show the decision for this company based on the EMV criterion. Nodes and arcs are provided below and you can make more of them by using "copy" and "paste" Q2: The company has the option of using some new technology and equipment combined with seismic survey data to learn the presence of oil (dry, wet or gushing) before drilling the land. However, it requires $2.3 million investment for the technology, equipment, and required analysis. Is…arrow_forwardThe Gorman Manufacturing Company must decide whether to manufacture a component part at its Milan, Michigan, plant or purchase the component part from a supplier. The resulting profit is dependent upon the demand for the product. The following payoff table shows the projected profit (in thousands of dollars): Decision State of Nature Alternative Low Demand (S1) Medium Demand (S2) High Demand )S3) Manufacture, d(1) -20 40 100 Purchase, d(2) 10 45 70 The state-of-nature probabilities are P s1= 0.35, P s2= 0.35, and P s3= 0.30 Use expected value to recommend a decision.arrow_forward
- Upparrow_forwardHiiiarrow_forwardAt a hydrocarbon processing factory, process control involves periodic analysis of samples for a certain process quality parameter. The analytic procedure currently used is costly and time consuming. A faster and more economical alternative procedure has been proposed. However, the numbers for the quality parameter given by the alternative procedure are somewhat different from those given by the current procedure, not because of any inherent errors but because of changes in the nature of the chemical analysis. Management believes that if the numbers from the new procedure can be used to forecast reliably the corresponding numbers from the current procedure, switching to the new procedure would be reasonable and cost effective. The following data were obtained for the quality parameter by analyzing samples using both procedures: Current (Y) 2.8 Current (Y) ITTT Proposed (X) 3.2 Proposed (X) 3.1 3.1 3.7 38 2.6 3.0 2.8 3.5 4.0 3.3 3.6 3.6 3.4 4.0 3.6 3.7 2.1 2.6 2.7 3.6 3.2 3.2 3.3 3.5…arrow_forward
- At a hydrocarbon processing factory, process control involves periodic analysis of samples for a certain process quality parameter. The analytic procedure currently used is costly and time consuming. A faster and more economical alternative procedure has been proposed. However, the numbers for the quality parameter given by the alternative procedure are somewhat different from those given by the current procedure, not because of any inherent errors but because of changes in the nature of the chemical analysis. Management believes that if the numbers from the new procedure can be used to forecast reliably the corresponding numbers from the current procedure, switching to the new procedure would be reasonable and cost effective. The following data were obtained for the quality parameter by analyzing samples using both procedures: Current (Y) 2.9 3.0 3.3 3.6 4.0 2.7 3.1 Proposed (X) 3.0 3.8 3.5 4.0 3.7 3.6 3.7 Current (Y) 3.1 2.9 3.3 2.9 2.1 3.2 2.8 The increases in X mostly result in how…arrow_forwardLetz Products has two decisions to make, with the second decision dependent on the outcomeof the first. The company intends to build a new plant. Letz has the option of conducting itsown marketing research survey for which the results will either be positive or negative. Theinformation from this survey could help it decide whether to build a large plant, to build a smallplant, or not to build at all. Letz recognizes that although such a survey will not provide it withperfect information, it may be extremely helpful. Using the image explain to your client (Letz) what the above decision tree shows. You arerequired to show all working.arrow_forwardMolly e-mailed her clients offering a free 30-minute massage for referrals. In the following validation set of 100, Class 1 reflects the clients predicted to provide referrals and Class O reflects the clients predicted to not provide referrals. Based on the confusion matrix, what was the True Positive (TP) of current clients who provided referrals for a free massage? Actual Class Predicted Class 1 Predicted Class 0. Class 1 Class 0 Multiple Choice 28 63 19 9 9 63arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License