Improving Supply Chain Management at St. Mary's Hospital: An Analysis

This project proposal investigates the impact of supply chain management in the logistics area on the employees of St. Mary's Hospital. The research addresses the importance of effective supply chain management in healthcare to improve customer service and address operational inefficiencies. The study highlights the need for improvement in the hospital's supply chain management, referencing poor performance in medicine and maternity sections due to service quality issues. The analysis includes frequency tables, bar charts, pie charts, and correlation matrices derived from data collected, aiming to assess employee satisfaction and identify areas for enhancement within the hospital's supply chain processes. The project seeks to understand how different aspects of supply chain management, such as transparency, cost suppression, and supplier relationships, correlate with employee perceptions and overall service quality.

GET DATA /TYPE=XLSX
/FILE='E:\New folder (3)\Book1.xlsx'
/SHEET=name 'Sheet1'
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
EXECUTE.
DATASET NAME DataSet1 WINDOW=FRONT.
FREQUENCIES VARIABLES=Whatisyourgenderspecification
Whichagegroupdoyoubelongto HowlonghaveyoubeenworkingatStMary’sHospital
Whatisyourmonthlysalary£
Areyouawareofthesupplychainmanagementandlogisticsworkthatisunder
/BARCHART FREQ
/ORDER=ANALYSIS.
Frequencies
Notes
Output Created 10-APR-2019 14:33:20
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data
File
30
Missing Value Handling Definition of Missing User-defined missing values
are treated as missing.
Cases Used Statistics are based on all
cases with valid data.

Syntax FREQUENCIES
VARIABLES=Whatisyourgen
derspecification
Whichagegroupdoyoubelongt
o
Howlonghaveyoubeenworkin
gatStMary’sHospital
Whatisyourmonthlysalary£
Areyouawareofthesupplychai
nmanagementandlogisticswo
rkthatisunder
/BARCHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:04.06
Elapsed Time 00:00:05.84
[DataSet1]
Statistics
What is your
gender
specification?
Which age
group do you
belong to?
How long have
you been
working at St
Mary’s Hospital?
What is your
monthly salary
(£)?
Are you aware
of the supply
chain
management
and logistics
work that is
undertaken in
the hospital?
N Valid 30 30 30 30 30
Missing 0 0 0 0 0
Frequency Table
What is your gender specification?

Frequency Percent Valid Percent
Cumulative
Percent
Valid Male 17 56.7 56.7 56.7
Female 13 43.3 43.3 100.0
Total 30 100.0 100.0
Which age group do you belong to?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 20-30 years 9 30.0 30.0 30.0
31-40 years 13 43.3 43.3 73.3
41 years and above 8 26.7 26.7 100.0
Total 30 100.0 100.0
How long have you been working at St Mary’s Hospital?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 2-5 years 11 36.7 36.7 36.7
6-9 years 12 40.0 40.0 76.7
10 years and above 7 23.3 23.3 100.0
Total 30 100.0 100.0
What is your monthly salary (£)?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 10,000-20,000 9 30.0 30.0 30.0
21,000-41,000 10 33.3 33.3 63.3
42,000-62,000 9 30.0 30.0 93.3
63,000 and above 2 6.7 6.7 100.0
Total 30 100.0 100.0
Are you aware of the supply chain management and logistics work that is
undertaken in the hospital?

Frequency Percent Valid Percent
Cumulative
Percent
Valid Yes 12 40.0 40.0 40.0
No 16 53.3 53.3 93.3
Maybe 2 6.7 6.7 100.0
Total 30 100.0 100.0
Bar Chart

FREQUENCIES VARIABLES=Whatisyourgenderspecification
Whichagegroupdoyoubelongto HowlonghaveyoubeenworkingatStMary’sHospital
Whatisyourmonthlysalary£
Areyouawareofthesupplychainmanagementandlogisticsworkthatisunder
/PIECHART FREQ
/ORDER=ANALYSIS.
Frequencies
Notes
Output Created 10-APR-2019 14:34:26
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>

Split File <none>
N of Rows in Working Data
File
30
Missing Value Handling Definition of Missing User-defined missing values
are treated as missing.
Cases Used Statistics are based on all
cases with valid data.
Syntax FREQUENCIES
VARIABLES=Whatisyourgen
derspecification
Whichagegroupdoyoubelongt
o
Howlonghaveyoubeenworkin
gatStMary’sHospital
Whatisyourmonthlysalary£
Areyouawareofthesupplychai
nmanagementandlogisticswo
rkthatisunder
/PIECHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:02.70
Elapsed Time 00:00:03.66
[DataSet1]
Statistics
What is your
gender
specification?
Which age
group do you
belong to?
How long have
you been
working at St
Mary’s Hospital?
What is your
monthly salary
(£)?
Are you aware
of the supply
chain
management
and logistics
work that is
undertaken in
the hospital?
N Valid 30 30 30 30 30
Missing 0 0 0 0 0

Frequency Table
What is your gender specification?
Frequency Percent Valid Percent
Cumulative
Percent
Valid Male 17 56.7 56.7 56.7
Female 13 43.3 43.3 100.0
Total 30 100.0 100.0
Which age group do you belong to?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 20-30 years 9 30.0 30.0 30.0
31-40 years 13 43.3 43.3 73.3
41 years and above 8 26.7 26.7 100.0
Total 30 100.0 100.0
How long have you been working at St Mary’s Hospital?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 2-5 years 11 36.7 36.7 36.7
6-9 years 12 40.0 40.0 76.7
10 years and above 7 23.3 23.3 100.0
Total 30 100.0 100.0
What is your monthly salary (£)?
Frequency Percent Valid Percent
Cumulative
Percent
Valid 10,000-20,000 9 30.0 30.0 30.0
21,000-41,000 10 33.3 33.3 63.3
42,000-62,000 9 30.0 30.0 93.3
63,000 and above 2 6.7 6.7 100.0
Total 30 100.0 100.0

Are you aware of the supply chain management and logistics work that is
undertaken in the hospital?
Frequency Percent Valid Percent
Cumulative
Percent
Valid Yes 12 40.0 40.0 40.0
No 16 53.3 53.3 93.3
Maybe 2 6.7 6.7 100.0
Total 30 100.0 100.0
Pie Chart