Please don't wait too long if you want to reject. I need to solve this question as soon as possible, and you can take as many questions as you need from me. There are 2 photos one of the questions and the second one related to the info you need from the Excel. Question 1:You have recently joined as the project manager of ABC Company. Please refer to the Excel file to seethe project information.a) Complete status reports for periods 1-6b) Complete the below performance indexes Summary Table.。。。Ac) Calculate the EAC, VAC, ETC, TCPI just for period 6. Assume CPI and SPI influence theremaining work.d) Draw CPI and SPI graph; how this graph can help you to understand the project situation.e) Based on your data, what is the project status at the end of period 6?2TaskABсDEFGHNONPeriod1234562 B 5003 5NON50100150100200100150100C 5OEV AC PV SPI CPI3sonWeekly Cost50501501001005050100DN1001501507077OE27 F19091013 11%Completion911009 2 11GLegendES IDSLLS DUR LF11 H0EFSL11513O2 13 )50%Cumulative TotalsStatus Report: Ending Period 3Task % CompleteA100%B0%с0%Cumulative Totals45 Status Report: Ending Period 45Task % CompleteA100%B60%с50%12B7B92B4Cumulative TotalsStatus Report: Ending Period 5Task % CompleteA100%B100%5с100%5Cumulative Totals7 Status Report: Ending Period 6BTask % Complete9A100%B100%с100%D75%Cumulative Totals0ABStatus Report: Ending Period 1Task % Complete125%Cumulative TotalsStatus Report: Ending Period 2Task % CompleteA2BсEVEVEVEVEVEVDAC5050AC100AC20000AC200100200AC200200400AC200200400100EPVPVPVPVPVPVFCVCVCVCVCVCVGSVSVSVSVSVSV

Find the Calculations methods below:

You have recently joined as the project manager of ABC Company. Please refer to the Excel file to see the project information. a) Complete status reports for periods 1-6 b) Complete the below performance indexes Summary Table. Period 1 2 3 4 5 6 EV AC PV SPI CPI Completion c) Calculate the EAC, VAC, ETC, TCPI just for period 6. Assume CPI and SPI influence the remaining work. d) Draw CPI and SPI graph; how this graph can help you to understand the project situation. e) Based on your data, what is the project status at the end of period 6?

You have recently joined as the project manager of ABC Company. Please refer to the Excel file to see the project information. a) Complete status reports for periods 1-6 b) Complete the below performance indexes Summary Table. Period 1 2 3 4 5 6 EV AC PV SPI CPI Completion c) Calculate the EAC, VAC, ETC, TCPI just for period 6. Assume CPI and SPI influence the remaining work. d) Draw CPI and SPI graph; how this graph can help you to understand the project situation. e) Based on your data, what is the project status at the end of period 6?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

quetion 1 a)What is a burn-down chart? What purpose does it serve? b)Why should a project manager be concerned with monitoring a project’s progress? c) Describe how the SPI and CPI can be used to forecast the final cost of a project?
Project Implementation Plan for Culinary Tourism. • You will be creating a Project Implementation Plan for the new service to be offered by your team/group • Step 4 - Outline of Deliverables - Deliverables are the tangibles of your company. Outlining the deliverables, you hope to create can serve as a resource. This will include time frames/ due dates for ensuring the product/ service is brought to the market. For example - you can use the GANTT CHART for this part (GANTT chart helps teams to plan work around deadlines and properly allocate resources). You are also required to assign tasks for team members for which they would be accountable, and allocate resources for each input required. Kindly prepare a Conclusion for Culinary Tourism State main points and way forward in the future. Synthesize the entire paper with specific details as included in the paper No new information is included in the conclusion
Project Implementation Plan for Culinary Tourism.: • You will be creating a Project Implementation Plan for the new service to be offered by your team/group • Step 4 - Outline of Deliverables - Deliverables are the tangibles of your company. Outlining the deliverables, you hope to create can serve as a resource. This will include time frames/ due dates for ensuring the product/ service is brought to the market. For example - you can use the GANTT CHART for this part (GANTT chart helps teams to plan work around deadlines and properly allocate resources). You are also required to assign tasks for team members for which they would be accountable, and allocate resources for each input required.
You are the manager of a project to improve a billing processat your firm. Table 7.7 contains the data you will need toconduct a cost analysis of the project. Indirect costs are $1,600per week, and penalty costs are $1,200 per week after week 12.a. What is the minimum-cost schedule for this project?b. What is the difference in total project costs between the ear-liest completion time of the project using “normal” timesand the minimum-cost schedule you derived in part (a)?
Part 1: The 5 project management groups have wide industry application in modern day project management. By using practical examples of your choice, demonstrate the practical application of the project management processes in bringing a project to a successful end (Detailed response required, also acknowledge information sources). Part 2: A gantt chart is widely applied in project management as a project scheduling tool,whose format is in bar chart form. Critically examine a gantt chart as a project scheduling tool and practically demonstrate how it can also be used as a project planning and control technique (Detailed response required, also acknowledge information sources).
Evaluate the below statement according to the project management terminologies and choose the correct answer: It is the process of making a forecast or precise approximation Choose... of time and cost associated with a work package or activity. Graphically describes a project consisting of well-defined Choose.. activities, the completion of which marks its end. One of the Perform Quantitative Risk Analysis process has a Choose.. Tools and Techniques. Useful for building accountability through assigning specific Choose.. tasks to team members. It is the standard format each path through the network must be continuous with no gaps, discontinuities, or dangling Choose... activities. Organizational Assets, Project Scope Statement, Cost Management Plan and Schedule Management Plan are inputs Choose.. of: Choose... Work Breakdown Structure Expert Judgment Bar chart Estimating A horizontal diagram format Plan Risk Management
AABCDE Activity J К Predecessor None PZABUD FGHL-KL EOFICI LA C H с H J.I,K Draft PDS Identify team Kickoff team meeting Source previous rocket Identify & order missing or new materials/parts Assembly Simulation Alpha Test Beta Test Training of key people Buy food to bring Launch DITONT Duration (wks) 1 1 0 2 4 8722860 1. Show the Critical Path. Give reasons for your answer. 2. If you needed to shorten the duration of the project, which activity or activities would you shorten and why?
2:51 0 SC Lee Principle. core.learn.edgenuity.com 3SC Lee Principles for Tourism and Hospitality- 3rd Six weeks EMILY MCKNIGHT Activity eNotes Project: Online Marketing Poster Project Active Section 1 of 1 Project. ONIIne Miar Keing PosSter Assignment Directions: Your poster should illustrate the advantages and disadvantages of online marketing. You can include information from this lesson and from the Internet. Assignment Guldelines Your response should meet the following qualifications: The poster can have printed or hand written text. It should also include pictures. The pictures can be printed from the internet or be hand drawn. Be sure to label the advantages and disadvantages clearly. Submission Requirements: « PREVIOUS B SAVE e SUBMIT NEXT v6.0.3 0038 20200504 mainline 2016 Glynlyon, Inc. All rights reserved. 1 Provious Activity
Project definition involves: Your answer: 1-identifying geo-social environment, econo-political environment, business environment, and internal environment. 2- identifying stakeholders, understanding their motivations,and prioritising and managing different stakeholders. 3- determining objectives, scope. and strategy. 4- Defining operations
RESEARCH TOPICS1. The difference between project feasibility and project appraisal and their significance toproject sustainability2. The interplay between the project components (Cost, time, scope and quality) and thesignificance to project performance and sustainability3. Report writing process and utility of project report to project management
Q You have been asked to select between three projects. Project A has a netpresent value of $54,750 and will take six months to complete. Project B hasa net present value of $85,100 and will take two years to complete. ProjectC has a net present value of $15,000 and a benefit-cost ratio of 5:2. Whichproject should you choose?A. Project AB. Project BC. Project CD. There is not enough information to decide Q Which of the following is a defect?A. A mistake made by a team member on the jobB. A change that the team needs to make in how they do the workC. A project management plan that does not meet its requirementsD. A change request that’s been rejected by the change control board
Corporate triple-A bond interest rates for 12 consecutive months follow. (a) Construct a time series plot. 11.01 10.5 10.0 9.5- FEFE 9.0- 8.5 8.0 7.5- 2 1 4 11.01 5 10.5 3 6 10.0 7 9.6 9.3 9.4 9.6 9.9 9.8 9.8 10.6 10.0 9.7 9.7 9.6 What type of pattern exists in the data? O The data appear to follow a seasonal pattern. O The data appear to follow a cyclical pattern. O The data appear to follow a horizontal pattern. O The data appear to follow a trend pattern. 8 Month 9 10 9.5 11 9.0 12 8.5 8.0 7.5 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Time Series Value 3-Month Moving Average Forecast 4-Month Moving Average Forecast 9.6 9.3 9.4 9.6 9.9 9.8 9.8 10.6 10.0 9.7 9.7 9.6 | | [ | Ⓒ L 11.0 T T 들 10.5 10.0- 9.5 9.0 8.5 8.0 7.5 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month 0° 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month Does the three-month or four-month moving average provide more…