Reference no: EM132584294

BA6052 Project Management - London Metropolitan University

BACKGROUND INFORMATION:

This case study is based on a job run by a firm of Computer Consultants to install some new database query software across a company with several different sites (nodes). The tasks are already grouped and indented - but resource allocations have been stripped out.

You can obtain the project file from WebLearn or from your BA6052 WebLearn site. The case study data file, called ‘BA6052.mpp', has been saved without a baseline.

Part A:

You are given the following information about the supply of resources for your project (all work based):

Resource Name:	Max Units:	Standard Rate	O/T rate:
Applications Manager	200%	£80.00/h	£95.00/h
Integration Manager	100%	£75.00/h	£90.00/h
Manager	100%	£80.00/h	£95.00/h
Network Engineer	600%	£50.00/h	£80.00/h
Programmer	500%	£50.00/h	£65.00/h
Software Installer	300%	£60.00/h	£80.00/h
Support Manager	100%	£60.00/h	£80.00/h
Systems Analyst	300%	£65.00/h	£85.00/h
System Tester	300%	£55.00/h	£70.00/h
Technical Author	100%	£70.00/h	£90.00/h

Required:

Part A i) 100% £70.00/h £90.00/h

First, allocate these resources to the tasks as stated below (where ‘NE' means ‘Network Engineer', ‘SA' means ‘Systems Analyst' ... and so on):

ID	Brief Name:	Resources to be allocated:
3	Install Ethernet and fast ethernet	NE at 200% and SA at 200%
4	Install multi mode fibre connection	NE at 100%
5	Request BT for connections	M at 100%
6	Schedule downtime for installation	NE at 200% and SA at 200%
9	Obtain Console hardware	SM at 100%
10	Determine subsystems to be installed	M at 100% and IM at 100%

Next, using your common sense (and differently from every other student), allocate at least one of the resources to each of the sub tasks as you consider appropriate. Do not add resources to top level summary tasks or milestones (though you may wish to add various fixed costs to these later).

For example, sub tasks that involve installation of software will require ‘Software Installers', sub tasks which involve writing or reviewing manuals will involve the ‘Technical Author', etc. Some sub tasks may need more than one resource. Do not feel that you have to use all of the resources listed.

For the first three such clashes that occur:
Resolve them in any way you consider sensible or let ‘MS Project' do it for you. Document carefully and explain any changes made either by you or by ‘MS Project' at the task level.

For any other clashes that occur:
Simply resolve them. There is no need to document any of the additional clashes.

Please note - as guidelines:

* With an acceptable allocation of resources (using the above tasks as guidelines for loadings), you should find that total costs are around £150,000 (possibly/probably a bit higher). You should not need to extend the duration of the project. If you do - you are probably loading in too many resources on each task. Try again.

* You are advised to choose the option for ‘Level within available slack' from the ‘Resource', ‘Levelling options' window and to show the baseline as a reference point via ‘Format'. You should also reset the baseline between clashes so as to collect the clearest possible evidence of each clash.

* Make sure that when you add resources to tasks you do so in a way that does not change task durations. Either allocate all the resources to a task at once or add the resources and then reset the duration in the ‘Gantt chart' to the original value.

* If you choose to solve clashes manually then remember that is it better to add new links between tasks rather than ‘dragging' them forward. Dragging a task sets an ‘SNET' constraint that may cause you problems later on.

* You may add other resources if you wish provided that you justify their inclusion.

Part A ii)

In part A i) above, you were given an initial supply of resources. Now that you have made your allocation of staff to tasks you should reconsider this initial allocation.

Required:

1. Find the minimum level of resources required for your project in order that it is still possible for all tasks to start at their earliest event times. Explain how you achieve this and give suitable evidence to show that it has been achieved.

2. Find the minimum number of ‘Network Engineers' that can be allocated without delaying the current project finish date. Again, explain and give evidence.

3. Explain also why this knowledge may be important to the effective management of your project

Leave the number of resources at the level found in ‘Part A ii) 1' for the rest of your work.

Part B:

You are now given the following information about various fixed costs:

Overheads are allocated to the project at £150 per day (covering management and administrative costs, secretarial support, consumables, photocopying, plan prints and office accommodation where allocated to this project, etc.). Payment is to be made pro rata.

For task 3 (Install ethernet and fast ...) the cost of components is £7000 paid up front.

For the duration of ‘Phase 2' you must hire a test site at a cost of £350 per week paid at the end of the phase.

Required:

Add the fixed costs as specified above. Describe carefully how each fixed costs is allocated within the programme and how much each adds to total cost. Provide evidence of these changes.

Of course, in the actual project, there would be far more fixed costs to take account of. But for the purposes of this assessment we will ignore them.

Note: When you add in fixed costs make sure you do so in a way that does not change the duration of your tasks.

Part C:

At the moment, by default, the project is using the ‘Standard' Microsoft Project calendar which ignores both Bank and Public Holidays. Create a new copy of the standard calendar (perhaps called by your name) and allocate it as the default calendar for your project. It should include the following dates, where relevant, as non working days:

Year 2021:	01 Jan	02 Apr	05 Apr	03 May	31 May
	30 Aug	27 Dec	28 Dec

Note: if you are using your own project for the assessment and dates fall outside the range given above, then simply visit the ‘GOV.UK' (or any other) web page for dates:

With the ‘Standard' calendar the project is due to start on Monday, 08 March 2021 and finish on Monday, 18 June, 2021 (a total of 75 working days).

Required:

Where will your new calendar be used in Project? Carefully explain any change in the project finish date.

Show some clear evidence that your dates have been changed to non working days.

Part D:

What is meant by the term ‘tracking'? Why is it necessary to ‘track' a project?

Your project now starts and you receive a report telling you that tasks 3 to 7 went off exactly according to plan.

Required:

Update MS Project to show that tasks 3 to 7 did indeed go according to plan.

Now, track through this project for tasks 9 to 13 inclusive making any assumptions about actual durations and/or costs you like. Have at least three tasks where either the duration or the cost (or both) were different from your baseline figure(s).

Explain carefully the variances you introduce for each of the tasks and carefully document the impact on costs and durations in your project for each task.

Provide some print out which demonstrates that tracking has occurred at task level and shows any cost and/or time variances so created.

Attachment:- Project Management.rar