(All answers were generated using 1,000 trials and native Excel functionality.) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Activity Time (weeks) Probability A 5 0.25 6 0.35 7 0.25 8 0.15 B 3 0.20 5 0.55 7 0.25 C 10 0.10 12 0.25 14 0.40 16 0.20 18 0.05 D 8 0.60 10 0.40
(a) Construct a spreadsheet simulation model to estimate the average length of the project and the standard deviation of the project length. Round your answers to one decimal place. Average Project Length weeks Standard Deviation in Project Length weeks
(b) What is the estimated probability that the project will be completed in 35 weeks or less? Round your answer to a whole percentage. %
(All answers were generated using 1,000 trials and native Excel functionality.) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for th...
project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Time (weeks) Activity Probability A 0.29 0.30 10 0.28 11 0.13 0.24 4 0.53 6 0.23 12 0.12 0.20 14 0.35 16 18 0.15 20 0.18 6 0.69 0.31 a. Provide the base-case, worst-case, and best-case calculations for the time to complete the project. Worst case Best case Activity...
(All answers were generated using 1,000 trials and native Excel functionality.) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Probability Labor Cost ($) Probability Transportation Cost ($) Probability 10 0.25 20 0.10 3 0.75 11 0.45 22...
A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Time (weeks) 5 Activity A Probability 0.30 6 0.35 7 0.26 8 0.09 B 6 0.21 8 0.53 10 0.26 с 5 0.09 7 0.27 9 0.40 11 0.19 13 0.05 D 6 0.66 8 0.34 a. Provide the base-case, worst-case, and best-case calculations for the time to...
(All answers were generated using 1,000 trials and native Excel functionality.) Suppose that the price of a share of a particular stock listed on the New York Stock Exchange is currently $39. The following probability distribution shows how the price per share is expected to change over a three- month period: Probability 0.05 0.10 0.25 0.20 0.20 Stock Price Change ($) 2 2 0 +1 +2 price per share is expected to change over a three- month period: Stock Price...
(All answers were generated using 1,000 trials and native Excel functionality.) Statewide Auto Insurance believes that for every trip longer than 10 minutes that a teenager drives, there is a 1 in 1,000 chance that the drive will results in an auto accident. Assume that the cost of an accident can be modeled with a beta distribution with an alpha parameter of 1.5, a beta parameter of 3, a minimum value of $500, and a maximum value of $20,000. Construct...
Answer next 3 questions using following information: A project has three activities A, B, and C that must be carried out sequentially. The probability distributions of the times required to complete each of the activities A, B, and C have uniform probability distribution in the following ranges:. Activity Completion Time A 1 to 5 B 2 to 3 C 3 to 6 Find the total project completion time and run 500 simulation trials in Excel. 1/ The “project completion time”...
All answers were generated using 1,000 trials and native Excel functionalty ) the management of Brsey Corporation is interested in using simlation to estimate the prafit per unit for a new product. The selling price cost, the labor cost, and the transportation cest are estimated s folow for the product wll be 945 per ntProbability bion orth p Transpertation Cost (6) Probability Cost (9) Probability Cest () Probebility 075 0.10 42225 .30 24 0.35 250.30 10 252 0.25 12 All...
Problem 12-09 (Algorithmic) A project has four activities (A, B, C, and D) that must be performed sequentially. The probability distributions for the time required to complete each of the activities are as follows: Activity Activity Time (weeks) Probability A 4 0.28 5 0.37 6 0.29 7 0.06 B 6 0.24 8 0.57 10 0.19 C 10 0.13 12 0.25 14 0.41 16 0.16 18 0.05 D 11 0.72 13 0.28 Provide the base-case, worst-case, and best-case calculations for the...
Problem 14-15 (All answers were generated using 1,000 trials and native Excel functionality.) In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougie that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $34 per doll. During the holiday selling season, FTC will sell the dolls for $42 each. If FTC overproduces the dolls, the excess...
A project has three activities A, B, and C that must be carried out sequentially, that is, A -> -> C. The probability distributions of the times required to complete each of the activities A, B, and C are uniformly distributed in intervals (1,6), (2,3) and (3,6) respectively. Find the total project completion time and run 1000 simulation trials in Excel. The "project completion time" is a(n)... Select one: O a. Input of the simulation O b. Decision variable in...