PART 1
Refer to the top assignment listed by the letter of your last name found below. Assume you are working on a project to improve customer service. Create a Pareto chart based on the information in the assigned option. Use the Pareto chart template (available in the online classroom) or use Excel to produce a Pareto chart that looks like the Pareto chart in Chapter 8 of the course textbook. Include three detailed actions to take to address the customer complaints.
Group 1 – Last names beginning with A – F:
Customer Complaint
Frequency/Week
Customer is on hold too long
41
An appointment is not available within 48 hours
35
Wait time in the exam room exceeds 20 minutes
98
Co-pay amount is incorrectly calculated by staff
75
PART 2
Using the Gantt chart and timeline developed in Week 3 for your clinic, determine the critical pathway. What are the factors that contribute to the critical pathway? Identify tasks that could be done simultaneously and if so redo the Gantt chart in preparation for the Final Project. If you cannot identify any tasks that could be done simultaneously, explain why.
Critical Path Method
HELP
© 2010-2023 Vertex42 LLC
Start Date
1/11/2015
Finish Date
2/5/2015
Days to Completion
20.00
Times (in Days)
Time Distribution:
ID
Task Name
10
20
30
40
50
60
70
80
90
Start
Task A
Task B
Task C
Task D
Task E
Task F
Task G
Finish
Days:
[42]
O
M
P
Duration
(Enter one ID per cell)
(min)
(most likely)
(max)
(exp. time)
6
9
7
10
7
8
8
0.00
4.00
5.67
5.33
6.67
5.33
5.00
5.33
0.00
10
10
20
20
30
50
60
70
0
Triangular
Predecessors
2
3
4
4
4
3
3
40
4
5
5
6
5
4
5
80
5
10
ES
EF
LS
LF
Slack
0.00
0.00
0.00
4.00
4.00
9.33
10.67
14.67
20.00
0.00
4.00
5.67
9.33
10.67
14.67
15.67
20.00
20.00
0.00
0.00
3.67
4.00
8.33
9.33
15.00
14.67
20.00
0.00
4.00
9.33
9.33
15.00
14.67
20.00
20.00
20.00
0.00
0.00
3.67
0.00
4.33
0.00
4.33
0.00
0.00
15
Start
20
ES
Critical
25
Flexible
Events
Task A
Task B
Task C
Task D
Task E
Task F
Task G
Finish
Weeks:
0
1
2
3
4
5
http://www.vertex42.com/ExcelTemplates/critical-path-method.html
Holidays to Exclude from Working Days
See help (F1) on the WORKDAY() function
This worksheet lets you create a list of dates to be excluded
from the number of Working Days. The WORKDAY() function
already excludes weekends, so you only need to list dates for
holidays and other non-working days. If your project spans more
than one year, make sure you add dates for each year. The
named range, holidays, is a dynamic named range ending at the
last blank cell in column A. The comments column is just for
your reference.
Date
Non-Working Days
1/1/2009 New Year’s Day
1/1/2011
12/25/2009 Christmas
12/25/2010
Critical Path Method
By Vertex42.com
http://www.vertex42.com/ExcelTemplates/critical-path-method.html
© 2010-2023 Vertex42 LLC
This spreadsheet, including all worksheets and associated content is a
copyrighted work under the United States and other copyright laws.
Do not submit copies or modifications of this template to any website or online
template gallery.
Please review the following license agreement to learn how you may or may not
use this template. Thank you.
See License Agreement
http://www.vertex42.com/licensing/EULA_privateuse.html
Do not delete this worksheet. If necessary, you may hide it by right-clicking on
the tab and selecting Hide.
Pareto Chart
Date
Be sure to enter your own data and check your formulas.
Problem
A
B
C
D
Total
Count
50
30
15
5
100
% Cumulative %
50%
50%
30%
80%
15%
95%
5%
100%
60
100%
90%
50
80%
70%
40
60%
30
50%
40%
20
30%
20%
10
10%
0
0%
A
B
C
D
[Project Name] Project Schedule
Gantt Chart Template © 2015 by Vertex42.com.
[Company Name]
Project Lead:
Project Start Date:
Display Week:
WBS
1
1
2
3
4
5
6
7
8
9
Task
Project One
Labor Acquisition
Creation of project
Charter
Project Charter
Approval
Site Selection
Lease/purchase
Completion,
Construction
Specification
capital equipment
and furniture
specifications,
Construction
Specification
Installation of
Equipment
Final Project Closing
Prede
cessor
Lead
[Name]
[ John Doe ]
3/17/2023 (Friday)
1
Start
Fri 3/17/23
## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ######
Week 1
3 / 13 / 23
Week 2
3 / 20 / 23
Week 3
3 / 27 / 23
Week 4
4 / 3 / 23
Week 5
4 / 10 / 23
Week 6
4 / 17 / 23
Week 7
4 / 24 / 23
Week 8
5 / 1 / 23
%
Work
Cal.
Days Done Days M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S
38
29
Mon 3/20/23
4
100%
2
End
Sat 3/18/23
Thu 3/23/23
6
50%
4
Mon 3/27/23
Mon 3/27/23
Wed 3/29/23
Thu 3/30/23
3
4
75%
50%
3
4
Fri 3/31/23
Sat 4/01/23
2
50%
1
Mon 4/03/23
Wed 4/05/23
2
50%
2
Tue 4/04/23
Sat 4/08/23
5
50%
4
Sun 4/09/23
Thu 4/13/23
5
50%
4
Tue 4/11/23
Mon 4/17/23
7
50%
5
TEMPLATE ROWS
See the Help worksheet to learn how to use these rows. You can hide these rows before printing.
CATEGORY ROWS and WBS NUMBERING
1
[ Task Category (label only) ]
1.1
[ Level 2 Task ]
1.1.1
. [ Level 3 Task ]
1.1.1.1 . . [ Level 4 Task ]
Examples of ways to define the Start, End, and Duration of tasks
1
[ Task Category (summary) ]
Sun 3/01/15
Sun 3/01/15
1
0
2
Milestone
Sun 3/01/15
Sun 3/01/15
2.1
[ Start Date and Calendar Days ]
Sat 1/00/00
0
2.2
[ Start Date and End Date ]
0
0
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
