Home Insert Draw Page Layout Formulas Data Review View Automate Help Share ~ File Comments D'a From Text/CSV From Picture Queries & Connections P X Clear Group G8 Le From Web To Recent Sources Properties Sort Filter 1Reapply Ungroup -= Get Refresh Text to EX What-If Forecast Stocks Currencies Data From Table/Range [ Existing Connections All Edit Links Advanced Columns Analysis * Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline C14 vi X fx =Gross_Profit-Total_Cost O Q A B C D E G H K M N P Bayside Logging Plots 200 Average Board Feet Cost Per Plot S 100,000 Goal Seek ? X Average Board Feet 10000.00 Pine % 9% Set cell: + Pine Price 12.00 To value Co Poplar % 38% By changing cell: Poplar Price $ 14.00 Spruce % 53% OK Cancel Spruce Price $ 13.00 12 Total Cost $ 20,000,000.00 13 Gross Profit $ 26,580,000.00 Net Profit $ 6,580,000.00 15 16 18 19 20 21 22 30 31 32 33 24 > Breakdown Questions + Enter Accessibility: Good to goGoal Seek You had to purchase new machinery to harvest the wood for this season. You need to determine how many board feet you need to average to cover the cost of the new machinery. d. Use Goal Seek in cell C14 to determine what the Average Board Feet must be if you bid on 200 plots at $100,000 each to cover your $2.5 million machinery cost