You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is designated as "Heads". Your simulation generates the following random numbers: 0.016, 0.904, 0.695, 0.236, 0.994, 0.527, 0.229, 0.167, 0.714, 0.502 (Do not round intermediate calculations.) How many trials ended in the result "Heads"? Heads How many trials ended in the result "Tails"? Tails
Q: Find the maximum and minimum values of the function Z = 8X1 + 5X2, subject to the following: 3X1 –…
A: The value of the objective function at each of these extreme points is as follows: Extreme…
Q: There are three investments, B1, B2 and B3. All of them have the same expected value and each with…
A: Given data is
Q: Consider the sports ratings model . If you were going to give more recent games more weight, how…
A: The sports ratings model calculates the ratings of a sports team based on actual and predicted point…
Q: A computer reseller needs to decide how many laptops to order next month. The lowest end laptop…
A: From the above mentioned information the demand probabilities for, P (0) = 0.3, P (1) = 0.4, P(2)…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: ANSWER : Given the value less then 0.5 is designated as " Heads " 0.180 Heads 0.571 Tails…
Q: he probability that a mobile phone is stolen in an electronic shop is 0.0008. If 8500 mobile phones…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: Suppose you want to invest a maximum amount of $20,000 in a portfolio with the objective to maximize…
A: note: only formulation has been asked.
Q: The political pollster Canter is preparing for a national election. It would like to poll at least…
A: Given Information:
Q: A hardware company sells a lot of low-cost, highvolumeproducts. For one such product, it is…
A: given, low sales = 60,000 high sales = 100,000 variable cost per unit 25% chance of = $6…
Q: A company has one machine which can be used to make product Alpha and product Beta. Each unit of…
A: Variable Formula H Hours per day 8 D Days per week 5 W H*D*60 Minutes per…
Q: Suppose you are a financial analyst and your company runs many simulation models to estimate the…
A: Simulation modeling: A simulation model is a computerized model that would depict or imitate a…
Q: The manager of a restaurant chain in Izmir is trying to decide on the types and amounts of…
A: Given information, Television Commercial cost = 30000 Customers = 50,000 Potential customers for…
Q: The aim of the objective function for Attaran Corporation should be to Maximize the objective value.…
A: Let number of portable Air conditioners manufactured be x and number of portable heaters…
Q: A computer reseller needs to decide how many laptops to order next month. The lowest end laptop…
A: Hi There, thanks for posting the question. But as per Q&A authoring guidelines, we must answer…
Q: In a nonlinear programming model, for any set of values of the decision variables, whether or not…
A: False
Q: A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the…
A: Let the amount invested in Bond A be Xa, Bond B be Xb, Bond C be Xc, Bond D be Xd, and Bond E be Xe…
Q: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
Q: You own a coffee shop in a metro Toronto shopping mall. It is Friday evening and you are trying to…
A: We have to find the value of payoff for quality baked(Q)+demand(D) by using below formula
Q: Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to…
A: Hello thank you for the question. As per guidelines, we would provide only first three sub-parts at…
Q: Toby’s Trucking Company determined that the distance travelled per truck per year is normally…
A: Proportion is the amount or figure which is in between and mixes of the variables. Here in this…
Q: TRUE OR FALSE In a simplex maximization slack variable is added to convert the objective function…
A: Slack variables are added to convert the objective function to the equation.
Q: Vladimir Ulanowsky is playing Keith Smithson in atwo-game chess match. Winning a game scores 1 match…
A:
Q: Blair & Rosen, Inc. (BSR) is a brokerage firm that specializes in investment portfolios designed to…
A: Note: - As we can answer only up to three subparts we will answer the first three subparts(a, b, and…
Q: A forest consists of two types of trees: those that are 0–5 ft and those that are taller than 5 ft.…
A: Step 1: As each year 40% of all 0-5ft trees die and other 10% are sold. That means the probability…
Q: Consider a firm in a competitive market with market price p. Which of the following statements are…
A: Different types of market structures can be classified on the basis of number of buyers and sellers…
Q: TRUE OR FALSE In the simplex minimization method, optimality is signaled by the presence of all…
A: In the optimal simplex table, cj-zj=0 value indicates an Alternative solution
Q: Maximize the objective function 4x + 4y subject to the constraints. X + 2y < 28 3x + 2y 2 36 X20,…
A: Hi, we are supposed to answer one question at a time. Since you have not mentioned which question to…
Q: We are considering investing in three stocks. The randomvariable Si represents the value one year…
A:
Q: The members of a private golf club have handicaps that are normally distributedwith mean 15 and…
A: Hence, the standard deviation of sample mean is 1.75.
Q: You have $50,000 to invest in three stocks. Let Ri be the random variable representing the annual…
A: The question can be solved using Excel solver. Objective: To find a minimum variance (minimum risk)…
Q: Given the model in the Multiserver Simulation.xlsmfile, what unit cost parameters should be used if…
A: Simulation is an important tool for addressing the complicated problems of managerial…
Q: What is the difference between the independent and dependent variable? How do you determine which…
A: A variable is a particular trademark or amount that can be estimated and is countable. Variables…
Q: The sensitivity range for an objective function coefficient is the range of values over which the…
A: YES the statement is true. The sensitivity range for an objective function coefficient is the range…
Q: • Formulate the problem of deciding how much of each product to make in the current week as a linear…
A: The linear programming method is a mathematical method by which the best outcome where profits are…
Q: Select the least accurate statement regarding RISKSIMTABLE. RISKSIMTABLE is a feature that is…
A: The RiskSimtable function is used to enter a list of values which is used to enter a list of values,…
Q: Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price…
A: Consider creating a $10 rebate for a $45 product. Alternatives to a rebate would be to reduce the…
Q: If a convex function is multiplied by a negative constant, the result: A. is concave B. could be…
A: . when a convex formula is multiplied by a negative constant the result will be a concave formula…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Below is the solution:-
Q: 7. Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Given, Max 3U+5H s.t 25U+50H <= 80000 0.5U+0.25D <= 700 U <= 1000 U,H >= 0
Q: Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: 40. Mutual Funds In 2015, the Phoenix/Zweig Advisors Zweig Total Return fund (ZTR) was expected to…
A: Z = Investment amount in ZTR M = Investment amount in MSP The objective is to maximize the return.…
Q: Which of the following is not a continuous random variable? The possible amount of rain on a given…
A: A continuous random variable is a variable which can have infinite values since the values measured…
Q: Home mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on…
A: Given data, The lender would loan $98 for each $100 borrowed The borrower receives $ 98 Loan…
Q: It has been suggested that at each iteration of the simplex algorithm, the entering variable should…
A: Since the entering variable will, in general, increase from 0 to a positive number, the value of the…
Q: When preforming sensitivity analysis, it is possible for your objective function value to change…
A: \The opportunity/reduced cost of a given decision variable are often interpreted because the rate at…
Q: The values of the same 15 student in two subject A and B are given below the two numbers within the…
A: Rx Ry d=Rx-Ry d^2 1 10 -9 81 2 7 -5 25 3 2 1 1 4 6 -2 4 5 4 1 1 6 8 -2 4 7 3 4 16 8…
Q: A group of 5 players play the following game. Each writes down a positive integer that is less than…
A: ANSWER:
Q: A savings and loan association estimates that the amount of money on deposit will be 10,000,000…
A: The revenue and cost for a bank are confusing as the bank loses money by paying interest on…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- The method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.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.You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).
- 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?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 60The simulation output from Example 11.6 indicates that an investment heavy in stocks produces the best results. Would it be better to invest entirely in stocks? Answer this by rerunning the simulation. Is there any apparent downside to this strategy?
- The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?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?It is surprising (but true) that if 23 people are in the same room, there is about a 50% chance that at least two people will have the same birthday. Suppose you want to estimate the probability that if 30 people are in the same room, at least two of them will have the same birthday. You can proceed as follows. a. Generate random birthdays for 30 different people. Ignoring the possibility of a leap year, each person has a 1/365 chance of having a given birthday (label the days of the year 1 to 365). You can use the RANDBETWEEN function to generate birthdays. b. Once you have generated 30 peoples birthdays, how can you tell whether at least two people have the same birthday? One way is to use Excels RANK function. (You can learn how to use this function in Excels online help.) This function returns the rank of a number relative to a given group of numbers. In the case of a tie, two numbers are given the same rank. For example, if the set of numbers is 4, 3, 2, 5, the RANK function returns 2, 3, 4, 1. (By default, RANK gives 1 to the largest number.) If the set of numbers is 4, 3, 2, 4, the RANK function returns 1, 3, 4, 1. c. After using the RANK function, you should be able to determine whether at least two of the 30 people have the same birthday. What is the (estimated) probability that this occurs?
- In Problem 11 from the previous section, we stated that the damage amount is normally distributed. Suppose instead that the damage amount is triangularly distributed with parameters 500, 1500, and 7000. That is, the damage in an accident can be as low as 500 or as high as 7000, the most likely value is 1500, and there is definite skewness to the right. (It turns out, as you can verify in @RISK, that the mean of this distribution is 3000, the same as in Problem 11.) Use @RISK to simulate the amount you pay for damage. Run 5000 iterations. Then answer the following questions. In each case, explain how the indicated event would occur. a. What is the probability that you pay a positive amount but less than 750? b. What is the probability that you pay more than 600? c. What is the probability that you pay exactly 1000 (the deductible)?The DC Cisco office is trying to predict the revenue it will generate next week. Ten deals may close next week. The probability of each deal closing and data on the possible size of each deal (in millions of dollars) are listed in the file P11_55.xlsx. Use simulation to estimate total revenue. Based on the simulation, the company can be 95% certain that its total revenue will be between what two numbers?Rerun the new car simulation from Example 11.4, but now introduce uncertainty into the fixed development cost. Let it be triangularly distributed with parameters 600 million, 650 million, and 850 million. (You can check that the mean of this distribution is 700 million, the same as the cost given in the example.) Comment on the differences between your output and those in the example. Would you say these differences are important for the company?