Free Essay

Submitted By summersanz
Words 352
Pages 2
Data Expected Value
Category name Value Frequency Probability Cumulative Probability Random No interval
Category 1 \$ 22.00 0.02 0.02 0.02 2
Category 2 \$ 23.00 0.35 0.35 0.37 37
Category 3 \$ 24.00 0.16 0.16 0.53 53
Category 4 \$ 25.00 0.44 0.44 0.97 97
Category 5 \$ 28.00 0.03 0.03 1 100
Category 6 0 1 100
Total 1 The probability for each cost is shown. The total of probability is 1.
We find the cumulative probability to assign range to each category.
Each category is represented by a range of random numbers between 1 to 100. To match the probability with random numbers we multiply cumulative probability by 100

So Labor Cost per Unit
Random numbers 1 to 2 represents \$ 22.00
Random numbers 3 to 37 represents \$ 23.00
Random numbers 38 to 53 represents \$ 24.00
Random numbers 54 to 97 represents \$ 25.00
Random numbers 98 to 100 represents \$ 28.00

so if random number is 75 then it is in range 54--97 so labor cost is \$ 25 Similarly for Utilities cost Expected Value
Category name Value Frequency Probability Cumulative Probability Random No interval
Category 1 \$ 3.00 0.36 0.36 0.36 36
Category 2 \$ 4.00 0.59 0.59 0.95 95
Category 3 \$ 6.00 0.05 0.05 1 100
Category 4 0 1 100
Category 5 0 1 100
Category 6 0 1 100
Total 1 The probability for each cost is shown. The total of probability is 1.
We find the cumulative probability to assign range to each category.
Each category is represented by a range of random numbers between 1 to 100. To match the probability with random numbers we multiply cumulative probability by 100

So Utilities Cost
Random numbers 1 to 36 represents \$ 3.00
Random numbers 37 to 95 represents \$ 4.00
Random numbers 96 to 100 represents \$ 6.00
Random numbers so if random number is 97 then it is in range 96-100 so utilities cost is \$ 6.

### Similar Documents

#### Qat 4

Words: 455 - Pages: 2

Free Essay

...QAT1 Task 5 Revised Task A. Develop New Product 1.) Develop Thoroughly= \$210,200 2.) Develop Rapidly= \$55,700 Consolidate Existing Product 3.) Strengthen Products= \$64,900 4.) Reap Without Investing= \$6,400 Task B. The decision alternative is to develop new products thoroughly, or decision alternative 1, with the expected value (EV) of \$210, 200. 1. Decision alternative 1 has the highest expected value (\$210,200) of all four branches, thus making it the most favorable decision. To find expected values for each decision alternative, first you multiply the Predicted Gains (or, Payoffs) by the Probability for each States of Nature (in this case, Market Reactions: Good, Moderate, and Poor). Then, you add the totals of each Market Reaction and that becomes the expected value for each decision alternative. The highest expected value from all the decisions is generally the most favorable decision. The following are the calculations for the expected values of each of the four decision alternatives: The formula is: EV= Predicted Gains(Probability) Decision alternative 1: Good: 500,000(.4) = 200,000 Moderate: 25,000(.4) = 10,000 Poor: 1,000(.2) = 200 Total: \$210,200 Decision alternative 2: Good: 500,000(.1) = 50,000 Moderate: 25,000(.2) = 5,000 Poor: 1,000(.7) = 700 Total: \$55,700 Decision alternative 3: Good: 200,000(.3) = 60,000 Moderate: 10,000(.4) = 4,000 Poor: 3,000(.3) = 900 Total: \$64,900 ......

Words: 253 - Pages: 2

Free Essay

...QAT1 Task 5 #258453 In the given scenario, a company is considering alternatives for improving profits by either developing new products, or consolidating existing products. There are 4 separate branches that split from the 2 main branches. Develop new product: 1). Develop thoroughly: a) Good demand .47 \$500,000 b) Moderate demand .38 \$25,000 c) Poor demand .15 \$1000 So, with the above given variables, to calculate the expected value, you multiply each probability times the corresponding payoff. Then add the results for each decision outcome. Calculations: a) .47 (500,000) = \$235,000 b) .38 (25000) = \$9500 c) .15 (1000) = \$150 Branch 1 expected value = \$244,650. 2). Develop rapidly: a) Good demand .06 \$500,000 b) Moderate demand .16 \$25000 c) Poor demand .78 \$1000 Calculations: a) .06 (500,000) = \$30000 b) .16 (25,000) = \$4000 c) .78 (1,000) = \$780 Branch 2 expected value = \$34780 Consolidate existing product: 3). Strengthen products: a) Good demand .69 \$2,000 b) Moderate demand .27 \$10,000 c) Poor demand .04 \$3,000 Calculations: a) .69 (2,000) = \$1380 b) .27 (10,000) = \$2700 c) .04 (3,000) = \$120 Branch 3 expected value = \$4200 4). Reap without investing: a) Good demand .32 \$10,000 b) Poor demand ...

Words: 290 - Pages: 2

...Quantitative Analysis for Business (QAT1) Submitted 05/05/2015 Assignment 309.3.3-04 Version LMF5-28 Student: Richard McClanahan Student ID: 000343792 TASK #5 Answer Task 5A Calculate the expected value for EACH of the four decision branches. 1. Develop Thoroughly: GOOD) \$500,000 (0.45) = \$225,000 MOD.) \$25,000 (0.10) = \$2,500 POOR) \$1,000 (0.45) = \$450 TOTAL EXPECTED VALUE: \$227,950 2. Develop Rapidly: GOOD) \$500,000 (0.52) = \$260,000 MOD) \$25,000 (0.23) =\$5,700 POOR) \$1,000 (0.25) =\$250 TOTAL EXPECTED VALUE: \$265,950 3. Strengthen Products GOOD) \$2,000 (0.33) = \$660 MOD) \$10,000 (0.52) = \$5,200 POOR) \$3,000 (0.15) = \$450 TOTAL EXPECTED VALUE: \$6,310 4. Reap without investing GOOD) \$10,000 (0.33) = \$3,300 POOR) \$1,000 (0.67) = \$670 TOTAL EXPECTED VALUE: \$3,970 EXPLINATION: We take the projected payoff and multiply that payoff by the probability factor. So if the good payoff to develop a product rapidly is \$500,000, we then multiply that by the probability factor of 52%, or 0.52. That gives us a probable payoff of \$260,000. Following this simply process, we extrapolate these results as listed above. ANSWER TASK 5B After calculating the total expected value for each decision alternative, the most profitable decision would be to RAPIDLY DEVELOP new products for a......

Words: 364 - Pages: 2