Fixed cost data E F G H For year of 2018 Intermountain. Mid Atlantic International Direct fixed expenses $ 61,32,428 $ Common allocated costs S 11,49,223 $ 78,22,483 $ 18,23,964 $ 7,12,540 $ 2,25,630 $ 95,54,760 $ 22,15,630 $ Great Plains Atlantic NortheasPacific Northwest Gulf Coast Southwest 40,23,981 $ 47,58,920 $ 62,58,745 $ 84,47,837 8,44,620 $ 9,94,630 $ 9,20,761 $ 12,24,657 This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questionm until you have asked for assistance from your instructor Using the data worksheet for Requirement. 1 in Kitchen Life, what is the contribution margin for customer number 291137 on 1/18/2015? (To find customer 201137 in Excel, in the Home nbbon, click on Find & Select and choose the option to Find) OA. $3.906.98 OB. $1,082 40 OC $5,880 38 OD. $1.331.75 Using the pivot table you created for Requirement 2 in Kitchen Life, what were total sales for 2016 in the Gulf Coast region? OA. $1,982,322.11 B. $15,270,451 25 OC. $12,684,022.13 OD. $19,427,495.57 Using the pivot table you created for Requirement 3 in Kitchen Life, what was the contribution margin for the Gulf Coast region in 2015? OA. $6,987,241.54 OB. $4,569,689.88 OC. $5,054,947.82 OD. $7.520,767.75 Using the pivot table you created for Requirement 4 in Kitchen Life, what was the most profitable brand in 2018, as measured by contribution margin? A. Au Courant OB. Classique Using the pivot table you created for Requirement 5 in Kitchen Life, what was the most profitable collection in 2018, for the Classique brand as measured by the contribution margin ratio? OA. Syracuse OB. Aiden OC. Rochester OD. Key West Using the data set in d Using the data set for requirement 6 in Kitchen Life, what was the segment margin for the Pacific Northwest region? OA. $185,500 OB. $7,119,819 OC. $2,360,899 OD. $3,911,361