CS9-Data Views (Tableau)- Answer Sheet
.pdf
keyboard_arrow_up
School
University of Massachusetts, Amherst *
*We aren’t endorsed by this school
Course
350
Subject
Management
Date
Apr 3, 2024
Type
Pages
13
Uploaded by ritamdutta
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 1 of 13 Business Intelligence & Analytics C
ASE S
TUDY 9:
D
ATA V
IEWS
This assignment is to create a number of data views in Tableau Desktop and report your analytical findings based on the data views. Create data views in Tableau Desktop and report your analytical findings. Submit your answer sheet and Tableau workbook
to the Blackboard Learn by 11:59PM on Friday, April 15
th
. You will use the following Excel files for this assignment: Primary source: SuperStoreUS - Sales (2014-2017).xlsx Secondary source: SuperStoreUS- Target (2014-2017).xlsx PART
1:
S
HIPMENT A
NALYSIS
Data View 1 D1a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 2 of 13 Q1a: Which of the regions had the highest percentage of the total orders that were delayed? Which of the regions had the highest number of orders that were delayed? Explain your conclusion based on the data view. East (27.62%) had the highest percentage of the total orders that were delayed. West (429) had the highest number of orders that were delayed. Both these values were higher compared to the other regions.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 3 of 13 Q1b: Which of the regions had the best shipment records? How is the region different from the other three region in terms of the number of orders processed? Explain your conclusion based on the data view. South had the best shipment records as they had the lowest percentage of late shipments (25.43%) and the highest percentage of early shipments(50%) which clearly better than the 3 other regions. South did have significantly less numbers of orders processes compared to the other three regions. Data View 2 D2a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 4 of 13 Q2a: Is there a particular shipping method that you would recommend customers of SuperStoreUS to use more frequently? Is there any shipping method that you would NOT recommend them to use? Explain your conclusion based on the dashboard. I would recommend Same Day shipping for customers of SuperStoreUS to use more frequently as it has the least variability and is on time around 95% of the time. I would not recommend customers of SuperStoreUS to use First Class as it has high variability and also ships late very often.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 5 of 13 PART
2:
S
ALES P
ERFORMANCE M
ONITORING &
F
ORECASTING Data View 3 D3a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
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
PROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows:
Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…
arrow_forward
Question 4 (1 point)
As buyers are increasingly facing information overload, salespeople should ensure information is streamlined and
personalized.
OTrue
OFalse
Question 5 (1 point)
Blogs, white papers, webinars, and presentations should be proyided to targeted customers.
OTrue
OFalse
Question 6 (1 point)
dal fne avaluating solution alternatives uses weighted averages.
arrow_forward
Pls choose right answers no need explanation
arrow_forward
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet7
Report Created: 9/26/2020 10:43:05 AM
Engine: Standard LP/Quadratic
Objective Cell (Min)
Cell
Name
Final Value
$B$13
Obj Func AN
4135000
Decision Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$B$11
variables AN
55000
0
33
7.0000001
41.0000001
$C$11
variables AO
0
7
48
1E+30
7
$D$11
variables BN
25000
0
27
8.0000001
7.0000001
$E$11
variables BO
47000
0
35
7.0000001
8.0000001
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$B$16
LHS
55000
41
55000
10500
47000
$B$17
LHS
72000
35
72000
10500
47000
$B$18
LHS
80000
-8
80000
47000
10500
$B$19
LHS
47000
0
57500
1E+30
10500
The answers to the questions…
arrow_forward
Required information
Camp Rainbow offers overnight summer camp programs for children ages 10–14 every summer during June and
July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys
attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp,
participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and
hayrides, and help assemble toys for local underprivileged children.
The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can
accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-
site regardless of the number of campers enrolled.
Following is the cost information for Camp Rainbow's operations last summer:
Number of
Cost to Run
Campers
172
Week
Camp
$13,810
9,350
11,360
14,380
14,000
12,440
10,180
8,440
112
3
148
4
184
5
174
152…
arrow_forward
explain thoroughly the table/diagram
arrow_forward
Answer number 2 only. Full solution. Unique answers only.
arrow_forward
Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3.
Can you please shows the answers in excel with the formula in it, becuase I need to practices this kinda question for my upcoming exam.
arrow_forward
Please do not give solution in image formate thanku.
arrow_forward
Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing them
Methods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a…
arrow_forward
Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing themMethods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a classification…
arrow_forward
Problem 3-4 (Static)
An electrical contractor's records during the last five weeks indicate the number of job requests:
2 3
22 18
Week:
Requests:
1
20
4
21
Click here for the Excel Data File
Predict the number of requests for week 6 using each of these methods:
a. Naive.
5
22
Answer is complete but not entirely correct.
Number of
requests
24 X
requests
b. A four-period moving average. (Round your answer to 2 decimal places.).
Answer is complete but not entirely correct.
Number of
23.25
c. Exponential smoothing with a = 0.30. Use 20 for week 2 forecast. (Round your intermediate calculations and fina
mal nisenel
arrow_forward
BSOP 588 Managing QualityAll Assignments Course Projects, Midterm and Final ExamWeek 2 Course Project:BSOP 588 Week 2 Project Proposal (Toyota Motor Corporation)Week 3 Assignments:Week 3 Paper; Measuring Customer Service – MCS (Jan 2013)Week 3 Paper; Measuring Customer Satisfaction (July 2014)Week 4 Midterm ExamSET 1Page 1Question (TCO A) Compare and contrast the evolution of quality and the role it played in the management of U.S. and Japanese business firms from the 1950s to the present.Question (TCO B) Compare and contrast the following definitions of quality. Definition 1: Quality is the totality of features and characteristics of a product or service that bears on its ability to satisfy given needs. Definition 2: Quality is meeting or exceeding customer expectations.Question (TCO A) Explain the three core principles of total quality.Question (TCO H) Identify and discuss five differences between service and manufacturing organizations.Question (TCO B) Cite two ways that the…
arrow_forward
Please do not give solution in image format thanku
subject is risk management
answer quickly please
arrow_forward
12.
please i need the external analysis for the PASTEL ( see below)
-PESTEL analysis for Sony Corporation Group
arrow_forward
The following are some check points: * Problem 6: Month 9 forecast: 26.333; Month 9 error: -3.333 * Problem 7: Month 7 forecast: 22.68; Month 7 error -0.68 * Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3.
arrow_forward
please answer ASAP . Q2
Subject : production and operation management
arrow_forward
Urgent plz: None of answers provided previously were correct. Need correct answers. Organized
A statistical program is recommended.
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow.
Quarter
Year 1
Year 2
Year 3
1
1,690
1,800
1,850
2
940
900
1,100
3
2,625
2,900
2,930
4
2,500
2,360
2,615
compute the quarterly forecasts for year 4. (Round your answers to the nearest ten.)
quarter 1 forecast ________
quarter 2 forecast_______
quarter 3 forecast ________
quarter 4 forecast _______
Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for year 4. (Round your answers to the nearest ten.)
quarter 1 forecast ________
quarter 2 forecast_______
quarter 3 forecast ________
quarter 4 forecast _______
arrow_forward
Problem 1 Forecasting
• All analysis and calculations and report must be done in a single (ONE) Excel file.• Put your name at the top of the worksheet.• Make Excel do all of the calculations. (Instructor must be able to see your cell-reference formulas.)• Include report/answers below the forecasting calculations. o Make sure answers are clear, complete and easy to find. o Your report must include: a. Presentation of forecasts b. Explanation of why you chose each of the methods
1. Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years oftourist visits to the area. The following data has been gathered on number of tourists who signed into the localinformation center.
Year Number of tourists1 7002 2483 6334 4585 14106 15887 16298 13019 145510 1989
Tom is interested in implementing a forecasting system and is…
arrow_forward
Subject:- accounting
arrow_forward
Required information
Problem 9-2
[The following information applies to the questions displayed below.]
An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table.
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
301
O/C
315
W/R
329
N/C
302
N/C
316
F/R
330
O/R
303
F/R
317
F/R
331
N/R
304
O/R
318
N/R
332
W/C
305
F/R
319
F/R
333
W/C
306
N/R
320
N/R
334
N/R
307
N/C
321
O/C
335
F/C
308
O/R
322
W/C
336
W/C
309
N/R
323
F/R
337
F/C
310
N/C
324
O/C
338
N/R
311
O/C
325
W/C
339
N/R
312
O/R
326
N/C
340
N/C
313
N/R
327
O/R
341
N/R
314
O/R
328
N/R
Key:
Problem type:
Customer type:
N
= Noisy
C
= Commercial customer
F
= Equipment failure
R
= Residential customer
W
= Runs warm
O
= Odor
Problem 9-2 Part a
a.
Using the data, prepare a check sheet for the problem…
arrow_forward
A service provided delivering packages to a locker for customers to pick up at their convenience is an example of:
Question content area bottom
Part 1
A.
hybrid office.
B.
passive contact.
C.
active contact.
D.
front office.
arrow_forward
%24
W WA 6.4 custom - Mat x
C The Willingnes
Zoom
Xb The daily demand for X
A clemson canvcas - Bin X
Cohnect to Canvas at X
https://www.webassign.net/web/Student/Assignment-Responses/submit?pos=D2&dep=27166051&tags=autosave#question4697815 2
->
The willingness of saddle-producers to supply saddles can be modeled as
for p < 5
= (d)s
2.194(1.295P)
for p 2 5
where S(p) is measured in thousand saddles and saddles are sold for p thousand dollars per saddle.
(a) How many saddles will producers supply when the market price is $2000?
thousand saddles
How many saddles will producers supply when the market price is $9000? (Round your answer to three decimal places.)
thousand saddles
(b) At what price will producers supply 10 thousand saddles? (Round your answer to three decimal places.)
thousand per saddle
(c) Calculate the producer revenue when the market price is $6500. (Round your answer to three decimal places.)
x million
24
(d) Calculate the producer surplus when the market price is $6500.…
arrow_forward
123456789unn3u5167
10
5
6 Variable Cells
18
19
20
21
22
23
24
25
26
27
28
29
30
31
7
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
8
9
10
11
2
11 13
12 14
12 Constraints
Name
Cell
$B$15 demand for A LHS
$B$16 total demand LHS
16 17 $B$17 procssing time LHS
Cell
$C$8 A
$D$8 B
15
16
Name
Final Reduced Objective Allowable Allowable
Value
Cost Coefficient Increase
Decrease
1E+30
250
100
Final
Value Price
250
350
600
0
0
Shadow Constraint
R.H. Side
0
4
-1
2
3
Q1 what is the range for objective coefficient of A and B?
125
350
600
1
1E+30
Allowable Allowable
Increase Decrease
Q4) if the objective coefficient of A goes up to 5 dollars what will happen?
Q2 assume that the final value of B is 0 and the reduced cost of B is 1; explain the situation ?
Q5 If the objective coefficient of B goes up to 8 dollars what will happen?
Q6) if the obj coeff of A goes down to -5 dollars what does that mean?
125
125
100
1
Q3 if the objective coefficient of A goes down to 1 dollar and objective coefficient of B…
arrow_forward
How can I match the term with its defin
arrow_forward
how can I analyse my findings for question 4&5?
arrow_forward
Solve this
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Related Questions
- PROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows: Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…arrow_forwardQuestion 4 (1 point) As buyers are increasingly facing information overload, salespeople should ensure information is streamlined and personalized. OTrue OFalse Question 5 (1 point) Blogs, white papers, webinars, and presentations should be proyided to targeted customers. OTrue OFalse Question 6 (1 point) dal fne avaluating solution alternatives uses weighted averages.arrow_forwardPls choose right answers no need explanationarrow_forward
- Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet7 Report Created: 9/26/2020 10:43:05 AM Engine: Standard LP/Quadratic Objective Cell (Min) Cell Name Final Value $B$13 Obj Func AN 4135000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 variables AN 55000 0 33 7.0000001 41.0000001 $C$11 variables AO 0 7 48 1E+30 7 $D$11 variables BN 25000 0 27 8.0000001 7.0000001 $E$11 variables BO 47000 0 35 7.0000001 8.0000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 $B$19 LHS 47000 0 57500 1E+30 10500 The answers to the questions…arrow_forwardRequired information Camp Rainbow offers overnight summer camp programs for children ages 10–14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on- site regardless of the number of campers enrolled. Following is the cost information for Camp Rainbow's operations last summer: Number of Cost to Run Campers 172 Week Camp $13,810 9,350 11,360 14,380 14,000 12,440 10,180 8,440 112 3 148 4 184 5 174 152…arrow_forwardexplain thoroughly the table/diagramarrow_forward
- Answer number 2 only. Full solution. Unique answers only.arrow_forwardProblem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3. Can you please shows the answers in excel with the formula in it, becuase I need to practices this kinda question for my upcoming exam.arrow_forwardPlease do not give solution in image formate thanku.arrow_forward
- Background: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing them Methods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a…arrow_forwardBackground: Data about the frequency of adverse events related to inappropriate care in hospitals come from studies of medical records as if they represented a true record of adverse events. In a prospective, observational design we analyzed discussion of adverse events during the care of all patients admitted to three units of a large, urban teaching hospital affiliated to a university medical school. Discussion took place during routine clinical meetings. We undertook the study to enhance understanding of the incidence and scope of adverse events as a basis for preventing themMethods: Ethnographers trained in qualitative observational research attended dayshift, weekday, regularly scheduled attending rounds, residents' work rounds, nursing shift changes, case conferences, and other scheduled meetings in three study units as well as various departmental and section meetings. They recorded all adverse events during patient care discussed at these meetings and developed a classification…arrow_forwardProblem 3-4 (Static) An electrical contractor's records during the last five weeks indicate the number of job requests: 2 3 22 18 Week: Requests: 1 20 4 21 Click here for the Excel Data File Predict the number of requests for week 6 using each of these methods: a. Naive. 5 22 Answer is complete but not entirely correct. Number of requests 24 X requests b. A four-period moving average. (Round your answer to 2 decimal places.). Answer is complete but not entirely correct. Number of 23.25 c. Exponential smoothing with a = 0.30. Use 20 for week 2 forecast. (Round your intermediate calculations and fina mal nisenelarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON