Referencing Styles : Harvard For part A of the assessment you must complete the following tasks and questions. Read all the questions before you commence the tasks. The schedule is to be developed in an appropriately named Microsoft Project 2013 file (see below) and the questions are to be answered in a Word document. As stated above, any assumptions must also be listed at the beginning of the Word document. 1. You have been asked by Billy the Banker at ANZ , to use Microsoft Project to develop the project schedule. Note that he has also asked you to include the milestones at the end of the task list in your schedule. These will be used for monitoring the cash flow of the project. Based on the information in the case study description above, use Microsoft Project 2013 to produce a “Part A” schedule. Make sure that you: a) Include the milestones at the end of the task list. b) Include the resource allocation details on the schedule. c) Have the project name (CQConstruction Supplier’s Business upgrade) as the top of the task list and have all other tasks and summary tasks indented according to the given WBS. d) Make sure that the holidays described in the “additional information” are not included in the available working days for your project. e) Use the Microsoft Project software to make sure that the critical path(s) are automatically displayed in red on the bars of the Gantt chart view of you schedule. At this point there may be resource over allocation issues. Do not attempt to resolve these before answering question 2. Save this version of your schedule in ms project file called CQContructionSupplysPartA1.mpp. You will be required to submit this file as part of your assignment submission. 2. At this point ignore any resource over allocations. Based on your CQContructionSupplysPartA1.mpp schedule (and assuming that you would have no resource constraints): a) How long would the project take? b) What are the start and finish dates of the project? c) List all the tasks that are on the critical path. d) Did the annual holidays make any difference to the end date of your project? Explain why/why not. e) If you were asked to complete the project 3 weeks earlier by reducing the duration of some of the tasks in the project, what tasks would you target for reduction and why? In your answer, include specific suggestions about how you could reduce the duration of those tasks. 3. Create a copy of CQContructionSupplysPartA1.mpp in another file called CQContructionSupplysA2.mpp. If there were any resource over-allocation issues resolve these in this new CQControllersPartA2.mpp without adding any additional resources. Save the “modified” version of CQContructionSupplysPartA2.mpp. a) Describe how you used/would use Microsoft Project to resolve any resource overallocation issues? b) In your Word document, list the tasks that are now displayed as “critical”. c) Do the resource constraints have any impact on your project duration and end date? Explain. d) Sometimes it is possible to resolve resource over-allocation issues by levelling within available slack. What impact does this have on your project schedule? (Hint: consider both the advantages and disadvantages in your answer.) 4. CQContruction Supply’s Purchasing department require 6 clear working days notice to authorise any purchase over $10,000 dollars. You have four such purchases that will require such notification falling within the project period. Answer the following questions based on your CQContructionSupplysPartA2.mpp schedule: a) List the dates you expect to require the Delivery of robotic arms, Delivery of hydrolics, Geo Logistics Mapping Hardware and Software purchase for work on the project. b) Add a “milestone” as a reminder of the last date you need to give notice to the Purchasing department for each of these acquisitions. Add this at the start of your list of milestones and highlight the milestone in the task list using the “background colour” icon on the task ribbon. This will make it easier for your marker to check your work. c) According to your schedule, when is the last date you need to give notice to the purchasing for material for the project? 5. Write a memo to George Readymix outlining: a) the expected completion date of the project, assuming it commences at M1 (5/10/15); b) the total duration of the project; c) an explanation of the main factors that cause the project to require that length of time and any recommendations that you might make if time was a priority for the project; d) the estimated direct labour cost of the project (excluding the cost of your project management consultancy) after the M1 concept review. Present the costs in a table showing the costs for the following: Cost Robotics Pump System CRM Geo Logistics Mapping Customer Mobile Portal Design & Depolyment Total for the Project: Assume that you will send the project schedule (CQContructionSupplysPartA2.mpp) as an attachment to the memo. The information in the memo should correspond to the attached schedule