mart Page Layout Formula Ravi Help PROTECTED VIEW Belastoman comes you to stay B18 A D 1 E 3 Amount 5 7 8 DATA Description Sales price per unit Variable cost per unit Contribution margin per unit Total Fed costs Profit at breakeven Target profit 9 10 11 14 Requirement1 Use the contribution margin approach to compute the company's monthly breakeven in units. Reference the cells in the DATA table above when constructing your breakeven formula below. Do not use target profit in this calculation. Formatase number (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong 15 16 12 18 Breakeven in Units 19 20 Requirement 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cells) in your formula for contribution margin ratio below. Do not use target profit in these calculations Format the ratio as a percentage and the breakeven in dollars as accounting number format in whole dollars. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong! 23 Contribution margin ratio Breakeven in Dollars 26 29 31 32 33 Requirement Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of 55,000 Reference the cells) in the DATA table above when constructing your target sales level formula below. Formatas number Use the Excel ROUNDUP Function to obtain whole units to reach the target operating income Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wton Target sales level fin units) 33 37 31 39 HINTS Instructions ENTERANSWERS Type here to search O DI E G Data Faye Lyout Formulas Review View Help PROTECTED VIEW Be care-les from the Internet con contain viruses. Unless you need to edit is safe to stay in Protected View Al Enable Editing fx Cost-Volume-Profit Analysis A D F G H B M N 9 Requirements: 10 1 Use the contribution margin approach to compute the company's monthly breakeven point in units. 12 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 13 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000. 14 15 Excel Skills: 16 1 Create formulas with cell references, 17 18 2 Format the cells as accounting number format or percent style. 19 3 Use the Excel function ROUNDUP to obtain units in whole numbers needed to achieve a minimum target operating income. 21 Saving & Submitting Solution 22 1 Save file to desktop. 22 . Great folder on desktop, and label COMPLETED EXCEL PROJECTS 24 2 Upload and submit your file to be graded 2. Navigate back to the activity window screen where you downloaded the initial spreadsheet 26 Click Choose button under step 3, locate the file you just saved and dick Open 27 Click Upload button under step 3 26 d. Click Submit button under step 4 25 30 31 Viewing Results 32 1 Click on Results tab in My Accountinglab 2 Click on the Assignment you were working on 34 Click on Project link this will bring up your Score Card 35 4 Within Score Card window, dick on Live Comments Report (lower right) to download spreadsheet with feedback 36 12 38 39 40 + 41 42 45 Instructions INTERANSWERS D F 1 Amount DATA Description Sales price per unit Variable cost per unit Contribution margin per unit Total fixed costs Profit at breakeven Target profit Requirement 1 Use the contribution margin approach to compute the company's monthly breakeven in units. Reference the cell(s) in the DATA table above when constructing your breakeven formula below. Do not use target profit in this calculation. Format as a number (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Breakeven in Units Requirement 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula for contribution margin ratio below. Do not use target profit in these calculations. Format the ratio as a percentage and the breakeven in dollars as accounting number format in whole dollars. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Contribution margin ratio Breakeven in Dollars Requirement 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000, Reference the cells) in the DATA table above when constructing your target sales level formula below. Formatas number Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong) Target sales level (in units) PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, in safe to stay in Protected View Tnable Editing A1 f Cost-Volume-Profit Analysis B M N 8 9 Requirements: 10 1 Use the contribution margin approach to compute the company's monthly breakeven point in units. 11 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 12 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000 13 14 15 Excel Skills: 16 1 Create formulas with cell references. 17 2 Format the cells as accounting number format or percent style. 18 3 Use the Excel function ROUNDUP to obtain units in whole numbers needed to achieve a minimum target operating income. 19 20 21 Saving & Submitting Solution 22 1 Save file to desktop. 23 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 24 2 Upload and submit your file to be graded 25 a. Navigate back to the activity window screen where you downloaded the initial spreadsheet 26 b. Click Choose button under step 3, locate the file you just saved and click Open 27 c. Click Upload button under step 3 28 d. Click Submit button under step 4 29 30 31 Viewing Results 32 1 Click on Results tab in MyAccountinglab 33 2 Click on the Assignment you were working on 34 3 Click on Project link; this will bring up your Score Card 35 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback 36 37 38 39 40 41 mart Page Layout Formula Ravi Help PROTECTED VIEW Belastoman comes you to stay B18 A D 1 E 3 Amount 5 7 8 DATA Description Sales price per unit Variable cost per unit Contribution margin per unit Total Fed costs Profit at breakeven Target profit 9 10 11 14 Requirement1 Use the contribution margin approach to compute the company's monthly breakeven in units. Reference the cells in the DATA table above when constructing your breakeven formula below. Do not use target profit in this calculation. Formatase number (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong 15 16 12 18 Breakeven in Units 19 20 Requirement 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cells) in your formula for contribution margin ratio below. Do not use target profit in these calculations Format the ratio as a percentage and the breakeven in dollars as accounting number format in whole dollars. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong! 23 Contribution margin ratio Breakeven in Dollars 26 29 31 32 33 Requirement Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of 55,000 Reference the cells) in the DATA table above when constructing your target sales level formula below. Formatas number Use the Excel ROUNDUP Function to obtain whole units to reach the target operating income Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wton Target sales level fin units) 33 37 31 39 HINTS Instructions ENTERANSWERS Type here to search O DI E G Data Faye Lyout Formulas Review View Help PROTECTED VIEW Be care-les from the Internet con contain viruses. Unless you need to edit is safe to stay in Protected View Al Enable Editing fx Cost-Volume-Profit Analysis A D F G H B M N 9 Requirements: 10 1 Use the contribution margin approach to compute the company's monthly breakeven point in units. 12 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 13 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000. 14 15 Excel Skills: 16 1 Create formulas with cell references, 17 18 2 Format the cells as accounting number format or percent style. 19 3 Use the Excel function ROUNDUP to obtain units in whole numbers needed to achieve a minimum target operating income. 21 Saving & Submitting Solution 22 1 Save file to desktop. 22 . Great folder on desktop, and label COMPLETED EXCEL PROJECTS 24 2 Upload and submit your file to be graded 2. Navigate back to the activity window screen where you downloaded the initial spreadsheet 26 Click Choose button under step 3, locate the file you just saved and dick Open 27 Click Upload button under step 3 26 d. Click Submit button under step 4 25 30 31 Viewing Results 32 1 Click on Results tab in My Accountinglab 2 Click on the Assignment you were working on 34 Click on Project link this will bring up your Score Card 35 4 Within Score Card window, dick on Live Comments Report (lower right) to download spreadsheet with feedback 36 12 38 39 40 + 41 42 45 Instructions INTERANSWERS D F 1 Amount DATA Description Sales price per unit Variable cost per unit Contribution margin per unit Total fixed costs Profit at breakeven Target profit Requirement 1 Use the contribution margin approach to compute the company's monthly breakeven in units. Reference the cell(s) in the DATA table above when constructing your breakeven formula below. Do not use target profit in this calculation. Format as a number (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Breakeven in Units Requirement 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula for contribution margin ratio below. Do not use target profit in these calculations. Format the ratio as a percentage and the breakeven in dollars as accounting number format in whole dollars. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Contribution margin ratio Breakeven in Dollars Requirement 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000, Reference the cells) in the DATA table above when constructing your target sales level formula below. Formatas number Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked wrong) Target sales level (in units) PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, in safe to stay in Protected View Tnable Editing A1 f Cost-Volume-Profit Analysis B M N 8 9 Requirements: 10 1 Use the contribution margin approach to compute the company's monthly breakeven point in units. 11 2 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 12 3 Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $5,000 13 14 15 Excel Skills: 16 1 Create formulas with cell references. 17 2 Format the cells as accounting number format or percent style. 18 3 Use the Excel function ROUNDUP to obtain units in whole numbers needed to achieve a minimum target operating income. 19 20 21 Saving & Submitting Solution 22 1 Save file to desktop. 23 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 24 2 Upload and submit your file to be graded 25 a. Navigate back to the activity window screen where you downloaded the initial spreadsheet 26 b. Click Choose button under step 3, locate the file you just saved and click Open 27 c. Click Upload button under step 3 28 d. Click Submit button under step 4 29 30 31 Viewing Results 32 1 Click on Results tab in MyAccountinglab 33 2 Click on the Assignment you were working on 34 3 Click on Project link; this will bring up your Score Card 35 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback 36 37 38 39 40 41