Using the data worksheet for Requirement 1 in Design Concepts, what is the contribution margin for customer number 389202 on 10 / 18/ 2015? (To find customer 389202 in Excel, in the Home ribbon, click on Find & Select and choose the option to Find.) O A. $3,093.57 O B. $420.00 O C. $777.00 O D. $1,197.00 Using the pivot table you created for Requirement 2 in Design Concepts, what were total sales for 2016 in the Far West region? O A. $15, 141,657.14 O B. $21,226,248.06 O C. $15,240,519.32 O D. $1,962,266.16Using the pivot table you created for Requirement 3 in Design Concepts, what was the sales revenue for the Plains region in 201?? O A. $6,824.?5326 O B. $10,5?9.131.63 O C. $23,011.60832 O D. 981140333439 Using the pivot table you created for Requirement 4 in Design Concepts, what was the most protable brand in 2018, as measured by contribution margin? 0 A. Regal O B. Casual Using the pivot table you created for Requirement 5 in Design Concepts, what was the least protable collection in 2018. forlhe Regal brand as measured by the contribution margin ratio? 0 A. Key'West O B. Venezia Using the pivot table you created for Requirement 5 in Design Concepts, what was the least profitable collection in 2018, for the Regal brand as measured by the contribution margin ratio? O A. Key West O B. Venezia O C. Hadley O D. Escutcheons Using the data set for requirement 6 in Design Concepts, what was the operating income (loss) for the West Central region? O A. $13,237,816 O B. $3,879,974 O C. $(946,911) O D. $2,222,642A B D E F G H Fixed cost data For year of 2018 Plains Atlantic Coastal World West Central Eastern Coastal |Western Coastal Southeastern Far West Direct fixed expenses 4,995,613 5 7,225,687 5 640,578 5 9,357,842 5 3,750,480 5 4,357,655 5 6,374,958 8,480,150 Common allocated costs 1,113,622 5 1,154,622 5 175,650 5 1,657,332 5 785,332 927,786 5 964,120 5 1,335,945X Check Figures Requirement 1: Cell M131 $377.34 Requirement 2: Cell C9 $41,931,754.92 (Grand Total) Requirement 3: Cell D7 $62,900, 145.84 Requirement 4: Cell F7 $196,586,643.89 (Grand Total) Requirement 5: Cell C90 40.20% Requirement 6: Cell G10 $1,797,257.00