do all requirements

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: Al, Bob, and Colleen. Al sold 110 tables with 4 chairs each. Bob sold 100 tables with 8 chairs each. Colleen sold 60 tables with 6 chairs each Read the requirements Requirement 1. Calculate the total conbribution 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 rep: Al Bob Colleen Calculate the total contrbution margin for each sales representative Tables sold Chairs per table Total chairs sold Data Table 110 100 60 800 360 TablesChairs Sales Price Variable manfacturing costs Sales commission (9%) $900$100 Bob Colleen Al 549 Saies representative Sales revenue Variable costs Contribution margin 81 Requirements 1. Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places) Which sales rep has the highest contribution margin ratio? Explain why 2. Enter any number in the edit fields and then click Check Answer Print Done