9. (14 points) A local restaurant is trying to evaluate opening a new location. This location...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
9. (14 points) A local restaurant is trying to evaluate opening a new location. This location is in a completely different neighborhood, and they do not expect any of their current customers to frequent the new location. They expect acquiring new customers will cost approximately $21 per customer gained, and they have set the ambitious goal of acquiring 3,500 customers in their initial marketing campaign. They assume no maintenance costs in years 2 and 3. They would like you to use a discount rate of 20% (10% interest rate and a risk factor of 2). They have provided you with a few additional pieces of information about their business, and would like your help evaluating the customer lifetime value after 2 years. Complete cells a - zb in the table below (shaded cells do not need to be completed): Revenues Year 1 Year 2 Year 3 Customers 3,500 i. Retention Rate 58% 70% 80% Average Purchase Size $35 $45 $55 Total Revenue j. Costs Variable Cost (%) 55% 55% 55% Variable Cost ($) k. Acquisition Cost ($) 1. Total Costs m. Gross Profit n. Discount rate applied O. NPV P. Cumulative NPV q. LTV r. a. b. C. d. e. f. g. h. 1 S. t. u. V. W. X. y. Z. za. zb. 9. (14 points) A local restaurant is trying to evaluate opening a new location. This location is in a completely different neighborhood, and they do not expect any of their current customers to frequent the new location. They expect acquiring new customers will cost approximately $21 per customer gained, and they have set the ambitious goal of acquiring 3,500 customers in their initial marketing campaign. They assume no maintenance costs in years 2 and 3. They would like you to use a discount rate of 20% (10% interest rate and a risk factor of 2). They have provided you with a few additional pieces of information about their business, and would like your help evaluating the customer lifetime value after 2 years. Complete cells a - zb in the table below (shaded cells do not need to be completed): Revenues Year 1 Year 2 Year 3 Customers 3,500 i. Retention Rate 58% 70% 80% Average Purchase Size $35 $45 $55 Total Revenue j. Costs Variable Cost (%) 55% 55% 55% Variable Cost ($) k. Acquisition Cost ($) 1. Total Costs m. Gross Profit n. Discount rate applied O. NPV P. Cumulative NPV q. LTV r. a. b. C. d. e. f. g. h. 1 S. t. u. V. W. X. y. Z. za. zb.
Expert Answer:
Answer rating: 100% (QA)
Revenues Year 1 Year 2 Year 3 Customers 3500 2030 1421 ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
A local restaurant is committed to providing its patrons with the best dining experience possible. On a recent survey, the restaurant asked patrons to rate the quality of their entrées....
-
A small-business owner is trying to evaluate the profitability of different segments. What are the key factors you would recommend she consider? Over what period of time would you recommend she...
-
A local restaurant is planning a study on demand for meals over holiday weekends. In calculating the desired sample size for the study, the restaurant's researcher decides to use a rule-of-thumb...
-
Svetlana (45) and Petro (43) are both employed and each have their own group benefit plan that provides family coverage. Svetlana's birthday is in June and Petro's is in December. The couple has one...
-
Mega Fitness, Inc., operates fitness centers throughout the Western states. Members pay a nonrefundable, initial fee of $100, as well as a monthly fee of $40. As an option, a member could reduce the...
-
Flanders Corporation's income statement for the year ended June 30, 20x8 and its comparative balance sheets as of June 30, 208 and 207 appear on the opposite page. During 208, the corporation sold...
-
Which of the following is least likely to be a purpose of a yearly staff appraisal meeting conducted between an information systems auditor and his/her manager? a. To determine the interpersonal...
-
Lauprechta Inc. has the following employees on payroll: Complete the table for taxes to be withhold for each pay period. Withholding Semimonthly Pavroll S4,800 7,250 $2,800 S3,600 Marital Status...
-
Provide two purposes for: an agency profile a personal profile a property profile
-
A business manufactures refrigerators for domestic use. There are three models: Lo, Mid and Hi. The models, their quality and their price are aimed at different markets. Product costs are computed...
-
A dependable company has offered to produce both jobs for Harris for $5,400 per output unit Harris may outsource (buy from the outside company) either Job A only, Job B only, or both jobs Which...
-
You're planning your Spring Break vacation. You're not going to a domestic destination, so select any country outside the United States and see how the cost of a $3,000 vacation will translate to the...
-
Building A is 170 feet shorter than Building B. The total height of the two buildings is 1520 feet. Find the height of each building. What is the height of Building A? n (Simplify your answer. Type...
-
Ivanhoe Corporation's fiscal year ends on November 30. The following accounts are found in its job order cost accounting system for the first month of the new fiscal year. Other data: 1. 2. 3. 4. On...
-
During the coronavirus pandemic, global supply chain issues caused the supply of new cars to shift left. Which role did price play in the new car market?
-
There is another good Y, and goods X and Y are substitutes. What happens to the demand curve of good Y, when the price of good X goes up? What would have happened if the goods X and Y were...
-
The data set Cold.csv contains the results of a study examining the relationship between taking cold medication and recovery from a cold. It contains two variables: Medicine taken : This variable...
-
Chapter 9 Stock Valuation at Ragan Engines Input area: Shares owned by each sibling Ragan EPS Dividend to each sibling Ragan ROE Ragan required return Blue Ribband Motors Corp. Bon Voyage Marine,...
-
Evaluate the decision to acquire Chicago Pacific Corporation (CPC). Do this both for the time of the decision, and for nowafter the factas a post mortem. Defend your overall conclusions.
-
Debate this issue: No nonprofit organization can ever attain the efficiency of a business firm that always has the bottom line to be concerned about.
-
You are a staff assistant to Ivester. It is 1998, and he has just assumed the top executive job with Coca-Cola. One of his first major decisions concerns raising soft-drink prices over 7 percent to...
-
Modify the spread sheet to handle development costs.
-
What is a What if analysis?
-
You developed an overhead budget for a construction company. Historically, the companys construction costs are 89% of revenues. What volume of work does the construction company need to achieve in...
Study smarter with the SolutionInn App