Microsoft Project 2013 - Real World Scheduling Microsoft Project Test Name Your assignment for this test is to create a computer-aided schedule for the following storage facility project using Microsoft Project Professional 2016 software. Sign and turn in these instructions with your test. Create the schedule using the following specifications. Your instructor will tell you where to Save the file. File name: Project 2016 Real World Scheduling - Test (your three initials). Start date: March 5th, 2019 Status date: March 5th, 2019 Title: (your name) Project Pro Scheduling Test. Subject: Storage Facility. Author: ( your name ). Company: ( your name ) Construction. Comments: This is the scheduling test for Microsoft Project Pro 2016. From the information below and the hand drawn schedule on the last page, create the construction schedule. Be sure to spell out the tasks descriptions exactly as they appear in this table. Do not include the words in (parenthesis) in the task description. Go to File, Options then to Schedule and make sure these three settings are set as follows: New tasks created: Auto Scheduled , , the Default task type: Fixed Work , and that the Split in-progress tasks is un-checked. Microsoft Project 2016 - Real World Scheduling Task Information TASK DESCRIPTION DUR CAL CONTRACT TYPE FIXED COST Notice to Proceed (milestone) 0 1 Lump Sum Order / Deliver Brick 40 1 Cost Plus 11000 Excavation 3 3 Cost Plus 4000 Underslab Rough-Ins 13 3 Lump Sum Lump Sum 17000 Footing and Foundation 17 3 Slab on Grade Backfill 6 3 Lump Sum 5900 2 Cost Plus Frame Walls 3 1 7 Cost Plus 7800 Frame / Shingle Roof 14 1 Cost Plus 22300 Masonry 22 3 1 Lump Sum 30000 Exterior Trim 19 Cost Plus HVAC Plumbing 15 1 Cost Plus 10 3 Cost Plus 9000 Electrical 5 3 Cost Plus 13000 Interior Finishes 17 1 Cost Plus Project Closeout 67 1 Lump Sum 2500 Punchout 10 Project Complete (milestone) 1 Cost Plus 0 1 Lump Sum 1 After creating the schedule as described above, you will generate and turn in a schedule using the following instructions. Be sure to follow these instructions in the order they are listed because they build on themselves. Make changes only to the schedule that are described below. 1. Add the six standard US holidays to the Standard calendar for the year 2019. Note: They are listed in your book as well as how they are specifically set by the US Department of Labor. 2. Create a Six Day Workweek calendar (starting from the Standard calendar) for the project and assign it to all the tasks on calendar 3. 3. Show the following columns with these names in this order: Task Name, Dur, Calendar Name, Start, Finish, Total Float, and Fixed Cost, with all data centered except Task Name (left) and Fixed Cost (right). Make all column titles Times New Roman (TNR), 12, bold, italic font, and centered. 4. Make sure that the Project Summary Task is showing at the top of the schedule. 5. Format the bar styles to ensure that all the task names appear to the right of the bars out on the Gantt chart on all of the tasks, milestones, and critical tasks. 6. Enter the fixed costs into the schedule. 7. The illustration to the right should help you picture the headings under which the tasks are to be organized using Summary Tasks. Note that this illustration shows only the summary tasks names but not the actual tasks. Organize all the tasks of the schedule using the summary task (your name) Construction Management on top for all tasks that are on calendar 1 as shown in the CAL column on the spreadsheet on the previous page followed by the Task Name i (your name) Project Pro Scheduling Test (your name) Construction Management + Lump Sum + Cost Plus Subcontractor summary task to include all tasks that are on Subcontractor calendar 3 as shown in the CAL column on the spreadsheet on + Lump Sum the previous page. Then all the tasks that you placed beneath + Cost Plus the (your name) Construction Management summary task should be organized into either the Lump Sum or Cost Plus summary task that you create based on the Contract Type column on the spreadsheet on the previous page. Finally, divide the tasks beneath the Subcontractor summary task the same way by contract type. 8. Adjust the column widths to be as narrow as possible, while still ensuring that the column titles and all the column data are visible and also ensuring that the task names do not wrap to a second line. 9. Adjust the column title cell height to ensure that the entire column title is visible. 10. Show the type of relationship lines that is shown here to the right. 11. The color of the critical bars should be red with the non-critical bars set at 12. Show only the following in the footer legend: Dark Blue, Lighter 60% . Task Summary Milestone Project Summary Critical Progress . 13. The schedule should fill one page horizontally. To get it to fit onto one page wide go to File, then Print to get to the print preview, then to Page Setup. In the Scaling section of this window, set pages wide by 1 tall Include a 5" Legend width. the Fit to: as shown here, Fit to: 1 . 14. In the Footer tab in the Left tab, type in Project 2016 Real World Scheduling, making all bold and switching Real World to italics. Make bold, the Page & [Page] number in the Center tab, then in the Right tab, type in JohnWyattPublishing.com making all in bold. 15. Save only to the Google drive. Print to PDF and Submit 2 Hand-Drawn - Storage Facility Schedule 55 (0) PROJECT GLOBEOUT FF ( 10 ) 67 - 1 010 BRICK FRAME 40 WALLS MASONRY FUNGHI COMPL OUT 0 7 22 TO S.O.G. FRAMES 3 0 EXCAV. FTG. ! FIND. 6 4 SHINGLE 17 BACK- KOPF 1 SS (6) EXTERIOR 4 TRIM - FILL - 14 19 3 - 2 - UNDER- - IFS(5) 1 SLAB ROUGH-INS 55 ( 6 ) HVAL INTERIOR 15 13 FINISHES 155(10) | PLUMBING 17 10 - - 1,55 ( 3) ELECTRIC 5