Generation 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.) Generation Furniture has three sales representatives: Archie, Brandon, and Crissy. Archie sold 50 tables with 4 chairs each. Brandon sold 90 tables with 8 chairs each. Crissy sold 110 tables with 6 chairs each Read the requirements. X Data Table 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 t Tables Chairs Chairs per table Sales representative: Tables sold Total chairs sold Sales Price 1,100 $ 50 50 4 200 Archie Variable manufacturing costs 90 847 6 720 Brandon Sales commission (8%) 4 88 110 6 660 Crissy Calculate the total contribution margin for each sales representative. Print Done X Sales representative: Brandon Crissy Archie Requirements Net sales revenue Variable costs 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. Contribution margin