Excel Problem for Test #2 (20 points total) Upload your Excel le to Blackboard when you nish. Make sure that your le has your last name in its title: MyLastName Test2 Excel ____________________________________________________________ Certain Company sells three dierent products. Product Alpha sells for $30.00, and this product has a contribution margin of 30%. Product Beta on the other hand has CM in dollars of $23.00 and as a percentage of 35%. Product Gamma has variable costs of $42.50 and a CM of $8.74. Certain Company had xed expenses of $80,000. ____________________________________________________________ Required: 1) Multi-Product Income Statement Construct a multi-product Contribution Format Income Statement for Certain Company. Assume that in total 10,000 units were sold. The product mix is 40% Alpha, 24% Beta, and 36% Gamma. 2) Break-Even Point At the product mix from the part 1, what is the break-even point in dollar sales? Prove it with another income statement using the total unit sales that you just calculated. (the NOI should round to $0) 3) Taget Prot Ownership of Certain Company wants the company to earn a pre-tax Net Operating Income of $100,000. Using the same product mix from part 1, create another multi-product Contribution Format Income Statement that results in a NOI of $100,000. (dont fret if NOI rounds to $100,001) 4) Dynamic Spreadsheet Each of the preceding parts of this problem are worth ve points. You should have a total of three income statements. If the spreadsheets you create are dynamic meaning that unless a cell is an input cell it must either reference another cell or be a calculation then I will add ve more points. The entire problem is worth twenty points. You should keep everything (all requirements) on a single sheet.