Sibling 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.) Sibling Furniture has three sales representatives: Archie, Brad, and Crystal. Archie sold 90 tables with 8 chairs each. Brad sold 100 tables with 4 chairs each. Crystal sold 80 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. Sales representative Archie Brad Crystal Tables sold 100 Chairs per table Total chairs sold 720 400 480 Data Table Calculate the total contribution margin for each sales representative Tables Chairs Sales Price $ 500 $ 100 Sales representative Archie Brad Crystal Net sales revenue 45,000 50,000 40.000 Variable manufacturing costs Sales commission (10%) 300 35 50 822 10 72,000 40,000 45,000 Variable costs Contribution margin 64,800 40,000 $ 38,400 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 Enter any number in the edit fields and then click Check Answer. parts 2 remaining Clear All Check Answer