Question

In: Accounting

Club Fitness is open from 5 A.M. until 9 P.M. Monday through Saturday. The gym is...

Club Fitness is open from 5 A.M. until 9 P.M. Monday through Saturday. The gym is closed on Sundays and holidays. Hank Hunkley, the owner, is considering offering 24-hour, 7-day-a-week, 365-days-a year access for an additional $59 a year per member. In exchange for the extra fee, the member would receive a magnetic fob that will unlock the door when the facility is closed. Each fob would cost Hank $5. Based on a survey taken of his 951 current members, Hank estimates that 36% of them will buy the fob to allow extended hours access. What is the total CLV associated with the 24/7/365 access plan for the current membership if the costs for personnel and equipment for the program are $9,548 annually?

Please post the Excel formula

Solutions

Expert Solution

   COMPUTATION OF CUSTOMER LIFE TIME VALUE                  
                      
NUMBER OF MEMBERS =                   951  
ESTIMATED MEMBERS OPT THE PLAN   =                   342   (951*36%)
FOB COST =                   1710   (5*342)
ADDITIONAL PACKAGE REVENUE =                   20178   (342*59)
PERSONNEL & EQUIPMENT COST FOR PROGRAMME =                   9548  
                      
CLV = (ANNUAL REVENUE PER CUSTOMER - CUSTOMER ACQUISITION COST)                      
=   (20178-9548-1710)                  
=   $8,920                
                      


Related Solutions

Flex Fitness is a health and fitness club that operates gym facilities through out the United...
Flex Fitness is a health and fitness club that operates gym facilities through out the United States.Flex Fitness members pay their membership dues annually.Selected fiscal- year information from the company's balance sheets follows(thousands). Selected Balance Sheet Data 2016 Defered membership Income( liability) 500,568 2017 453,881 During fiscal 2016, Flex Fitness collected$1,119,833 cash for membership fees.Calculate the membership fee revenue that flex fitness recognizied during the year.
An IV of 1,000 mL is to infuse from 6 a.m. until 2 p.m. The drop...
An IV of 1,000 mL is to infuse from 6 a.m. until 2 p.m. The drop factor is 15 gtt/mL. Calculate the flow rate.__________    At 11 a.m. you notice that 750 mL has infused. Recalculate the flow rate for the remaining solution. _____________ Does it fall within the safe range for recalculating an IV flow rate? ________
An IV of 1,000 mL is to infuse from 6 a.m. until 2 p.m. The drop...
An IV of 1,000 mL is to infuse from 6 a.m. until 2 p.m. The drop factor is 15 gtt/mL. Calculate the flow rate
A toll-free phone number is available from 9 a.m. to 9 p.m. for your customers to...
A toll-free phone number is available from 9 a.m. to 9 p.m. for your customers to register complaints about a product purchased from your company. Past history indicates that an average of 1.0 calls are received per minute. Complete parts (a)through (c). A.    what is the probability that during a 1 min period zero phone calls will be received? B.    what is the probability that during a 1 min period three or more phone calls will be received? C.    what is the maximum...
C&A makes two types of products using four machines from 9 a.m. to 5 p.m. each...
C&A makes two types of products using four machines from 9 a.m. to 5 p.m. each day. Product A visits machines 1, 2, and 4. Product B only visits machines 1 and 3. The capacity is 0.4 unit per minute at machine 1, 0.12 unit per minute at machine 2, 0.2 unit per minute at machine 3, and 0.3 unit per minute at machine 4. The demand per day is 40 units for Product A and 160 units for Product...
A toll-free phone number is available from 9 a.m. to 9 p.m. to customers who want...
A toll-free phone number is available from 9 a.m. to 9 p.m. to customers who want to register a complaint about a product purchased from your company. Past history indicates that, on average, 0.4 calls are received per hour. (a) Decide what would be an appropriate distribution to describe the process [2] of people making complaints. Give a justification of your answer, in at most one sentence. (b) Using the distribution in (a), find the following probabilities: (i) the probability...
During the first 13 weeks of the television season, the Saturday evening 8 p.m. to 9...
During the first 13 weeks of the television season, the Saturday evening 8 p.m. to 9 p.m. audience proportions were recorded as ABC 29%, CBS 28%, NBC 25%, and independents 18%. A sample of 300 homes two weeks after a Saturday night schedule revision yielded the following viewing audience data: ABC 95 homes, CBS 70 homes, NBC 89 homes, and independents 46 homes. Test with α = 0.05 to determine whether the viewing audience proportions changed. State the null and...
/ the case: spree cruise lines at 9:00 a.m. on monday, tara hoopes, manager of corporate...
/ the case: spree cruise lines at 9:00 a.m. on monday, tara hoopes, manager of corporate communications... Question: The Case: Spree Cruise Lines At 9:00 a.m. on Monday, Tara Hoopes, manager of corporate communicat... The Case: Spree Cruise Lines At 9:00 a.m. on Monday, Tara Hoopes, manager of corporate communications for Spree Cruise Lines, arrived at her office at Spree's corporate headquarters to find several messages already in her inbox. The New Orleans city attorney, Mike Litke, had contacted several...
During the first 13 weeks of the television season, the Saturday evening 8:00 p.m. to 9:00...
During the first 13 weeks of the television season, the Saturday evening 8:00 p.m. to 9:00 p.m. audience proportions were recorded as ABC 30%, CBS 27%, NBC 26%, and independents 17%. A sample of 300 homes two weeks after a Saturday night schedule revision yielded the following viewing audience data: ABC 94 homes, CBS 71 homes, NBC 88 homes, and independents 47 homes. Test with α = 0.05 to determine whether the viewing audience proportions changed. Find the value of...
During the first 13 weeks of the television season, the Saturday evening 8:00 P.M. to 9:00...
During the first 13 weeks of the television season, the Saturday evening 8:00 P.M. to 9:00 P.M. audience proportions were recorded as ABC 30%, CBS 28%, NBC 22%, and independents 20%. A sample of 300 homes two weeks after a Saturday night schedule revision yielded the following viewing audience data: ABC 93 homes, CBS 70 homes, NBC 82 homes, and independents 55 homes. Test with =.05 to determine whether the viewing audience proportions changed. Round your answers to two decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT