Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in
Question:
Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in cells B9 and B10 (see Figure 6.4) to ensure that the probabilities of "fair" and "awful" remain in the same ratio, 35 to 20, and that all three probabilities continue to sum to 1. Then let the probability of "great" vary from 0.25 to 0.50 in increments of 0.05. Is it ever best to abandon the product in this range?
Transcribed Image Text:
3 Decision 1: Continue development and market the new product 4 Fixed cost 5 Unit margin 18 7 Market 8 Great 9 Fair 10 Awful All monetary values (except the unit margin in cell B5) are in $1000s, and all sales volumes are in 1000s of units. Probabili 0.45 0.35 0.20 Sales volume 600 300 90 Net revenue 10,800 $5,400 $1,620 $1,074 13 14 Decision 2: Stop deve lopment and abandon product 15 No payoffs, no costs, no uncertainty $0
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (6 reviews)
Acme singlestage new product decision Decision 1 Continue developme...View the full answer
Answered By
Hassan Ali
I am an electrical engineer with Master in Management (Engineering). I have been teaching for more than 10years and still helping a a lot of students online and in person. In addition to that, I not only have theoretical experience but also have practical experience by working on different managerial positions in different companies. Now I am running my own company successfully which I launched in 2019. I can provide complete guidance in the following fields. System engineering management, research and lab reports, power transmission, utilisation and distribution, generators and motors, organizational behaviour, essay writing, general management, digital system design, control system, business and leadership.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Business Analytics Data Analysis and Decision Making
ISBN: 978-1305947542
6th edition
Authors: S. Christian Albright, Wayne L. Winston
Question Posted:
Students also viewed these Statistics questions
-
Using a data table in Excel, perform a sensitivity analysis on the example in Simple Decision Problem.xlsx. Specifically, keep the probabilities in row 10 (for D2) as they are, but vary the...
-
In the Acme problem, perform a sensitivity analysis on the quantity sold from a great national market (the value in cell B11). Let this value vary over a range of values greater than the current...
-
Mr. Maloy has just bought a new $30,000 sport utility vehicle. As a reasonably safe driver, he believes that there is only about a 5% chance of being in an accident in the coming year. If he is...
-
In a recent survey, 80% of the community favored building a police substation in their neighborhood. If 20 citizens are chosen, what is the mean and standard deviation for the number favoring the...
-
Crenshaw uses a job order costing system to account for projects. It applies Manufacturing overhead to jobs on the basis of direct labor hours and pays its direct labor workers $25 per hour. The...
-
Chevron Corporation Financial Summary for 2023: Total Revenue: $280 billion Cost of Goods Sold: $170 billion Operating Expenses: $80 billion Interest Expense: $7 billion Tax Expense: $10 billion...
-
Which of the following statistics is really the same thing as the effective periodic interest rate that we've discussed in earlier chapters? a. Arithmetic average b. Geometric average c. Population...
-
The following selected transactions relate to investment activities of Ornamental Insulation Corporation during 2018. The company buys debt securities, intending to profit from short-term differences...
-
The equation p = 5000cos (t) +54000 describes the number of deer in a forest where t is the number of years afm 1972. What was the population in the year 1991 to the nearest whole number? NOTE: The...
-
Call center A processed 1.2 million phone orders for a total of 2.4 million items. 50% of the orders are new customers and it takes 7 minutes to set up an order for a new customer. 50% of the orders...
-
The fixed cost of $6 million in the Acme problem is evidently not large enough to make Acme abandon the product at the current time. How large would the fixed cost need to be to make the abandon...
-
Sometimes it is possible for a company to influence the uncertain outcomes in a favorable direction. Suppose Acme could, by an early marketing blitz, change the probabilities of "great," "fair," and...
-
Which of the following alternatives would NOT be appropriate? F. NO CHANGE G. With colorful ribbons and paper, these clay pots could be unadorned or decorated. H. These clay pots could be unadorned...
-
Try to point out the factors affecting the strength of attached vortex around steady airfoil and the reasons.
-
Explain the formation process of starting vortex and attached vortex.
-
A light ray travels through medium 1 , index of refraction \(n_{1}=1.5\), into medium 2, index of refraction \(n_{2}=2.4\) (Figure P33.55). At what angle with respect to the normal to the interface...
-
What is the maximum efficiency of a Carnot heat engine that operates between \(485 \mathrm{~K}\) and \(625 \mathrm{~K}\) ?
-
By rubbing object \(A\) against \(B\), if 10 electrons get transferred from \(A\) to \(B\), calculate the electric force between the two objects if separated \(10 \mathrm{~cm}\) apart.
-
Declare an array of five ints and initialize it to the first five odd positive integers.
-
Use the graphs of f and g to graph h(x) = (f + g) (x). To print an enlarged copy of the graph, go to MathGraphs.com. 1. 2. y 24 8. 2. -2 -2 4 6
-
Prepare a 2017 balance sheet for Jarrow Corp. based on the following information: cash = $168,000; patents and copyrights = $827,000; accounts payable = $429,000; accounts receivable = $237,000;...
-
Huang, Inc., is obligated to pay its creditors $11,600 very soon. a. What is the market value of the shareholders equity if assets have a market value of $15,100? b. What if assets equal $9,900?
-
In the previous problem, suppose Raines Umbrella Corp. paid out $75,000 in cash dividends. Is this possible? If net capital spending and the change in net working capital were both zero, and if no...
-
P11.34 Overhead variances; journal entries; closing variance accounts: manufacturer LO11.5 Broome Instruments Company manufactures a control valve used in air-conditioning systems. The firm uses a...
-
What are the problems with the ideal CNN model? A. Requirement of a large and labeled image dataset B. Higher computational cost for training deep CNNs C. Lower computational cost for training deep...
-
Pregunta 10 1 pts El ingenio Mujica labora en INHGEOMIN; el contador de la institucin le informa que una mina en explotacin tiene una produccin anual de $600,000 y se calcula que se agotar en cinco...
Study smarter with the SolutionInn App