ACC 2343 Mid-Term Assignment - The Ottawa Gladiators Lacrosse Club

ACC2343 Assignments

Individual Assignment #2 The Ottawa Gladiators Lacrosse Club

This assignment is out of 100 points and is worth 25% of your final grade.

For this assignment you will be required to analyze the sales and ticketing data for a

professional sports team. After preparing an analysis model and determining various

business metrics based, you will draw conclusions about a marketing proposal for

presentation to management. Write a brief business memo that summarizes your

findings for submission to the club president.

6.

Assignment Structure & Format

You should submit two artefacts for this assignment:

A business memo that presents your findings and makes recommendations;

A summary page from your Excel model that presents the facts and conclusions

found in your model (in PDF format, portrait or landscape view, 8.5 x 11 inch

page)

The business memo should be a maximum of 2 pages in length, using no smaller than a

10 point font with minimum line spacing of 1.5. Include the questions from the

assignment, and feel free to include content from your Excel model. Remember, as in

business, presentation matters so please pay attention to formatting and aesthetics with

your memo and your summary page.

There is an infinite number of ways you can layout the data for this assignment and

model for your solutions, but there are a finite set of correct answers.

Instructions

Download the case study and data file for this assignment. After reading the case study

perform the following tasks:

Load the data files into an Excel spreadsheet using the appropriate features and

functions. The layout of the files is included in the files;

Create Excel functions and formulas that answer the questions posed below;

Consolidate your findings from the formula and functions into a summary page in

arious lessons;

Create a PDF output of the summary page for submission;

Answer the questions posed below in a maximum 2 page business memo that

Mid-Term Assignment - The Ottawa Gladiators Lacrosse Club

ACC2343 Assignments

Submit the memo (preferably as a PDF) and the summary page from your model

(as a PDF) for grading.

Questions

1. Develop an analysis model that will support pivot table analysis using RFM

techniques. Use no more than five quintiles to cluster the ticket data. From your

RFM model which customers are (40 marks):

a.

b. Who are they? Why do you feel

c. What in your analysis

leads to this definition of value?

2. For the 12 game season (20 marks):

a. What was total attendance? How do you propose to segment attendance

to report to Mr. Goldsmith as requested?

b. What was per game attendance? Using segmentation as defined above,

report variance across the season.

c. Do you have any recommendations to assist in attendance for next

season?

SCORING RUBRIC

Students will be evaluated using the following criteria for a total of 100 marks:

Section Scoring Level Requirements Points

Business memo 45 60 excellent

30 45 good

15 45 satisfactory

0 15 poor

Based on the findings in your

analysis the questions posed are

answered in a well-structured

business memo

The business memo is correctly

targeted to the president of the

Ottawa Gladiators Lacrosse Club

The business memo contains

insight, analysis and

recommended actions rather than

simply numbers

/60

Analysis summary 20 25 excellent

15-20 good

8-15 satisfactory

0 8 poor

The outcome of your analysis

(answers) are accurate and

correct relative the data and

questions

This demonstrates mastery of the

mathematical and database

functions and your ability to

accurately structure formula

/25

ACC2343 Assignments

Section Scoring Level Requirements Points

Overall Structural

Quality

12 15 excellent

8 12 good

4 8 satisfactory

0 4 poor

Structure, layout and flow of the

memo (up to 10 marks) which

includes:

Presentation

Formatting

clarity of presentation of

findings and

recommendations

Grammar, sentence structure and

spelling (5 marks).

/15

TOTAL /100