Spreadsheet and Critical Path - 796 Words

Q1. Solve problem 27, page 182 of Mantel. a. Find the expected time and variance for each task. b. Draw the network (either AOA or AON) and the critical path and time. You may use MS Project or draw it manually. In either case, highlight or name the critical path and state the duration. c. Find the probability that the critical path will be completed in 23 weeks d. What is the probability that the other main paths will be completed in 23 weeks? e. If the paths are independent, what is the probability that the entire network will be completed in 23 weeks? SOLUTION: (a) Expected time and Variance is calculated in the Excel file attached. (b) The AOA network is drawn below: (c ) (d) and (e) done in the Excel Spreadsheet Q2.†¦show more content†¦In row 8, type each activity’s crash time Copy row 7 and paste it into Row 9. Label each of the Times rows by typing â€Å"Norma† in G7, â€Å"Crash† in G8, and â€Å"Actual† in G9. In Cell A10, type â€Å"Costs† In Row 11, put each activity’s normal cost. In G11, type â€Å"Normal†. In Row 12, put each activity’s crash cost. In G12, type â€Å"Crash†. In G13, type â€Å"Actual†. Put the formula in A13, =A11+(A7-A9)/(A7-A8)*(A12-A11) Select cells A13:F13, and paste Find the Path and In cell A14, type :Paths† In A15 type the Paths, there are 2 paths in cells A15 and A16. In H15 type =SUMPRODUCT(A15:F15,$A$9:$F$9) Copy and paste it to H16 This shows --ïÆ'   How long each path takes? Step 2: Identify the critical path The critical path is in row 16 The critical path is 1-AïÆ'  2-CïÆ'  4-EïÆ'  5-FïÆ'  6. It’s the path with the longest time. To make it easier to see which activities are in each path, got to cell A20 and type =IF(A15=1,A$2,) copy to A20:F21 In cell G17 type MAX In cell H17, type =MAX(H15:H16) This shows how long the slowest path takes. In cell H20 type =IF(H15=H$17,CRITICAL,) Copy cell to H20:H21 The critical path will be labeled as â€Å"CRITICAL† Step 3: Total Cost Formula In cell D14 , type â€Å"Total actual cost:† In cell G14, add up the actual costs of all of the activities. Type =SUM(A13:F13) This shows that if we use all normal times for all activities, the total cost is $1300 Step 4: Fill in theShow MoreRelatedBusiness Informatics1176 Words   |  5 Pagesuse a filter to narrow down the results on my screen and then just enter the correct data in the first cell and then using the ‘+’ in the corner of the cell drag it down to the bottom of the appropriate cells. II. While this spreadsheet is ideal for keeping track of small amounts of data such as in this case, but once the company grows, so will the amount of customers, staff and products. Making it difficult to keep up with manually entering all of the data and fixing any mistakesRead MoreThe Critical Path Method ( Cpm )1023 Words   |  5 Pagesbusiness, project management is critically important. The critical path method (CPM) will provide a timeline for the project manager for when tasks should be completed. In addition, providing a deadline and the negative effects it will have on the following successors if not completed on time. These many task are interdepended. Therefore, the CPM provides the start and finishes times of the tasks, and identifies the few tasks on the critical path that the project manager should observe to determine whichRead MoreApplication For Making An Organization Context1719 Words   |  7 Pagesorganization context 3.1 Demonstrate collected data and information through various graphs using any statistical software e.g. spreadsheet Using spreadsheet, decision makers record their information in rows and column so that data can be presented in graph using MS excel. For quick review of information and easy understanding, business organization uses spreadsheet line. Now, spreadsheet line, pie chart, bar chart will be used to analyze information. Question for the CR Which food you like in the restaurantRead MoreAnalyzing The Concepts Of Production And Cost Essay892 Words   |  4 PagesTown. The table outline the total product, average product of labor, marginal product of labor and labor. The excel spreadsheet below outline the weekly outputs of Al`s Bicycle Town and provide a graph that displays the data. In order to help determine where the average product of labor and marginal product of the labor cost curve cross we must determine where their paths cross on the graph. Looking at the table and graph it is easy to see that the AP and MP curve cross at 100 with 1 laborRead MoreThe Sql Server Integration Services ( Ssis )1032 Words   |  5 Pageshave the code call directly to a programming API. This sort of direct interaction allows for the most powerful integration and data manipulation. Risk Mitigation As with most database environments the largest risk a company can face is the loss of critical customer data, especially where it pertains to financial obligations. At a minimum any loss of data will have an impact on customer perception damaging your valuable relationship. An unrecoverable loss of data or prolonged outage may lead to lossRead MoreMechanisms For Risk Management And Control1671 Words   |  7 Pagesidentifying the incident types that have been most problematic for the agency. Review the agency’s loss data to determine what types of incidents historically have had the greatest negative affect on officer safety and civil liability. Once this high-risk critical incident list is generated, agency leaders should require selected supervisory personnel to conduct a mandatory review of all incidents that fall under these categories. Step 2. Deconstruction and Key Performance Indicators The next step in developingRead MoreCard 405- Rough Draft Portfolio1921 Words   |  8 PagesReference†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..†¦Ã¢â‚¬ ¦.11 Reference List †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.†¦Ã¢â‚¬ ¦..12 Awards and Accomplishments †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.†¦Ã¢â‚¬ ¦13 Volunteer History †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..14 Professional Affiliations †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..15 Career Path †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..16 Work Samples †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦...†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦17 Statement of Authenticity I, Ani Ohanian am the writer of all of the statements you are aboutRead MoreThe Castle s Family Restaurant926 Words   |  4 Pagesshift. At the end of each week, Morgan drives to each location and collects the time cards. He then inputs the data from the time cards in an Excel spreadsheet to calculate the number of hours worked by each employee. He then uses a computer application to print out payroll checks for each employee based on the calculations from the Excel spreadsheet. After which Morgan drives the checks to each location for distribution. IDENTIFIED PROBLEMS The Castle’s Family Organization could benefit fromRead MoreRiordan Manufacturing Hrms Integration Project1743 Words   |  7 Pageswriting (on special forms) by the employee s manager and are entered into the system by the payroll clerk, making the process vulnerable to errors and lag time. • Each recruiter maintains applicant information for open positions and an Excel spreadsheet is used to track the status of applicants. • Training and development records are stored in an Excel file by the training and development specialist. • Workers compensation is managed by a third-party provider, which keeps its own records.Read MoreProject for Goodwill Industries International, Inc. Essay1261 Words   |  6 PagesGoodwill Internet auction site, www.shopgoodwill.com. The revenues fund job training and other services to prepare people for job success. More than 84 percent of Goodwill’s total revenues are used to fund education and career services, and other critical community programs Here at Goodwill, we have five values which we feel strongly about and are sure to follow. First we have respect. Respect is listed first because no matter whom you encounter in life, all people deserve respect. At Goodwill