Attached Files: 3 POM+_Week6_Updated (1).mpp & (421.5KB) (3 POM+_CrashingData.xIsx &) (26.418 KB) 3 POM+ Status Update Information_4.30.2012.xIsx &y (10.886 KB) The attached Excel file provides progress information/updates for project tasks as of April 30, 2012. The file in Step 6 (below) provides the crashing data. The attached Project file includes the project file following status update at March 31, which you did in Week 6. Step 1: set the Status Date to April 30, 2012. Then input the actual task info for each task. Use the task status info and MS Project to assess project performance in terms of cost and schedule. Prepare a status report that summarizes your findings. Include in your report the following deliverables: . Executive summary not to exceed 1 page in length . Current status with respect to schedule performance . Current status with respect to cost performance . Use the MSP views that include CV, SV, CPI, SPI, EAC, and tracking Gantt to aid in your analysis . Does the project require action given the status at April 30, 2012? Why or why not? (You do not need to develop a project recovery plan for this step.) . Use the attached Excel file that includes information to shorten project duration for completion by July 31, 2012. Provide the steps necessary to complete the POM+ project by July 31, 2012. Provide which tasks to shorten and the added cost to shorten. 7. To wrap up the assignment, provide the new completion date and project cost. U R WN = Sobhita Kare POM+_Week6_upu riuject Professional X File Task Resource Report Project View Help Gantt Chart Format Tell me what you want to do Notes Find & Cut Mark on Track 11 Details Clear Calibri [B Copy Respect Links Task Summary Milestone Deliverable Information - Add to Timeline Scroll Manually Auto Inspect Move Mode to Task Fill Gantt Paste Format Painter BIUAV FEW ONE Inactivate Schedule Schedule Chart Tasks Insert Properties Editing Font Schedule 1st Quarter 2nd Quarter 3rd View Clipboard Remaining Bast Durati . Star Dec Jan Feb Mar Apr May Jun Ju Task Fixed Cost CV SV Duration Mode * Task Name Duration Cost Actual Cost EAC 156 days Tue $2,112,640.00 $1,098,740.00 $2,114,063.08 $0.00 ($1,540.00 ($14,720.00) 108.95 days 1 Pom+ Project 156 days 0 days 54 days Tue 1.1 R&D Product Developmedays $166,400.00 $166,400.00 $166,400.00 $0.00 $16,000.00) $0.00 0 days 22 days Tue MRKT [500%] 60.0 22 days $70,400.00 $0.00 ($6,400.00) 1.1.1 Need survey $70,400.00 $70,400.00 18 days Wed MRKT[200%],R&D[400%] $69,120.00 $69,120.00 $69,120.00 $0.00 ($11,520.00) $0.00 0 days 1.1.2 Set product specs 18 days R&D[300% $19,200.00 $19,200.00 $0.00 $0.00 $0.00 o days 10 days Wed 1.1.3 Shelf life report 10 days $19,200.00 o days 4 days Wec R&D[300%] $0.00 $7,680.00 $7,680.00 $7,680.00 $0.00 $1,920.00 1.1.4 Nutrition report 4 days BURCH ($1,920.00) 11 days 20 days Wed 1.2 Secure fruit suppliers 20 days $9,600.00 $4,320.00 $9,600.00 $0.00 $0.00 $14,460.00 $0.00 0 days 2 days Wed IE (Scope Change), Purchasing M 1.3 Order new production 2 days $893,920.00 $893,920.00 $893,920.00 $892,000.00 equipment 0 days Attorney $5,300.00 $0.00 2 days Mor $0.00 $0.00 1.4 Obtain State/Local 2 days $5,300.00 $5,300.00 regulatory permits $0.00 $0.00 69 days 59 days Mor 1.5 Initial Production 69 days $503,820.00 $0.00 $503,820.00 $0.00 10 $33,420.00 30.00 $0.00 $0.00 14 days 14 days Mor 1.5.1 Install New 14 days $33,420.00 $0.00 Production Equipment 1 day 1 day Mon IE (Scope Change) 1.5.1.1 New 1 day $640.00 $0.00 $640.00 30.00 50.00 S0.00 12 production 4 days Tue Master Electrician, IE $14,460.00 $0.00 $14,460.00 $0.00 $0.00 $0.00 4 days 1.5.1.2 Electrical Work 4 days 6 days Mor IE (Scope Change), 13 1.5.1.3 Remove old 6 days $14,640.00 $0.00 $14,640.00 $0.00 $0.00 $0.00 6 days 14 and retrofit new $2,880.00 $0.00 $0.00 $0.00 2 days 2 days Tue Operations Mana 1.5.1.4 Installation test 2 days $2,880.00 $0.00 Operations Man $0.00 $0.00 $0.0 1 day 1 day Thu GANTT CHART 1.5.1.5 Installation acce 1 day $800.00 $0.00 $800.00 PROD[1,500 16 $235,200.00 $0.00 $0.00 $0.00 15 days 15 days Fri 4 15 days $235,200.00 $0.00 QUAI 1.5.2 production trials $86,400.00 $0.00 $0.00 20 days Fri 5 $86,400.00 $0.00 QU 1.5.3 Quality trials 20 days $0.00 20 days $12,000.00 $0.00 $0.00 $0.00 5 days 5 days Mor 1.5.4 Quality metrics 5 days $12,000.00 $0.00 $136,800.00 $0.00 $0.00 $0.00 15 days 15 days Mor 1.5.5 Quality training 15 days $136,800.00 $0.00 61 days $207,200.00 $0.00 ($12,800.00) 70 days We $0.00 1.6 Distribution 70 days $207,200.00 $28,8 $0.00 ($12,800.00) 21 days 30 days Wed MRKT[500%] 1.6.1 Market testing 30 days $96,000.00 $28,800.00 $96,000.00 $0.00 MRI $0.00 $0.00 15 days 15 days Thu 1.6.2 Package design 15 days 30.00 $0.00 $31,200.00 $0.00 25 days Wed MRKILSO 1.6.3 Select distributors 25 days $80,000.00 $0.00 $80,000.00 $0.00 $0.00 $0.00 25 days 20 days Wet L $57,600.00 $0.00 $57,600.00 $0.00 $0.00 $0.00 20 days 1.7 Legal 20 days $0.00 $0.00 $0.0 15 days 15 days Wed LEGAL[300%% $43,200.0 1.7.1 Complete FDA certif 15 days $43,200.00 $0.00 $0.00 $0.00 5 days 5 days Wed LEGAH-1306 $14,400.00 $0.00 1.7.2 Register trademark 5 days $14,400.00 $0.00 $268,800.00 $0.00 $0.00 $0.00 15 days 15 days Tue 28 1.8 Prepare Product Launch 15 days $268,800.00 $0.00 4:28 PM Ready New Tasks : Manually Scheduled ~ ()4/24/2024 Content - Google C. P Project Professiona..A B C | L E POM+ Status Update | April 30, 2012 _ WBS - Task Name/Description % Complete Actual Start Actual Finish Actual Duration 1.2 Secure Fruit suppliers 100% 3/20/2012 A/2772012 29 ;1.5.1 Market Testing 100% 3/20/2012 4/30/2012 30 1.5.1.1 New production equipment delivery 100% 4/13/2012 41372012 1 1.5.1.2 Electrical work 100% 41772012 4/23/2012 5 1.5.1.3 Remove old and retrofit new prod equip 100% A4/24/2012 4302012 5 e e W00~ |0 |[w & [wW M= [~ Task ~ Duration 1.5.3 Quality trials 20 days 1.5.4 Quality metrics 5 days 1.5.5 Quality training 15 days 4 1,6 Distribution 70 days 1.6.1 Market testing 30 days 1.6.2 Package design 15 days 1.6.3 Select distributors 25 days 4 1.7 Legal 20 days 1.7.1 Complete FDA certification 15 days 1.7.2 Register trademark 5 days 1.8 Prepare Product Launch 15 days C D E F G Options to shorten project duration Task Cost | Task Cost/Day Contract Cost/Day | Net Daily Cost to Crash For 1.5.3 - Quality Trials, use lag notation, 1755+ 10 (Hint: use this!) crash time = 10 days .l $ 136,800 9,120 | 15,000 | 5,880 Crash time =25 days 3 96,0003 3,200 $ 5,000 | 1,800 crash time =12 days $ 31,200 |5 2,080 $ 3,000 | 5 920 crash time = 20 days $ 80,000 |5 3,200 $ 4,500 | 5 1,300 crash time =12 days $ 268,800 | S 17,920 22,000 | 4,080 A guick supporting note about the Net Daily Cost to Crash (shorten a task's duration): Look at 1.5.5 - Quality Training. Duration is 15 days and task cost is $136,800, so the daily cost of our assigned resources is $3,120. We can shorten the task by using contract services with a daily cost of $15,000. If we shorten by one day, we incur the $15,000 in contract costs and will use our assigned resources for the task one less day, with a cost of $9,120. The net cost becomes $15,000 less $9,120 = $5,830 per day