Hello! I need help completing this flexible budget. Thank you!

Budgeted Flex Actual Units Direct Materials Ounces of Nickel per Unit Number of Integrated Circuits per Unit Advance Units Cost 6 $ 2.46 2 $ 22.00 Basic Cost 9 $ 2.50 1 $ 22.00 Advanced Revenues (Projected Sales = 300,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Advanced 52,500,000 56,000,000 54,400,000 17,700,000 20,420,224 16,800,000 18,331,200 14,250,000 16,315,200 3,750,000 -666,624 Direct Labor DL Hours per Unit (Electrical Components) 1.00 2.00 DL Hours per Unit (Assembly) Total DL Hours per Unit Cost per DL Hour 1 3 4 14 2 2 4 14 Basic Revenues (Projected Sales = 350,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Basic Total Gross Margin 47,250,000 37,800,000 39,200,000 15,575,000 11,508,560 19,600,000 16,837,800 9,975,000 7,872,480 2,100,000 2,981,160 5,850,000 2,314,536 Manufacturing Overhead (machine hours is the chosen cost driver) Machine Hours per Unit (Electrical Components) Machine Hours per Unit (Assembly) Total Machine Hours per Unit Pre-Determined MOH Rate per Machine Hour 3 2 5 9.5 1 2 3 9.5 Period Costs Commissions (2 percent of revenues) Salesperson Salaries Fixed Administrative Costs Interest Pre-Tax Income 1,995,000 450,000 1,650,000 520,000 1,235,000 1,872,000 425,000 1,505,000 630,000 -2,117,464 Advanced Units Price DM DM 300000 175 320000 175 320000 170 DL DL MH Var Basic 350000 135 280000 135 280000 140 Units Price DM DM DL DL MH Var Budgeted Flex Actual Advanced Revenues (Projected Sales = 300,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Advanced 52,500,000 56,000,000 54,400,000 17,700,000 20,420,224 16,800,000 18,331,200 14,250,000 16,315,200 3,750,000 -666,624 Basic Revenues (Projected Sales = 350,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Basic Total Gross Margin 47,250,000 37,800,000 39,200,000 15,575,000 11,508,560 19,600,000 16,837,800 9,975,000 7,872,480 2,100,000 2,981,160 5,850,000 2,314,536 Period Costs Commissions (2 percent of revenues) Salesperson Salaries Fixed Administrative Costs Interest Pre-Tax Income 1,995,000 450,000 1,650,000 520,000 1,235,000 1,872,000 425,000 1,505,000 630,000 -2,117,464 Direct Materials Ounces of Nickel per Unit Number of Integrated Circuits per Unit Advance Units Cost 6 $ 2.46 2 $ 22.00 Basic Units Cost 9 $ 2.50 1 $ 22.00 1 Direct Labor DL Hours per Unit (Electrical Components) 1.00 2.00 DL Hours per Unit (Assembly) Total DL Hours per Unit Cost per DL Hour 2 2 3 3 4 st 14 14 3 Manufacturing Overhead (machine hours is the chosen cost driver) Machine Hours per Unit (Electrical Components) Machine Hours per Unit (Assembly) Total Machine Hours per Unit Pre-Determined MOH Rate per Machine Hour 1 2 N 5 5 3 9.5 9.5 300000 175 320000 175 320000 170 Advanced Units Price DM DM DL DL MH Var 350000 135 280000 135 280000 140 Basic Units Price DM DM DL DL MH Var Budgeted Flex Actual Units Direct Materials Ounces of Nickel per Unit Number of Integrated Circuits per Unit Advance Units Cost 6 $ 2.46 2 $ 22.00 Basic Cost 9 $ 2.50 1 $ 22.00 Advanced Revenues (Projected Sales = 300,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Advanced 52,500,000 56,000,000 54,400,000 17,700,000 20,420,224 16,800,000 18,331,200 14,250,000 16,315,200 3,750,000 -666,624 Direct Labor DL Hours per Unit (Electrical Components) 1.00 2.00 DL Hours per Unit (Assembly) Total DL Hours per Unit Cost per DL Hour 1 3 4 14 2 2 4 14 Basic Revenues (Projected Sales = 350,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Basic Total Gross Margin 47,250,000 37,800,000 39,200,000 15,575,000 11,508,560 19,600,000 16,837,800 9,975,000 7,872,480 2,100,000 2,981,160 5,850,000 2,314,536 Manufacturing Overhead (machine hours is the chosen cost driver) Machine Hours per Unit (Electrical Components) Machine Hours per Unit (Assembly) Total Machine Hours per Unit Pre-Determined MOH Rate per Machine Hour 3 2 5 9.5 1 2 3 9.5 Period Costs Commissions (2 percent of revenues) Salesperson Salaries Fixed Administrative Costs Interest Pre-Tax Income 1,995,000 450,000 1,650,000 520,000 1,235,000 1,872,000 425,000 1,505,000 630,000 -2,117,464 Advanced Units Price DM DM 300000 175 320000 175 320000 170 DL DL MH Var Basic 350000 135 280000 135 280000 140 Units Price DM DM DL DL MH Var Budgeted Flex Actual Advanced Revenues (Projected Sales = 300,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Advanced 52,500,000 56,000,000 54,400,000 17,700,000 20,420,224 16,800,000 18,331,200 14,250,000 16,315,200 3,750,000 -666,624 Basic Revenues (Projected Sales = 350,000 units) Direct Materials Direct Labor Applied Manufacturing Overhead Gross Margin - Basic Total Gross Margin 47,250,000 37,800,000 39,200,000 15,575,000 11,508,560 19,600,000 16,837,800 9,975,000 7,872,480 2,100,000 2,981,160 5,850,000 2,314,536 Period Costs Commissions (2 percent of revenues) Salesperson Salaries Fixed Administrative Costs Interest Pre-Tax Income 1,995,000 450,000 1,650,000 520,000 1,235,000 1,872,000 425,000 1,505,000 630,000 -2,117,464 Direct Materials Ounces of Nickel per Unit Number of Integrated Circuits per Unit Advance Units Cost 6 $ 2.46 2 $ 22.00 Basic Units Cost 9 $ 2.50 1 $ 22.00 1 Direct Labor DL Hours per Unit (Electrical Components) 1.00 2.00 DL Hours per Unit (Assembly) Total DL Hours per Unit Cost per DL Hour 2 2 3 3 4 st 14 14 3 Manufacturing Overhead (machine hours is the chosen cost driver) Machine Hours per Unit (Electrical Components) Machine Hours per Unit (Assembly) Total Machine Hours per Unit Pre-Determined MOH Rate per Machine Hour 1 2 N 5 5 3 9.5 9.5 300000 175 320000 175 320000 170 Advanced Units Price DM DM DL DL MH Var 350000 135 280000 135 280000 140 Basic Units Price DM DM DL DL MH Var