Sam Quinn is a student at NEU Boston Campus and buys his groceries from Whole Foods...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sam Quinn is a student at NEU Boston Campus and buys his groceries from Whole Foods (WF). To encourage students to shop at Wholefoods, one time 'Welcome Coupon' of $500 is given to each student during the first year to spend on groceries at WF. The store wants to know how much each student spends at their stores and the associated costs to see the profitability of customers on an individual basis. Whole Foods started tracking income from individual students and Sam was one of the customers randomly chosen for this study. The table below shows Sam's revenue and the associated expenses the company incurred to acquire and maintain Sam as a loyal customer. As per company policy, strategies for customer retention are initiated if the projected LTV per customer is greater than 4 times the acquisition cost. Assume a discount rate of 10% ㅁ 1 2 3 4 5 6 7 8 9 10 1% 0.9901 0.9803 0.9706 0.9515 0.9610 0.9239 0.9421 0.9151 0.8885 0.9057 0.8626 0.8880 0.9327 0.8706 0.9235 0.8535 0.9143 0.9053 Sales Revenue COGS (as % of sales) A. Gross Margin 2% 0.9804 0.9612 S&M expenses Consumer Promotion. Advertising Sales Force Administrative overhead 0.9423 0.8368 0.8204 B. Total S and M C. General and Admin Expenses D. Customer Acquistion Cost Net Income (A-B-C-D) 3% 0.9709 Present Valueat 10% Present value (NET INCOME X PV) 0.9426 0.8375 0.8131 0.7894 0.7664 0.7441 as % of sales from PV Table 4% 0.9615 0.9524 0.9246 0.9070 0.8638 0.8227 0.8890 0.8548 0.8219 0.7903 0.7599 0.7307 0.7026 0.6756 5% 0.7835 0.6139 2020 6,200 61.60% $ 3,819 $ $ 2,381 2.4% $ 3.7% $ 0.7462 0.7050 0.7107 0.6651 0.6768 0.6274 0.6446 5.6% $ 2.7% $ $ 149 229 347 167 893 9% $ 558 $ 500 $ 430 6% 0.9434 0.9259 0.8900 0.8396 0.7938 0.7921 0.7473 0.9091 $390.91 1 0.5919 0.5584 8% 0.7350 0.8573 0.8265 0.6806 12% 0.9091 0.8929 0.7972 0.6302 10% 0,5003 0.7513 0.6830 0.6209 0.5645 0.5066 0.5835 0.5132 0.4524 0.5403 0.4665 0.4039 0.4241 0.7118 0.6355 0.3606 0.4632 0.3855 0.3220 2021 2022 2023 6,500 3,800 4,900 0.5674 2024 5,200 Sam Quinn is a student at NEU Boston Campus and buys his groceries from Whole Foods (WF). To encourage students to shop at Wholefoods, one time 'Welcome Coupon' of $500 is given to each student during the first year to spend on groceries at WF. The store wants to know how much each student spends at their stores and the associated costs to see the profitability of customers on an individual basis. Whole Foods started tracking income from individual students and Sam was one of the customers randomly chosen for this study. The table below shows Sam's revenue and the associated expenses the company incurred to acquire and maintain Sam as a loyal customer. As per company policy, strategies for customer retention are initiated if the projected LTV per customer is greater than 4 times the acquisition cost. Assume a discount rate of 10% ㅁ 1 2 3 4 5 6 7 8 9 10 1% 0.9901 0.9803 0.9706 0.9515 0.9610 0.9239 0.9421 0.9151 0.8885 0.9057 0.8626 0.8880 0.9327 0.8706 0.9235 0.8535 0.9143 0.9053 Sales Revenue COGS (as % of sales) A. Gross Margin 2% 0.9804 0.9612 S&M expenses Consumer Promotion. Advertising Sales Force Administrative overhead 0.9423 0.8368 0.8204 B. Total S and M C. General and Admin Expenses D. Customer Acquistion Cost Net Income (A-B-C-D) 3% 0.9709 Present Valueat 10% Present value (NET INCOME X PV) 0.9426 0.8375 0.8131 0.7894 0.7664 0.7441 as % of sales from PV Table 4% 0.9615 0.9524 0.9246 0.9070 0.8638 0.8227 0.8890 0.8548 0.8219 0.7903 0.7599 0.7307 0.7026 0.6756 5% 0.7835 0.6139 2020 6,200 61.60% $ 3,819 $ $ 2,381 2.4% $ 3.7% $ 0.7462 0.7050 0.7107 0.6651 0.6768 0.6274 0.6446 5.6% $ 2.7% $ $ 149 229 347 167 893 9% $ 558 $ 500 $ 430 6% 0.9434 0.9259 0.8900 0.8396 0.7938 0.7921 0.7473 0.9091 $390.91 1 0.5919 0.5584 8% 0.7350 0.8573 0.8265 0.6806 12% 0.9091 0.8929 0.7972 0.6302 10% 0,5003 0.7513 0.6830 0.6209 0.5645 0.5066 0.5835 0.5132 0.4524 0.5403 0.4665 0.4039 0.4241 0.7118 0.6355 0.3606 0.4632 0.3855 0.3220 2021 2022 2023 6,500 3,800 4,900 0.5674 2024 5,200
Expert Answer:
Related Book For
Canadian Income Taxation Planning And Decision Making
ISBN: 9781259094330
17th Edition 2014-2015 Version
Authors: Joan Kitunen, William Buckwold
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
During the first year of operations, Benjis Health Club had the following transactions pertaining to its common stock : Jan. 8 Issued 50,000 shares for cash at $10 per share. Aug. 1 Issued 25,000...
-
During the first year of operation, 2013, Ferrells Appliance recognized $261,000 of service revenue on account. At the end of 2013, the accounts receivable balance was $46,300. Even though this is...
-
Mookie The Beagle Concierge Trial Balance As of January 31,2023 is given 1001 Checking 1010 Money Market 1100 Accounts Receivable (A/R) 1210 Prepaid Expenses:Supplies 1220 Prepaid Expenses:Insurance...
-
What is the general decision rule for a firm considering undertaking a project? Give a real-life example.
-
What are the two possible attributions of poor performance? What are the implications of each?
-
State two different ways in which profit can be measured.
-
On July 1, 2011, a five-year agreement is signed between the City of Genoa and the Computer Leasing Corporation for the use of computer equipment not associated with proprietary funds activity. The...
-
Factory Overhead Volume Variance Bellingham Company produced 15,000 units of product that required 4 standard direct labor hours per unit. The standard fixed overhead cost per unit is $1.15 per...
-
Lydell Corporation currently operates in two states, P and Q. State P has a 5 percent tax rate and uses an equally weighted three-factor apportionment formula. State Q has a 9 percent tax rate and...
-
Use the following table: $ 397 $ 330 $ 375 $ 418 $ 412 349 449 493 211 301 230 532 348 283 581 Prepare a frequency distribution from the above weekly salaries of teachers at Moore Community College....
-
A solenoid has N turns of area A distributed uniformly along its length. When the current in this solenoid increases at the rate of 2.0 A/s, an induced emf of 75 mV is observed. Suppose the spacing...
-
7. NB Power plans to acquire a large water turbine for one of its dams by entering into a long-termlease agreement with the Atlantic Steel Ltd (ASL). ASL will provide the turbine under either of the...
-
Consider the following graph. Find (i) (ii) (iii) (iv) a f the number of vertices. www the number of edges. total degree. the number of loops. www. b e d
-
Blood flows through the aorta at an average speed of v = 19cm/s. The aorta is roughly cylindrical with a radius r = 17.6 mm. The volume rate of blood flow through the aorta is r 2 v . Calculate the...
-
1.In theory, what should happen to the plot of your range ( y ) vs. launch angle ( x ) as the launch speed is increased? (a).Clearly state which specific points should change, and which should remain...
-
One of the reasons organizational training programs on implicit bias do not work is that long-standing perceptions, stereotypes, and ideas are deeply ingrained in people. Therefore, occasional...
-
Research corporate acquisitions using Web resources and then answer the following questions: Why do firms purchase other corporations? Do firms pay too much for the acquired corporation? Why do so...
-
Explain how a non-capital loss is created and how it is treated for tax purposes.
-
The Canadian Queens Bank of Industry Ltd. is a large national Canadian bank. It has significant expansion opportunities. However, its ability to raise additional debt capital from bonds or debentures...
-
Harvey and Walter Bachynski operate a welding supply business as a partnership in Sackville, New Brunswick. Over the years, their sales territory has expanded steadily, as they maintain an efficient,...
-
B Arkwright started in business on 1 January 19X5 with 10,000 in a bank account. Unfortunately he did not keep proper books of account. He is forced to submit a calculation of profit for the year...
-
A J Kirkwood is a dealer who has not kept proper books of account. At 31 August 19X6 his state of affairs was as follows: During the year to 31 August 19X7 his drawings amounted to 7,560. Winnings...
-
25.4 P Balance Sheet as at 31 December 19X5 Investment in S: 30,000 shares bought 31.12.19X4 53,400 Fixed assets 60,000 Less Depreciation for year 6,000 54,000 Current assets 10,600 118,000 Share...
Study smarter with the SolutionInn App