Management homework

SWU Data

Overall Grade
		A-C	%A-C	A	B	C	D	F
Game Day	Parking	50	7%	90	105	45	5	5		1. Create Pareto chart to analyze data of game day SUCCESS.
	Traffic	63	16%	50	85	48	52	15		2. Insert two columns to left of column C.
	Seating	150	36%	35	30	115	35	35		3. Label new column C: C-F
	Entertainment	45	42%	160	35	26	10	19		4. Label new column D: Cum. % C-F
	Printed Program	134	61%	60	34	104	22	30		5. In the column you labeled C-F sum the grades C-F for rows 3-12.
Tickets	Pricing	26	64%	105	104	16	15	10		6. In the column you labeled Cum. % C-F, calculate the cumulative percentage of C-F.
	Season Ticket Plans	54	72%	75	80	54	41	0		7. Create a Pareto Chart of C-F and Cum. % C-F. Label it Pareto Game Day Success.
Concessions	Prices	60	80%	16	116	58	58	2		8. Comment on areas of focus.
	Selection of Foods	24	83%	155	60	24	11	0
	Speed of Service	122	100%	35	45	46	48	76
		728
	The president has received complaints about the game day experience at SWU. The VP has collected data, both numerical and open-ended data. Respond to the president by using three tools - Pareto for numerical SWU data and for open-ended survey data,
	check sheet for open-ended data on Survey Cards, and a Cause-and-Effect Diagram analysis.

Survey Cards

Survey Cards - Fan Satisfaction Data Check Sheet
Category	Mentioned	Cum % - Mentioned	1. Create a check sheet by categorizng the Open-Ended Comments on the Survey Cards
Food	5	0.11	2. Create a Pareto chart of the check sheet data with descending frequency bar chart and cumulative percentage.
Parking	7	0.26	3. Identify possible categories for further focus.
Seating	16	0.61	4. Organize your data on the cause and effect diagram template and add other causes as appropriate (e.g., appropriate measures, likely environmental issues, relevant processes, etc.). Make sure you include an appropriate effect.
Skybox	7	0.76
Stadium Old	3	0.83
Student Behavior	4	0.91
Toilets	2	0.96
Traffic	2	1
	46
Open Ended Comments on Survey Cards (Heizer and Render, Pearson, p. 239)
Parking a mess	More hot dog stands	Put in bigger seats	My company will buy a skybox - build it!
Add a skybox	Seats all metal	Friendly ushers	Programs overpriced
Get better cheerleaders	Need skyboxes	Need better seats	Want softer seats
Double parking attendants	Seats stink	Expand parking lots	Beat thos longhorns
Everything okay	Go SWU!	Hate bleacher seats	I'll pay for skybox
Too crowded	Lines are awful	Hot dogs cold	Seats too small
Seats too narrow	Seats are uncomfortable	$3 for coffee? No way!	Band was terrific					Survey D-F
Great food	I will pay for better view	Get some skyboxes	Love Phil Flamm
Phil F. for President	Get new stadium	Love new unis	Everything is great
I smelled drugs	Student dress code needed	Took an hour to park	Build new stadium
Stadium ancient	I want cushioned seats	Coach is terrific	Move games to Dallas
Seats like rocks	Not enough police	More water fountains	No complaints
Not enough traffic cops	Students too rowdy	Better seats	Dirty bathroom
Game stars late	Parking terrible	Seats not comfy	Seats are not clean
Hire more traffic cops	Toilets weren't clean	Bigger parking lot	Seats are cold
Need new band	Not enough handicap spots in lot	Too old for bench seats	I CAN'T FIND A PARKING SPACE!!!
Great!	Well done, SWU	Cold coffee served at game
	Pareto Chart Below Here

People

Materials

Measurements

Environment

Facilities

Processes

Effect

Other Venues

Parking space

Food price

Seat Pithc

Cleaning Supplies

Cause

Programs

Tix

Food

Traffic cops

Parking Attendante

Vendors

Maintenance

Cause

Traffic Management

Cause

Parking lot

Toilet Maintenance

Cause

Queueing

Cause

League

Seating

Stadium

weather

Myself

Blank