accounting 2 please show steps and formuals in excel !!!

please help!!!!

Draw Formulas Insert Data Review View Page Layout Home Tell me 12 ' ' Arial = Wrap Text X LD * V Paste ov Merge & cer a. Av E9 x fx F G H -TUT A D E U wompre ure worroogerwore amour Tor 7. Prepare income statements in good form for Boyd for 2024. 21 22 The company sold 500 units in 2024. Use the information given to calculate the following for 2024: 23 24 25 26 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 earn a target operating income of $655,000. 27 28 Use the contribution margin approach to compute the annual increase in net operating income if sales increase to 501 units. 29 12 Use the contribution margin approach to compute the change in net operating income if sales fall by 90 units. 30 13 31 14 32 15 33 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 34 17 Income? 35 36 37 a Savino & Submittina Comprehensive Proiect Assionments Instructions data Transactions MOH Rate Solution Journal Fotries Solutir Review View Home Insert Formulas Data Draw Page Layout Tell me X Arial v 12 2 Wrap Text ' v Paste BIU Merge & cer V A E9 X & fx F G H A B D E Voorprorov varoroou or ITUTO TOTEUT 7. Prepare income statements in good form for Boyd for 2024 21 22 The company sold 500 units in 2024. Use the information given to calculate the following for 2024 23 24 25 26 27 Use the informatie 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. 28 29 12 30 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 31 14 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. 32 15 Use the contribution margin approach to calculate margin of safety in dollars, as a 33 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 34 17 Income? 35 36 37 a Savina & Submittina Comprehensive Proiect Assianments Instructions data Transactions MOH Rate Solution Journal Entries Solutic Ready AutoSave OFF Copy of Compr 2 v 3 ABC 8 L Draw Formulas Data Review Page Layout Tell me Home Insert View Aria! 12 29 Wrap To v A A X I DO Paste B I U v a. Av ill Merge 8 B D E G H CS 1 x fox 1 Manufacturing Accounts 2 3 Accounts Receivable 4 Raw Materials Inventory 5 Work-in-Process Inventory 6 Finished Goods Inventory 7 Accounts Payable 8 Wages Payable 9 Sales Revenue 10 Manufacturing Overhead 11 Cost of Goods Sold 12 Selling & Administrative Expense 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Instructions data Transactions MOH Rate Solution Ready Journal Entries Sol Excel File Edit VIEW AutoSave OFF c Copy of Comprehensive Proje View Tell me Data Review Formulas Home Insert Draw Page Layout 12 GA = Arial ' 26 Wrap Text X (D Paste Os BTU A- 2011 ilil $ 9 Merge & Center B5 C D E 1 Requirement 2 2 Journalize the transactions in the general journal 3 4 Date Account/Explanation Debit Credit 5 (a) 6 7 B 9 (b) 10 12 13 ( (c) 15 16 17 18 19 (d) 20 21 22 23 (e) 24 Instructions data Transactions MOH Rate Solution Ready Journal Entries Solution T-A Home Insert Draw Page Layout Formulas Data Review View Tell me Arial 11 V ' ' Nur LG Wrap Text Merge & Center Paste B IU H ~ ====== $ E12 fx A B D G H Requirement 3 Post the journal entries Accounts Receivable Accounts Payable Sales Revenue 1 2 3 4 5 6 7 8 9 10 0 0 Raw Materials Inventory Wages Payable Manufacturing Overhead 0 0 Work-in-Process Inventory ARSNN 0 0 11 12 bal 13 14 15 16 17 bal 18 19 20 21 22 23 24 bal 25 26 0 Cost of Goods Sold Finished Goods Inventory 0 Selling & Administrative Expenses 22 28 29 30 31 32 33 0 35 36 37 Instructions data Transactions MOH Rate Solution Ready Journal Entries Solution T-Account AutoSave OFF 2 Copy of Comprehensive Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial 12 A A V 29 Wrap Text lilli Paste BIU v v Merge & Center C12 x fx B D E F 1 Requirement 4 2 Adjust the manufacturing overhead. 3 1. Prepare the journal entry 4 2. Post the journal entry to the T-accounts worksheet. 5 6 Date Account/Explanation Debit Credit 8 10 9 Adjusted manufacturing overhead. 10 11 12 13 16 15 16 18 19 20 21 22 SOSSAN 24 25 27 28 20 30 31 32 33 Instructions data Ready Transactions MOH Rate Solution Journal Entries Solution T-AC ty OFF ABC AutoSave 60 Copy of Comprehensive Project View Tell me Insert Draw Formulas Page Layout Home Data Review Arial 12 - A A 2 Wrap Text Gen Paste B 1 U V A Merge & Center $ B5 x fx Year Ended D A B C Requirement 5: Complete the Schedule of Cost of Goods Manufactured. 1 2 3 4 Boyd Corporation Schedule of Cost of Goods Manufactured Year Ended 5 7 8 9 10 11 12 13 14 15 16 17 Requirement 6: Complete the cost of Goods Sold schedule. Schedule of Cost of Goods Sold 19 20 21 22 23 24 25 26 27 29 30 31 32 33 34 25 Requirement 7: Complete the income Statement. Instructions data Transactions MOH Rate Solution Ready Journal Entries Solution T-Accour AutoSave OFF A 2 GAC @ Page Layout Formulas Copy of Comprehensive Pro, View Tell me Insert Home Draw Data Review X Arial v 12 a Wrap Text A u a. Av Paste B I U v CE Merge & Center B5 * fx Year Ended D 45 46 47 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 48 49 50 51 52 53 54 55 55 57 58 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 59 60 61 Boyd sold 400 units in 2023 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit Step 2 - Fixed Cost GS 64 65 66 67 68 69 70 71 72 73 74 75 76 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 Instructions data Transactions Ready MOH Rate Solution Journal Entries Solution T-Acce AutoSave OFF 2G APC 9 Copy of Comprehensive Pro Insert Home Draw Page Layout Formulas Data Review View Tell me Arial 12 X LO DE ' ' Wrap Text Merge & Center Pasto IU A BS Xfx Year Ended D 45 46 47 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 48 43 50 51 52 5 55 56 57 SH 59 60 61 62 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 GE High Low Method Cost of Goods Sold Step 1 - Variable cost per unit 65 56 Step 2 - Fixed Cost 69 70 71 Step 3. Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Selling & Administrative Costs Step 1 - Variable cost per unit 73 14 75 76 Smp 2 - Fixed Cost Instructions data Transactions Ready MOH Rato Solution Journal Entries Solution T-Ace stv O MacBoc AutoSave OFF CARE Copy of Comprehensive Pro Insert Draw Home Formulas Data Page Layout Tell me Review View X Arial 12 " == Wrap Text Merge & Center Paste B a. Av B5 XVfx Year Ended D F A 54 35 Sales Revenue Cost of Goods Sold Gross Prot Selling and Administrative Expenses Operating Income $ 2,280,000 1,560,000 720,000 597,000 $ 123,000 57 so 59 60 Boyd sold 400 units in 2023 62 53 64 65 66 High Low Method Cost of Goods Sold Step 1 - Variable cost per unit 1 Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) 68 69 70 71 72 73 74 75 Selling & Administrative Costs Step 1 - Variable cost per unit Step 2 - Fixed Cost Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) 72 24 19 NO 1 Contribution Format + 02 84 AS BE Instructions data Transactions Ready MOH Rato Solution Journal Entries Solution T-Acce sty A O MacBoc Data Formulas Review View Tell me ame Insert Draw Page Layout Genera $ 3 X Arial 12 - A A == 2 Wrap Text ( B a. Av = = = Merge & Center x fx Change in Operating Income % B D E F G Requirement 10 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cel(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. H A 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. 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 collis) 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 Reme 16 Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution Ready MOH ad, and E stv V MacBook E AGU Data Formulas Review View Tell me ome Insert Draw Page Layout 12 = - A A Arial 2 Wrap Text General LEO E B 1 B U A $9 = = = Merge & Center 38 X fx Change in Operating Income % C D E G 5 H A 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 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 s Margin Safety Margin Safety units 5 2 5 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 coll(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 and En Ready Stv > MacBook E AutoSave lor Copy of Comprehensive Project 1 Tem View Tell me Data Formulas Home Insert Draw Review Page Layout General Arial 12 29 Wrap Text - A A Paste Merge & Center $ % TU ==== = B 88 fx Change in Operating Income % D E G 14 A 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 cells) 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 coll(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 S20 per unit and the sales volume decreases by 50 units Reference the DATA cell(s) in your formula below. Formatas number Use the Excel ROUNDUP function to obtain whole units or dollars 8 1 2 2 New Operating Income change in Operating Income 5 6 Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj and End Ready sty A MacBook P AutoSave OF Data Formulas Review View Tell me ame Insert Draw Page Layout 33 2 Wrap Text General v Merge & Center $ % Arial 12 ' D B IU OA 4 xfx Change in Operating Income 3 H ULO EXCT ROUNDUP obtain whole uits 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 cells) 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 MOH adi and End Ready ity > MacBook P Arial 12 MacBook E AutoSave lor Copy of Comprehensive Project 1 Tem View Tell me Data Formulas Home Insert Draw Review Page Layout General Arial 12 29 Wrap Text - A A Paste Merge & Center $ % TU ==== = B 88 fx Change in Operating Income % D E G 14 A 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 cells) 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 coll(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 S20 per unit and the sales volume decreases by 50 units Reference the DATA cell(s) in your formula below. Formatas number Use the Excel ROUNDUP function to obtain whole units or dollars 8 1 2 2 New Operating Income change in Operating Income 5 6 Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 5% and Transactions MOH Rate Solution Journal Entries Solution T-Accounts Solution MOH adj and End Ready sty A MacBook P AutoSave OF Data Formulas Review View Tell me ame Insert Draw Page Layout 33 2 Wrap Text General v Merge & Center $ % Arial 12 ' D B IU OA 4 xfx Change in Operating Income 3 H ULO EXCT ROUNDUP obtain whole uits 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 cells) 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 MOH adi and End Ready ity > MacBook P Arial 12