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

Berlioz symphonie fantastique movement 5 - Cash receipts from sales on account have been misappropriated - Indra nooyi interview questions and answers - Cecs in border terriers - In a cross between two individuals of the genotype aabbccddee - Tenon saw and bench hook - Marketing plan - A survey was conducted at springdale - PTSD Active duty and Veterans - Mlc masterkey super performance - Capella mha reviews - Physics units and dimensions formulas - Forster v jododex australia pty ltd - Infoblox 1410 end of life - Icem 3d mesh tutorial - Taguchi design of experiments ppt - Bachelor of media rmit - 5-3-1 activity: historical context chart - Kotter's 8 step change management model - Adjectives to describe films - Effect of home accident - Claude cahun cause of death - The damnation of a canyon is unconvincing - Wigton adult education centre - Apple foxconn case study - Www koi moodle - Www northampton ac uk - Organizational Development Plan - Anterior compartment of arm - The open boat questions and answers - On june 30 sharper corporation - CASE STUDY 5 - Syrian War And EU In A Vulnerable Situation - Disney in france case study answer - Do you support or oppose the death penalty? - Art elements and principles vce - Case study 1 transforming the organization - Everyone's an author tumblr - Assessment Tools - Describe the management style at rondell data corporation - Week 10 Discussion for Bus 599 - Nasm stabilization endurance workout - Final Portfolio Project - Bs en 12635 2002 - Issuing common shares journal entry - Keep patients waiting not in my office - A worn path research paper - Ebola vaccine - Grammar and writing skills for the health professional 3rd edition - Freedom of press gone too far essay - Geology Week 1 - 2 in 1 - Impacts of tourism slideshare - Penner medical products case study solution - Which american composer was an insurance salesman in everyday life - Who owns be natural cereals - 31 raynesford drive mount louisa - 8.2 double object pronouns answers - Critical infrastructure data collection - Essay - Concept map for major depressive disorder - Order 2248417: Case Study (plus 3 unpaid Case Studies), 750-word Rationale, 500-word Agenda essay - Merlin gerin multi 9 c60n c40 - The Executive Branch/ NO PLAGIARISM/ MUST BE ORIGINAL/ SCHOLARLY RESOURCES 2015/ - Fresh novel original new - Facing poverty with a rich girl's habits - Https www myworkday com cerner login flex redirect n - Spotted marsh frog call - Queensland plumbing and wastewater code - Financial Engineering 5 - Metaphor meanings worksheet answers - Bigger books bigger reading muscles - Hobart stickmate lx 235 manual - Crypto Security Architecture - Pangea Governance & Leadership - Decision making styles university of phoenix - Donahue angry white men - Wedding cake model of criminal justice - Barriers to Communication - Https www procon org headline php headlineid 005323 - Lead and manage team effectiveness assessment - Psychology-Suicide - Top front and side views of 3d objects - Chick fil a swot analysis 2018 - 5 observations of a chemical reaction - Drawing electron dot diagrams - Belt driven centrifugal fan - Cutter enterprises purchased equipment for - A puzzle with many pieces development of the periodic table - Healthcare quality book 3rd edition pdf - What is a dot on stuffdot - Verizon wireless value chain - Rmit diploma of marketing - Horizontal and vertical analysis of financial statements excel - Roman numerals printable pdf - Assassin's creed black flag governors outfit - Brandon brown versus yucatan chapter 4 - Bypass firewall to get to facebook - Option for the poor and vulnerable - Dissertation topic