GEB 3422 Aspen University Business Project Management Worksheet

User Generated

PyrbIva

Business Finance

GEB 3422

Aspen University

GEB

Description

My first submission did not meet requirements. I've attached the "sample" the grading instructor gave me to use as reference when she provided me feedback.

In your role as a Project Manager for Kingston-Bryce Limited you have been assigned to create a scorecard. Now that the acquisition is underway, the Board of Directors for Kingston-Bryce Limited (KBL) wants to be updated on a regular basis about the performance of the project. In order for this acquisition to be successful, you will need to use your project management skills to ensure success and that all stakeholders are updated on the performance of the project.

Instructions

Your task is to develop a scorecard in Excel. The scorecard will be used to measure the performance of the project. Include the following in your scorecard:

  • Actual versus budget for the following (you will need to create these numbers):
    • Timelines
    • Project duration
    • Budget
    • Meeting frequency

Unformatted Attachment Preview

Task Name Duration Evaluate Strategic Acquisition 383 days Develop Acquisition Strategy Identify Current Capabilities and Positioning Perform Competitive Analysis Perform Market Trend Analysis Define Current Positioning and Gaps Define Acquisition Goals Define Strategic Objectives For Acquisition Define Risk Tolerance Define Financial Risk Tolerance Define Market Position Risk Tolerance Define Capabilities Risk Tolerance Define Internal Versus Acquisition Evaluation Criteria Define Internal Development Capabilities Model Define Internal Versus Acquisition Comparison Model Define Selection Scenario and Target Performance Measures Form Acquisition Team Identify Acquisition Team Members Document Acquisition Team Charter Set Acquisition Team Major Milestones Set Acquisition Team Process Hold Acquisition Team Kickoff Meeting Define Acquisition Target Screening Criteria Define Target Identification Criteria Define Industry, Product, and Channel Criteria Define Profitability, Capitalization, and Cash Flow Criteria Define Intellectual Property and R&D Criteria Define Management, Organization & Governance Criteria Define Risk, Legal, & Financial Exposure Criteria Define and Summarize Synergy Criteria Define Quantitative &Qualitative Screening Criteria Define Industry, Product, & Channel Screens Define Profitability, Capitalization, and Cash Flow Screens Define Intellectual Property and R&D Screens Define Management, Organization & Governance Screens Define Risk, Legal, & Financial Exposure Tolerance Screens Perform Acquisition Target Valuation Analysis & Due Diligence Select Investment Banker Perform Valuation Analysis Perform Financial Valuation Analysis Define Financial Scenarios Develop Financial Synergy Analysis Define Financial Risks and Opportunities 106 days 30 days 10 days 10 days 10 days 24 days 5 days 27 days 7 days 11 days 10 days 18 days 6 days 6 days 6 days 28.93 days 9 days 5 days 5 days 10 days 1 day 70 days 35 days 5 days 5 days 5 days 8 days 7 days 5 days 35 days 7 days 7 days 7 days 7 days 7 days 180 days 14 days 110 days 19 days 7 days 7 days 5 days Perform Market & Product Analysis Identify Market Synergies Identify Product Synergies Identify Combined Portfolio Strategies Perform Industry Specific Analysis Perform Intellectual Property and R&D Analysis Perform Legal and Gov't Compliance Analysis Define Legal Risks, Issues, and Synergies Define Other Gov't Regulatory Risks, Issues, and Synergies Perform Management & Corporate Governance Analysis Define Management Synergies and Scenarios Define Corporate Governance Synergies and Scenarios Define Institutional Shareholder Synergies, Impacts & Scenarios Finalize Due Diligence Checklists Prioritize Due Diligence Activities Assign Due Diligence Activities Define Due Diligence Schedule Perform Due Diligence Activities Perform Fiscal Cost/Benefit Due Diligence Perform Financial Reporting Requirements Due Diligence Perform Market & Product Due Diligence Perform Industry-Specific Due Diligence Perform Intellectual Property and R&D Due Diligence Perform Legal, Risk, and Government Compliance Due Diligence Perform Management and Corporate Governance Due Diligence Compile Results of Due Diligence Assessment Perform Investment Activities Develop Acquisition Financing Strategies Secure Financing Prepare and Hold Proxy Vote Finalize Investment Activities Acquisition Transaction Complete 21 days 7 days 7 days 7 days 7 days 7 days 20 days 10 days 10 days 21 days 7 days 7 days 7 days 15 days 5 days 5 days 5 days 56 days 7 days 7 days 7 days 7 days 7 days 7 days 7 days 7 days 380 days 7 days 10 days 1 day 3 days 2 days Actual Duration Cost Actual Cost Start Finish 127.49 days $592,281.80 $133,189.78 Mon 1/20/20 Wed 7/28/21 106 days 30 days 10 days 10 days 10 days 24 days 5 days 27 days 7 days 11 days 10 days 18 days 6 days 6 days 6 days 28.93 days 9 days 5 days 5 days 10 days 1 day 16.82 days 16.82 days 5 days 5 days 5 days 1.82 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days $162,017.13 $16,800.00 $2,800.00 $2,800.00 $2,800.00 $37,280.00 $2,800.00 $22,000.00 $2,800.00 $4,400.00 $4,000.00 $19,440.00 $3,360.00 $3,360.00 $3,360.00 $33,377.13 $3,062.29 $2,600.00 $2,600.00 $5,200.00 $4,872.00 $134,785.33 $46,016.00 $1,400.00 $2,360.00 $1,800.00 $11,456.00 $8,400.00 $2,400.00 $52,369.33 $1,960.00 $3,304.00 $8,260.00 $3,341.33 $17,304.00 $237,547.33 $6,608.00 $94,350.00 $9,500.00 $3,304.00 $3,304.00 $2,360.00 $106,617.13 $16,520.00 $2,800.00 $2,800.00 $2,800.00 $37,280.00 $2,800.00 $22,000.00 $2,800.00 $4,400.00 $4,000.00 $19,440.00 $3,360.00 $3,360.00 $3,360.00 $33,377.13 $3,062.29 $2,600.00 $2,600.00 $5,200.00 $4,872.00 $26,572.65 $16,915.49 $1,400.00 $2,360.00 $1,800.00 $2,608.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Wed 6/17/20 Tue 3/3/20 Mon 2/3/20 Tue 2/18/20 Tue 3/3/20 Mon 4/6/20 Fri 3/27/20 Tue 5/5/20 Tue 4/7/20 Wed 4/22/20 Tue 5/5/20 Fri 5/29/20 Wed 5/13/20 Thu 5/21/20 Fri 5/29/20 Fri 7/10/20 Thu 6/11/20 Thu 6/18/20 Thu 6/25/20 Fri 7/10/20 Mon 7/6/20 Wed 10/14/20 Mon 8/24/20 Mon 7/13/20 Mon 7/20/20 Mon 7/27/20 Thu 8/6/20 Mon 8/17/20 Mon 8/24/20 Wed 10/14/20 Wed 9/2/20 Mon 9/14/20 Wed 9/23/20 Fri 10/2/20 Wed 10/14/20 Wed 7/7/21 Tue 11/3/20 Mon 4/19/21 Thu 12/3/20 Fri 11/13/20 Tue 11/24/20 Thu 12/3/20 Tue 1/21/20 Tue 1/21/20 Tue 1/21/20 Tue 2/4/20 Wed 2/19/20 Wed 3/4/20 Mon 3/23/20 Mon 3/30/20 Mon 3/30/20 Wed 4/8/20 Wed 4/22/20 Wed 5/6/20 Wed 5/6/20 Thu 5/14/20 Fri 5/22/20 Mon 6/1/20 Mon 6/1/20 Thu 6/11/20 Thu 6/18/20 Thu 6/25/20 Thu 7/2/20 Mon 7/6/20 Mon 7/6/20 Mon 7/6/20 Mon 7/13/20 Mon 7/20/20 Mon 7/27/20 Thu 8/6/20 Mon 8/17/20 Mon 8/24/20 Mon 8/24/20 Wed 9/2/20 Mon 9/14/20 Wed 9/23/20 Fri 10/2/20 Wed 10/14/20 Wed 10/14/20 Tue 11/3/20 Tue 11/3/20 Tue 11/3/20 Fri 11/13/20 Tue 11/24/20 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days 0 days $5,880.00 $1,960.00 $1,960.00 $1,960.00 $2,520.00 $16,520.00 $40,000.00 $20,000.00 $20,000.00 $10,640.00 $3,360.00 $3,360.00 $3,920.00 $9,290.00 $4,090.00 $2,600.00 $2,600.00 $42,989.33 $3,304.00 $3,304.00 $1,960.00 $2,520.00 $16,520.00 $8,400.00 $3,341.33 $3,640.00 $47,468.00 $3,612.00 $32,720.00 $560.00 $3,816.00 $10,464.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Thu 12/3/20 Thu 12/3/20 Mon 12/14/20 Wed 12/23/20 Thu 1/7/21 Tue 1/19/21 Thu 1/28/21 Thu 1/28/21 Thu 2/11/21 Fri 2/26/21 Fri 2/26/21 Tue 3/9/21 Thu 3/18/21 Mon 3/29/21 Mon 3/29/21 Mon 4/5/21 Mon 4/12/21 Mon 4/19/21 Mon 4/19/21 Wed 4/28/21 Fri 5/7/21 Tue 5/18/21 Thu 5/27/21 Tue 6/8/21 Thu 6/17/21 Mon 6/28/21 Mon 1/20/20 Tue 1/21/20 Tue 7/6/21 Fri 7/23/21 Tue 1/21/20 Tue 7/27/21 Thu 1/7/21 Mon 12/14/20 Wed 12/23/20 Thu 1/7/21 Tue 1/19/21 Thu 1/28/21 Fri 2/26/21 Thu 2/11/21 Fri 2/26/21 Mon 3/29/21 Tue 3/9/21 Thu 3/18/21 Mon 3/29/21 Mon 4/19/21 Mon 4/5/21 Mon 4/12/21 Mon 4/19/21 Wed 7/7/21 Wed 4/28/21 Fri 5/7/21 Tue 5/18/21 Thu 5/27/21 Tue 6/8/21 Thu 6/17/21 Mon 6/28/21 Wed 7/7/21 Fri 7/23/21 Wed 1/29/20 Mon 7/19/21 Fri 7/23/21 Thu 1/23/20 Wed 7/28/21 Actual Start Actual Finish Mon 1/20/20 NA Tue 1/21/20 Tue 1/21/20 Tue 1/21/20 Tue 2/4/20 Wed 2/19/20 Wed 3/4/20 Mon 3/23/20 Mon 3/30/20 Mon 3/30/20 Wed 4/8/20 Wed 4/22/20 Wed 5/6/20 Wed 5/6/20 Thu 5/14/20 Fri 5/22/20 Mon 6/1/20 Mon 6/1/20 Thu 6/11/20 Thu 6/18/20 Thu 6/25/20 Thu 7/2/20 Mon 7/6/20 Mon 7/6/20 Mon 7/6/20 Mon 7/13/20 Mon 7/20/20 Mon 7/27/20 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Mon 2/3/20 Tue 2/18/20 Tue 3/3/20 Tue 5/5/20 Fri 3/27/20 Tue 5/5/20 Tue 4/7/20 Wed 4/22/20 Tue 5/5/20 Fri 5/29/20 Wed 5/13/20 Thu 5/21/20 Fri 5/29/20 Fri 7/10/20 Thu 6/11/20 Thu 6/18/20 Thu 6/25/20 Fri 7/10/20 Mon 7/6/20 NA NA Mon 7/13/20 Mon 7/20/20 Mon 7/27/20 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Meeting Frequency Actual Meeting Frequency Daily Standup (1 per day @ 15 min) +1 Per Week = 127 All meetings scheduled were attended 36 12 12 12 28 Quarterly (1) 36 12 10 10 28 Quarterly (1) 32 8 13 12 22 7 7 7 35 11 Quarterly (1) Quarterly (1) 6 12 1 84 40 6 6 6 9 Quarterly (1) 32 8 13 12 22 7 7 7 35 11 6 12 1 20 20 6 6 6 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Quarterly (1) Quarterly (1) Quarterly (1) End of Project (1)
Purchase answer to see full attachment
Explanation & Answer:
3 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello, have a look

WBS

Task Name

Duration

Actual
Duration

Actual Start

1

Evaluate Strategic Acquisition

540 days

511.21 days

Tue 2/11/20

120 days

120 days

Tue 2/11/20

9 days
3 days
2 days
4 days
8 days
8 days
5 days
4 days
3 days
1 day
23 days
6 days
2 days

9 days
3 days
2 days
4 days
8 days
8 days
5 days
4 days
3 days
1 day
23 days
6 days
2 days

Tue 2/11/20
Tue 2/11/20
Fri 2/14/20
Tue 2/18/20
Mon 2/24/20
Mon 2/24/20
Thu 3/5/20
Thu 3/5/20
Thu 3/5/20
Wed 3/11/20
Thu 3/12/20
Thu 3/12/20
Fri 3/20/20

15 days

15 days

Tue 3/24/20

75 days
14 days
21 days
17 days
23 days
21 days
115 days
92 days
22 days

75 days
14 days
21 days
17 days
23 days
21 days
101.88 days
87.73 days
22 days

Tue 4/14/20
Tue 4/14/20
Mon 5/4/20
Tue 6/2/20
Thu 6/25/20
Thu 6/25/20
Fri 7/24/20
Fri 7/24/20
Fri 7/24/20

1.1
1.1.1
1.1.1.1
1.1.1.2
1.1.1.3
1.1.2
1.1.2.1
1.1.3
1.1.3.1
1.1.3.2
1.1.3.3
1.1.4
1.1.4.1
1.1.4.2
1.1.4.3
1.1.5
1.1.5.1
1.1.5.2
1.1.5.3
1.1.5.4
1.1.5.5
1.2
1.2.1
1.2.1.1

Develop Acquisition Strategy
Identify Current Capabilities and Positioning
Perform Competitive Analysis
Perform Market Trend Analysis
Define Current Positioning and Gaps
Define Acquisition Goals
Define Strategic Objectives For Acquisition
Define Risk Tolerance
Define Financial Risk Tolerance
Define Market Position Risk Tolerance
Define Capabilities Risk Tolerance
Define Internal Versus Acquisition Evaluation Criteria
Define Internal Development Capabilities Model
Define Internal Versus Acquisition Comparison Model
Define Selection Scenario and Target Performance Measures
Form Acquisition Team
Identify Acquisition Team Members
Document Acquisition Team Charter
Set Acquisition Team Major Milestones
Set Acquisition Team Process
Hold Acquisition Team Kickoff Meeting
Define Acquisition Target Screening Criteria
Define Target Identification Criteria
Define Industry, Product, and Channel Criteria

1.2.1.2

Define Profitability, Capitalization, and Cash Flow Criteria

36 days

36 days

Tue 8/25/20

1.2.1.3

Define Intellectual Property and R&D Criteria

16 ...


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags