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		58,000			38,000			20,000
Average customer representative salary				$	78,000		$	78,000
Promotion costs	$	4,700,000
Average gross margin per customer				$	700		$	290

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.

b. Which customers are more profitable?

If possible please include formulas on how to get all the numbers, it would be greatly appreciated! Thank you!