please answer in spreadsheet format

White Company sells flags with team logos, White has fixed costs of $198,000 per year plus variable costs of $15.40 per flag. Each flag sells for $22.00 Read the requirements, Requirements 1. Use the equation approach to compute the number of flags White must sell each year to break even. 2. Use the contribution margin ratio approach to compute the dollar sales White needs to earn $19,800 in operating income for 2018. (Round the contribution margin ratio to two decimal places.) 3. Prepare White's contribution margin income statement for the year ended December 31, 2018, for sales of 24,000 flags. (Round your final answers up to the next whole number.) 4. The company is considering an expansion that will increase fixed costs by 30% and variable costs by $2.20 per flag. Compute the new breakeven point in units and in dollars. Should White undertake the expansion? Give your reasoning, (Round your final answers up to the next whole number.) Requirement 1. Use the equation approach to compute the number of fags White must soll each year to break even First let the formula to compute the requiredits to break even Target profil Rearrange the formula you determined above and compute the required number of flags to break even The number of finge White must solch year to break even Requirement 2. Use the contribution margin ratio approach to compute the doors White needs to earn $10.800 in operating income for 2016. Round Contowodem Begin by showing the formula and then entering the amounts to calculate the required sales dolom 510,800 in operating income and then done to the whole lot for mame, $10.25 would be rounded to $11. Abbreviation und CM contribution margin) Required sales in Requirement 3. Prepare White's contribution margin income statement for the year ended December 31, 2018, for as of 24.000 fogs (Round your finalen up to the next Whole number.) (par aminot sign for an operatings) White Company Contribution Margint Income Statement Year Ended December 31, 2018 Operating income (Loss) Requirement. The company is considering an expansion that will increased costs by 30% and variable costs by $2.20 per la compute the new beer point in units and indoors. Should We undertake the expansion Give your reasoning (Round your finnes po the next whole number) (the equation approach Begin by selecting the formula to compute the required in units to break even under the pasion plan Torge proti Reage the form you determined above and compute the required number of fage to break ever under be expansion on Under the expansion plan, the breakeventinis would be Rags Under the expansion plan, the broken portin dollars would be Should White undertake the expansion? Give your ring While should only undertake the expansion expected prorom spansion