Through the information provided above could you help me answer these requirements, please!

THANK YOU SOOO MUCH!!!!

Boyd Corporation is a manufacturer that uses job-order costing. On January 1, 2024, the company's inventory balances were as follows: Raw Materials Inventory Work-in-Process Inventory Finished Goods Inventory $60,000 $38,000 $55,000 The company applies overhead cost to jobs on the basis of direct labor-hours. For the current year, 2024, the company's predetermined overhead rate per direct labor-hour was based on a cost formula that estimated $812,500 of total manufacturing overhead for an estimated activity level of 65,000 direct labor-hours. Requirements: Compute the predetermined overhead allocation rate for fiscal year 2024. 1. Use the blue shaded areas for inputs. Use Excel to journalize the transactions listed in the Transactions tab for 2. the current year, 2024. Enter the beginning balances for the inventories in the T-accounts. Assume the rest of the accounts have beginning balances of zero. Post the journal entries to T-accounts. T-account balances will automatically calculate except for Manufacturing Overhead. You will need to calculate 3. the appropriate balance in that account. 4. Adjust the manufacturing overhead account. Prepare the journal entry. b. Post to T-accounts. 5. Complete the Schedule of Cost of Goods Manufactured for 2024. 6. Complete the Cost of Goods Sold schedule for 2024. 7. Prepare income statements in good form for Boyd for 2024. a. 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 8 margin 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 10 point in sales dollars. Use the contribution margin approach to compute the annual sales level (in units) 11 required to earn a target operating income of $655,000. Use the contribution margin approach to compute the annual increase in 12 net operating income if sales increase to 501 units. Use the contribution margin approach to compute the change in net 13 operating income if sales fall by 90 units. 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 14 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 15 $5,000. Use the contribution margin approach to calculate margin of safety in 16 dollars, as a 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 17 10%? New Operating Income? DEBIT ($) 5,60,000 CREDIT ($) | 5,60,000 5,30,000 5,30,000 6,50,000 2,00,000 2,90,000 11,40,000 4,17,000 4,17,000 JOURNAL ENTRIES S.NO. ACCOUNT TITLE & EXPLANATION a Raw material inventory Account Payable (inventory purchased on account) b WIP Inventory Raw material inventory (Raw material issued) WIP Inventory Manufacturing Overhead Selling and administrative OH Wages payable (Labour used) d Selling and administrative OH Cash (Selling and administrative expenses incurred) e Manufacturing Overhead Cash (Manufacturing OH incurred) f WIP Inventory Manufacturing Overhead ( factory overhead applied) & Finished goods WIP Inventory (goods transfer to F.G h cost of goods sold Finished goods (to record cost of goods sold Account receivable Sales (sales on account) 5,50,000 5,50,000 5,75,000 5,75,000 17,30,000 17,30,000 17,40,000 17,40,000 28,50,000 28,50,000 $ Beg. Balance h ACCOUNT RECEIVABLE $ 0 28,50,000 End. Balance 28,50,000 ACCOUNT PAYABLE $ Beg. Balance 5,60,000 End. Balance 5,60,000 SALES $ $ 28,50,000 h End. Balance 28,50,000 RAW MATERIAL INVENTORY $ 60,000 b 5,60,000 $ 5,30,000 Opening Balance End. Balance Opening Balance 90,000 WORK IN PROGRESS INVENTORY $ 38,000 8 5,30,000 6,50,000 5,75,000 $ 17,30,000 b c t End. Balance 63,000 FINISHED GOODS INVENTORY $ 55,000 h 17,30,000 $ 17,40,000 Opening Balance 8 End. Balance 45,000 MANUFACTURING OVERHEAD $ 2,00,000 f 5,50,000 $ 5,75,000 End. Balance 1,75,000 COST OF GOODS SOLD $ 17,40,000 $ h End. Balance 17,40,000 WAGES PAYABLE CONTROL $ C $ 6,50,000 2,00,000 2,90,000 End. Balance 11,40,000 SELLING AND ADMINISTRATIVE EXPENSES $ 2,90,000 4,17,000 $ C d End. Balance 7,07,000 Requirement 4 Adjust the manufacturing overhead. 1. Prepare the journal entry. 2. Post the journal entry to the T-accounts worksheet. Date Account/Explanation Debit Credit (0) Adjusted manufacturing overhead. Requirement 5: Complete the Schedule of Cost of Goods Manufactured. Schedule of Cost of Goods Manufactured Requirement 6: Complete the cost of Goods Sold schedule. Schedule of Cost of Goods Sold Requirement 7. Complete the Income Statement Requirement 7: Complete the Income Statement. Income Statement 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 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 Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Step 3 - Mixed Cost Formula (STATE the ACTUAL formula in the blue box provided) Contribution Format