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

Reviews

Write a Review

Accounting Basics Questions & Answers

  A company recently completed 45000 units of a product that

a company recently completed 45000 units of a product that was expected to consume four pounds of direct material per

  Industry with e-commerce activities

Research a U.S. company in the service industry with e-commerce activities.

  What specific services are commonly provided by accountants

What specific services are commonly provided by accountants in your chosen area and role? What skills, characteristics, educational background, licenses, credentials, and experience would provide you.

  Enterprise-resource planning software is another name for

enterprise-resource planning software is another name for database programs. refers to programs that help manage a

  The following information is available for the first month

the following information is available for the first month of operations of korv inc. a manufacturer of art and craft

  Shipshape company makes 2 different types of boats

shipshape company makes 2 different types of boats commercial fishing and sail boats both for recreation and

  Jean jackson estimated that the units in ending inventory

the final processing department in carols production facility began the year with no work in process inventories.

  Regulation and the uniform cpa examination

Regulation and the Uniform CPA Examination

  Prepare a table to allocate the lump sum purchase price

Nagy Company negotiates a lump  sum purchase of several assets from a contractor who is relocating.

  Prepare bank reconciliation for december

Identify and list the deposits in transit at the end of December. Identify and list the outstanding checks at the end of December. Prepare bank reconciliation for December. Give any journal entries that the company should make as a result of the bank..

  For both fifo and lifo calculate the sum of ending

boarders sells a snowboard xpert that is popular with snow board enthusiasts. below is information relating to

  As a long-term investment painters equipment company

as a long-term investment painters equipment company purchased 20 of amc supplies inc.s 400000 shares for 480000 at the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd