EBK OM
6th Edition
ISBN: 9781305888210
Author: Collier
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Question
Chapter 16, Problem 2PA
Summary Introduction
Interpretation: The number of responses at each level (1 through 10) is to be counted, and the number and percentage of customers at the promoter, passive, and detractor levels are to be determined and the net promoter score (NPS) is to be calculated.
Concept Introduction: NPS (Net Promoter Score) is one of the measurement tools to growth of the company. It is calculated by the percentage of the promoters and detractors.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Since the Covid-19 outbreak, the use of sports facilities and venues has dropped significantly. You have a group of friends who are frequent visitors to a swimming pool and they are interested in understanding the impact of Covid-19 on the income of the swimming pool operator. Knowing that you have learned the knowledge related to making forecasts, your friends ask for your opinion on the following questions.
Please use relevant data in the Excel workbook Q2_input_file.xlsx in Canvas (next to this question paper) to answer the following questions.
(a) Comment on the underlying pattern in the swimming pool attendances over 2016 1Q – 2019 4Q. Please limit the answer to within one page.
(b) Use a suitable method to forecast the swimming pool attendances for every quarter between 2020 1Q and 2021 2Q, assuming that actual data in that range is not yet available. After that, combined with the actual data, estimate the income loss of the swimming pool for each quarter in that range,…
Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entrées for consumption by its clients. The entrées are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entrée will be a beef sirloin tips dinner. It will consist of beef tips and gravy, plus some combination of peas, carrots, and a dinner roll. Nutri-Jenny would like to determine what quantity of each item to include in the entrée to meet the nutritional requirements, while costing as little as possible. The nutritional information for each item and its cost are given in the table on the bottom of the preceding page.
The nutritional requirements for the entrée are as follows: (1) it must have between 280 and 320 calories, (2) calories from fat should be no more than 30 percent of the total number of calories, and (3) it must have at least 600 IUs of vitamin A, 10 milligrams of vitamin C, and 30 grams of protein. Furthermore, for practical reasons,…
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks:
Week Of
Pints Used
August 31
360
September 7
389
September 14
412
September 21
383
September 28
366
October 5
374
a) The forecasted demand for the week of October 12 using a 3-week
moving average
LOADING...
=
374.33374.33
pints (round your response to two decimal places).
b) Using a 3-week weighted moving average, with weights of
0.15,
0.35,
and
0.50,
using
0.50
for the most recent week, the forecasted demand for the week of October 12 =
372.55372.55
pints (round your response to two decimal places and
remember
to use the weights in appropriate order
—
the largest weight applies to most recent period and smallest weight applies to oldest
period.)
c) If the forecasted demand for the week of August 31 is
360
and
α
=
0.20,
using exponential smoothing,…
Knowledge Booster
Similar questions
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?arrow_forwardThe Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?arrow_forwardThe file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?arrow_forward
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.arrow_forwardThe file P14_01.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might be useful in discriminating between these two groups: gender, marital status, annual income level, and age. a. Use logistic regression to classify the consumers on the basis of these explanatory variables. How successful is it? Which variables appear to be most important in the classification? b. Consider a new customer: Male, Married, Income 42,000, Age 47. Use the logistic regression equation to estimate the probability that this customer prefers Regular. How would you classify this person?arrow_forwardThe owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?arrow_forward
- The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?arrow_forwardThe file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?arrow_forwardA regional distributor purchases discontinued appliances from various suppliers and then sells them on demand to retailers in the region. The distributor operates 5 days per week, 52 weeks per year. Only when it is open for business can orders be received. The following data are estimated for a counter-top mixer: Average daily demand 1d2 = 100 mixers Standard deviation of daily demand 1sd2 = 30 mixers Lead time 1L2 = 3 days Holding cost 1H2 = $9.40>unit>year Ordering cost 1S2 = $35>order Cycle@service level = 92 percent The distributor uses a continuous review Q system. a. What order quantity Q, and reorder point, R, should be used? b. What is the total annual cost of the system? c. If on-hand inventory is 40 units, one open order for 440 mixers is pending, and no backorders exist, should a new order be placed?arrow_forward
- Well Water Inc. wants to produce and sell a new flavored water. In order to penetrate the market, the product will have to sell at $2.00 per 12 oz. bottle. The following data has been collected: Annual sales 50,000 bottles Projected selling and administrative costs $8,000 Desired profit $70,000 The target cost per bottle is Group of answer choices $0.40. $0.44. $0.60. $0.16.arrow_forwardLifang Wu owns an automated machine shop that makes precision auto parts. He has just compiled an input —output report for the grinding work center. Period 1 2 3 4 Total Planned input 90 90 95 95 Actual input 95 95 95 95 Deviation Planned output 85 85 85 85 Actual output 85 85 80 80 Deviation Initial backlog: 35 Part 2 For the given information related to "inputs," the values for deviation and total are: The deviation in period 2 = enter your response here units (enter your response as an integer, including a minus sign if necessary). Part 3 The deviation in period 4 = enter your response here units (enter your response as an integer, including a minus sign if…arrow_forwardClips, a competitor of Staples, is a national chain that provides office supplies to small businesses. Maya, who is the store manager at the Bethesda store, is also responsible for the store’s replenishment functions. Maya is interested in establishing a standard replenishment policy for some of her steady, non-seasonal products of which paperclips is one. Paperclips sell in small boxes that contain two hundred units. Maya estimates that Clips Bethesda sells 100 boxes of paperclips in a typical week and that the purchase price for Clips per box of paperclips is $2.00. The fixed ordering cost any time an order is placed is $20. Maya also estimates a nominal holding cost of $0.10 per box per week. (a) What is the optimal order quantity for paperclips at their Bethesda store?(b) Assuming 50 weeks in a year, how many times a year should the paperclips be ordered?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,