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

  Compute the cost of goods sold

The manufacturing operations of REason,inc had the following balances for the month of January: Compute the cost of goods sold.

  Which of the following aspects of the company would not be

which of the following aspects of a company would not be considered a critical success factor for a company that

  Write down a 1400- to 2100-word paper in which you conduct

prepare a 1400- to 2100-word paper in which you conduct a country risk analysis for your selected global business

  The city of albuquerque would probably not use a capital

the city of albuquerque would probably not use a capital projects fund for which of the following assets?1 construction

  Due to an error in computing depreciation expense prewitt

1. to encourage employee ownership of the companys common shares kl corp. permits any of its employees to buy shares

  Calculate and compare the following ratios for fort bend

fort bend company contributes cash of 250000 and costal bend company contributes net assets of 250000 to create

  Ken cascioli and bill ryder master painters

Ken Cascioli and Bill Ryder, master painters and paperhangers, formed a partnership. They had the following transactions during their first month of business.

  Discuss how those control procedures would be best

alden inc. has hired you to review its internal controls for the purchase receipt storage and issuance of raw

  Management is considering purchasing an asset for 31000

management is considering purchasing an asset for 31000 that would have a useful life of 4 years and no salvage value.

  Determine the number of units of each product that will be

hubert tax service offers tax and consulting services to individuals and small businesses. data for fees and costs of

  A company leases equpiment from b company on january 1 2009

a company leases equpiment from b company on january 1 2009. the 10 year noncancelable lease agreement requires that

  Cyclone rentals borrowed 15550 from a bank for three years

cyclone rentals borrowed 15550 from a bank for three years. if the quoted rate apr is 8.83 percent and the compounding

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