Folk Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow m (Click the icon to view the price and cost data) Folk Furniture has three sales representatives Alfred, Brody, and Colleen Alfred sold 60 tables with 6 chairs each Brody sold 100 tables with 4 chairseach Coleen sold 70 tables with chars 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 Alfred Brody Colleen Tables Chairs Sales Price 02 900 $ Variable manufacturing costs 540 Sales commission (5%) 45 Print Done 440 Sales representative Tables sold Chairs per table Total chairs sold Archie Bill 720 Candy Calculate the total contribution margin for each sales representative. Sales representative: Archie Candy Net sales revenue 99,000 $ 117,000 $ 66,000 Variable costs 59,950 59,850 36,300 Contribution margin 39,050 s 57,150 $ 29,700 Now calculate the contribution margin ratio for each sales representative. (Round to two decimal places- Contribution margin Net sales revenue = Contribution margin ratio Archie 39,050 $ 99,000 39.44 % Bill 57,150 $ 117,000 48.85% Candy 29,700 66,000 45.00 % Requirement 2. Which sales representative has the highest contribution margin ratio? Explain why. CA Bill is the sales representative with the highest contribution margin ratio because this representative 0 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