Question: 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

Home Insert Draw Page Layout Formulas Data ReviewHome Insert Draw Page Layout Formulas Data Review
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!