Category: Manufacturing Technology

Excel Exercises

This exercise begins with information for an IT Consultant Business Startup. Working in Microsoft Project, you will create the task list, including summary tasks and their sub-tasks, create links between tasks and their predecessors, add resources, and make changes to the original plan. Each student is required to submit their own, unique Project file.


  1. Enter the tasks, including the specified duration, specified predecessors, and specified resources from the View in a new windowHW9Data filePreview the documentView in a new window. Make the Start date of the project: June 30, 2017.


  1. Your business in charge of the IT Consultant Business Startup will be observing some holidays during the span of the project. They will take the following days off:


The week of the 4th of July

The week of Labor Day


Be sure to enter the working exceptions for these holidays through the working time of the project, not through individual tasks or resources. After you make your corrections, identify the Original Finish Date for the entire project. Save the baseline at this point.


  1. Your CEO feels the cost for the project to be excessive. Due to other projects planned, the CEO has asked for you to reduce the total cost for the project. The target budget for this operation is $55,000. Think carefully about the duration of the tasks and the resources required to make the project a success. Document the changes (ID number, task name, duration change, resource change, etc.) you plan on making to get the project under $55,000. (Reducing personnel wages and number of required resources is not permitted for this project.) Justify why you made the changes you did. Identify the new final cost of the project.


For your written response to B and C, submit a Word document. Remember to make your changes in response to C in the project.