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

Religious Discrimination: Reasonable Accommodations Part 2 - Distributed algorithms nancy lynch - According to the textbook, the central theme of the wisdom literature is: - Automatic floor cleaning machine project - Nara ii reading test - Shannon and weaver communication model - Brand research report - Dimplex heater timer instructions - Leonard kip rhinelander - Stem cell webquest answers - The short story and its writer 9th edition - Cisco commands cheat sheet - Review an article - Is 101 a prime number - SOCW 6361 - Exp 105 final assignment - Influence of highly permeable materials on the magnetic flux lines - Question 3 - Alwaysrain irrigation inc would like to determine - Central nervous system ppt - Everyday use assessment answers - Montgomery Bus Boycott - Harvard business school global supply chain management simulation answers - C.wright mills claimed that the sociological imagination transformed - Briar rose sleeping beauty analysis - When did the target data breach occur - 11.2.4 configure a ppp wan link - Design formula for inset fed microstrip patch antenna - The Middleboro Casebook – Case 1 – The Community Final Case Analysis - Qld teachers meritorious sick leave - Reflection of threats to sea turtles(150words) - Folk song philippine literature - Examples of empirical indicators in nursing - Abc net au austory - Vhi company plan extra level 1 - Sas nodupkey multiple variables - Case Study related to diabetes - Introduction to applied linear algebra solutions - Does an onion cell have a cell membrane - Cpp - Discussion week1 - Iprofile wiley - Holy cow canvas push pin map - Suzanne crazy eyes mental illness - Taxation of individuals and business entities solutions - Lamb of the slaughter - Solve Algebraic Questions (MyMathLab) - Golfsmith tour cavity professional grind - Atlas quadrant with sliding doors 900 - Usp labs versa 1 review - The art of wall e - Http njaes rutgers edu money riskquiz - Rail fence cipher decryption example - Paypal in 2015 reshaping the financial services landscape - An acrostic poem using the word environment - Crisis Intervention - Adhd and reading fluency - Travel to work loan - Wall street movie blue star - Clancy of the overflow poem pdf - Access grader project chapter 3 - Magnesium oxide experiment lab report - Business Law - Discussion 2 - Performance Appraisal Process Evaluation - Colter company prepares monthly cash budgets - 260 230 ratio dna - Kels assessment form pdf - SOCIOLOGY - Klockner moeller contactors catalogue - Essay - The supply of loanable funds is perfectly elastic - East side dukes pueblo colorado - The primary purpose of an it forensic audit is - Calculating heat in calories b answers - The Role of the Leader in Governing - Wk 1 - Reflective Journal Writing - Captain thunderbolt and his lady - Hematologic Disorder - 3 bit synchronous counter using d flip flop - 140 englefield road oxley - Elinchrom scanlite halogen 300 650w set - Chcece005 provide care for babies and toddlers answers - What is access pay - Mature student accommodation galway - Amortisation of leasehold property - How to report shapiro wilk test apa style - Penn foster written communication writing assignment - Find the solution of the initial value problem - Volcanic glass crossword clue - Www ucumberlands edu ilearn - Cognitive psychology exam questions multiple choice - Games for past tense - Exercise 3.1 - Access training centre wingfield - Does table salt melt ice faster - Persuasive speech mental illness - Adjective phrase in a sentence - Find an equation relating x and y - Basic facial steps milady - Sunquest laboratory information system manual