Given this frequency distribution, what demand values would be associated with the following random numbers? (Do not round intermediate calculations.) Demand Frequency 16 10 28 3. 46 Random Number Simulated Demand 0.1 0.5 0.9
Q: Problem A large company in the communication and publishing industry has quantified the relationship…
A: Given: The demand for this product as Price (P) = 150−0.01Q Q = Demand for a yearly printing of…
Q: Which of the following is the correct equation for calculating net purchases? O a. Purchases +…
A: Net purchase is the found by subtracting the allowances and the credit balance in the purchase…
Q: Determine the explanation for the simulation's effects to vary from run to run.
A: The following explains why the simulation outcomes vary from run to run:
Q: An organization purchases the same component from three different suppliers viz V1, V2 and V3. This…
A: Given data is
Q: What is the probability that the dinner will be ready within 3 minutes early?
A: Below is the solution:-
Q: Required: Solve for the variable and fixed cost component using: a.) High- Low Method b.) Least-…
A: THE ANSWER IS AS BELOW:
Q: Given this frequency distribution, what demand values would be associated with the following random…
A: The answer is as below:
Q: Cost Estimation; High-Low Method; MAPE Ethan Manufacturing Inc. produces floor matsfor automobiles.…
A: a.
Q: Compute for the Customer Lifetime Value (CLV) of the following situations. 1. For every visit of…
A: 1. In the given question statement, The total value of a customer to a firm throughout their…
Q: Demand 7 9 5 11 10 13 The least squares regression equation that shows the best relationship between…
A: To get the relationship between demand and period, here, first, I would determine the intercept and…
Q: b. The mean absolute deviation as of the end of week 10 is___ rentals enter your response here.…
A: Forecasting is a strategy that uses historical data to make estimates that are predictive in taking…
Q: An organization purchases the same component from three different suppliers viz V1, V2 and V3. This…
A: Given data is
Q: Antonio is the RM at the 180-room Hawthorne Suites. Disappointed in his occupancy rate last year, he…
A: Occupancy and ADR are given.
Q: a buliding owned by hopewell company was recently valued at 850,00 by a real estate expert , the…
A: Valuation of fixed assets can be change because of depreciation or appreciation. In case of land…
Q: What other real-world factors might be important to consider in designing the simulation and making…
A: Simulation functions are used for preparation and corrections of mistakes in a timely manner.
Q: Mancini's Pizzeria sells four types of pizza crust. Last week, the owner tracked the number sold of…
A: This question is related to the topic forecasting approach, here, This topic falls under the…
Q: What is an Interactive Single Variable process control loop?
A: The interactive single variable Process control loop It is the simplest form of process control.…
Q: A large company in the communication and publishing industry has quantified the relationship between…
A: Given: The interest for this item as: Price (P) = 150 - 0.01Q Q= Demand for a yearly printing of…
Q: Chem-Tex Chemical is considering two additives for improving the dry-weather stability of its low-…
A: Since ROR is lesser than the MARR of 20%, the original process, which uses Additive A should be…
Q: Determine the optimum preventive maintenance frequency for each of the pieces of equipment if…
A: Probability ratio = Preventive cost / breakdown cost Interval = Average time + (z x standard…
Q: An online news platform is hosting sports news on a local webserver. Assuming the webserver is…
A: Given data is Asset value = $10000 Frequency = 7 Loss = 3%
Q: A newspaper stand operator has the following sales data for one- year sales of Fine magazine.…
A: Given below some of the calculations. Quantities sold per day No. of days quantity sold Profit…
Q: Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local…
A: Formulas for weighted average forecasting- 3-week weighted moving average forecast…
Q: Franklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All…
A: Solution i) One period moving average is calculated by taking average of two previous values.…
Q: Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local…
A: Forecasting is the process of predicting the future demand with the help of previous or historic…
Q: rue or false 9. The second-degree stochastic dominance is better than the firstdegree stochastic…
A: It is a structure of stochastic requesting. The idea emerges in decision theory and decision…
Q: A short-term model of measurement that can be used to evaluate an organization's operational…
A: In an organization objectives determine the very purpose of business operations and existence.…
Q: The frequency for Booking control level of revenue management decision is A. Daily or weekly B. Real…
A: ANSWER : Option : b) Real time
Q: 3. The ore of a gold mine in the province contains, on average, 0.5 ounce of gold per ton. Method A…
A: Solution The net value associated with a particular choice is used to make a decision among all…
Q: What type of time-series components would you expect for the following products and services?a.…
A: The time series components include the three major parts and it includes irregular, seasonal, and…
Q: (1 point) Suppose that X is normally distributed with mean 90 and standard deviation 14. A. What is…
A: The concept used here is Normal distribution and using the standard normal table.
Q: The historical demand for four perlod is 40, 50, 70, and 71 respectively. Using the Naive method,…
A: Given - Period Demand 1 40 2 50 3 70 4 71 Mean Absolute Deviation (MAD)?
Q: RKE & Associates is considering the purchase of a building it currently leases for $30,000 per year.…
A: Pay back period is the time takes for the company to recover its investment. Here the company…
Q: In dividing up the quality and price (MSRP) of similar retail goods, the expression good-…
A: Quality the check of the performance or how good is the product or services that are provided. It is…
Q: + 1. Product Yield. Calculate the yield (%) of white cheese that can be produced from the given…
A: Yield in relation to manufacturing means output. It is calculated with the help of following formula…
Q: perating procedures and developing such key competencies as process capability, flexibility,…
A: 1. b Process planning 2. b 0.3085
Q: Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three week and a four-week…
A: Forecasting helps in predicting the future sales in advance so that there is no overstocking or…
Q: ou are serving flank steak for an event and need 200 6-oz. servings. You get samples and do yield…
A:
Q: Which of the following characteristics is a subcomponent of the consumption utility in acustomer…
A: Correct answer is a
Q: The army is attempting to determine the optimal replacement age for a piece of field equipment. The…
A: A replacement cost, often known as a "replacement value," can vary based on elements such as the…
Q: Increases in demand ________ reorder points Group of answer choices Decrease Have no effect on…
A: Inventory comprises items such as raw material, work-in-process goods and finished goods which are…
Q: Given this frequency distribution, what demand values would be associated with the following random…
A: Below is the solution:-
Q: han 100 beds are not required to hire licensed workers, while those with over 100 beds ar o hire…
A: According to the case, the are many variables that can not be neglected. Example:- Beds, licensed…
Q: State the difference between the simulated average demand and expected average demand in simulation…
A: A simulation is a time-based depiction of a real-world process or system's operation. Simulations…
Q: How reliable is one product of calculator
A: Reliability indicating the overall consistency of measure which helps to identify in a quantitative…
Q: Casting molds are produced by MYMOLD company. Each order has unique specifications, depending on…
A: Supply chain management is the management of the transportation of products and services, and it…
Computer Simulation
Step by step
Solved in 2 steps with 2 images
- Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?In Example 11.2, the gamma distribution was used to model the skewness to the right of the lifetime distribution. Experiment to see whether the triangular distribution could have been used instead. Let its minimum value be 0, and choose its most likely and maximum values so that this triangular distribution has approximately the same mean and standard deviation as the gamma distribution in the example. (Use @RISKs Define Distributions window and trial and error to do this.) Then run the simulation and comment on similarities or differences between your outputs and the outputs in the example.Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.
- Assume that all of a companys job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 25% means that the company will accept applicants for jobs who rank in the top 25% of all applicants. If the company chooses a selection ratio of 25%, the average test score of those selected will be 1.27 standard deviations above average. Use simulation to verify this fact, proceeding as follows. a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.) b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excels DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and 0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excels database D functions. c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?Continuing the previous problem, assume, as in Problem 11, that the damage amount is normally distributed with mean 3000 and standard deviation 750. Run @RISK with 5000 iterations to simulate the amount you pay for damage. Compare your results with those in the previous problem. Does it appear to matter whether you assume a triangular distribution or a normal distribution for damage amounts? Why isnt this a totally fair comparison? (Hint: Use @RISKs Define Distributions tool to find the standard deviation for the triangular distribution.)
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.A new edition of a very popular textbook will be published a year from now. The publisher currently has 1000 copies on hand and is deciding whether to do another printing before the new edition comes out. The publisher estimates that demand for the book during the next year is governed by the probability distribution in the file P10_31.xlsx. A production run incurs a fixed cost of 15,000 plus a variable cost of 20 per book printed. Books are sold for 190 per book. Any demand that cannot be met incurs a penalty cost of 30 per book, due to loss of goodwill. Up to 1000 of any leftover books can be sold to Barnes and Noble for 45 per book. The publisher is interested in maximizing expected profit. The following print-run sizes are under consideration: 0 (no production run) to 16,000 in increments of 2000. What decision would you recommend? Use simulation with 1000 replications. For your optimal decision, the publisher can be 90% certain that the actual profit associated with remaining sales of the current edition will be between what two values?Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)
- 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?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?Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation 1300 and that the demand at the reduced price is normally distributed with mean 3800 and standard deviation 1400.