Submission Details To complete the assignment, use MS Project. Submit: - - 1. Resource Allocation. Given the schedule below with the limit of 5 resources (R), perform the following: a. Complete the precedence diagram and indicate the project's duration (number of workdays) without the resource limit. b. Calculate the dates of each activity and the daily resource usage with the resource limit by completing the chart on the next page, or you may use Excel if you prefer. c. Indicate the project's new duration (number of work days) with the resource limit. Activity Predecessor Duration Resource (R) A - 1 0 B A 2 1 C A 2 2 D A 1 3 E A 3 3 F B, C, D 1 1 G E 7 5 H F 2 1 J H 1 1 K G, J 3 2 1 Act. Resources Dur. TF LS / 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 2 2. Resource Leveling. Level the resources for the following schedule. Draw two manpower curves for the project: one before and one after leveling. Indicate the peak number of workers in both cases. Use the early start dates for the "before leveling" schedule. (It is suggested you use Excel to solve this problem). Activity Predecessor Duration Workers A 5 5 - B A 3 8 C A 5 10 D A 2 6 E C 2 12 F Milestone E 3 6 B, C, D, E, F 0 0 G Milestone 2 9 H Milestone 2 10 I Milestone 3 8 J Milestone K Milestone A 7 12 2 12 L 5 8 M A 7 6 N G,H,I,J,K,L,M 3 4 3 Bar Chart 1 2 3 4 5 6 17 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 22 24 25 Resource leveling 4 3. Use the schedule of the project activities listed below and add the corresponding resources. (see instructions below) Task Name Duration Predecessors Resources 1 Family House 2 Move-in 3 Notice to Proceed 0 days 4 Mobilize 5 days 3 1 Mobile Crane 5 6 Excavation Clear and Grub 4 days 4 1 dozer 1 excavator 7 Excavation 3 days 6 1 excavator, 2 haulers 8 Foundation 9 Formwork 9 days 7 Crew C-1 10 Place Rebar 3 days 9 4 Rodman 11 Rebar Inspection 0 days 10FS+1 day 12 Pour Footings 1 day 11FS+1 day Crew C-14C 13 Framing 14 Frame Structure 10 days 12FS+5 days 2 carpenters 1 forklift 15 Install Roof Trusses 1 day 14 1 forklift 2 carpenters 16 Roof Sheathing 2 days 15 1 forklift 2 carpenters 17 Install Windows & Doors 5 days 16 1 forklift 2 carpenters 18 Exterior Siding 6 days 16 2 carpenters 1 forklift 19 Paint Exterior 2 days 18,17 1 Painter, Ordinary Crew Q10, Crew Q-15 20 Rough-In 21 Rough-In MEP 18 days 19 22 Inspect MEP 0 days 21FS+1 day 23 Finishes 24 Insulate Walls 3 days 22FS+2 days 2 carpenters 25 GWB 5 days 24 1 carpenter 26 Tape and Texture 10 days 25 1 carpenter 27 Flooring 15 days 26 2 carpenters 28 Paint Interior 7 days 27 1 Painter, Ordinary 1 carpenter 1 Painter, Ordinary 30 Final Inspection 0 days 29FS+1 day 5 29 Remaining Finishes 12 days 28 Note: a) You may use the schedule you prepared for the HW_6 b) The start date for the project is 03/04/2024. c) The task name in bold indicates that it is a summary task. d) You can select the column with the activities and copy it to MS Project; you can do the same for the duration and the predecessors. e) If you copy the activities, you will have to adjust the hierarchy of the activities - they will all be left aligned, and you will need to create the summary tasks. Microsoft Project requires you to categorize your resources into one of three types: Work, Material, or Cost. · Work resources are associated with time. People and equipment are considered work resources as they are tracked by time. Tracking by time allows availability to be determined over allocation and cost tracking. · Material resources are assigned by quantity instead of time. · Cost resources are purely based on costs without time or quantity variables. E.g., building permits or the certificate of occupancy. Once you have the activities and corresponding durations and preferences in the MS project, you can create a resource pool that lists all available resources. For this project, consider that the following resources are available: Equipment Cost ($/hr) 1 Mobile Crane $250/hr 1 dozer $175/hr 1 excavator $260/hr 2 haulers $25/hr 1 forklift $75/hr Crew Crew C-1 $137/hr 4 Rodman $38/hr Crew C- 14C $930/hr 4 carpenters $40/hr 1 Painter, Ordinary $35/hr Crew Q10 $118/hr Crew Q-15 $86/hr 6 · In the View tab, in the Resource Views group, select Resource Sheet. . In the Resource sheet, Resource Name field, type the names of the resources. · As we are adding equipment and labor, select Work for type. . In MS Project, when you set up a resource pool, the default unit of measure for a Work resource is 100%. It means you have one of these work resources available full-time for your project. So, for example, if you have two laborers, you must enter 200%. · In the group field for the resource, type a group name (e.g., equipment). · Add costs to each resource (use the same value for Std. Rate and Ovt.) · Keep the calendar as standard (8 hr/day) Assign the resources to the tasks. . In the Resource tab, select the task to which you want to assign a resource. Then select Assign resource. File Task Resource Report Project View 11 Team Assign Resource Adc Information Note Planter Resources Pool Resources . View Assignments Insert Propertie Task Mode Task Name Duration 1 ^ Family House 127 days 2 Move-in 5 days 3 Notice to Proce 0 da 4 Mobilize Tp days 5 Excavation 7 days • Select the resources you want to add to each task. Create a cash flow. . In the Report tab, select Costs and Cash Flow. File Task Resource Report Project View Help Acrob Compare New Dashboards Resources Costs In Progress Getting Custom Rec Projects Report 4 Started Project Cash Flow Fixed Task Name Cost Overruns Cost > E 1 Family House Earned Value Report 240.00 2 Move-in Resource Cost Overview 200.00 3 Notice to Proce Task Cost Overview $0.00 4 Mobilize More Reports ... 200.00 5 Excavation $0.00 Prorated $3,040.00 · MS Project will create a default cash flow chart set per quarter. . On the right, you will see the Field List. Edit the time category and change the timescale to weeks. The orange line gives you the cumulative cost (in this case, for labor and equipment). The blue bars show your expected cost per week. 7 What to submit? · Gantt Chart with task name, duration, start date, finish date, predecessors, resources, and the bar chart (please ensure the above information is readable). . Cash Flow Chart . A table with the resource usage cost (Go to View> Tables> Cost) To generate the pdf for the Gant chart: i. Go to File > Print > Page Setup > Page, set orientation to Landscape, scale the page to fit 1 page wide by one tall, and use a letter as paper size. (You may need to hide some columns and adjust their width on the Gantt Chart to ensure all necessary content can be fit into 1 page). Page Setup - Gantt Chart ? × Page Margins | Header Footer | Legend View Orientation Portrait A Landscape Scaling Adjust to: 69 % normal size Fit to: 1 pages wide by 1 tall Other Paper Size: Letter First page number: Auto Print Preview ... Options ... Print ... OK Cancel ii. Add a header (Left - CE420/520; Center - Resource Allocation; Right - Last Name, First Name) and a footer (Center - Page Number by default) Page Setup - Gantt Chart ? X Page Margins Header Footer Legend View Preview: CE 420/520 Lab Assignment Xu Yiye Left Center Right Xu, Yiye A General: Page Number V Add Project fields: % Complete V Add Print Preview ... Options ... Print ... OK Cancel iii. Go to Print > Print to PDF (The image below is for reference only). Please ensure the necessary information and bar chart are readable and presented entirely. 8