Answer To: MNG XXXXXXXXXXSP5 Workbook Rubric Each section of the workbook is allocated a certain number of...
Swati answered on Aug 04 2021
MNG91217 Gantt
Farm house renovation project Resources available Code Cost per hour
You Y $ - 0 Instructions:
Contractor C $ 125 To allocate a resource in column F, click the cell and choose the resource from the drop-down box.
Apprentice I A1 $ 60 To create the bar, insert a number "1" (without quotation marks) in the cell.
Apprentice II A2 $ 40
You + Apprentice II Y&2 $ 40
Apprentice I + II 1&2 $ 100
Contractor + Son C&S $ 150
Schedule ACTIVITY PLANNED PLANNED RESOURCE PERIOD (HOURS)
START DURATION Week 1 Week 2
cost ($) 1 2 3 4 5 6 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 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
Purchase supplies 0 2 0 8 Y Y 1 1 1 1 1 1 1 1
Repair Shutters 450 3.1 2 3 C&S C 1 1 1
Paint Shutters 120 3.2 3.1 2 A1 C 1 1
Hang Shutters 80 3.3 3.2 2 A2 C 1 1
Repair porch 900 4.1 2 6 C&S C 1 1 1 1 1 1
Paint porch 240 4.2 4.1 4 A1 C 1 1 1 1
Repair floor 900 5.1 2 6 C&S C 1 1 1 1 1 1
Sand Floor 80 5.2 5.1 2 A2 C 1 1
Paint floor 480 5.3 5.2 8 A1 C 1 1 1 1 1 1
Paint ceilings 480 6.1 5.3 8 C C 1 1 1 1 1 1 1 1
Paint doors 240 6.2 6.1 4 A1 C 1 1 1 1
Paint interior walls 480 6.3 6.2 8 A1 C 1 1 1 1 1 1 1 1
Paint exterior walls 480 6.4 2, 3.3, 4.2 8 A1 C 1 1 1 1 1 1 1 1
Wash exterior windows 80 7.1 2, 4.2, 6.4 2 C Y 1 1 1 1
Wash interior windows 80 7.2 2, 6.3 2 Y&2 Y 1 1 1 1
Hang curtains 80 7.3 2, 6.2, 7.2 2 Y&2 Y 1 1 1 1
5170
Cost Per Hour $ - 0 $ 450 $ 120 $ 80 $ 900 $ 240 $ 480 $ 80 $ 900 $ 480 $ 240 $ 480 $ 480 $ 80 $ 80 $ 80 $ 150 $ 150 $ 150 $ 150 $ 150 $ 150 $ 60 $ 60 $ 60 $ 60 $ 150 $ 150 $ 150 $ 150 $ 150 $ 150 $ 40 $ 40 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 60 $ 125 $ 125 $ 125 $ 125 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ 40 $ - 0
Cumilative Cost $ 5,000 $ 5,450 $ 5,570 $ 5,650 $ 6,550 $ 6,790 $ 7,270 $ 7,350 $ 8,250 $ 8,730 $ 8,970 $ 9,450 $ 9,930 $ 10,010 $ 10,090 $ 10,170 $ 10,320 $ 10,470 $ 10,620 $ 10,770 $ 10,920 $ 11,070 $ 11,130 $ 11,190 $ 11,250 $ 11,310 $ 11,460 $ 11,610 $ 11,760 $ 11,910 $ 12,060 $ 12,210 $ 12,250 $ 12,290 $ 12,350 $ 12,410 $ 12,470 $ 12,530 $ 12,590 $ 12,650 $ 12,775 $ 12,900 $ 13,025 $ 13,150 $ 13,275 $ 13,400 $ 13,525 $ 13,650 $ 13,710 $ 13,770 $ 13,830 $ 13,890 $ 13,950 $ 14,010 $ 14,070 $ 14,130 $ 14,190 $ 14,250 $ 14,310 $ 14,370 $ 14,430 $ 14,490 $ 14,550 $ 14,610 $ 14,670 $ 14,730 $ 14,790 $ 14,850 $ 14,975 $ 15,100 $ 15,225 $ 15,350 $ 15,390 $ 15,430 $ 15,470 $ 15,510 $ 15,550 $ 15,590 $ 15,630 $ 15,670 $ 15,670
Cost Overview
Cumilative Cost 5000 5450 5570 5650 6550 6790 7270 7350 8250 8730 8970 9450 9930 10010 10090 10170 10320 10470 10620 10770 10920 11070 11130 11190 11250 11310 11460 11610 11760 11910 12060 12210 12250 12290 12350 12410 12470 12530 12590 12650 12775 12900 13025 13150 13275 13400 13525 13650 13710 13770 13830 13890 13950 14010 14070 14130 14190 14250 14310 14370 14430 14490 14550 14610 14670 14730 14790 14850 14975 15100 15225 15350 15390 15430 15470 15510 15550 15590 15630 15670 15670 Cost Per Hour 0 450 120 80 900 240 480 80 900 480 240 480 480 80 80 80 150 150 150 150 150 150 60 60 60 60 150 150 150 150 150 150 40 40 60 60 60 60 60 60 125 125 125 125 125 125 125 125 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 60 125 125 125 125 40 40 40 40 40 40 40 40 0
HISTOGRAMS
Contractor 0 4 5 6 1 7 0 0 4 0 Days
Apprentice 2 0 2 0 1 1 0 0 0 1 7 Days
You 8 0 0 0 0 0 0 0 1 7 Days
Son 0 4 5 6 0 0 0 0 0 0 Days
Apprentice 1 0 2 3 1 6 1 8 8 3 0 Days
Sheet 3
Old Farm Hous Project Resources available Code Cost per hour
You Y $ - 0
Contractor C $ 125
Apprentice I A1 $ 60
Apprentice II A2 $ 40
You + Apprentice II Y&1 $ 40
Apprentice I + II 1&2 $ 100
Contractor + Son C&S $ 150
Schedule ACTIVITY PLANNED PLANNED RESOURCE PERIOD (HOURS)
START DURATION Week 1 Week...