Goal Seek You had to purchase new machinery to harvest the wood for this season. You need to deteIInine how many board feet you need to average to cover the cost of the new machinery. e. Use Goal Seek to determine what the Average Board Feet must be if you bid on 100 plots at $75,000 each to cover your $2 million net profit. f. Answer Question 1 on the Results worksheet