P21-29A

Clan Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow:

Clan Furniture has three sales representatives: Allen, Brian, and Camara. Allen sold 80 tables with 6 chairs each. Brian sold 90 tables with 8 chairs each. Camara sold 100 tables with 4 chairs each.

i Requirements - 1. Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places). 2. Which sales representative has the highest contribution margin ratio? Explain why Before calculating the total contribution margin, begin by identifying and calculating the total number of tables ar Sales representative: Total chairs sold Tables sold 80 Chairs per table 6 Allen 480 Brian 90 8 720 Camara 100 4 400 Calculate the total contribution margin for each sales representative. Brian Camara $ Sales representative: Net sales revenue Variable costs Contribution margin Allen 126,400 $ 193,200 142,000 156,600 $ 78,750 66,800 78,750 Data Table X Tables Chairs Sales Price $ 1,100 $ 80 Cai 715 20 Variable manufacturing costs Sales commission (5%) 55 4. Print Done