Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Global superstore data analysis

19/04/2021 Client: muhammad11 Deadline: 2 Day

MKT 356 Take Home Midterm Exam Spring 2018 Instructions: 1. Open notes/book, but independent work is required. You may work with other students on this exam. However, each individual must turn in their own exam. Plagiarism will result in a mark of zero for the exam, and will be reported to the department. 2. Please support your claims with proper charts or exhibits – remember you are talking to a business audience. If you show a chart that is with too much information or not readable, no marks can be given. One or two charts are expected for each question, except for Part B q1 and q2 (For these two questions, you may just say “Done. See sheet2 in the file xxx.xlsx.”). 3. An appendix of how you construct each exhibit is required. An example of such appendix is on Canvas. Please put the appendix at the end of your word document. 4. Your work is due 5pm 3/20/2018 on Canvas. Please submit a word document (put the Appendix mentioned above at the end of the document – don’t put them in the text), and other supporting twb files and/or excel files. Please save your Tableau charts as images and paste them in the proper places in your word file. I will be grading your word file ONLY. 5. No re-do is allowed for the Midterm Exam. Using the global_superstore.xls data (the “Orders” sheet, unless instructed otherwise), answer the following questions. Part A [50 marks]: Compare profitability for the Africa, LATAM, and the US market. 1. Describe what this dataset is all about. (It is about How many consumers’ purchasing records, where, when, and in what product categories?) (5 marks) 2. Comment on the overall profit of these markets. Together with their sales, what would you say? (5 marks) 3. Now add product category information to the picture. Comment on profitability again. (5 marks) 4. Take the US market as an example, see whether your comments in question 3 would apply on a year to year basis or not. What do you say now? (5 marks) 5. Bring variable “Discount” to the picture. Do you see discount done differently in these markets, in each category? (5 marks) 6. Bring variable “Shipping Cost” to the picture. Please comment on how shipping cost may affect profitability in each category. (5 marks) 7. Now Open the data in Excel. In the “Orders” sheet, create a new column, and call it Returned. Use the vlookup function, and the OrderID as identifier, to bring in information for “whether the order is returned or not” from the “Returns” sheet. Then create a blank Tableau workbook and connect the data again. Compare two economic aspects of the returned orders to those that are not returned. Comment on the results. [Hint: you may consult hw3.] (15 marks) 8. Based on what you have observed so far, can you make some conjectures and recommendations for each market, in terms of how we may improve its profitability? Please support your claims with facts that you commented on previously. (5 marks) Part B [40 marks]: RFM is commonly used in marketing, retail and professional services industries to assess customer value. The general idea behind the analysis can be summarized as: Recency: People who have purchased recently from you are much more likely to respond to a new offer than someone who you haven’t sold to in a long time. Frequency: People who shop frequently at your store are more likely to respond to new offers than less frequent buyers. Monetary: People who spend more money at your store are more likely to show interest in new offers. They are defined as: Recency: How long ago did the customer make a purchase (usually measured by days)? Frequency: How many purchases has the customer made (during the last year or other time period)? Monetary Value: How much has the customer spent in total (in given time period)? 1. Please set 2014 data aside, and use 2011-2013 data (the end of year 2013 as cutoff point for recency), and compute the RFM for each customer.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Guru
Quick Finance Master
Calculation Master
Accounting Homework Help
Engineering Exam Guru
Financial Assignments
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$39 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$34 Chat With Writer
Calculation Master

ONLINE

Calculation Master

I will cover all the points which you have mentioned in your project details.

$27 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$47 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I have read your project details. I can do this within your deadline.

$42 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

I have read your project details. I can do this within your deadline.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

For sochien - Who made the georgia guidestones - Does a red lionfish have a backbone - Ob gyn soap note template - Learning Reflections Paper - WEEEK VII PART 2A - D3 reflection - Older Adults Patient Education Issues Essay and Interview - Pendleton act of 1881 - Supply Chain management - Essay - Custom chrome hand controls - Stage 2 biology sace - Philosophy and Vision for Nursing - Vulnerability analysis - What must be general dynamics’ earnings per share? - Charles w hill international business 9th edition - Cfg to pda solved examples - Umuc last day to withdraw - The two primary issues to consider in organizational feasibility analysis are ________. - St dominic de guzman - COM - Lima beans and chorizo recipe adrian richardson - Lorem ipsum - Utz better than nuts - Sociology - 631wk5assign1 - Asian pacific endodontic confederation - Strategy, Planning, and Selection - Crafting and executing strategy 21e pdf - Value proposition canvas strategyzer pdf - Transfer essay - Set 1 relative humidity answers - 13.25 as a mixed number - Learning and memory w scott terry - Epson eb 1410wi price - The south division of wiig company reported - Your investment club has only two stocks in its portfolio - Home video game industry case study - Medial epicondylitis special test - Putting the brakes on teenage driving speech analysis - Skill Builder #5 - D4 - Human inquiry and science - Operations management simulation inventory basics answers - Alvin dewey in cold blood quotes - The coffee shop social and physical factors influencing place attachment - Edld 5311 fundamentals of leadership - Intitle index of passwords modified - Uq semester 2 exam timetable - Mandevilla alice dupont plant - Vitamin a has a molar mass of 286.4 - Det nsw secure internet login - The shaft is supported by smooth journal bearings - Laboratory report gram staining exercise 7 - Razor over comb definition - How to find a cumulative frequency - Orthogonal codes in cdma - Simple seminar topics for mechanical engineering - Dna rna protein synthesis review answer key - 490 RN - Amazon case study strategic management - Otway national park koalas - Football managers - Great expectations test questions - Temperate deciduous forest average rainfall - English file advanced third edition answer key pdf - Holy child school killiney - Centurion d5 evo status light red - Why was jesus a role model - 8 10 page research paper - Installing ice and water shield in cold weather - Musyokiones change management - Derivatives using power rule worksheet answers - Case Study – Security - 3 methyl 2 pentene isomers - Different types of capacitors ppt - Case 4 - Escience lab 1 answers - Food and beverages at southwestern university football games - Hp 3par storage pdf - Sims 3 iams pet starter kit - Cox craft rum runner 2 - 000214a0 0000 0000 c000 000000000046 - Memo Due Tomorrow - Banchory community centre hillside - Kraft Food Marketing Strategy - Assignment M2 - 2 responses - Penn state diner sticky buns - Sudarshan kriya benefits and side effects - Security Architecture and Design - Episodic focused soap note format - Evidence-Based Project, Part 4: Critical Appraisal of Research - In cell l5 enter an if function - How much litres of paint required per m2 - Tutorials in introductory physics forces - Is raisin bread a heterogeneous mixture - Matt teachout - Mr clean mother's day ad