(e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31.The variance of activity is computed using formula ((p - o)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights.(f) Write a formula in cell I25 to compute the activity A variance. Copy the formula to cells I26 to I31.Screenshot attached thank you 1516171819202122232425262728293031ABсActivityABсDEDFGPrecedingActivities--EAAC,BDE,FYou would like to determine the expected duration and variance for the project's seven activities named A to G. Table 4 has the weights assigned to optimistic, most likely, and pessimistic situations.The expected duration for an activity is the weighted average of the weights and the duration for the activities in each of the situations.As an example, expected duration for Activity A = Weight of Optimistic * Optimistic duration + Weight of Most Likely * Most Likely duration + Weight of Pessimistic * Pessimistic duration.(e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31.The variance of activity is computed using formula ((p - o)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights.(f) Write a formula in cell 125 to compute the activity A variance. Copy the formula to cells 126 to 131.Optimistic(0)667578FTable 4: WeightsMost likely(m)51Table 5: Expected duration and variance for seven activitiesMost likely Pessimistic ExpectedOptimistic (0)(p)t (days)8(m)7991010G488Pessimistic(p)1411H112121110Variance ²ActivityABсDE=FGLAAC.B.DE,F667MTable 5: Expected duration and variance for seven activitiesPrecedingMost likely Pessimistic ExpectedOptimistic (0)Activities(p) t (days)85785(m)72N991010880Sample Answer14=1112121110P7.009.339.009.509.838.507.83Variance o²0.1111111.7777780.4444441.3611110.6944440.2500000.694444QF

Excel:- Data formatting, organization, and calculation are all made possible by Microsoft Excel.…

(e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31. The variance of activity is computed using formula ((p - o)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights. (f) Write a formula in cell I25 to compute the activity A variance. Copy the formula to cells I26 to I31. Screenshot attached thank you

(e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31. The variance of activity is computed using formula ((p - o)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights. (f) Write a formula in cell I25 to compute the activity A variance. Copy the formula to cells I26 to I31. Screenshot attached thank you

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter8: Network Models

Section8.4: Cpm And Pert

Problem 7P

See similar textbooks

Similar questions

In the model in Example 15.5, suppose bonuses and penalties are incurred for earliness or lateness. Specifically, suppose a bonus of $2000 is received if the project is completed within 60 days, an extra bonus of $1000 is received if the project is completed within 58 days, and a penalty of $1000 is incurred for every full day past a project completion of 64 days. (For example, if the project is completed in 66.7 days, the penalty is $2000—two full days late.) Modify the model appropriately, and then run the simulation to find the distribution of the net monetary outcome (negative if a penalty, positive if a bonus). What is the expected value of this net amount? What is the probability of a $3000 total bonus? What is the probability of a penalty of at least $4000? Example 15.5 LAN PROJECT WITH UNCERTAIN ACTIVITY TIMES We again analyze the LAN project from Example 15.1, but we now assume that the activity durations are uncertain, with given probability distributions. The…
Depending on the cause of death, racial/ethnic and gender disparities exist on years of potential life lost in the United States. Years of Potential Life Lost (YPLL) can be defined as the number of years lost when death occurs before one’s life expectancy. For this assignment, life expectancy will be set for everyone at 75. For YPLL, a death of a very young person is weighted more than a death of a very old person (McKenzie, Pinger, & Seabert, 2018). AS Instructions: Investigate one cause of death (infant mortality, homicide, suicide, unintentional injuries (such as car accidents, drowning, falling, etc.), pregnancy complications, COVID-19, etc.) in the United States and research the YPLL for racial/ethnic groups and genders. Summarize your findings in your paper and discuss how calculating YPLL can change the way we think about that particular cause of death differently.
Ma1. 1) On a Bank Reconciliation, if our check was written for $492.83 and was processed as such by the bank, but had been shown in our company's accounting records as a check for $498.23, we would code this as a C+ item.T rue or False 2) In the Bottom-Up method of calculating required revenue, we treat the amount of desired net income (once we have calculated how much it should be) as:a. a variable cost. b. a step cost. c. unnecessary for the calculation. d. a fixed item. e. none of the above. 3) A large F variance from budget in a revenue item should be investigated. True or False 4) If a Bank Reconciliation cannot be made to balance, then something unusual has occurred and must be investigated. True or False 5) In preparing a bank reconciliation, we will code an NSF check (using the fabulous Bessner system) as: a. a C+ item. b. a C- item. c. a B+ item. d. a B- item. e. none of the above. 6) If a company wants to end up with an AFTER-TAX profit of $25,000, and its tax rate is 38%,…
(An LP model for the blending problem) The Exxoff-Still Company must decide how different components of the raw materials are blended for their gasoline production. The characteristics of their two gasoline products are listed below: Gasoline Vaper Pressure Octane Number Selling price ($/barrel) Regular ≤7 ≥80 10 Premium ≤6 ≥100 12 The characteristics of the raw materials from which the gasoline can be blended are shown below: Raw Materials Vaper Pressure Octane Number Availability (barrels) Cat Gas 8 83 2700 IsoIso Gas 20 109 1350 Brady Gas 4 74 4100 The vapor pressure and octane number of a blend is simply the weighted average of the corre- sponding characteristics of its components (weighted by their proportion in the blend). (a) Please formulate a linear programming model to determine how different components of the raw materials are blended for their gasoline production to maximize Exxoff-Still’s total rev- enue. Be sure to clearly define all decision variables and explain the…
A software company has 3 senior developers and 4 junior developers. These developers are working as 3 different teams; 2 sets of ‘1Senior+1Junior’ and 1 set of ‘1Senior+2Junior’. Productivity levels of junior developers according to their senior developer working with are given in the table. Formulate this problem as an LP model. Senior D. 1 Senior D. 2 Senior D. 3 Junior D. 1 2 10 5 Junior D. 2 6 9 8 Junior D. 3 7 5 6 Junior D. 4 10 6 10
Depending on the cause of death, racial/ethnic and gender disparities exist on years of potential life lost in the United States. Years of Potential Life Lost (YPLL) can be defined as the number of years lost when death occurs before one’s life expectancy. For this assignment, life expectancy will be set for everyone at 75. For YPLL, a death of a very young person is weighted more than a death of a very old person (Seabert, McKenzie, & Pinger, 2022). AS Instructions: Investigate one cause of death (infant mortality, homicide, suicide, unintentional injuries (such as car accidents, drowning, falling, etc.), pregnancy complications, COVID-19, etc.) in the United States and research the YPLL for racial/ethnic groups and genders. Summarize your findings in your paper and discuss how calculating YPLL can change the way we think about that particular cause of death differently. Provide factual documentation that reinforces your findings from at least three peer reviewed sources…
It has been observed by management that some faculty members at theuniversity demonstrate a lackadaisical attitude toward teaching. They seldom go to class yet at the end of each month they receive full salary. Management has decided that GHs 200, 300, 400, and 500 will be deducted from a faculty’s salary if he/she offends once, twice, third time and forth time respectively in a month. This means that if a faculty member offends once in a month GHs200 will be deducted, if a faculty member offends twice in a month, GHs 500 (i.e. 200+300) will be deducted, if a faculty member offends three times in a month GHs 900 (i.e. 200+300+400), will be deducted and if a faculty member offends four times in a month GHs 1,400 (i.e. 200+300+400+500). Assuming all faculty members are on a flat salary rate of GHs 2000.a. Write a program to request for the names of four faculty members and number times he/she has absented him/herself from class in a month.One of them should have absented him/herself…
Correct answer will be upvoted else downvoted. Computer science. There are n urban communities numbered from 1 to n, and city I has excellence computer based intelligence. A sales rep needs to begin at city 1, visit each city precisely once, and return to city 1. For all i≠j, a departure from city I to city j costs max(ci,aj−ai) dollars, where ci is the value floor implemented by city I. Note that there is no outright worth. Track down the base absolute expense for the sales rep to finish his excursion. Input The main line contains a solitary integer n (2≤n≤105) — the number of urban communities. The I-th of the following n lines contains two integers artificial intelligence, ci (0≤ai,ci≤109) — the magnificence and value floor of the I-th city. Output Output a solitary integer — the base all out cost
Tom Cruise, Freddy Prinze Jr., Harrison Ford, and MattLeBlanc are marooned on a desert island with JenniferAniston, Courteney Cox, Gwyneth Paltrow, and JuliaRoberts. The "compatibility measures" in Table 52 indicatehow much happiness each couple would experience if theyspent all their time together. The happiness earned by acouple is proportional to the fraction of time they spendtogether. For example, if Freddie and Gwyneth spend halftheir time together, they earn happiness of tC9) = 4.5.a Let xu be the fraction of time that the ith man spendswith the jth woman. The goal of the eight people is tomaximize the total happiness of the people on the island. Formulate an LP whose optimal solution will yieldthe optimal values of the xy's.b Explain why the optimal solution in part (a) willhave four xu = I and twelve xy = 0. The optimal solution requires that each person spend all his or her timewith one person of the opposite sex, so this result is often referred to as the Marriage Theorem.c…
Suppose you have to select one project partner from a set of four classmates, who have different GPAs. Assume you do not know any student’s GPA in advance but can get to know it after you have picked a student from that group (a) Suppose you pick one of the four students at random and accept that student as your project partner. What is the probability that your partner is the one with the highest GPA? (b) Suppose you decide to reject the first student and to then accept the next student if and only if that student has a higher GPA. Note that you MUST have a partner, so if the first three are rejected by you, then you have to accept the fourth student. What is the probability that your partner will be the one with the highest GPA.
using c++ ..Given a set of activities and the starting and finishing time of each activity, find themaximum number of activities that can be performed by a single person assuming that aperson can only work on a single activity at a time.This problem is called the activity selection problem, which concerns the selection ofnon-conflicting activities to perform within a given time frame, given a set of activities eachmarked by a start and finish time. Input:11{1, 4}, {3, 5}, {0, 6}, {5, 7}, {3, 8}, {5, 9}, {6, 10}, {8, 11}, {8, 12}, {2, 13}, {12, 14}Output:4{1, 4}, {5, 7}, {8, 11}, {12, 14}
A company's board consists of 4 people: Abigail (the CEO), Benoit, Charlie, and Debra. When they take a vote, if there is a majority (either up or down), that vote prevails. If, however, there is a tie, then Abigail's vote is the tie-breaker (e.g. if A&B vote up, and C&D vote down, the outcome is "up", because A's vote breaks the tie). The truth table will show all possible combinations of the 4 votes, and the final decision for each.