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: Alfred, Bob, and Cait. Alfred sold 100 tables with 4 chairs each. Bob sold 70 tables with 6 chairs each. Cait sold 60 tables with 8 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 Tables sold Chairs per table Total chairs sold Data table Bob Alfred 100 70 60 6 400 420 480 Cait 8 Tables Chairs S 800 S 100 Bob Calt Calculate the total contribution margin for each sales representative. Salos representative Alfred Net sales revenue 400 420 65 65 Variable costs Contribution margin 26000 Sales Price Variable manufacturing costs Sales commission (9%) 508 480 65 26 72 9 27300 31200 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 Print Done