Family Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow: BE(Click the icon to view the price and cost data.) Family Furniture has three sales representatives: Archie, Bill, and Colleen. Archie sold 110 tables with 4 chairs each. Bill sold 100 tables with 8 chairs each. Colleen sold 90 tables with 6 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. Chairs per table Sales representative: Archie X Tables sold 110 100 Total chairs sold 440 800 i Data Table 7 A Requirements - X Bill 000 Colleen 90 540 Calculate the total contribution margin for each sales representative. Tables Chairs 500 $ 295 30 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. Sales representative: Archie Bill Sales Price Variable manufacturing costs Sales commission (6%) Colleen Net sales revenue Variable costs Contribution margin Print Done Print Done