Family Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow (Click the icon to view the price and cost data.) Family Furniture has three sales representatives: Archie, Brody, and Carla. Archie sold 90 tables with 6 chairs each. Brody sold 80 tables with 8 chairs each. Carla sold 50 tables with 4 chairs each Read the requirements Requirement 1. Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places). Before calculating the total contribution margin, begin by identifying and calculating the total number of tables and chairs sold by each sales representative for the period. Sales representative: Archie Brody Carla Tables sold Chairs per table Total chairs sold 90 6 540 80 50 8 640 4 200 Calculate the total contribution margin for each sales representative. Sales representative: Net sales revenue Variable costs Archie Brody Carla Contribution margin Now calculate the contribution margin ratio for each sales representative. (Round to two decimal places-the nearest hundredth percent-X.XX%) Archie Brody Contribution margin ratio % % Carla Requirement 2. Which sales representative has the highest contribution margin ratio? Explain why. Yis the sales representative with the highest contribution margin ratio because this representative: Data table Tables Chairs Sales Price $ 1,500 $ 40 Variable manufacturing costs 1,200 12 Sales commission (10%) 150 4 Print Done 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. -