I have an assignment for an engineering project management class. I want it done in 8 hours.

it is based on a prevouse hw that i did. I also attached the previouse HW , and an example of the assgimnet that you are going to do. here is the professor instruction: Students: Here is your HW3 assignment. Since our least class session is today, please submit HW3 by email. I will go over the assignment in detail during today’s session. We can discuss any questions that you may have by email. 1) HW3 Assignment HW3 consists of assigning some cost items to the activities identified in your HW2 projects. Assignment as follows: · Select at least two activities from your HW2 project for which to assign a minimum of nine total cost items (e.g. you might select three activities from HW2, and develop three cost items for each activity, for a total of nine cost items). · In Excel, develop a spreadsheet with the columns: WBS; ID; Description; Quantity; Unit; Labor; Equipment; Material; Sub-bid; and, Total. You may use the attached Excel spreadsheet as a template. · You must have at least one each of the four cost elements (labor, equipment, material, sub-bid) represented among the nine cost items (i.e. not acceptable that all cost items are labor or sub-bid cost elements). · The totals of all the cost items should “roll-up” to a total cost for each WBS. · The deliverable for HW3 shall be an Excel spreadsheet, with the nine cost items in the format discussed above and as presented during class, which is similar to the detailed cost items shown on pages 13-30 of the attached “Petaluma River FCP - 95% Estimate.pdf”. · HW3 is due to be emailed to me by Friday 31-March. So that you may receive a satisfactory grade, I may interact with you by email (though not as intensively as for HW2) to complete grading of HW3. 2) HW3 General Notes · The main reason that I have reduced the number of activities for which you will have cost items assigned, is that some of you have projects with some high-level activities, which are not specific enough to easily cost. E.g. The low-level activity “Assemble Cylinder Head” would be relatively easy to cost, because that is primarily a labor item of short duration. However, the high-level activity “Build Bridge Superstructure” is obviously an early planning phase activity with longer duration, that would develop into numerous activities and cost items during detailed planning phase. For those of you that may have defined projects where most of the activities are high-level, I will be available to help you define cost items during either of the two times I will be in the classroom, and by email. · As I discussed yesterday during Session 7, the “Description” for each cost item should include three parts: o detailed description of the cost item; o notes of how the quantities are derived (e.g. 60 HP10 x 42 x 50’ piles = 3,000 LF); o and, the source of pricing information (e.g. http://www.get-a-quote.net/ 2009 Alabama Heavy Construction, 10 x 10 x 42 lbs. per foot, Per vertical foot driven. Add the cost of moving equipment on and off the job site, using a 1,600 CFM at 100 PSI air compressor, 200’ of 3" hardrock air hose, an 85-ton crawler mechanical crane with 160’ boom, a 19,500 lb. single action pile hammer, 8" x 26" 60’ long pile leads and small tools.) · As will be discussed in class, http://www.get-a-quote.net/ is accessible to all of you on the internet for pricing information. · As will be discussed in class, I will put on reserve at the SFSU library: R.S. Means Building Construction Cost Data, 2009 and 2010 editions, for your use to find pricing information. · As will be discussed in class, also please find attached California union personnel labor rates from May 2014. 3) HW3 Excel template notes • The four cost items for activity 21, Injector Cleaning, each have only one cost element. These are cost items that a student in a previous class developed by doing their own research. 21-4 is a good example of a sub-bid cost item. 21-3 shows how the student used SFCA Davis Bacon data to develop a labor rate. • The six cost items for activities 15 and 16 have multiple cost elements for each cost item. 15.1 is an example of a cost item that you will find in the R.S. Means Building Cost Data book on reserve for this class at the library. The other items are from http://www.get-a-quote.net • I have formatted the attached spreadsheet so that unit costs are italicized for each cost item. Populate the unit costs and the quantity, then the total costs are calculated. Of course, depending on how many activities and cost items that you have, you may have to adjust the formulas for the roll-up sums at the activity levels, and the WBS levels.