Please display all cell refrences

DATA (copy from Requirement B) Description Your answers must be supported with calculations and formulas. No credit will be given for simply placing numbers in the answer blocks. Requirement 9 Use the contribution margin approach to compute the company's annual broakevon in units Reference the DATA cell(s) in your fommula below. Format as a number. Always refer to the original data Breakcven in Units Requirement 10 Uso the contritudion margin ratio approach to computo the breakiven point in sales dollars Relerence the DATA cel(s) in your formula below Format as a number. Aways refor to the original data Format the ratio as a percent, broakewon in doltars as accounting number format in whole dolars Requirement 11 Use the contribution margin approach to compute the annual saks level (in units) required to earn a target operating income (profi) of $670,000 Reference the DATA cel(s) in your formula below Format as a mumber. Always refer to the onginal data Use the Excol ROUNDUP function to obtain whion units to roach the target operating inceme Use the contrbution margin approach to compute the annual increase in net operating income if sales increase by 1 unit. Reference the DATA cell(s) in your formula below. Format as a number. Always fefer to the oniginal data Use the Excol ROUNDUP function to obtain wholo units or dolars Requirement 13 Use the contribution margin approach to compute the change in net operating income if the selling price increases by 2%, raw material costs increase by 5% and sales fall by 95 unts Relerence the DATA cel(s) in your formula below. Format as a number. Aways refer to the original data Use the Excel ROUNDUP function to obtain whole units or dollars Requirement 14 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $25 per unit and the sales fall by 55 units Reference the DATA cell(s) in your formula below. Format as number Use the Excel ROUNDUP function to obtain whole units or dollars Requirement 15 Use the contibution margin approach to compute the change in net operating income if the sales increase by 6% and advertising spending is increased by $6,000. Relerence the DATA cell(s) in your formula below. Format as a number. Aways refer to the original data Use the Excel ROUNDUP function to obtain whole units of dollars Requirement 16 Use the contribution margin approach to calculate margin of safety in dollars, as a percent and in units. Reference the DATA cell(s) in your formula below. Format as a number. Aways refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dolars Requirement 17 Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 15% ? What is the New Operating Income? Reference the DATA cel(s) in your formula below. Format as a number. Always refer to the original data