Assume you are management in authority within an organization. You are on vacation and your boss has...

Question

Assume you are management in authority within an organization. You are on vacation and your boss has asked you for an analysis of customer complaints. The only thing you have to work with at this moment is the data presented below.Your assignment is to present to your boss your concise analysis of the available data in a single Excel file. Using the following data on the number of monthly complaints, you need to (a) construct a control chart for the number of monthly customer complaints by plotting the monthly frequency and showing the average, and the upper and lower control limits; (b) discuss what the patterns in the data suggest; (c) identify other tools that would be appropriate for use in understanding and analyzing this situation; (d) explain what action you would take, why this action (i.e., what principles support your action); and (e) discuss what additional data you would require and why. [Note: You must use Excel to calculate and construct the control chart for these data.]Your assignment must be submitted in an Excel file with comments placed within the file. You can use arrows, comments … any tools to communicate your message to your boss … You must submit a single Excel file for this assignment.
	
Document Preview: 9 PAGES TOTAL; INCLUDING TITLE & REFERENCE PAGE!!!Assume you are management in authority within an organization. You are on vacation and your boss has asked you for an analysis of customer complaints. The only thing you have to work with at this moment is the data presented below. Your assignment is to present to your boss your concise analysis of the available data in a single Excel file. Using the following data on the number of monthly complaints, you need to (a) construct a control chart for the number of monthly customer complaints by plotting the monthly frequency and showing the average, and the upper and lower control limits; (b) discuss what the patterns in the data suggest; (c) identify other tools that would be appropriate for use in understanding and analyzing this situation; (d) explain what action you would take, why this action (i.e., what principles support your action); and (e) discuss what additional data you would require and why. [Note: You must use Excel to calculate and construct the control chart for these data.] Your assignment must be submitted in an Excel file with comments placed within the file. You can use arrows, comments … any tools to communicate your message to your boss … You must submit a single Excel file for this assignment. 3-Mar653-Apr743-May373-Jun303-Jul483-Aug353-Sep313-Oct443-Nov823-Dec404-Jan474-Feb204-Mar524-Apr1354-May804-Jun424-Jul544-Aug664-Sep804-Oct634-Nov1374-Dec725-Jan1075-Feb585-Mar355-Apr525-May805-Jun785-Jul545-Aug855-Sep495-Oct965-Nov845-Dec686-Jan626-Feb556-Mar316-Apr52ASSIGNMENT 3 BROKEN DOWN IN SIMPLE STEPSAs management in authority within an organization: PROVIDE AN ANALYSIS OF CUTOMER COMPLAINTS USING THE DATA PRESENTED ABOVE.ASSIGNMENT: PRESENT A CONCISE ANALYSIS OF THE AVAILABLE DATA IN A SINGLE EXCEL FILE. USING THE FOLLOWING ABOVE DATA ON THE NUMBER OF MONTHLY COMPLAINTS:...

Robert · Accepted Answer

Assignment 3 
Running head: MANAGEMENT IN AUTHORITY                                                           1
Assignment 3: Management in Authority    
    William A Frudakis
MANAGEMENT IN AUTHORITY                                                                                   2
                       Analysis of Customer Complaints Using Presented Data (Intro)
Proper addressing of consumer complaints is an important criterion for any company to be called as successful and reputed. It is an important factor because any consumer, apart from expecting a quality product at a good price, looks for a nice after sales service so that he/she need not worry unnecessarily in case something goes wrong with his/her device. Complaints can be made through devices such a message or mail, voice call or a personal visit to the authorized center of company. To check the quality of consumer readressal system of a company a lot of factors need to be considered like the ratio of complaints made to number of complaints solved, time taken to solve a complaint.
                          Concise Analysis of Available Data in a Single Excel File
The problem statement comprises of analyzing a given sample data of consumer complaints of a given office. Control chart is an effective and widely used tool to determine whether a given industrial is in control or out of control. One of the basic criteria to use a control chart is that all the sample values must have their values nearby and must not be too far from their mean values. The common types of control charts used are X bar Chart, R chart and S chart etc. They vary in  the way the data is compared to mean, variance or standard deviation. 
.
MANAGEMENT IN AUTHORITY                                                                                   3
Using the Data on the Number of Monthly Complaints
(A) Control Chart for the Number of Monthly Complaints by Plotting the Number of Frequency and Showing the Average, and Upper and Lower Control Limits
	ANSWER
	
	average
	standard deviation
	upper control limit= avg.+3*SD
	lower control limit= avg.-3*SD
	3-Mar
	65
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Apr
	74
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-May
	37
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Jun
	30
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Jul
	48
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Aug
	35
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Sep
	31
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Oct
	44
	62.63158
	26.58532521
	142.3875546
	-17.12439667
	3-Nov
	82
	62.

Assume you are management in authority within an organization. You are on vacation and your boss has asked you for an analysis of customer complaints. The only thing you have to work with at this...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment