in this worksheet,

how to use Goal Seek to determine the breakeven point based on the units of production in cell B6. Accept the Goal Seek result so that cell B6 is updated with the number of units required for a break even. (Remember, break even is when revenues =expenses)

Thank you for your time and help. Please be specific.

Units_Pro... f 800 B D E F Gatchell Bikes Ltd 1 2 BATTERY POWERED BIKE ANALYSIS 3 Break-Even Analysis Revenue Expenses Units Sold Net Income 800 $3,000 2,400,000 $ 800 $1,287 1,029,600 $476 380,800 1,410,400 $ 4 5 Revenue 6 Units Produced and Sold 7 Average Price per Unit 8 Total Revenue 9 10 Variable Expenses 11 Units Produced 12 Average Material Cost per Unit 13 Total Material Cost 14 Average Manufacturing Cost per Unit 15 Total Manufacturing Cost 16 Total Variable Expenses 17 18 Fixed Expenses 19 Salaries and other benefits 20 Property tax 21 Insurance 22 Miscellaneous 23 Total Fixed Expenses 24 25 Summary 26 Total Revenue 27 Total Expenses 28 Net Income 29 30 31 32 $ 745,000 87,000 82,000 39,000 953,000 $ 2,400,000 2,363,400 36,600 $