Answered: 53. Why is the RISKCORRMAT function…

Name: 53. Why is the RISKCORRMAT function necessary?How does @RISK generate
Uploaded: 2024-03-20T07:07:50.000Z
Channel: Bartleby
Description: 53. Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is, when RISKCORRMAT is not used

Business

Operations Management

53. Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is, when RISKCORRMAT is not used

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 32P

See similar textbooks

Related questions

Q: evices do in fact represent the voice d discuss how this is accomplishe= and House of Quality (HOQ).

A: Customer needs are defined and translated into design specifications or product control characterist...

Q: The proposed Ghana Airways Airline project is being procured through a Public-Private Partnership (P...

A: Decision tree analysis can be stated as the approach of sketching or drawing a decision tree, which ...

Q: 1. A bakeshop has recorded sales (in dozens) for three products, as shown belowboar en a. Predict or...

A: Given-

Q: XYZ Healthcare Center receives reimbursement from C.H.E.A.T.E.M. insurance company. XYZ receives P20...

A: Fixed costs are brought about, independent of the reality of whether or not the activities are run. ...

Q: What is the role of a project manager throughout the project life cycle

A: Project management is the management in which different kinds of skills and knowledge are used to pr...

Q: Why are qualitative factors important in project development plans?

A: Qualitative factors Qualitative factors can be stated as the output that cannot be evaluated with th...

Q: Case Narrative: As a young investor with a moderate risk attitude, you consulted a financial adviser...

A: GIVEN,

Q: 10. Quarterly demand for Jaguar XJ8’s at a Tacloban Auto dealership is forecast with the equation, ...

A: Forecasting is used by companies to match supply with demand and to avoid opportunity costs issues. ...

Q: A city has only 10 households, and they have the following annual incomes: $32,000, $12,000, $56,000...

A: (a) Steps to calculate quintiles: Arrange the data in ascending order (as shown in column 1). Divid...

Q: 12) Which of the following jobs could be analyzed effectively using direct observation? Desi...

A: Direct observation refers to observing an employee in the position when they perform their daily job...

Q: Basseterre, St. Kitts, April 29, 2021 (SKNIS): St. Kitts and Nevis Youth Ambassador Corps officially...

A: Note: "Since you have posted an inquiry with different sub-parts, we will settle the initial three s...

Q: Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel ...

A: Given- Inventory Cost/Week = $ 1.00Shortage Cost/Week = $ 2.00Lead Time = 2 weeksBeginning Stock o...

Q: What is your estimate of the average range?

A: Process average is the average of average for all 5 average values and average of samples is the ave...

Q: Software upgrade times (in minutes) are being evaluated. Samples of five observations each have been...

Q: Assume that Triksi Co. makes footballs and is trying to determine the quantity of leather it should ...

A: The detailed solution is given in Step 2.

Q: What are the distinctions between the agile project management model and the traditional waterfall m...

A: Agile and waterfall project management strategies exist on a spectrum that should be used as needed ...

Q: You create your own start-up company that supply bowl directly to a number of customers. You receive...

A: To solve this, we need to convert units per hour to hour per unit such that all the units are same. ...

Q: why is it important for managers and supervisors to delegate work to others

A: Delegation of authroity refers to the process of dividing the work or tasks amngts the subordinate.

Q: Smith Smith Products Ltd produces two products, in a process which is partly automated. It is restr...

Q: re managers interested in forecasting sales figures for the next quarter. What different types of us...

A: Technology-enabled data analysis, known as business intelligence (BI), helps executives, managers, a...

Q: Discuss in detail the steps for Import of goods and equipment’s for a tertiary care teaching hospita...

A: A Small Introduction about Documentation The presentation ordinarily depicts the extent of the re...

Q: True or False Cost driver analysis is a comprehensive understanding of how an organization generate...

A: The Cost driver analysis may be defined as the analysis of various cost drivers for a particular typ...

Q: Many organizations use the same process capability star services (e.g., 1.33), but some companies us...

A: The Process capability standards make the process that should be capable of making defect-free produ...

Q: using the naive method. using a 3-month moving average. y 2021 using a 5-month moving average.

A: Forecasting is technique which helps to predict unknown future based on known historic information. ...

Q: The sensitivity range for an objective function coefficient is the range of values over which the op...

A: YES the statement is true. The sensitivity range for an objective function coefficient is the range ...

Q: Activity Resources Duration (days) Precedence activity A Sub-con 10 Direct labour Material Supplier ...

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for y...

Q: When it comes to Enterprise Resource Planning (ERP), is Amazon Web Services a good choice?

A: Cloud-based services are described as the services that are facilitated or provided by the informati...

Q: 5. Describe the three ways of achieving cost savings in industrial facilities.

A: Note: As per the Bartleby guidelines only the first three parts have been answered. For getting answ...

Q: 1. A company that makes shopping carts for supermarkets and other stores recently purchased some new...

Q: Kendi Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Co...

A: The detailed solution is given in Step 2.

Q: Use exponential smoothing with smoothing parameter a = 0.3 to co 13). Use exponential smoothing with...

A: Exponential smoothing is a forecasting method which considering the actual demand and forecasting de...

Q: With reference to project of an organization of your choice, describe how goods, works and services ...

A: Procurement is buying goods or services and is generally about business investing or spending. Busin...

Q: three ways in which Human resource management concepts are related to or connected with the top ten ...

A: In an organization, human resource plays an important role in managing the performance of the employ...

Q: A company has limited machine hours available per week, in result the company is able to produce onl...

A: Productivity is a ratio between the output volume and the volume of inputs. It measures how efficien...

Q: What does change management accomplish and what are the components of an effective change management...

A: As it is said that change is the law of nature so the business also undergoes number of changes on e...

Q: 4- George Kyparisis makes bowling balls in his Miami plant. With recent increases in his costs, he h...

Q: 24. Each of the processes listed is non-centered with respect to the specifications for that process...

A: Given-

Q: 1.6 George Kyparisis (using data from Problem 1.5) determines his costs to be as follows: • Labor: S...

Q: y contract and a cost-plus contract? Include in your discussion the advantages and disadvantages of ...

A: Contract types include Cost-Plus and Turnkey, with the former being the more popular (sometimes refe...

Q: Houston North Hospital is trying to improve its image by providing a positive experience for its pat...

A: Here, the question data states that for each day, we have got the numbers of unsatisfied patients, t...

Q: Explain Briefly 1. Why is operations management is an important activity to a project? Who is suit...

A: Operations management is a field of business that deals include many different sub-fields for its wh...

Q: Your company has received an order for 60 units of a product. The labor cost to produce the item is ...

A: Given- Time for the first unit = 12 hourLabor cost = $22 per hourMaterial cost = $80 per unitOverh...

Q: What is Product Positioning, also explain how we can identify the possible competitive advantage in ...

A: Competitive advantage can be stated as the factors that permit an organization to generate or produc...

Q: Identify and explain ONE key factor prompted Sushiro to operate outside Japan.

A: A Small Introduction about Operation Management Operations management (OM) is the organization of...

Q: An example can be seen in the operation of a security-conscious jewelry shop. Customers are allowed ...

A: Operations management is described as a process through which business practices are put up to the h...

Q: 4) The choice of technology revolves around two basic questions: (1) What is the desired amount of...

A: Choices of technology has important implications for capacity planning, facility layout, equipment c...

Q: 4. How important are customer feedbacks in improving product design?

A: Product design is the process of development of consistent and successful products after blending th...

Q: Evaluate the persuasiveness of Mazzucato’s arguments in The Value of Everything (2018) using the con...

A: A Small Introduction About Critical Management Being basic can be positive and valuable and can bri...

Q: 1.The store manager realized that she has so many this to attend to. She listed the tasks that neede...

A: Prioritizing includes deciding what request tasks should be finished in light of their importance. T...

Q: Will new entrants more likely to develop new technology? Yes or no? and Why?

A: a) Yes,new entrants more likely to develop new technology. Without any new innovations and new techn...

Concept explainers

Addition Rule of Probability

It simply refers to the likelihood of an event taking place whenever the occurrence of an event is uncertain. The probability of a single event can be calculated by dividing the number of successful trials of that event by the total number of trials.

Expected Value

When a large number of trials are performed for any random variable ‘X’, the predicted result is most likely the mean of all the outcomes for the random variable and it is known as expected value also known as expectation. The expected value, also known as the expectation, is denoted by: E(X).

Probability Distributions

Understanding probability is necessary to know the probability distributions. In statistics, probability is how the uncertainty of an event is measured. This event can be anything. The most common examples include tossing a coin, rolling a die, or choosing a card. Each of these events has multiple possibilities. Every such possibility is measured with the help of probability. To be more precise, the probability is used for calculating the occurrence of events that may or may not happen. Probability does not give sure results. Unless the probability of any event is 1, the different outcomes may or may not happen in real life, regardless of how less or how more their probability is.

Basic Probability

The simple definition of probability it is a chance of the occurrence of an event. It is defined in numerical form and the probability value is between 0 to 1. The probability value 0 indicates that there is no chance of that event occurring and the probability value 1 indicates that the event will occur. Sum of the probability value must be 1. The probability value is never a negative number. If it happens, then recheck the calculation.

Topic Video

Question

53. Why is the RISKCORRMAT function necessary?
How does @RISK generate random inputs by default,
that is, when RISKCORRMAT is not used

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Sample space, Events, and Basic Rules of Probability

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)
Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Millers optimal bid increase or decrease? To study this question, assume that each competitors bid, expressed as a multiple of Millers cost to complete the project, follows each of the following distributions. a. Triangular with parameters 1.0, 1.3, and 2.4 b. Triangular with parameters 1.2, 1.3, and 2.2 c. Use @RISKs Define Distributions window to check that the distributions in parts a and b have the same mean as the original triangular distribution in the example, but smaller standard deviations. What is the common mean? Why is it not the same as the most likely value, 1.3?
Although the normal distribution is a reasonable input distribution in many situations, it does have two potential drawbacks: (1) it allows negative values, even though they may be extremely improbable, and (2) it is a symmetric distribution. Many situations are modelled better with a distribution that allows only positive values and is skewed to the right. Two of these that have been used in many real applications are the gamma and lognormal distributions. @RISK enables you to generate observations from each of these distributions. The @RISK function for the gamma distribution is RISKGAMMA, and it takes two arguments, as in =RISKGAMMA(3,10). The first argument, which must be positive, determines the shape. The smaller it is, the more skewed the distribution is to the right; the larger it is, the more symmetric the distribution is. The second argument determines the scale, in the sense that the product of it and the first argument equals the mean of the distribution. (The mean in this example is 30.) Also, the product of the second argument and the square root of the first argument is the standard deviation of the distribution. (In this example, it is 3(10=17.32.) The @RISK function for the lognormal distribution is RISKLOGNORM. It has two arguments, as in =RISKLOGNORM(40,10). These arguments are the mean and standard deviation of the distribution. Rework Example 10.2 for the following demand distributions. Do the simulated outputs have any different qualitative properties with these skewed distributions than with the triangular distribution used in the example? a. Gamma distribution with parameters 2 and 85 b. Gamma distribution with parameters 5 and 35 c. Lognormal distribution with mean 170 and standard deviation 60
We all hate to bring small change to the store. Usingrandom numbers, we can eliminate the need for change andgive the store and the customer a fair shake.a Suppose you buy something that costs $.20. How could you use random numbers (built into the cash reg-ister system) to decide whether you should pay $1.00 or nothing? This eliminates the need for change!b If you bought something for $9.60, how would youuse random numbers to eliminate the need for change?c In the long run, why is this method fair to both thestore and the customer?
Suppose that $100 is invested at the beginning of a year. Which (if either) of the following methods of growing the investment results in a larger amount at the end of the year? (i) The investment grows at an interest rate of 4% per year, compounded continuously.(ii) The investment grows at an instantaneous growth rate of 4% per year. method (i) method (ii) Both methods produce the same amount.
We must invest all our money in two stocks: x and y.The variance of the annual return on one share of stock x isvar x, and the variance of the annual return on one share ofstock y is var y. Assume that the covariance between theannual return for one share of x and one share of y is cov(x,y). If we invest a% of our money in stock x and b% in stocky, then the variance of our return is given by a2var xb2var y2ab cov(x, y). We want to minimize the variance of thereturn on our invested money. What percentage of the moneyshould be invested in each stock?
MacBurger has just opened a fast-food restaurant inBloomington. Currently, i0 customers frequent MacBurger(we call these loyal customers), and N i0 customers frequentother fast-food establishments (we call these nonloyalcustomers). At the beginning of each month, MacBurger mustdecide how much money to spend on advertising. At the endof a month in which MacBurger spends d dollars onadvertising, a fraction p(d) of the loyal customers becomenonloyal customers, and a fraction q(d) of the nonloyalcustomers become loyal customers. During the next 12months, MacBurger wants to spend D dollars on advertising.Develop a dynamic programming recursion that will enableMacBurger to maximize the number of loyal customers thecompany will have at the end of month 12. (Ignore thepossibility of a fractional number of loyal customers.)
4. Explain how the logit model overcomes the problems associated with the Linera Probability Model in binary dependent variaraile model.
A building contains 1000 lightbulbs. Each bulb lastsat most five months. The company maintaining thebuilding is trying to decide whether it is worthwhileto practice a “group replacement” policy. Under agroup replacement policy, all bulbs are replaced everyT months (where T is to be determined). Also, bulbsare replaced when they burn out. Assume that it costs$0.05 to replace each bulb during a group replacementand $0.20 to replace each burned-out bulb if it isreplaced individually. How would you use simulationto determine whether a group replacement policy isworthwhile?
1. Suppose you are going on a weekend trip to a city that is d miles away. Develop a model that determines your round-trip gasoline costs. What assumptions or approximations are necessary to treat this model as a deterministic model? Are these assumptions or approximations acceptable to you? 2. Suppose that a manager has a choice between the following two mathematical models of a given situation: (a)a relatively simple model that is a reasonable approximation of the real situation, and (b)a thorough and complex model that is the most accurate mathematical representation of the real situation possible. Why might the model described in part (a) be preferred by the manager?
Which of the following is NOT a determinant of the demand for good X?
Appliances Unlimited (AU) sells refrigerators. Anyrefrigerator that fails before it is three years old isreplaced for free. Of all refrigerators, 3% fail duringtheir first year of operation; 5% of all one-year-oldrefrigerators fail during their second year of operation;and 7% of all two-year-old refrigerators fail duringtheir third year of operation.a. Use simulation to estimate the fraction of all refrigeratorsthat will have to be replaced.b. It costs $500 to replace a refrigerator, and AU sells10,000 refrigerators per year. If the warranty periodwere reduced to two years, how much per year inreplacement costs would be saved?