Lab4_Salonis_Paper
.docx
keyboard_arrow_up
School
University of Louisiana, Lafayette *
*We aren’t endorsed by this school
Course
1020B
Subject
Business
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by emarielaver
Stefanie Salonis
BIAM500 – January 2019
Professor Walker
Lab4: Developing a KPI Dashboard
Developing a KPI Dashboard
Scenario / Summary:
Adventure Works Cycles manufactures and sells metal and composite bicycles and related products in North America, Europe, and Asia. Adventure Works operates a call center that responds to customers who call to place orders over the phone, request technical support with products, or deal with issues such as warranty claims, products damaged in shipment, or billing errors. For its upcoming fiscal year, Adventure Works has established a strategic objective of improving the level of customer service provided by the call center. Strategic goals and associated key performance indicators (KPIs) that managers established to support this objective include the following:
KPI
Goal
Call Abandonment Rate
Reduce call abandonment rate to 5% by end of fiscal year.
Calls Handled by Automated Response System
Have at least 65% of calls handled by auto response by end of fiscal year.
Findings
–
Call Center Key Metrics Dashboard
:
Summary of key metrics with call numbers, trend lines, abandon rate with traffic light status indicator,
and orders for all shifts and each shift individually
For abandon rate, Adventure Works has set a goal of 5% or less. The first dashboard monitors performance versus the abandon rate goals. A rate of abandoned calls greater than 10% is extremely
Stefanie Salonis
BIAM500 – January 2019
Professor Walker
Lab4: Developing a KPI Dashboard
bad. The red
icon shows abandon rates of 5% to 10% which are not great. The yellow
icon shows values greater than or equal to 0.05% but less than 5%. The green
icon shows values less than or equal to 0.05, which is good. The dashboard currently shows AM / PM1 shifts with an abandoned rate greater than 9.5
% and PM2 / Midnight shifts with an abandoned rate greater than 10
%.
Calls Handled by Auto Response Dashboard
:
Column chart for percent of calls handled by auto response, including target line and slicers for day type and date
The second dashboard monitors the percentage of calls handled by the auto response system. The clustered column line chart shows the actual data as columns and the target as a line. Calls handled by auto response for Weekdays in November 2016
:
First week, Midnight (55%) and PM1 (61%) shifts failed to meet their goal of 65%
Second week, PM1 (60%) shift failed to meet its goal
Third week, PM2 (64%) shift failed to meet its goal
Fourth week, all shifts exceeded 65%
Calls handled by auto response for Weekends in November 2016
:
All shifts exceeded 65%
Calls handled by auto response for Holiday in November 2016
:
All shifts excluding PM2 (63%) shift exceeded 65%
Recommended Actions for Management:
Based on data, AM shift met their goal of 65% for the entire month. PM1 & PM2 represent the largest volume of calls handled (64.5%). Both shifts had 2 weeks in which they failed to meet their goal. Recommendation is for Management to concentrate its initial effort on addressing both shifts to ensure compliance with its goal of 65% of calls handled by auto response by end of fiscal year. Its secondary effort should be to address the Midnight shift’s noncompliance.
Calls per Shift Dashboard
:
The third dashboard monitors the number of calls handled per shift which coincides with data from the second chart. 87% of calls were originated from AM, PM1 and PM2 shifts as to be expected due to daytime hours. Recommended actions from Management, as mentioned above, would be to ensure compliance with the 65% goal.
Total Operators Available per Shift Dashboard
:
The fourth dashboard monitors the total number of operators available per shift. As the bulk of calls come in during AM, PM1 and PM2 shifts, the majority of operators are on-call during those shifts. Therefore, recommendation is for management to assess the call handling procedures and initial reply given during auto response to ensure that customer inquiries are adequately addressed so as not to be escalated to live operators.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Sun TV sells TV sets. It does not sell smart TVs so customers do not come to Sun TV if they want to purchase
smart TVs. Sun TV wants to start selling smart TVs and will only sell smart TVs to customers to whom they
advertise. Managers use customer information (income level, previous purchase history) to decide which
customers they should target. The team needs to decide how sure it must be in predicting customer interest in
a smart TV. If it is too cautious, it will choose a very high cutoff probability and only market to customers who
it believes are very likely to be in the market for a smart TV. This may cause them to miss out on many customers.
If they are too aggressive and choose a low cutoff probability, they may identify more individuals interested in
buying smart TVs but also end up wasting marketing dollars on customers who are not interested in purchasing
smart TVs. To choose a cutoff probability, the team develops the confusion matrices below for two cutoff
probabilities on…
arrow_forward
Are my formulas correct and did I get the correct answer?
Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20.
a. Determine how Sunblessed can maximize its profit.
arrow_forward
Scenario 3:
Kohl’s Department Store has experienced steady growth in every department over the past decade. Sales and market share continue to grow but Kohl’s wants to know the level of customer satisfaction among its existing target market. In addition, the company would like to know how to continue to expand sales over the upcoming decade and would like to know how they could better serve customers within their stores and online.
Using any form of a Likert scale, create a questionnaire with a minimum of 10 questions that Kohl’s current customers could answer:
arrow_forward
An auditor used regression analysis to evaluate the relationship between utility costs andmachine hours. The following information was developed using a computer softwareprogram:
Intercept 2,050
Standard error of estimate 200Regression 0.825
Number of observations 36Correlation coefficient 0.800
How much is the utility cost if the company’s 10 machines will use 2,400 hours next month?a. ₱3,830b. ₱3,970c. ₱4,030d. ₱4,050
arrow_forward
write Each variable in the table below has a corresponding indicator (measurement) from the literature?
Nb: independent variable:awareness,convenience and benifit, transection mode of online,preventive management
dependent variable: cybercrime, development of ecommerce
arrow_forward
A plastic injection molding machine operates 334 days a year. It is the bottleneck workstation in a process that produces plastic housed wall clocks.
Industrial engineers collected data on the probability of machine breakdowns, the costs of preventive maintenance, and the cost of a breakdown.
Number of Molding
Machine Breakdowns
per Day
Probability of a
breakdown
0
0.32
1
0.27
2
0.22
3
0.13
4
0.06
The cost of preventive maintenance is high due to performing it between 1 and 4 a.m. each day by two machine experts. The preventive
maintenance cost is $2,030 per day including replacement parts, cleaning, and software upgrades. The cost of a breakdown of $1,940 is also high
because the downstream workstations can only work until all work-in-progress inventory is completed; then the entire process must stop. What are
the economics of the situation? Do not round intermediate calculations. Round your answers to the nearest cent.
The expected cost of a breakdown per day is $
The manufacturing…
arrow_forward
1. Discuss how your client may determine the customer cost for its service, including non-monetary costs (time, effort, and perceived risk)
When considering Customer Cost, we need to understand the perceived cost of its customer’s. From a customer’s point of view, the costs involved in buying and using a service is only part of the price charged by the supplier. Related monetary and non-monetary costs make up the other costs of the service.
Time Office Automation may determine their Customer Cost for its service, including monetary and non-monetary costs, depending on various factors such as:
The time taken to perform the service.
The costs of the parts used / needed.
Labour Costs.
The costs their competitors are charging, to provide a competitive rate.
A call out fee, time, and money (for fuel, etc) used to drive to the customers location.
Cost of shipping.
Quality of service, Time Office Automation’s staff has more than 25 years of experience in the field, therefore, could…
arrow_forward
Problem 2: Customer complaints
Each question in this problem (Q5-Q8) consists of a customer complaint. From the options below, indicate which dimension of customer utility each complaint relates to.
Ease of use
Timing
Fit
Convenience
Durability
Location
Affordability
Performance
Reliability
Aesthetics
Question 5
“I had to spend 27 minutes on hold before talking to an agent”.
Question 6
“This car is not fuel efficient at all."
Question 7
“When I needed a restroom in the amusement park, I had to walk almost a mile."
Question 8
“I had this suit tailored for me, but now I realize that the shoulders are too wide."
arrow_forward
Quality Foods Case
Quality Foods, Inc. first started as a single family operated restaurant in southern New Jersey providing high quality meals at reasonable prices and using fresh local ingredients. The business grew and Quality Foods expanded to operating multiple restaurants. The restaurant business is very competitive and Quality Foods’ competition included McDonald’s, SmashBurger and Chipotle’s.
Besides quality and price, Quality Foods management also ascertains that the speed of service is critical to the success of their company. Based on preliminary observations, they found that their service delivery times were lacking when compared to their main competitors. From their studies, it appears that their restaurants provided slower and erratic service, when compared to their competitors. In order to identify and correct this potential problem, top management used various control tools such as check sheets, fishbone charts, Pareto charts, statistical process control and…
arrow_forward
give details calculation
arrow_forward
Q/ Talk in details about : Attendance
management in school problem,
Make a virtual system to solve this
problem using one of the MIS
topics, and explain the topic and the
method used to solve this problem
arrow_forward
Please forecast the mileage for 2013 using the Naive method.
arrow_forward
Chart and Regression analysis :
What does the intercept predict?
X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day)
Equation: y=2.9x + 14.5
Slope:2.9
Intercept:14.5
Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?
arrow_forward
The following gives the number of accidents thatoccurred on Florida State Highway 101 during the past 4 months:
Forecast the number of accidents that will occur in May,using least-squares regression to derive a trend equation.
arrow_forward
Please forecast the mileage (in 100) for 2013 using a 4 period moving average method. Please keep 1 decimal place.
arrow_forward
How is moving average approach related to exponential smoothing?
arrow_forward
Please answer this problem
arrow_forward
Forecasting Ticket Revenue for Orlando Magic Basketball Games For its first two decades of existence, the NBA’s Orlando Magic basketball team set seat prices for its 41- game home schedule the same for each game. If a lower-deck seat sold for $150, that was the price charged, regardless of the opponent, day of the week, or time of the season. If an upper-deck seat sold for $10 in the first game of the year, it likewise sold for $10 for every game. But when Anthony Perez, director of business strategy, finished his MBA at the University of Florida, he developed a valuable database of ticket sales. Analysis of the data led him to build a forecasting model he hoped would increase ticket revenue. Perez hypothesized that selling a ticket for similar seats should differ based on demand. Studying individual sales of Magic tickets on the open Stub Hub marketplace during the prior season. Perez determined the additional potential sales revenue the Magic could have made had they charged prices…
arrow_forward
do fast
arrow_forward
How would you go about calculating the likelihood of a "super-event" or a "unique event?" What variables would you take into account ?
arrow_forward
The manager of a local restaurant “RRR” asks you to improve the existing “online food ordering system” with an additional function. It is desired that the new function informs the customer about the approximate time needed to deliver the foods after customer submits the order via the website of “RRR”.
If you plan to prepare an online questionnaire for the customers that they may fill on theweb site of “RRR”
Write 2 questions that you may use nominal scale and 2 questions that you may useinterval scale.
arrow_forward
Estimating a cost function, high-low method. Lacy Dallas is examining customer-service costs in the southern region of Camilla Products. Camilla Products has more than 200 separate electrical products that are sold with a 6-month guarantee of full repair or replacement with a new product. When a product is returned by a customer, a service report is prepared. This service report includes details of the problem and the time and cost of resolving the problem. Weekly data for the most recent 8-week period are as follows:
Plot the relationship between customer-service costs and number of service reports. Is the relationship economically plausible?
Use the high-low method to compute the cost function relating customer-service costs to the number of service reports.
What variables, in addition to number of service reports, might be cost drivers of weekly customer-service costs of Camilla Products?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Sun TV sells TV sets. It does not sell smart TVs so customers do not come to Sun TV if they want to purchase smart TVs. Sun TV wants to start selling smart TVs and will only sell smart TVs to customers to whom they advertise. Managers use customer information (income level, previous purchase history) to decide which customers they should target. The team needs to decide how sure it must be in predicting customer interest in a smart TV. If it is too cautious, it will choose a very high cutoff probability and only market to customers who it believes are very likely to be in the market for a smart TV. This may cause them to miss out on many customers. If they are too aggressive and choose a low cutoff probability, they may identify more individuals interested in buying smart TVs but also end up wasting marketing dollars on customers who are not interested in purchasing smart TVs. To choose a cutoff probability, the team develops the confusion matrices below for two cutoff probabilities on…arrow_forwardAre my formulas correct and did I get the correct answer? Question: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20. a. Determine how Sunblessed can maximize its profit.arrow_forwardScenario 3: Kohl’s Department Store has experienced steady growth in every department over the past decade. Sales and market share continue to grow but Kohl’s wants to know the level of customer satisfaction among its existing target market. In addition, the company would like to know how to continue to expand sales over the upcoming decade and would like to know how they could better serve customers within their stores and online. Using any form of a Likert scale, create a questionnaire with a minimum of 10 questions that Kohl’s current customers could answer:arrow_forward
- An auditor used regression analysis to evaluate the relationship between utility costs andmachine hours. The following information was developed using a computer softwareprogram: Intercept 2,050 Standard error of estimate 200Regression 0.825 Number of observations 36Correlation coefficient 0.800 How much is the utility cost if the company’s 10 machines will use 2,400 hours next month?a. ₱3,830b. ₱3,970c. ₱4,030d. ₱4,050arrow_forwardwrite Each variable in the table below has a corresponding indicator (measurement) from the literature? Nb: independent variable:awareness,convenience and benifit, transection mode of online,preventive management dependent variable: cybercrime, development of ecommercearrow_forwardA plastic injection molding machine operates 334 days a year. It is the bottleneck workstation in a process that produces plastic housed wall clocks. Industrial engineers collected data on the probability of machine breakdowns, the costs of preventive maintenance, and the cost of a breakdown. Number of Molding Machine Breakdowns per Day Probability of a breakdown 0 0.32 1 0.27 2 0.22 3 0.13 4 0.06 The cost of preventive maintenance is high due to performing it between 1 and 4 a.m. each day by two machine experts. The preventive maintenance cost is $2,030 per day including replacement parts, cleaning, and software upgrades. The cost of a breakdown of $1,940 is also high because the downstream workstations can only work until all work-in-progress inventory is completed; then the entire process must stop. What are the economics of the situation? Do not round intermediate calculations. Round your answers to the nearest cent. The expected cost of a breakdown per day is $ The manufacturing…arrow_forward
- 1. Discuss how your client may determine the customer cost for its service, including non-monetary costs (time, effort, and perceived risk) When considering Customer Cost, we need to understand the perceived cost of its customer’s. From a customer’s point of view, the costs involved in buying and using a service is only part of the price charged by the supplier. Related monetary and non-monetary costs make up the other costs of the service. Time Office Automation may determine their Customer Cost for its service, including monetary and non-monetary costs, depending on various factors such as: The time taken to perform the service. The costs of the parts used / needed. Labour Costs. The costs their competitors are charging, to provide a competitive rate. A call out fee, time, and money (for fuel, etc) used to drive to the customers location. Cost of shipping. Quality of service, Time Office Automation’s staff has more than 25 years of experience in the field, therefore, could…arrow_forwardProblem 2: Customer complaints Each question in this problem (Q5-Q8) consists of a customer complaint. From the options below, indicate which dimension of customer utility each complaint relates to. Ease of use Timing Fit Convenience Durability Location Affordability Performance Reliability Aesthetics Question 5 “I had to spend 27 minutes on hold before talking to an agent”. Question 6 “This car is not fuel efficient at all." Question 7 “When I needed a restroom in the amusement park, I had to walk almost a mile." Question 8 “I had this suit tailored for me, but now I realize that the shoulders are too wide."arrow_forwardQuality Foods Case Quality Foods, Inc. first started as a single family operated restaurant in southern New Jersey providing high quality meals at reasonable prices and using fresh local ingredients. The business grew and Quality Foods expanded to operating multiple restaurants. The restaurant business is very competitive and Quality Foods’ competition included McDonald’s, SmashBurger and Chipotle’s. Besides quality and price, Quality Foods management also ascertains that the speed of service is critical to the success of their company. Based on preliminary observations, they found that their service delivery times were lacking when compared to their main competitors. From their studies, it appears that their restaurants provided slower and erratic service, when compared to their competitors. In order to identify and correct this potential problem, top management used various control tools such as check sheets, fishbone charts, Pareto charts, statistical process control and…arrow_forward
- give details calculationarrow_forwardQ/ Talk in details about : Attendance management in school problem, Make a virtual system to solve this problem using one of the MIS topics, and explain the topic and the method used to solve this problemarrow_forwardPlease forecast the mileage for 2013 using the Naive method.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you