Description
The report should be between 750 and 1,000 words long and written in a Microsoft Word file. It must include tables, graphs, and charts inserted at appropriate places (every figure or table must be captioned; refer to the sample report). In other words, the report must be self-contained; there should be no reference whatsoever to the Microsoft Excel file where your analyses and calculations are located. The report should solely focus on interpretations of the results instead of the detailed results; for instance, the detailed results of a simulation in the spreadsheet should NOT be included in the report. Review the sample report in the attachment. Some general guidelines for professional report writing can be found here (Links to an external site.). Must use forecasting, hypothesis testing, and regression analysis in excel to analyze given data.
! QMB 3302 – CRN 80784 – TR – 202008 Assignments Case Study 2Total Points: 100.0Case Study 2Due Thursday by 11:59pm Points 100 Submi!ng a file upload A”empts 0Allowed A”empts 1 Available Oct 29 at 12am – Oct 29 at 11:59pm 1 dayRubric for Case StudiesCriteria Ra#ngs Pts60.0 pts40.0 ptsSubmit AssignmentEagle Industrial Supplies (EIS) produces lawn mowers and tractors and sell them in North America, South America,Europe, Pacific Rim, and recently China. EIS’s management is commi!ed to increasing the company’s market shares inboth mower and tractor sales in all five regions in the next few years. The execu”ve team wants to closely monitor theprogress toward increasing the market share. Meanwhile, some process enhancements have been implemented at theproduc”on facility to improve the efficiency of mower produc”on in order to fulfill the expected increase in demand.One specific area undergoing improvement is the produc”on of mower blades. The weight of a blade can significantlyaffect the mower performance as well as the produc”on cost. Hence, the produc”on manager wants to perform abenchmark on the newly enhanced blade produc”on process. She is also concerned that the overall produc”onprocess has been handicapped by the high turnover of employees. Consequently, the human resource manager hasbeen tasked with inves”ga”ng the underlying factors that may impact the reten”on of employees.The a!ached Microso% Excel file contains the following data: EIS’s mower and tractor unit sales, mower and tractormarket unit sales, a sample of blade weights, and employee reten”on data. Use appropriate tools such as Excelfunc”ons and relevant tools to analyze the given data and write a report that clearly explains key insights on:The forecasts of EIS’s mower and tractor sales and those of the respec!ve markets in various regions (Does the analysissupport the management’s ambi”on to increase market shares—company’s unit sales as percentage of the overallmarket—in every region? Which regions are performing well, and which regions are not in terms of the marketshare? How accurate are your forecasts? What forecas”ng technique is most suitable and why?)The produc!on of mower blades which should weigh 5 lbs. when finished according to the specifica!on (Is the bladeproduc”on process under control and capable of producing as per specifica”ons? In other words, is theresta”s”cally evidence that the blade weights are 5 lbs.? Is the sample of blade weights sufficient to achieve themargin of error of 0.01, and if not, what is the sample size required?)The factors that impact the reten!on of employees (What factors have sta”s”cally significant effects on the numberof years employees stay with the company? Which factors are most important, and which are least important?)RequirementsThe report should be between 750 and 1,000 words long and wri!en in a Microso” Word file. It must include tables,graphs, and charts inserted at appropriate places (every figure or table must be cap!oned; refer to the sample report). Inother words, the report must be self-contained; there should be no reference whatsoever to the Microso” Excel filewhere your analyses and calcula”ons are located. The report should solely focus on interpreta!ons of the results instead ofthe detailed results; for instance, the detailed results of a simula”on in the spreadsheet should NOT be included in thereport. Review the sample report in the a!achment. Some general guidelines for professional report wri”ng can befound here .The submission should include one Microso” Word file named Cassee Sttudyy 2 — Fullll Namee..doccxx for the report and oneMicroso” Excel file named Cassee Sttudyy 2 — Fullll Namee..xxllssxx for all your suppor”ng analyses (replace Full Name withyour full name; for example, Cassee Sttudyy 2 — JJohn Doee). Any submission without the suppor!ng Microso” Excel file willautoma!cally receive a score of 0. You are free to use any tool in Microso” Excel for analysis so long as appropriateresults or outputs are included in the report and the suppor”ng a!achment.GradingYour report is expected to at the very least provide answers to ques”ons listed in the bullets above, with appropriatesuppor”ng analyses. Your submission will be graded based on the following criteria:Are all analyses correctly performed using appropriate tools and techniques?Does the report seamlessly integrate all analyses and discussions into a single coherent document that is wri!enprofessionally?Are all specified tasks and instruc”ons correctly completed?A!achmentsQMB3302-80784 (2020 Fall) Case Study – Sample Report.pdfQMB3302-80784 (2020 Fall) Case Study 2 Database.xlsxAnalysisStudent isable toanalyze theproblemusingappropriatetools andtechniques60.0 ptsExemplaryStudentcompletes allanalysesappropriatelywith no error(60 pts)55.0 ptsAccomplishedStudentcompletes allanalysesappropriatelybut withsome errors(55 pts)50.0 ptsAcceptableStudentcompletesmostanalysesappropriatelybut withminor errors(50 pts)40.0 ptsNeedImprovementsStudentcompletessome analysesappropriatelybut withmajor errors(40 pts)30.0 ptsNeed MajorImprovementsStudentcompletessome analysesappropriatelybut withsignificanterrors (30 pts)15.0 ptsBeginningStudentcompletesonly a fewanalysesappropriatelybut withsignificanterrors (15pts)0.0 ptsNotAcceptableStudentdoes notcompleteanyanalysis (0pts)ReportStudent isable tointegrateanalysesanddiscussionsinto acoherentandprofessionalreport40.0 ptsExemplaryStudentproduces anexemplaryreport withno apparentdeficiency(40 pts)35.0 ptsAccomplishedStudentproduces anexcellentreport withminordeficiencies(35 pts)30.0 ptsAcceptableStudentproduces asa”sfactoryreport withsomedeficiencies(30 pts)25.0 ptsNeedImprovementsStudentproduces asa”sfactoryreport withmajordeficiencies(25 pts)15.0 ptsNeed MajorImprovementsStudentproduces anincompletereport withmajordeficiencies(15 pts)5.0 ptsBeginningStudentproduces anincompletereport withsignificantdeficiencies(5 pts)0.0 ptsNotAcceptableStudentdoes notproduce areport (0pts)“Previous Next#Fall 2020HomeAnnouncementsGradesPeopleSyllabusModulesConferencesLibrary GuidesFolioOffice 365Purchase CourseMaterialsAccountDashboardCoursesCalendarInboxHistoryHelp &Resources72
Company’s Mower Unit Sales
Companys’s Tractor Unit Sales
Month
North America
South America
Europe
Pacific Rim
China
Total
Month
North America
South America
Europe
Pacific Rim
China
Total
Jan-14
6,000
200
720
100
0
7,020
Jan-14
570
250
560
212
0
1,592
Feb-14
7,950
220
990
120
0
9,280
Feb-14
611
270
600
230
0
1,711
Mar-14
8,100
250
1,320
110
0
9,780
Mar-14
630
260
680
240
0
1,810
Apr-14
9,050
280
1,650
120
0
11,100
Apr-14
684
270
650
263
0
1,867
May-14
9,900
310
1,590
130
0
11,930
May-14
650
280
580
269
0
1,779
Jun-14
10,200
300
1,620
120
0
12,240
Jun-14
600
270
590
280
0
1,740
Jul-14
8,730
280
1,590
140
0
10,740
Jul-14
512
264
760
290
0
1,826
Aug-14
8,140
250
1,560
130
0
10,080
Aug-14
500
280
645
270
0
1,695
Sep-14
6,480
230
1,590
130
0
8,430
Sep-14
478
290
650
263
0
1,681
Oct-14
5,990
220
1,320
120
0
7,650
Oct-14
455
280
670
258
0
1,663
Nov-14
5,320
210
990
130
0
6,650
Nov-14
407
290
888
240
0
1,825
Dec-14
4,640
180
660
140
0
5,620
Dec-14
360
280
850
230
0
1,720
Jan-15
5,980
210
690
140
0
7,020
Jan-15
571
320
620
250
0
1,761
Feb-15
7,620
240
1,020
150
0
9,030
Feb-15
650
350
760
275
0
2,035
Mar-15
8,370
250
1,290
140
0
10,050
Mar-15
740
390
742
270
0
2,142
Apr-15
8,830
290
1,620
150
0
10,890
Apr-15
840
440
780
280
0
2,340
May-15
9,310
330
1,650
130
0
11,420
May-15
830
470
690
290
0
2,280
Jun-15
10,230
310
1,590
140
0
12,270
Jun-15
760
490
721
300
0
2,271
Jul-15
8,720
290
1,560
150
0
10,720
Jul-15
681
481
680
312
0
2,154
Aug-15
7,710
270
1,530
140
0
9,650
Aug-15
670
460
711
305
0
2,146
Sep-15
6,320
250
1,590
150
0
8,310
Sep-15
640
460
695
290
0
2,085
Oct-15
5,840
250
1,260
160
0
7,510
Oct-15
620
440
650
260
0
1,970
Nov-15
4,960
240
900
150
0
6,250
Nov-15
570
436
680
250
0
1,936
Dec-15
4,350
210
660
150
0
5,370
Dec-15
533
420
657
240
0
1,850
Jan-16
6,020
220
570
160
0
6,970
Jan-16
620
510
610
250
10
2,000
Feb-16
7,920
250
840
150
0
9,160
Feb-16
792
590
680
250
12
2,324
Mar-16
8,430
270
1,110
160
0
9,970
Mar-16
890
610
730
260
20
2,510
Apr-16
9,040
310
1,500
170
0
11,020
Apr-16
960
600
820
270
22
2,672
May-16
9,820
360
1,440
160
0
11,780
May-16
1,040
620
810
290
20
2,780
Jun-16
10,370
330
1,410
170
0
12,280
Jun-16
1,032
640
807
310
24
2,813
Jul-16
9,050
310
1,440
160
0
10,960
Jul-16
1,006
590
760
340
20
2,716
Aug-16
7,620
300
1,410
170
0
9,500
Aug-16
910
600
720
320
31
2,581
Sep-16
6,420
280
1,350
180
0
8,230
Sep-16
803
670
660
313
30
2,476
Oct-16
5,890
270
1,080
180
0
7,420
Oct-16
730
630
630
290
37
2,317
Nov-16
5,340
260
840
190
0
6,630
Nov-16
699
710
603
280
32
2,324
Dec-16
4,430
230
510
180
0
5,350
Dec-16
647
570
570
260
33
2,080
Jan-17
6,100
250
480
200
0
7,030
Jan-17
730
650
500
287
35
2,202
Feb-17
8,010
270
750
190
0
9,220
Feb-17
930
680
590
290
50
2,540
Mar-17
8,430
280
1,140
200
0
10,050
Mar-17
1,160
724
620
300
63
2,867
Apr-17
9,110
320
1,410
210
0
11,050
Apr-17
1,510
730
730
310
68
3,348
May-17
9,730
380
1,340
190
0
11,640
May-17
1,650
760
740
330
70
3,550
Jun-17
10,120
360
1,360
200
0
12,040
Jun-17
1,490
800
720
340
82
3,432
Jul-17
9,080
320
1,410
200
0
11,010
Jul-17
1,460
840
670
350
80
3,400
Aug-17
7,820
310
1,490
210
0
9,830
Aug-17
1,390
830
610
341
90
3,261
Sep-17
6,540
300
1,310
220
0
8,370
Sep-17
1,360
820
599
330
100
3,209
Oct-17
6,010
290
980
210
0
7,490
Oct-17
1,340
810
560
320
102
3,132
Nov-17
5,270
270
770
220
0
6,530
Nov-17
1,240
827
550
300
110
3,027
Dec-17
5,380
260
430
230
0
6,300
Dec-17
1,103
750
520
290
114
2,777
Jan-18
6,210
270
400
200
0
7,080
Jan-18
1,250
780
480
200
111
2,821
Feb-18
8,030
280
750
190
0
9,250
Feb-18
1,550
805
523
210
121
3,209
Mar-18
8,540
300
970
210
5
10,025
Mar-18
1,820
830
560
220
123
3,553
Apr-18
9,120
340
1,310
220
16
11,006
Apr-18
2,010
890
570
230
120
3,820
May-18
9,570
390
1,260
200
22
11,442
May-18
2,230
930
590
253
130
4,133
Jun-18
10,230
380
1,240
210
26
12,086
Jun-18
2,490
980
600
270
136
4,476
Jul-18
9,580
350
1,300
230
14
11,474
Jul-18
2,440
1,002
580
280
134
4,436
Aug-18
7,680
340
1,250
220
15
9,505
Aug-18
2,334
970
570
250
132
4,256
Sep-18
6,870
320
1,210
220
11
8,631
Sep-18
2,190
960
550
230
137
4,067
Oct-18
5,930
310
970
230
3
7,443
Oct-18
2,080
930
530
220
130
3,890
Nov-18
5,260
300
650
240
1
6,451
Nov-18
2,050
920
517
190
139
3,816
Dec-18
4,830
290
300
230
0
5,650
Dec-18
2,004
902
490
190
131
3,717
<!– /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536869121 1107305727 33554432 0 415 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-536859905 -1073732485 9 0 511 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:””; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:”Calibri”,”sans-serif”; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} h2 {mso-style-priority:9; mso-style-qformat:yes; mso-style-link:”Heading 2 Char”; mso-style-next:Normal; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; line-height:115%; mso-pagination:widow-orphan lines-together; page-break-after:avoid; mso-outline-level:2; font-size:13.0pt; font-family:”Cambria”,”serif”; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:”Times New Roman”; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; mso-themecolor:hyperlink; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Times New Roman”,”serif”; mso-fareast-font-family:”Times New Roman”;} span.Heading2Char {mso-style-name:”Heading 2 Char”; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:”Heading 2″; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:”Cambria”,”serif”; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:”Times New Roman”; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:”Calibri”,”sans-serif”; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times New Roman”; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:1968898547; mso-list-template-ids:-609950248;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:”Courier New”; mso-bidi-font-family:”Times New Roman”;} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} –>Get professional assignment help cheaplyAre you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.Why choose our academic writing service?Plagiarism free papersTimely deliveryAny deadlineSkilled, Experienced Native English WritersSubject-relevant academic writerAdherence to paper instructionsAbility to tackle bulk assignmentsReasonable prices24/7 Customer SupportGet superb grades consistently
Get Professional Assignment Help Cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor’s, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why Choose Our Academic Writing Service?
Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently
How It Works
1. Place an order
You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.
2. Pay for the order
Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.
3. Track the progress
You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.
4. Download the paper
The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.
PLACE THIS ORDER OR A SIMILAR ORDER WITH Essay fount TODAY AND GET AN AMAZING DISCOUNT
The post Database case study appeared first on Essay fount.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
