Why is the RISKCORRMAT function necessary How does RISK generate Why is the RISKCORRMAT function necessary? How does @RISK generate random inputs by default, that is, when RISKCORRMAT is not used? Why is the RISKCORRMAT function necessary How does RISK generate
Q: Describe and apply group-level diagnostic processes. Describe and apply individual-level diagnostic ...
A: Group level diagnostic process - This is the level of diagnosis in which focus is mainly made on the...
Q: For an additional fee, a customer purchasing a Whirlpool appliance, such as washing machine, can pur...
A:
Q: Some companies have begun to bring production from Low Cost Countries back to North America and Euro...
A: Category Strategy Development is acquiring goods, services, or works from an external source to iden...
Q: What factors have contributed to the success of intermodal rail service? What barriers exist to futu...
A: The rapid and timely transportation of goods contributes to an efficient logistics system.
Q: How is the traditional model different from the collaborative model?
A: Traditional model Collaborative model No commitment to the future Commitment to the future Unba...
Q: Which of the changes being considered by the manager of Quality Parts Company are counter to the lea...
A: Lean is a way of working which focuses on the removal of waste within the processes. It mainly invol...
Q: A manufacturer of exercise equipment purchases the pulley section of the equipment from a supplier w...
A: Operation management in an organization aims at providing the highest efficiency possible. It focuse...
Q: What is a P-chart used for?
A: The control charts are quality assurance tools used to measure how a process changes over a specific...
Q: Discuss the two most important benefits to decentralized purchasing authority. Justify your choices.
A: Decentralization in the organization implies the delegation of the power in the lower and middle-lev...
Q: 18. SuperCity iš a largé rétáilèř óf éléčtroničs and appliances. The store sells three different mod...
A: The goal is to limit the absolute expense. Choice Variables is , where is the quantity of TV of ea...
Q: When is the capacity needed?
A: Capacity resource planning is comparing future resource utilization with actual resources. It helps ...
Q: c. Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, andC, respectiv...
A: LP model is as follows: Decision variables: X = production quantity of product 1 Y = production qua...
Q: note : please give me excel formulas
A:
Q: Halloween is the big holiday for a candy manufacturer—more than half of its salesoccur in the month ...
A: Organization is a place where different tasks are done by many people to achieve some objective or g...
Q: Use logarithms to solve the problem. How long will it take $12,000 to grow to $19,000 if the investm...
A: WE WOULD USE THE FORMULA OF COMPOUND INTEREST HERE. IT IS THE INTEREST WHIC IS ADDED OVER PRINCIPAL ...
Q: 2. Compare and contrast the scientific principles and techniques developed by quality improvement ex...
A: Scientific management was a theory developed by Frederick Winslow Taylor to increase the productivit...
Q: How can we meet the needs of low-income families, single parents, older Americans, and the less fort...
A: Various welfare policies are adopted by the government and many individuals of the society to help t...
Q: Discuss why the involvement of external suppliers can positively affect a team’s effort.
A: External suppliers are the agents, sub suppliers or third party suppliers which helps in providing ...
Q: Would you agree that the importance of the individual supply chain managementactivities vary with th...
A: Yes, an individual is fully satisfied with the statement that the importance of the individual suppl...
Q: The demand equation for the Drake GPS Navigator is x + 4p − 1225 = 0, where x is the quantity demand...
A: Given Demand equation is: x+4p-1225=0 Supply equation is: x-21p+1000=0 where x is the the quantity a...
Q: Rework can increase the costs of an operation but has no impact on the capacity of theprocess. True ...
A: True. Because Capacity is the most extreme yield that an organization can support to make an item or...
Q: John has been fixing bicycles for three years now. He notices that he is getting betterwith an incre...
A: Let's understand the concept of Autonomous learning and how that impact along with the experience on...
Q: Insecure usage of the many applications through mobile devices may allow cyber criminals to access s...
A: Cyber-attack is an attack by the cyber hacker using the computer against another server or computer.
Q: Why did Congress create (and later strengthen) the Equal Employment Opportunity Commission?
A: Protection of employees from discrimination based on race, color, religion, caste, sex and national ...
Q: . It takes a dentist 20 minutes to see one patient. What is the capacity of the dentistexpressed in ...
A: Given Information: Time taken by a dentist to see one patient = 20 minutes
Q: 1. Is it wrong to use company e-mail for personal reasons? 2. Is it wrong to use office equipment to...
A: As per Bartleby guidelines, we are only allowed to do 3 subparts of the question. Please upload the ...
Q: As a export manager in gems and jewelleries how will you use information system in decision making p...
A: An information system is a system that is used to gather, process, store, and spread within the orga...
Q: What is the flow time?
A: Flow time - It is the time from beginning to end of a business process spend by a flow unit (basic u...
Q: FMCG sector has been affected due to COVID-19.They have issues before them like how to drive growth ...
A: The product development process includes all the steps required to take a product from idea to marke...
Q: What do we mean by a process-control system, and what are the typical elements in such systems?
A: Process control is utilized in persistent creation – in assembling and in different fields and busin...
Q: Which of the following are the requirements of an aggressive new product development strategy:a) ope...
A: Aggressive new product development strategy involves taking the product from conception to the marke...
Q: When would you want to use a preferred supplier?
A: Preferred Suppliers are those who have successfully met all there expecttaions in term sof quality, ...
Q: Suggest how we could set the time between deliveries in a fixed period system.
A: The fixed period system is used for inventory control where the inventory replenishment order is sen...
Q: Peak Inc. was a very successful company about 50 years ago. Its managers still behave today as they ...
A: The management system has evolved vastly over the years.
Q: Technomach Sdn. Bhd. is a company that produces low-end mobiles devices. The demand for this device ...
A: EOQ = Square root ( 2 * annual demand * ordering cost / carrying cost one unit per year) = Square r...
Q: Discuss the concept of the internal customer. Who are purchasing’s internal customers?
A: Internal customers of an association incorporate its workers. Other than the outer clients, an organ...
Q: Two different manufacturing processes are being considered formaking a new product. The first proces...
A: Process 1 (less capital intensive): Fixed Cost = $46,400 Variable Cost = $720 per unit Process 2: F...
Q: Is it likely that Rapid-Lube has increased productivity over its more traditional competitors? Why? ...
A: 1. Productivity is the ratio of outputs (goods and services) divided by the inputs (capital and labo...
Q: What is the relationship between the number of kanban cards in a process and theinventory level?a. T...
A: The correct answer is option b). Kanban cards are issued introduction businesses to signify the stat...
Q: Do your suppliers regard you as a customer of choice worthy of sharing in new innovations?
A: Supplier selection is one of the important tasks for every organization. Organization has selected f...
Q: Explain the concept of cross-docking.
A: Cross-docking is a useful concept used in the supply chain management of various business. Cross-doc...
Q: What variables have to be considered in designing the organizational structure for international ope...
A: Organizational structure is a system that guides the employees of the company about their work to ac...
Q: Describe Transient advantage ? related to any HBR article ?
A: Technique is trapped. For a really long time the business world has been fixated on the idea of buil...
Q: What is scalability, in the context of managing a servicebusiness?
A: Management is described as the set of guiding principles allowing control, direction, organization, ...
Q: What suggestion or solutions you have for the owners of Micro, Small, and Medium Enterprises to cope...
A: As we know that COVID-19 has originated from the wet markets of Wuhan, City China in 1 December 2019...
Q: In what way does the time horizon chosen for an aggregate plan determine whether it is the best plan...
A: Selecting time horizon plays an important role for firms as it is an integral part of decision makin...
Why is the RISKCORRMAT function necessary How does RISK generate
Why is the RISKCORRMAT function necessary? How does @RISK generate random inputs by default, that is, when RISKCORRMAT is not used?
Why is the RISKCORRMAT function necessary How does RISK generate
Step by step
Solved in 2 steps
- Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)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.)
- 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 60Based on Kelly (1956). You currently have 100. Each week you can invest any amount of money you currently have in a risky investment. With probability 0.4, the amount you invest is tripled (e.g., if you invest 100, you increase your asset position by 300), and, with probability 0.6, the amount you invest is lost. Consider the following investment strategies: Each week, invest 10% of your money. Each week, invest 30% of your money. Each week, invest 50% of your money. Use @RISK to simulate 100 weeks of each strategy 1000 times. Which strategy appears to be best in terms of the maximum growth rate? (In general, if you can multiply your investment by M with probability p and lose your investment with probability q = 1 p, you should invest a fraction [p(M 1) q]/(M 1) of your money each week. This strategy maximizes the expected growth rate of your fortune and is known as the Kelly criterion.) (Hint: If an initial wealth of I dollars grows to F dollars in 100 weeks, the weekly growth rate, labeled r, satisfies F = (I + r)100, so that r = (F/I)1/100 1.)If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.
- Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.
- Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)If you own a stock, buying a put option on the stock will greatly reduce your risk. This is the idea behind portfolio insurance. To illustrate, consider a stock that currently sells for 56 and has an annual volatility of 30%. Assume the risk-free rate is 8%, and you estimate that the stocks annual growth rate is 12%. a. Suppose you own 100 shares of this stock. Use simulation to estimate the probability distribution of the percentage return earned on this stock during a one-year period. b. Now suppose you also buy a put option (for 238) on the stock. The option has an exercise price of 50 and an exercise date one year from now. Use simulation to estimate the probability distribution of the percentage return on your portfolio over a one-year period. Can you see why this strategy is called a portfolio insurance strategy? c. Use simulation to show that the put option should, indeed, sell for about 238.Rework the previous problem for a case in which the one-year warranty requires you to pay for the new device even if failure occurs during the warranty period. Specifically, if the device fails at time t, measured relative to the time it went into use, you must pay 300t for a new device. For example, if the device goes into use at the beginning of April and fails nine months later, at the beginning of January, you must pay 225. The reasoning is that you got 9/12 of the warranty period for use, so you should pay that fraction of the total cost for the next device. As before, how-ever, if the device fails outside the warranty period, you must pay the full 300 cost for a new device.