1. Project Definition/Parameters and Risks (20 Marks)

Module name Fundamentals of Project Management (BT7073)

Assessment Brief

The Fundamentals of Project Management course has TWO separate deliverables to be submitted as a single document:

Part A

Project Management Consultancy Report This should be structured in four sections based on the Case Study – 3500 words (85% of final course grade)

Part B

Reflective Essay Prepare an analysis into the challenges encountered throughout the Module and the difficulties producing the assessment. Identify clear personal development goals. Briefly from your research highlight the characteristics of a Good Project Manager.

2.2. Case Study

Background Automation Futures (AF) PLC which is shown in Fig.1 is a technology contracting, consulting and product/software development company with extensive experience in the design, manufacture, commissioning and delivery of a range of Electronic/Technology projects but specialising in Automation and New products for a range of clients including Bespoke Automation Factories. It operates out of a large Consultancy Practice in The Thames Valley (UK) and a Product Development factory in Ireland (ROI) which develops and manufactures automation plant and Prefabricated Factories for various clients largely in Europe. The company’s facilities and expertise allow them to offer tailor-made solutions that are highly competitive with other companies in this market. Margins on projects are good given the innovative nature of the business but clients are demanding and require competitive responses in a fastchanging world. AF PLC has won a major contract to design and build a new engineering Automation plant for a major Train manufacturing client, TTF PLC, based in Germany which will deliver Electronic Component parts including a to be designed Inverter Product specifically aimed at Power Saving for new train fleets. TTF is itself a major supplier to various governments and train operating companies throughout the world. The contract is structured on a risk and reward basis with a target price of £58.5m with a shared bonus if finished early and a shared penalty if finished late. The target price is extremely competitive and reflects the belief that they have the capacity to improve on the delivery date and thereby earn the bonus. The AF PLC bid was based on a conceptual design provided to them setting out the outputs in terms of product attributes including power saving targets and product availability. AF Plc will have to complete the detailed design of the Inverter product from outline designs prepared by TTF along with the automated production line as part of the Contract and organise installation of the equipment in the New factory in Germany which they will also have to commission and Construct

Questions:

1. Project Definition/Parameters and Risks (20 Marks)

(a) Discuss the relative importance of the various iron triangle parameters in setting the Overall Project objectives that will need to be managed by you as the AF PLC project manager over the course of the project, and how they may inter-relate to each other. (10 marks)

(b) Use the template provided to create a risk register, identifying a maximum of ten risks that AF PLC are likely to face with a construction project of this nature. (10 marks)

2. Planning and costs

There was to be a programmed review on progress after 17 weeks. There will only be an internal management cost for the review which will be incurred for this task outside the project cost. To complete this project, AF has recognised that it needs to Contract for the additional resources indicated above. These will be contracted from TECHRES. The average (fully inclusive) cost of an engineer was estimated to be £69.00 per hour and for technician/production staff £39.00 per hour. The company generally works a standard five-day week and eight-hour days. The Contract staff will all be on leave for 2 weeks over the Christmas period and will not be paid. This break also needs to be considered when scheduling the tasks. Project Management support will be provided by an external PM Company on the following basis 2 Assistant Project Manager, 2 project planners - £5,500 per week until project review and then reduced to one project planner, 1 Assistant Project Manager through to completion at £2,000 per week and 1 Commercial Manager/cost engineer through to review and then 2 until 4 weeks after Contract Completion at a cost of £2,750 per week per manager

A team of engineers working for TTF would be present at the AF PLC factory to supervise manufacture of the Automation Equipment– to ensure the intensive testing before they are transported from the AF PLC factory to the site. 10 weeks is allowed for this work (Task G in Table 1), and if any problems were detected, then delays could occur because TTF would be entitled to demand that the faults were rectified on the spot before the section was acceptable to them. AF PLC were accustomed to working with clients in this manner. The cost of this team will be borne by AF as a project Cost. It has been costed at £20k per week.

(a) Prepare a network diagram showing the critical path and planned duration of the project. Quantify the float on the non-critical tasks. (8 marks)

(b) Using Microsoft Project (or a similar package) prepare a Gantt chart for the project to a professional standard. Calibrate the timescale in weeks. If the project is scheduled to start on Monday 8 th July 2019 determine the planned completion date based on the constraints outlined in table 1 and the brief. (8 marks)

(c) Using the information provided, detail the overall Project Budget and the projected Net profit for the contract (i.e. revenue – costs) (including any bonus or allowing for any penalty) that the company will be aiming to achieve based on the projected completion date and the contract terms. You are also required to provide an indication of what budget components could impact the point at which in terms of days late the project could become loss making assuming no increases on the initial Project Budget. Show your workings clearly using a spreadsheet (You can submit as a separate spreadsheet file attachment, but the overall figures must be included in the main body of the report) (9 marks

3 Managing progress and spending (10 Marks

The project started on time, and after 17 weeks of work following on from the Project Review, an intensive analysis of the project was held at the AF PLC Factory. The following information was reported by the project team.

(a) Using the Gantt chart, determine the planned progress (%) for each task, after 17 weeks had been completed. Assume that progress is achieved on a linear basis for each task. For example, if a task is planned over the course of 4 weeks, then if 3 weeks have elapsed planned progress would be 75%. Then create a TABLE comparing the planned progress against the actual progress values from table 2. (5 marks)

(b) Enter the actual progress values for progress from the revised Table produced in answering Q3a into the Gantt Chart, and using Microsoft Project or similar software reschedule the project with effect from the review date. Produce a revised GANTT Chart AND IDENTIFY the new completion date and COMMENT on the outcome from a commercial perspective detailing any POTENTIAL effect on the Profit from the Project AND the budget cost. (5 marks)

4 Earned Value Analysis and Acceleration

(a) Create an Earned Value Analysis table showing ACWP, BCWP and BCWS values for every project task. Show all workings in a neat and professional layout. This is based on progress calculated at 1st November 2019 and the calculations in answer to Q3 above. Using EVA determine an overall planned % percentage Complete figure for the entire project and compare with an overall actual % percentage Complete figure for the project to that date. Also provide the CPI and SPI figures to date and explain what these figures indicate regarding Project Performance. Show all workings in a neat and professional layout. (10 marks)

(b) Create a projected completion date for the entire project using the Estimate at Completion (schedule) method derived from the Earned Value Analysis. Create a projected final spend for the entire project using the Estimate at Completion (cost) method derived from the Earned Value Analysis. Show your calculations clearly Compare these values with the original contract value to determine the likely profitability of the contract as it now stands.