London Jets

Questions for the capital of the United Kingdom Jets effort Download the file capital of the United KingdomJets. xls, available on the course website. I. Perform RFM Analysis ( recency, frequency, m startary (total sales) analysis) as indicated on rogue 3 of the field bars for RFM ar given on page 8 of the case (I have provided one snuggle on page 3 of this document). Use pin table with relative frequency and Monetary value for rows and Recency for column. Data field should be Count of CustID. Important Note The do for this table is shown on the next page use this format for your RFM table.Please provide a skeleton interpretation for the RFM analysis assume you be the consultant to London Jets how would you justify what the numbers in the pivot table mean (keep the discussion brief for all(prenominal) one and every entry need not be explained). II. carryitional Analysis Do two additional sets of analysis beyond RFM. As an example, you may indispensability to analyze attendance patterns for Fan Club Members versus non-members to see if there is any merit in increase the size of this club (this would count as one analysis). There are several different variables in the database, and as such there are lots of ways in which the data can be analyzed.Think about the issue London Jets is facing how to increase attendance and let this objective puzzle your analysis. For each additional analysis undertaken by your group, provide a rationale as to why should London Jets consider the customer segment you are analyzing. Please also be sure to briefly explain the outcome of your analysis (what did you learn for your analysis, and how London Jets can benefit from this analysis). What to submit? Please submit one hard re-create of the report per team. List the prevail names of team members on the cover page in alphabetical order.Prepare your report in power point such that it could be presented to London Jets management (although your team will not be a sked to present the report). Your report should end with a Conclusions page where you draw conclusions from all the analyses you have done, and recommended actions London Jets can take to increase attendance to its games based on your work. Please make sure that the report is contained within a maximum of 12 pages (slides) including the title and conclusions pages. police squad work pretences I have seen two models of team work.The starting and more commonly used model is where the team divides the workload and each member is responsible for completing their share of work. These different pieces are stage together as a report. The obvious advantage of this approach is that the work is divided evenly among members. The drawback of this approach is that sloppy work by one or more team members adversely impacts the score of those who flummox in good work. Additionally, if someone in the team does not take the trouble to integrate the disparate pieces, the end result can be a repo rt that appears disjoint (i. . made up of pieces that do not flow well together). The second, less common approach is where each member provides input on every aspect (question) of the case. Compared to the approach described above, the second approach certainly requires more time from each member. The advantage however is that often the best ideas (i. e. responses to case questions) make it into the report, resulting in a higher attribute of submitted work. Important Note This note applies for all cases done in this class.I cannot entertain questions such as Professor, please take a look at what we have so far and let us know if we are on the right track. Teams are expected to work on each case independently. Taking necessary decisions in situations where there is no clear consensus is a part of team learning process. pic Learn more about RFM here http//searchcrm. techtarget. com/sDefinition/0,,sid11_gci751219,00. html cadences for creating RFM table for London Jets footstep 0 Start by creating a column with 3000 entries such that the first 600 entries are 5s, followed by 600 4s, 600 3s, 600 2s and 600 1s.With copy and paste, this takesless than2 minutes and I can gladly show you how. Here are the stay steps for assigning RFM codes to the London Jets. Step 1 Sort the entire data on recency of attendance so that customers that attended the games most recently will be on the top of the list. Add a new column to the data labeled R, where you copy and paste the column created in step 0. Step 2 Sort the entire data, including recency codes assign in step 1, on the basis of frequency of attendance such that customers with the highest frequency of attendance are at the top of the list.Add a new column to the data labeled F, where you copy and paste the column created in step 0. Step 3 Sort the entire data, including recency codes assigned in step 1 and frequency codes assigned in step 2, on the basis ofmonetary spending such that customers spending the mos t are at the top of the list. Add a new column to the data labeled M, where you assign first 1000 hundred customers aM code of 5, the next 1000 a code of 4, and the last 1000 a code of 3. You are done assigning codes at the end of step 3, and are ready to create the RFM table.