help please show formula's and steps . can not figure out trying to learn

X Arial 12 ' ' 2 Wrap ste BIU Merge AA- x fx A D E merr Vorwurm Y 7. Prepare income statements in good form for Boyd for 2024. The company sold 500 units in 2024. Use the information given to calculate the following for 2024 Use the information provided, the high low method and the contribution margin 8 approach to prepare a contribution format income statement Use the contribution margin approach to compute the company's annual 9 breakeven point in units. Use the contribution margin ratio approach to compute the breakeven point in 10 sales dollars Use the contribution margin approach to compute the annual sales level (in units) required 11 to eam a target operating income of $655,000 Use the contribution margin approach to compute the annual increase in net operating income if sales increase to 501 units. 12 14 Use the contribution margin approach to compute the change in net operating income if sales fall by 90 units. 13 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $20 per unit and the sales volume decreases by 50 units. Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and advertising spending is increased by $5,000. Use the contribution margin approach to calculate margin of safety in dollars, as a 16 percent and in units. Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 10%? New Operating 17 Income? 15 avino & Submitting Comprehensive Proiect aste Merge & B I VE A B Requirement 8 Use the information provided below, the high low method and the contribution margin approach to prepare a contribution format income statement Use your mixed cost formulas to create your contribution format statement. Reference the DATA cell(s) as provided to complete your statement below. Format as numbers. Round to 2 decimal places where appropriate Boyd Corporation Income Statement For the Year 2023 Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income $ 2,280,000 1,560,000 720,000 597,000 $ 123,000 Boyd sold 400 units in 2023 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Selling & Administrative Costs Step 1 - Variable cost per unit Step 2 - Fixed Cost Stan - Mixed Cost. Formula Transactions MOH Rate Solution Ready Journal Entries Solution T-Accounts Solution B24 x v fx C D E B Boyd sold 400 units in 2023 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Selling & Administrative Costs Step 1 - Variable cost per unit Step 2 - Fixed Cost 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Contribution Format Transactions MOH Rate Solution Journal Entries Solution Ready T-Accounts Sol tv C D E F G Per Unit DATA (refer to Requirement 8) Description Unit Sales for 2024 500 Sales Revenue Variable Costs Contribution Margin Fixed Costs Operating Income Breakeven Target Profit $ $ 655,000 Requirement 9 Use the contribution margin approach to compute the company's annual breakeven in units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Breakeven in Units Requirement 10 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Format the ratio as a percent, breakeven in dollars as accounting number format in whole dollars. Contribution margin ratio Breakeven in Dollars Requirement 11 Use the contribution margin approach to compute the annual sales level (in units) required to earn a target operating income of $655,000 Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj ar nady 39 fx B D E F G H Requirement 11 Use the contribution margin approach to compute the annual sales level (in units) required to earn a target operating income of $655,000 Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. Target sales level (in units) Requirement 12 Use the contribution margin approach to compute the annual increase in operating income if sales increase to 501 units, Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 13 Use the contribution margin approach to compute the change in net operating income if sales fall by 90 units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 14 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $20 per unit and the sales volume decreases by 50 units. Reference the DATA cell(s) in your formula below. Format as number. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj and En ady Page Layout Formulas Data Review View Tell me LD Arial V 12 V ' ' ab Wrap Text General Paste BIU Lil * v BE V = = Merge & Center $ % 789 fx A E G Reference the DATA cell(s) in your formula below. Format as number Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income 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. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars Margin Safety Margin Safety % Margin Safety units Requirement 17 Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 10%? New Operating Income? Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Operating Leverage Change in Operating Income % New Operating Income $ Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution dy MOH adj and Ende X Arial 12 ' ' 2 Wrap ste BIU Merge AA- x fx A D E merr Vorwurm Y 7. Prepare income statements in good form for Boyd for 2024. The company sold 500 units in 2024. Use the information given to calculate the following for 2024 Use the information provided, the high low method and the contribution margin 8 approach to prepare a contribution format income statement Use the contribution margin approach to compute the company's annual 9 breakeven point in units. Use the contribution margin ratio approach to compute the breakeven point in 10 sales dollars Use the contribution margin approach to compute the annual sales level (in units) required 11 to eam a target operating income of $655,000 Use the contribution margin approach to compute the annual increase in net operating income if sales increase to 501 units. 12 14 Use the contribution margin approach to compute the change in net operating income if sales fall by 90 units. 13 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $20 per unit and the sales volume decreases by 50 units. Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and advertising spending is increased by $5,000. Use the contribution margin approach to calculate margin of safety in dollars, as a 16 percent and in units. Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 10%? New Operating 17 Income? 15 avino & Submitting Comprehensive Proiect aste Merge & B I VE A B Requirement 8 Use the information provided below, the high low method and the contribution margin approach to prepare a contribution format income statement Use your mixed cost formulas to create your contribution format statement. Reference the DATA cell(s) as provided to complete your statement below. Format as numbers. Round to 2 decimal places where appropriate Boyd Corporation Income Statement For the Year 2023 Sales Revenue Cost of Goods Sold Gross Profit Selling and Administrative Expenses Operating Income $ 2,280,000 1,560,000 720,000 597,000 $ 123,000 Boyd sold 400 units in 2023 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Selling & Administrative Costs Step 1 - Variable cost per unit Step 2 - Fixed Cost Stan - Mixed Cost. Formula Transactions MOH Rate Solution Ready Journal Entries Solution T-Accounts Solution B24 x v fx C D E B Boyd sold 400 units in 2023 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Selling & Administrative Costs Step 1 - Variable cost per unit Step 2 - Fixed Cost 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Contribution Format Transactions MOH Rate Solution Journal Entries Solution Ready T-Accounts Sol tv C D E F G Per Unit DATA (refer to Requirement 8) Description Unit Sales for 2024 500 Sales Revenue Variable Costs Contribution Margin Fixed Costs Operating Income Breakeven Target Profit $ $ 655,000 Requirement 9 Use the contribution margin approach to compute the company's annual breakeven in units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Breakeven in Units Requirement 10 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Format the ratio as a percent, breakeven in dollars as accounting number format in whole dollars. Contribution margin ratio Breakeven in Dollars Requirement 11 Use the contribution margin approach to compute the annual sales level (in units) required to earn a target operating income of $655,000 Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj ar nady 39 fx B D E F G H Requirement 11 Use the contribution margin approach to compute the annual sales level (in units) required to earn a target operating income of $655,000 Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. Target sales level (in units) Requirement 12 Use the contribution margin approach to compute the annual increase in operating income if sales increase to 501 units, Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 13 Use the contribution margin approach to compute the change in net operating income if sales fall by 90 units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 14 Use the contribution margin approach to compute the change in net operating income if the selling price per unit increases by $20 per unit and the sales volume decreases by 50 units. Reference the DATA cell(s) in your formula below. Format as number. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj and En ady Page Layout Formulas Data Review View Tell me LD Arial V 12 V ' ' ab Wrap Text General Paste BIU Lil * v BE V = = Merge & Center $ % 789 fx A E G Reference the DATA cell(s) in your formula below. Format as number Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars New Operating Income change in Operating Income 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. Always refer to the original data. Use the Excel ROUNDUP function to obtain whole units or dollars Margin Safety Margin Safety % Margin Safety units Requirement 17 Use the contribution margin approach to calculate operating leverage. What is the estimated percent increase in net income if sales increase 10%? New Operating Income? Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Operating Leverage Change in Operating Income % New Operating Income $ Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution dy MOH adj and Ende