EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 20PE
Create a useful dashboard for the data in the Excel file Store and Regional Sales Database. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explain why you chose the elements of the dashboard and how a manager might use them.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Sales Planning and Forecasting:
In a manufacturing & distribution company
a. how often sales forecast is completed?
b. how well is the sales-forecasting plan used in the day to day operations?
c. what are some of the sales forecasting tools that could be used?
Which type of analytics is used to know the effect of product price on sales.
OA) predictive
OB) forecast
C) prescriptive
D) descriptive
You manager gave you February 2021 actual sales and sales forecast. This is the only raw data you have access to.
Which of the following is the most appropriate technique for forecasting March 2021's sales?
a.Simple moving average
b.Exponential smoothing
c.Causal relationship forecasting
d.Simple linear regression
e.Weighted moving average
Chapter 3 Solutions
EBK BUSINESS ANALYTICS
Ch. 3 - Prob. 2PECh. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - Create a stacked area chart contrasting primary...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - The Excel file Facebook Survey provides data...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...
Ch. 3 - A marketing researcher surveyed 92 individuals,...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, apply...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...Ch. 3 - Create a useful dashboard for the data in the...
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
- What is one of the biggest challenges to overcome in new product forecasting? a. Selecting the best Quantitative forecasting method. B. Determining which product life cycle is appropriate. C. Lack of Historical Data D. Identifying Supply Chain Participantsarrow_forwardHow many columns had to be selected to create this chart? Product Line - Units Sold This year Last year Product A Product B Product C Product D 200 400 600 800 1000 1200 O 3: 1 column of labels and 2 columns of data O 2: one column of labels and one column of data O 4: 2 columns of labels and 2 columns of data O 1: all labels and data were in the same columnarrow_forwardfour techniques used for forecasting sales (market researchers, delphi technique, trend analysis, and econometric models) were introduced. What are some factors when preparing a sales forecast that would lead you to rely on one or two of these techniques more than the others? Support your choice with evidence.arrow_forward
- Sales Forecast 1. what is a sales forecast? a. In a manufacturing and distribution company how often shoud the sales forecast be completed?arrow_forwardPart 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Part 1 a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 09/17/2010 09/20/2010 09/21/2010 Date A B C D Stock Exchange09/03/2010 128.82 18.38 21.22 15.37 10,462.5509/07/2010 124.78 18.27 20.54 15.54 10,262.8409/08/2010 126.03 17.86 20.68 15.77 10,351.6809/09/2010 125.91 17.98 20.43 15.99 10,319.1309/10/2010 126.87 17.87…arrow_forwardDescribe the steps used to develop a forecasting system.arrow_forward
- 2.1 Compare and contrast between the grassroots forecasting technique and the Delphi method. 2.2 Explain integrated service providers in logistics managementarrow_forwardForecasts and actual sales of digital music players at Just Say Music are as follows: Month Forecast Actual Sales March 150 170 April 207 214 May 202 190 June 265 247 July 268 242 August 250 210 September 285 240 October 267 192 What is the forecast for November, using a two-period moving average? Round your answer to two decimal places. What is the forecast for November, using a three-period moving average? Round your answer to two decimal places. Compute MSE for the two- and three-period moving average models and compare your results. Do not round intermediate calculations. Round your answers to two decimal places.arrow_forwardDescribe the concept of predictive analytics in CRM. How can it be utilized to forecast customer behavior and trends?arrow_forward
- Why forecasting is important for Airlines industry? What are the impacts ofCovid-19 on forecasting of this industry?arrow_forward4.4 A check-processing center uses exponential smooth- ing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- cast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July? b) If the center received 45 million checks in July, what would be the forecast for August? c) Why might this be an inappropriate forecasting method for this situation? Px .. 4.5 The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the antici- pated mileage to be driven next year. The miles driven during the past 5 years are as follows: YEAR 1 2 3 4 5 a) Forecast the mileage for next year (6th year) using a 2-year moving average. b) Find the MAD based on the 2-year moving average. (Hint: You will have only 3 years of matched data.) c) Use a weighted 2-year moving average with weights of 4 and .6 to forecast next year's mileage. (The weight of .6 is for the most…arrow_forwardSmart Phone covers sales for the past 12 months is given below. Management forecast's for the months of March, April, May, and June are listed Month Unit Sales Management's Forecast Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 100 95 95 112 126 118 95 85 101 94 89 110 122 114 108 112 a) What is the MAD for the forecast developed by management sales (round your response to two decimal places) What in the MAPE for the forecast developed by management % (round your response to two decimal places). %3Darrow_forward
arrow_back_ios
arrow_forward_ios
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY