Develop an analysis model that will support pivot table

Assignment Help Accounting Basics

Reference no: EM13902633

Case: The Ottawa Gladiators Lacrosse Club.

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:

a. "Most valuable" to the club?

b. Are their "least valuable" customers? Who are they? Why do you feel they're "least valuable"?

c. How do you define "value to the club" and why? What in your analysis leads to this definition of value?

2. For the 12 game seasons:

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?

Attachment:- Gladiators_Data_File.txt

Reference no: EM13902633

Questions Cloud

The adjustments are normal for this machine : Rizio Co. purchases a machine for $12,500, terms 2/10, n/60, FOB shipping point.

What is the correct rule for the marginal advertising dollar : Why is it incorrect to advertise up to the point that the last dollar of advertising expenditures generates another dollar of sales? What is the correct rule for the marginal advertising dollar?

How does tying differ from bundling : How does mixed bundling differ from pure bundling? Under what conditions is mixed bundling preferable to pure bundling? Why do many restaurants practice mixed bundling (by offering a complete dinner as well as an à la carte menu) instead of pure b..

Cala manufacturing purchases a large lot : Cala Manufacturing purchases a large lot on which an old building is located as part of its plans to build a new plant.

Develop an analysis model that will support pivot table : Develop an analysis model that will support pivot table analysis using RFM techniques. Use no more than five quintiles to cluster the ticket data.

Why did mgm bundle gone with the wind : In the town of Woodland, California, there are many dentists but only one eye doctor. Are senior citizens more likely to be offered discount prices for dental exams or for eye exams? Why?

Write mini-essay comparing self reliance to superman and me : Write a mini-essay comparing "Self Reliance" to "superman and me" and "Why We Crave Horror Movies"

Why pricing of a gillette safety razor of two-part tariff : Why is the pricing of a Gillette safety razor a form of two-part tariff? Must Gillette be a monopoly producer of its blades as well as its razors? Suppose you were advising Gillette on how to determine the two parts of the tariff. What procedure w..

The real estate consists of land appraised : The real estate consists of land appraised at $ 157,040; land improvements appraised at $ 58,890; and a building appraised

User Account

All Pages