Question

Carmel Company has a frequent buyer program for its customers, where the customers can attain an...

Carmel Company has a frequent buyer program for its customers, where the customers can attain an “elite” level based on the number of orders and the total revenue of the orders. There are two elite levels: Platinum and Titanium. The benefits of elite membership include discounts and access to special customer service representatives who can resolve problems. The company has one full-time customer representative per 200 Titanium customers and one full-time customer representative per 2,000 Platinum customers. Customer representatives receive salaries plus bonuses of 2 percent of customer gross margin. Carmel spends 80 percent of its promotion costs on Titanium customers to encourage their loyalty.

  

Customer Costs Total Titanium Platinum
Number of customers 27,000 7,000 20,000
Average customer representative salary $ 60,000 $ 60,000
Promotion costs $ 2,050,000
Average gross margin per customer $ 1,510 $ 285

   

Required:

a. Calculate the totals of the items below for both titanium and platinum customers, as well as the excess of gross margin over customer costs for each category.

b. Which customers are more profitable?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SOLUTION

A.

Titanium Platinum
Total gross margin (a) (7,000*$1,510) , (20,000*$285) 10,570,000 5,700,000
Customer representative salaries & bonuses (b) 2,311,400 714,000
Promotion costs (c) (2,050,000*80%), (2,050,000*20%) 1,640,000 410,000
Excess of gross margin over customer cost (a-b-c) 6,618,600 4,576,000

Working note-

Titanium - ($60,000*7,000/ 200) + (2%*10,570,000)

= 2,100,000 + 211,400 = 2,311,400

Platinum - (60,000*20,000/2,000) + (2%*5,700,000)

= 600,000 + 114,000 = 714,000

B.  Titanium customers are more profitable.

Add a comment
Know the answer?
Add Answer to:
Carmel Company has a frequent buyer program for its customers, where the customers can attain an...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Carmel Company has a frequent buyer program for its customers, where the customers can attain an...

    Carmel Company has a frequent buyer program for its customers, where the customers can attain an “elite” level based on the number of orders and the total revenue of the orders. There are two elite levels: Platinum and Titanium. The benefits of elite membership include discounts and access to special customer service representatives who can resolve problems. The company has one full-time customer representative per 200 Titanium customers and one full-time customer representative per 2,000 Platinum customers. Customer representatives receive...

  • SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time...

    SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time customer representative per 1,000 Gold customers and one full-time customer representative per 10,000 Silver customers. Customer representatives receive salaries plus bonuses of 10 percent of customer gross margin. SkiBlu spends 80 percent of its promotion costs on Gold customers to encourage their loyalty. Customer Costs Total Gold Silver Number of customers 110,000 40,000 70,000 Average customer representative salary $ 80,000 $ 80,000 Promotion costs...

  • SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time...

    SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time customer representative per 1,000 Gold customers and one full-time customer representative per 10,000 Silver customers. Customer representatives receive salaries plus bonuses of 10 percent of customer gross margin. SkiBlu spends 90 percent of its promotion costs on Gold customers to encourage their loyalty. Customer Costs Total Gold Silver Number of customers 49,000 39,000 10,000 Average customer representative salary $ 79,000 $ 79,000 Promotion costs...

  • SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time...

    SkiBlu, Ltd., divides its customers into Gold customers and Silver customers. The company has one full-time customer representative per 1,000 Gold customers and one full-time customer representative per 10,000 Silver customers. Customer representatives receive salaries plus bonuses of 10 percent of customer gross margin. SkiBlu spends 80 percent of its promotion costs on Gold customers to encourage their loyalty. Total 68,000 Customer Costs Number of customers Average customer representative salary Promotion costs Average gross margin per customer Gold 48,000 $88,000...

  • Customer Costs Total Gold Silver Number of customers 110,000 40,000 70,000 Average customer representative salary $...

    Customer Costs Total Gold Silver Number of customers 110,000 40,000 70,000 Average customer representative salary $ 80,000 $ 80,000 Promotion costs $ 4,900,000 Average gross margin per customer $ 710 $ 310    Required: a. Calculate the totals of the items below for both gold and silver customers, as well as the excess of gross margin over customer costs for each category. (Do not round intermediate calculations.) Gold Silver total gross margin customer representative salaries and bonuses promotion costs excess...

  • can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and...

    can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and M (Monetary value) related information for the representative 10 customers of a home store. Recency is the number of months since the last purchase made by the customer. Frequency is the average number of times the customer comes to the store for purchase. Monetary value is the average dollar value of the transactions that the customer makes with the store. The...

  • Starcups Coffee Company is launching a new sustainability Initiative that would reward customers for purchasing a...

    Starcups Coffee Company is launching a new sustainability Initiative that would reward customers for purchasing a reusable cup. During the cup promotion, customers would pay an extra $100 for the reusable cup and would receive a 25 percent discount each time they return with the cup to buy a cup of coffee. Each week Starcups serves 40,000 customers who purchase an average of 2.5 cups of coffee per week (100,000 cups totall. Starcups's contribution margin income statement for a typical...

  • Colleen Company has gathered the following data pertaining to activities it performed for two of its...

    Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. 3 3,000 Kate Co. 40 180 Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls 1 60 11 3 120 6 Colleen sells its products at $180 per unit. The firm's gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30...

  • Colleen Company has gathered the following data pertaining to activities it performed for two of its...

    Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. 3 3,000 Kate Co. 40 180 Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls 1 60 11 3 120 6 Colleen sells its products at $180 per unit. The firm's gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30...

  • nerrod Company sells its products at $840 per unit, net 30. The firm's gross margin ratio...

    nerrod Company sells its products at $840 per unit, net 30. The firm's gross margin ratio is 40 percent. The firm has estimated the following operating costs: Activity Cost Driver and Rate Sales calls $ 570 per visit Order processing $ 185 per order Deliveries $ 80 per order + $0.50 per mile Sales returns $ 95 per return and $3.0 restocking per unit returned Nerrod Company has gathered the following data pertaining to activities it performed for two of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT