Requirement 7: Complete the hatione Fizement Recuirement 8 Use the kifocmation proviond beciow aiong with your ncome statonetif trick fequitment f2. the Use yout mived cost formulas io creste your contrieution tomat statement:. numbers. Round to 2 decimul pilsces where approprate Lse your macd cost focmitas fa create yoel contr bution format ataterment Felerence the DATA cefs) as proviced to complete your statement below Foemat as mumbers Round to 2 decimat places stiele agyragride DATA (copy from Requirement 8) Descriotion Your answers murst be supported with cakculations and formulas. No credit will be gren for simply placing numbers in the an Requirement 9 Use the contribution margin approach to compute the campanyes annust broskone in unts: Polocence the DATA cell(s) in your formula betow. Format as a number. Aways reler to the original data. Broakeven in Unats Requirement 10 Use the contribution masgin ratio approach to compeile the trooweven poit is sales dolas: Reference the DATA cell(s) in your formula below. Fonnat os a nunber. Aways reter to the original data. Focmat the rabio as a perceet, breokeven in dolars as accoutiong namber format in whole dotars Requirement 11 Use the coritribution margin apprtach to conpule the annual sales kves (in unts) requared to earn a target operating income (profit). of 5664,000 Roference the DATA cel(5) in your formuls below. Formut as a number. Alwerss refor to the onginal dafa Use the Excel RoUvDUP fanction to ottain whole units to reach the target operaterg income. Targot saies level (in units) Requirement 12 Use the contribusion margin approach to compelt the anchust increase in operating income it saies increase by 1 unit. Referance the DATA cell(s) in your formuda betow. Foninat as a number. AWeys reler to the onginal data. Use the Excel RoUNDUP function to ablain whick unts or dolars Requirement 13 Use the coritibeition margin npproach to compute the change in not operatieg income if saks tall by 91 units Roferonce the DATA cells) in your fomtuls below. Format as a numbor Aweys refor fo the original data . Use the Excel ROUNDUP function to obtain Whicke inits or dollars Requirement 14 Use the contribution margin approach to compude the change in fed operating income if the seling frice por unit mereases by 521 . por unit and the sales voluine docreases by 51 units Reference the DATA cols(s) in your formula bohow. Fomat as number Use the Excel ROUNDUP function to obthin which inits of dolars: Requirement 15 Use tie contribution margin approach in compute the chango in not eperatung income it the saks increase by 56% and adwetising spending is increesod by $5,600 Reference the DATA cells) in your formula below Format as a nember Aways refor to the original data Use the Excel ROUNDUP fimetion to obtain whoile units or dolars Requiremsent 16 Use the contribution margin approach to cacculale margia of saloly in dolars, as a percent and in units Relerence the DATA cel(s) in your formata below. Fomat as a number. Always rolor to the onginal date Use the Excel Pouldoup function to obtain wholo units or dollars Requirement 17 increase 1195? What is the Now Operativi income? Peforence the DATA cel(s) in your formata below Forinal as a nember. Aways refor to the original dita Requirement 7: Complete the hatione Fizement Recuirement 8 Use the kifocmation proviond beciow aiong with your ncome statonetif trick fequitment f2. the Use yout mived cost formulas io creste your contrieution tomat statement:. numbers. Round to 2 decimul pilsces where approprate Lse your macd cost focmitas fa create yoel contr bution format ataterment Felerence the DATA cefs) as proviced to complete your statement below Foemat as mumbers Round to 2 decimat places stiele agyragride DATA (copy from Requirement 8) Descriotion Your answers murst be supported with cakculations and formulas. No credit will be gren for simply placing numbers in the an Requirement 9 Use the contribution margin approach to compute the campanyes annust broskone in unts: Polocence the DATA cell(s) in your formula betow. Format as a number. Aways reler to the original data. Broakeven in Unats Requirement 10 Use the contribution masgin ratio approach to compeile the trooweven poit is sales dolas: Reference the DATA cell(s) in your formula below. Fonnat os a nunber. Aways reter to the original data. Focmat the rabio as a perceet, breokeven in dolars as accoutiong namber format in whole dotars Requirement 11 Use the coritribution margin apprtach to conpule the annual sales kves (in unts) requared to earn a target operating income (profit). of 5664,000 Roference the DATA cel(5) in your formuls below. Formut as a number. Alwerss refor to the onginal dafa Use the Excel RoUvDUP fanction to ottain whole units to reach the target operaterg income. Targot saies level (in units) Requirement 12 Use the contribusion margin approach to compelt the anchust increase in operating income it saies increase by 1 unit. Referance the DATA cell(s) in your formuda betow. Foninat as a number. AWeys reler to the onginal data. Use the Excel RoUNDUP function to ablain whick unts or dolars Requirement 13 Use the coritibeition margin npproach to compute the change in not operatieg income if saks tall by 91 units Roferonce the DATA cells) in your fomtuls below. Format as a numbor Aweys refor fo the original data . Use the Excel ROUNDUP function to obtain Whicke inits or dollars Requirement 14 Use the contribution margin approach to compude the change in fed operating income if the seling frice por unit mereases by 521 . por unit and the sales voluine docreases by 51 units Reference the DATA cols(s) in your formula bohow. Fomat as number Use the Excel ROUNDUP function to obthin which inits of dolars: Requirement 15 Use tie contribution margin approach in compute the chango in not eperatung income it the saks increase by 56% and adwetising spending is increesod by $5,600 Reference the DATA cells) in your formula below Format as a nember Aways refor to the original data Use the Excel ROUNDUP fimetion to obtain whoile units or dolars Requiremsent 16 Use the contribution margin approach to cacculale margia of saloly in dolars, as a percent and in units Relerence the DATA cel(s) in your formata below. Fomat as a number. Always rolor to the onginal date Use the Excel Pouldoup function to obtain wholo units or dollars Requirement 17 increase 1195? What is the Now Operativi income? Peforence the DATA cel(s) in your formata below Forinal as a nember. Aways refor to the original dita
