Plots $200$

Cost Per Plot $ $1,00,000$

Average Board Feet $10000\mathrm{.}00$

Pine $\%9\%$

Pine Price $ $12\mathrm{.}00$

Poplar $\%38\%$

Poplar Price $ $14\mathrm{.}00$

Spruce $\%53\%$

Spruce Price $ $13\mathrm{.}00$

Total Cost $ $2,00,00,000\mathrm{.}00$

Gross Profit $ $2,65,80,000\mathrm{.}00$

Net Profit $ $65,80,000\mathrm{.}00$

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Bayside Logging

You are an owner of a logging company looking to bid on the plots you plan to cut this year. You need to perform some analysis of the risk, reward, and break$-$even points based on how many plots you purchase, the average production per plot, and the cost you pay per plot. Historically, the distribution of the type of trees on these plots are consistent and the price for each type of tree have been estimated for the season.

Goal 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.

a$.$ Use Goal Seek to determine what the Average Board Feet must be if you bid on $200$ plots at $$150,000$ each to cover your $$2\mathrm{.}5$ million machinery cost.