1. In the attached spreadsheet (Module 3 Assignment 1.xlsx), you will find a network logic diagram and resource information (please see the various worksheet tabs).
2. Using the attached spreadsheet, prepare the Early Start Bar Chart, the Early Start Resource Histogram, and the Early Start Resource Usage Graph.
3. You may use Excel features, such as Column Charts and X-Y Scatter Graph to produce the outputs, or create the outputs using manual inputs into teh Excel worksheets provided in the attached file.
4. Answer the following two questions regarding this resource allocation (you may note the responses to these questions in your Excel file):

What is the maximum number of resources used on any given day?

What is the total number of resources for the entire project?

1. Save your Excel file, adding your own name to the existing file name.
2. Submit your Excel file using this assignment link.

Excel File Edit View Insert Format Tools Data Window Help 1 0 8 2 Q 9 Fri Apr 19 8:50 PM Ciudad Juarez 1 77 Clear H:86. L:580 AutoSave Q AF ? C ... Module 3 Assignment 1 Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat Comments Share A ab v Conditional Formatting Aria A General Insert O Format as Table Delete v -00 Editing Sensitivity Add-ins Analyze Create PDF Paste B I U MVA $ ~ % Cell Styles v Format v Data and share link B3 X V fx NTP C D E F G H I J L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS A B No ACT DUR RES 0 1 2 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 JAWN 1 NTP 0 0 AWARD SUBS 3 0 PROC JST 10 0 PROC ACL 10 0 PROC FURN 8 8 5 0 VOULAWN CLR SITE 2 FDNS 3 U/G SERV 11 EXT WALL RF DECK 11 RF FIN 12 EXT DR&WNDW 13 BLDG ENCI 14 FLR SOG 17 . W - NW - WONNN 15 MTL STD 16 PART 17 FLR FIN SO N O W W N W N W W N N W N WA WA OAAA ON WWO F/CARE 20 CLG GRID 21 CLG TILE 22 PAINT 25 R/PLBG 26 F/PLBG 27 25 R/MECH 28 26 F/MECH - N W W N - N WC 29 R/ELEC 30 28 F/ELE 31 WTHR CONT 32 30 PUNCH LIST 33 31 PROJ COMP 0 34 DAILY TOTAL: 35 CUMULATIVE TOTAL: 0 36 37 38 Mod 3 Assignment 1 Network Mod 3 Assignment 1 Bar Chart Mod 3 Assignment 1 ES Histogram Mod 3 Assignment 1 ES Usage Ready 100% Ex Accessibility: Investigate APR 19