Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $100, when the gross margin on the drill averages 30 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if the customer retention rate is 20 percent? Round your answer to the nearest cent.. $ 2. What is the value of a loyal customer (VLC) if the customer retention rate increases to 80 percent? Round your answer to the nearest cent. $ 3. What is a 1 percent change in market share worth to the manufacturer if it represents 150,000 customers? Round your answers to the nearest dollar. 20 percent customer retention rate case: $ 80 percent customer retention rate case: $ 4. What do you conclude? If customer retention can be increased from 20 to 80 percent through better value chain performance, the economic payoff is quadrupled Check My Work Reset Problem 3 3 Value of a Loyal Customer 0 11 12 13 14 HESABARAN 15 16 17 18 19 20 21 22 23 24 A Revenue per unit Percent contribution margin to profit and overhead Repurchase frequency (purchases/year) Customer retention rate Number of customers representing 1 percent market share Buyer's life cycle VLC Value of a 1 percent change in market share Customer retention rate Buyer's life cycle VLC Value of a 1 percent change in market share B $100.00 30% 0.5 0.2 150,000 0.8 C D Formulas #N/A #N/A #N/A #N/A #N/A #N/A LLI E Excel Online Activity: VLC Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $100, when the gross margin on the drill averages 30 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What is the value of a loyal customer (VLC) if the customer retention rate is 20 percent? Round your answer to the nearest cent.. $ 2. What is the value of a loyal customer (VLC) if the customer retention rate increases to 80 percent? Round your answer to the nearest cent. $ 3. What is a 1 percent change in market share worth to the manufacturer if it represents 150,000 customers? Round your answers to the nearest dollar. 20 percent customer retention rate case: $ 80 percent customer retention rate case: $ 4. What do you conclude? If customer retention can be increased from 20 to 80 percent through better value chain performance, the economic payoff is quadrupled Check My Work Reset Problem 3 3 Value of a Loyal Customer 0 11 12 13 14 HESABARAN 15 16 17 18 19 20 21 22 23 24 A Revenue per unit Percent contribution margin to profit and overhead Repurchase frequency (purchases/year) Customer retention rate Number of customers representing 1 percent market share Buyer's life cycle VLC Value of a 1 percent change in market share Customer retention rate Buyer's life cycle VLC Value of a 1 percent change in market share B $100.00 30% 0.5 0.2 150,000 0.8 C D Formulas #N/A #N/A #N/A #N/A #N/A #N/A LLI E
Expert Answer:
Answer rating: 100% (QA)
Here as per the available data Repurchase frequency RF 05 Revenue per unit P 150 Gross margin CM 30 ... View the full answer
Related Book For
Basic Business Statistics Concepts and Applications
ISBN: 978-0132168380
12th edition
Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel
Posted Date:
Students also viewed these accounting questions
-
A customer in the wholesale garment trade is often entitled to a discount for a cash payment for goods. The amount of discount varies by vendor. A sample of 150 items selected from a population of...
-
The Cairo Wheat Supply Company, a client of yours, informs you that they recently lost several employees in their accounting department. They are strug- gling to prepare for their yearly audit, so...
-
Value of a Loyal Customer Conceptual Overview: Explore components that determine the value of a loyal customer. Maintaining customer loyalty, especially if repurchases are frequent, can obviously...
-
Certain merchandising transactions for Yule Park Gifts are listed below. November 2: Purchased 110 souvenir calendars at $9 each from Aloha Co. for cash Nov 4: Paid shipping costs $38 for the...
-
Table P-9 contains data on food expenditures, annual income, and family size for a sample of 10 families. a. Construct the correlation matrix for the three variables in Table P-9. Interpret the...
-
Explain how a scattergraph is used to separate a mixed cost into its fixed and variable components.
-
From the following balance sheets and further information you are to draw up a consolidated balance sheet as at 31 December \(19 \times 8\). P Balance Sheet as at 31 December 19X8 Fixed assets...
-
Comprehensive variance analysis Kitchen Whiz manufactures premium food processors. The following is some manufacturing overhead data for Kitchen Whiz for the year ended December 31, 2010: Budgeted...
-
Homework: Week One Question 7, E8-7 (book/s... HW Score: 26.52%, 2.92 of 11 points Save Score: 0 of 1 Green-Up Inc. contracts with a building manager to provide goods and services to enhance energy...
-
Two quality control technicians measured the surface finish of a metal part, obtaining the data in Table 4E.1. Assume that the measurements are normally distributed. (a)Test the hypothesis that the...
-
Explain the difference between an ordinary annuity and an annuity due. The optimal capital structure: a. depends on a theory developed by Modigliani and Miller. b. maximizes the current reward to the...
-
1. A kinematics track in your lab is almost frictionless. Suppose a toy car weighs 0.5 kg and is attached to a spring (k=10 N/m). Another toy car weighing 0.25 kg moving with 1.2 m/s collides with...
-
Suppose we are moving a box from (0,0) to (6,0) using 3 lbs of force, but we are trying to decide at which angle to apply that force. (a) If we apply that force at an angle of 13 radians to the...
-
During a rockslide, a 590 kg rock slides from rest down a hillside that is 750 m along the slope and 370 m high. The coefficient of kinetic friction between the rock and the hill surface is 0.45. (a)...
-
BSO, Incorporated, has current assets of $1,160,000 and current liabilities of $580,000, resulting in a current ratio of 2.0. Required: Calculate the current ratio and determine whether it will...
-
These are your peers who have read and replied, so you must read and respond with a final post. Final Responses must demonstrate you have read and appropriately responded to your peers' posts on your...
-
46. Basic Illustration Corp. produces and sells a single product. The selling price is P25 and the variable costs is 15 per unit. The corporation's fixed costs is 100,000 per month Average monthly...
-
Identify Thank You mission, strategy and core competencies. Identify strategy changes that have taken place at Thank You since its founding in 2008. Your answer must in text references and must be...
-
The data in FedReceipt represent federal receipts from 1978 through 2009, in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax,...
-
A quality characteristic of interest for a tea-bag-filling process is the weight of the tea in the individual bags. If the bags are underfilled, two problems arise. First, customers may not be able...
-
An agronomist designed a study in which tomatoes were grown using six different amounts of fertilizer: 0, 20, 40, 60, 80, and 100 pounds per 1,000 square feet. These fertilizer application rates were...
-
Use properties of the real numbers and mental math to calculate the following: 1. \(2 \times 13 \times 50\) 2. \(13+84+27\) 3. \(9 \times 16 \times 11\)
-
In each of the following, identify which property of the real numbers is being applied. 1. \(4+(8+13)=(4+8)+13\) 2. \(34 \times\left(\frac{1}{34} ight)=1\) 3. \(14+27=27+14\)
-
Find the value of the following numbers modulo 12 : 1. 34 2. 539 3. 156
Study smarter with the SolutionInn App