Sanford Medical Center Amazing Coffee Houses Expansion Project Excel Worksheet Create a project schedule for the given activities. Read the attached instru

Sanford Medical Center Amazing Coffee Houses Expansion Project Excel Worksheet Create a project schedule for the given activities. Read the attached instructions and guidelines At the next meeting, you and the team had a very productive discussion on your findings related
to the identification of all of the project activities that must happen to start and finish your
project. You even took a step further in working with your team members to estimate resources
and cost for each of the activities. Everyone feels that it is time to present your findings to Sam
and Gloria and provide them with a baseline estimate of how long this project will most likely
cost in terms of time and dollars.
“Thanks for educating us on the schedule development planning,” says Jerry to you. “We have
some great information here, but I think it is too much detail to present to Sam and Gloria.”
“I agree,” says Melissa. “Does anyone have any ideas on how best to present this information?”
“We should go ahead and plug this information into a project schedule that both Sam and Gloria
know and will appreciate. We ought to establish a project baseline at this time. We should define
the tasks, start and finish dates, durations, predecessors (sequence of activities), resource names,
and possibly cost,” says Sara.
“The project schedule should account for all of the activities that must happen. It must not be less
than 30–50 activities and subactivities,” you say.
“Oh, that’s great!” says Jim. “Do you think you can prepare it for the team by next week?”
Assignment
Tips: Start by looking at the work breakdown structure (WBS) activities that you defined last
week. Think about how you could decompose your work packages into activities and
subactivities to complete this coffee house project. You should use all of the project artifacts
(deliverables) you produced so far and the given project scenario to identify all of the activities
that are needed.
You should be able to come up with 30–100 activities easily for your schedule baseline. Once
those activities have been identified, finish your schedule by plugging in start and finish dates,
durations, predecessor relationships, and adding cost and resource names. Resource names and
cost can be added in the main summary page or directly in the resource sheet. Your project name
must go in the first row, and all other activates should be indented under it. You should link all
activities to summary tasks and subactivities to the main activity. You may make assumptions
for any of this work, and estimates do not need to be real. You should save the finished project
file as: “Week 3 deliverable_your name.”
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course
materials.
V 2.0
Project
Name
Project
Team
Owner(s)
Amazing Coffee Houses Milwaukee’s
expansion Project
1. Jim young – Project Manager
2. Daniel Johnson
3. Samson Kreuk
4. Mathias West
5. Maryann Love
Sam and Gloria Ryder
Project
Number
Prioritization
001
Start Date:
4th January
2019
Scheduled
Completion
Date:
Mission/
Purpose
SOW: Project
Description
and Project
Product
Top priority
4th July 2019
This project aims to undertake the expansion of the Amazing Coffee
Houses to a new location in a different state (Milwaukee, WI). It relates
to the overall strategic goals of the organization where they seek to
expand the coffee establishment throughout the United States
This project will create a new branch of Amazing Coffee Houses at
Milwaukee, WI. The outcome of this expansion will be new outlets for
the organization allowing it to increase revenue generation by$125,000.
The project will be completed by;
1. Establishing the project management team
2. Acquiring and renovating the property
3. Getting all the legal and regulatory requirement
4. Equipping the location
5. Launching the operations
Objectives
The objective of this project is to expand business operation of the
Amazing Coffee Houses from its birth place in Chicago t in order to
increase the revenue generation of the company. Its goals include;
1. Acquiring a new property in the Milwaukee, WI. region
2. Establishing a new location
3. Offering customers premier café experience
4. Generating additional revenue over$125,000.
Business Need
The project will expand the operations of Amazing Coffee Houses
beyond the borders of Chicago where it has been operating, reach new
markets and increase the revenue generation of the company
Milestones
Project Charter
Milestone
Deciding on the best expansion
project
Creation of project management
team
Development of project plan
Date
Purchase of property
January 18th 2019
Acquiring the require material
January 25th- February 15th
Contracting the project
executioners
Renovation of the building
February 20th
Evaluation of the premises
April 25th- April 30th
Marketing the location
June 28th- July 2nd 2019
Official launch
July 4th 2019
Monitoring and Evaluation
November 4th 2019
December 20i8
January 4th, 2019
January 5th-
March 1st-april 20th
Budget
Estimated Labor
$100,000
Estimated Materials
$100,000
Estimated Contractors
$100,000
Estimated Equipment and
Facilities
Estimated Travel
Total Estimated Cost
User Acceptance
Criteria
$ 300,000
$50,000
$650,000
Success of the project will be measured using the ability of the
establishment to meet set targets in terms of revenue generation
projection and customer experience feedback. The ability of the
establishment to receive and surpass the projected revenue
generation and the customers give positive feedback, the owners
will know its successful.
Project Charter
High-Level
Project
Assumptions
High-Level
Project
Constraints
1. The project will run on schedule
2. There will be enough resources to see the project through
3. All the parties involved in the project will be committed to the
process
4. The management of the organization will fully give their
support for the project operation
5. The staff members from the organization brought in will offer
the needed assistance
6. The project team will work cohesively together till the end
7. The project execution will meet the desired outcomes
1.
2.
3.
4.
5.
6.
7.
8.
9.
Budgetary constraints
Time constraints
Project management guidelines
Procurement procedures
Contracting procedures
State laws and regulation of establishing a business
Licensing requirement
Health guidelines and safety regulations
Operational standards evaluation
Exclusions
and
Boundaries
1.
2.
3.
4.
5.
6.
7.
8.
Business diversification
Training
Acquisitions of coffee houses
Establishment of multiple branches outside
The rebranding of Amazing Coffee Houses
Recruitment
Introduction of new menu products
Restructuring organization’s leadership and operations
Major Risks
1.
2.
3.
4.
5.
6.
7.
8.
Cost overruns
Time overruns
Resource shortages
Project team’s disagreement
Regulatory setbacks
Stakeholder issues
Changes in pricing of goods
Demands supply issues
Project Charter
Work Breakdown Structure
Project: Amazing Coffee Houses Milwaukee’s Expansion Project
1.0 Project Management
2.0 Establishing the project management team
2.1 selecting the members
2.2 Completing the project plan
3.0 Acquiring and renovating the property
3.1 Acquisition of the property
3.2 Contracting renovators
3.3 Renovation of the property
4.0 . Getting all the legal and regulatory requirement
4.1 Acquisition of licenses from Milwaukee, WI.
4.2 Getting clearance from the region’s regulators
5.0 Equipping the location
5.1 Buying the material required for the new location
5.2 Fitting the material to the facility
6.0 Launching the operations
6.1 Marketing the place
6.2 Officially launching the operations of the branch
7.0 Monitoring and evaluation
7.1 Monitoring the operations of the branch
7.2 Evaluating to determine its performance
KEY STAKEHOLDERS
1.
2.
3.
4.
5.
6.
Management of Amazing Coffee Houses
Project team members
Amazing Coffee Houses staff
Contractors
Government agencies
Local communities in Milwaukee, WI
Project Charter
Project Core
Team
Subject Matter
Experts
1.
2.
3.
4.
5.
Jim young – Project Manager
Daniel Johnson
Samson Kreuk
Mathias West
Maryann Love
Project management skills
Communication skills
Resource management skills
Type Name
Project Manager Approval
Jim Young
Customer/Sponsor Approval
Sam and Gloria Ryder
APPROVALS
Signature
Date
Project Charter
Reference
Hobbs, P. (2015). Project management. New York: DK Publishing

Purchase answer to see full
attachment