EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 1, Problem 3PE
A supermarket has been experiencing long lines during peak periods of the day. The problem is notice ably worse on certain days of the week, and the peak periods sometimes differ according to the day of the week. There are usually enough workers on the job to open all cash registers. The problem the supermarket manager faces is knowing when to call some of the workers who are stocking shelves up to the front to work the checkout counters. How might business analytics help the supermarket manager? What data would be needed to facilitate good decisions?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The role of forecasting in ensuring proper management of customer orders
Spring 2019 Credit Card Products Collections DFD
At Columbia Southern Bank, credit card accounts are booked and serviced at Individualized BankCard Services(IBS). If such accounts become delinquent, their information is sent to the collection system via the IBS FILE (see appendix D). This file is sent to the collection system on a daily basis. Besides being used to update the collection history database it is used to generate the IBS new accounts report.
Recall that the predictive dialer software is used as part of the collection process. It involves using packaged software to contact delinquent borrowers. Using a file of telephone and account numbers the software takes into consideration how many collection agents are working at the given time and paces the calls accordingly. This will assure that an agent will be available to take the call if a delinquent customer answers the telephone when the dialer places the call.
When a customer answers the…
The director of the Riley County, Kansas, library system would like to forecast evening patron usage for next week. Below are the data for the past 4 weeks:
Mon
Tue
Wed
Thu
Fri
Sat
Week 1
210
178
250
215
160
180
Week 2
215
180
250
213
165
185
Week 3
220
176
260
220
175
190
Week 4
225
178
260
225
176
190
a) Calculate a seasonal index for each day of the week (enter your responses rounded to three decimal places).
Day of the week
Mon
Tue
Wed
Thu
Fri
Sat
Seasonal index
Chapter 1 Solutions
EBK BUSINESS ANALYTICS
Ch. 1 - Discuss how you might use business analytics in...Ch. 1 - How might analytics be used in the following...Ch. 1 - A supermarket has been experiencing long lines...Ch. 1 - For each of the following scenarios, state whether...Ch. 1 - Suppose that a manufacturer can produce a part for...Ch. 1 - A bank developed a model for predicting the...Ch. 1 - Four key marketing decision options are price P,...Ch. 1 - Total marketing effort is a term used to describe...Ch. 1 - A manufacturer of headphones is preparing to set...Ch. 1 - In this chapter, we noted the importance of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- The 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_forwardA restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are shown in this Excel file (also shown in Problem 6 on page 243 in the textbook). Answer the following questions related to this information: What is the MSE for the two- and three-period moving average models? Compare the results. Find the best number of periods for the moving average model based on MSE.arrow_forwardThe Holt method (exponential smoothing with trend andwithout seasonality) is being used to forecast weekly carsales at TOD Ford. Currently, the base is estimated to be 50cars per week, and the trend is estimated to be 6 cars perweek. During the current week, 30 cars are sold. Afterobserving the current week’s sales, forecast the number ofcars to be sold during the week that begins three weeks afterthe conclusion of the current week. Use a b 0.3.arrow_forward
- With this regard, critically examine the role of forecasting in ensuring proper management of customer ordersarrow_forwardThe American Baker's Association reports that annual sales of bakery goods last year rose 15 percent, driven by a 50 percent increase in the demand for bran muffins. Most of the increase was attributed to a report that diets rich in bran help prevent certain types of cancer. You are the manager of a bakery that produces and packages gourmet bran muffins, and you currently sell bran muffins in packages of three. However, as a result of this new report, a typical consumer's inverse demand for your bran muffins is now P= 11 -15Q If your cost of producing bran muffins is C(Q) = 3.5Q, determine the optimal number of bran muffins to sell in a single package and the optimal package price. Instructions: Enter your response for the optimal package price rounded to two decimal places. Optimal package size: Optimal package price: $ unitsarrow_forwardLori Cook has developed the following forecasting modaly = 36 + 4.3xwhere y = demand for Kool Air conditioners and X= the outside temperature (F)° a) Forecast demand for the Kool Air when the temperature is 70° F.b) What is demand when the temperature is 80° F?c) What is demand when the temperature is 90° F?arrow_forward
- Since economic and technological forecasts are beyond the expertise of an operations manager, he should not be concerned about them anymore. True Falsearrow_forwardState the impacts of covid -19 on forecasting of airline industry ?arrow_forwardPatxiko just opened his website, where he sells his Patxaran online. His websites gatheres all kinds of data from customers navigation (time spent on each page, how long the customer has products in his cart before purchasing, what he purchased, etc). He is trying to optimize the website to increase the probability of a purchase. First, he wants to predict whether a customer will purchase or not. What model would you advise him to use? Suggest two methods and explain how one of them works.arrow_forward
- What are some of the common Business Statistics used in Excell for Hospitality Management?arrow_forward3. Attendance at Los Angeles' newest Disney like attraction, Vacation World has been as follows: Quarter Guests Quarter Guests (in Thousands) (in Thousands) 2017 Q1 73 Q3 124 Q2 104 Q4 52 Q3 168 2019 Q1 89 Q4 74 Q2 146 2018 Q1 65 Q3 205 Q2 82 Q4 98 a. Graph the data. (Use Excel) b. Compute seasonal indices using all the data. (Solve manually)arrow_forwardWhat type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible? domain predictive prescriptive descriptive What does the robustness of a data mining method refer to? its ability to construct a prediction model efficiently given a large amount of data its speed of computation and computational costs in using the mode its ability to overcome noisy data to make somewhat accurate predictions its ability to predict the outcome of a previously unknown data set accuratelyarrow_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,
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY