Font Alignment ANDFE14, Question 11 G D H B 4 You are an owner of a logging company looking to bid on the pine tree plots you plan to cut this year. You need to perform some analysis of the risks and 5 rewards based on the number of pine tree plots of land you purchase, the cost you pay per plot of land, and the average production per plot (board feet) 6 You also need to purchase a new plece of machinery this season to harvest this wood, at a cost of $2,000,000 2 3 0 Input Data 10 Number of plots 200 1 Cost per plot s 100,000 12 Avg board feet (production) 10,000 13 Sales Price (per board toot) S 14 Total Revenue $ 13,096,000 15 Total Cost $ 20.000.000 16 Profit 3 (6,904,000) 12 logical teatre Value raise PARTA Paste the list of all range nam here: 19 Number of plots 20 Cost per plot 21 Ave board feet (production) 23 Sales Price per board foot 23 Total Revenue 24 Total cost Profit 16 27 PART What is the average board feet per plot required to cover the machinery cost and earn this profit? For your answ! 28 PARTE What is the Profitif each plot averages 12,000 board feet? een your new 29 PARTO What is the Profitifs plots are purchased at a cost of $105,000 per plot? reference your 30 31 32 PART A R Names 191) For the input data in celo 30:16, new names for this dating the Create from Selection option in 14) dit the names in cell C12 10 beard feet", in cell to be 251) Edit the formula in cell C16 to use this instead of references 104) Anwwer the PART A question above PART Goal See 39 ) U Goals to determine the average Board Feet needed to cover the cost of the new machinery plus eam a profit of 1,000,000 (um of bot) 40 Answer the PART Gestion above Questions Outthon Duito Cuva Question Question 1 Font Alignment ANDFE14, Question 11 G D H B 4 You are an owner of a logging company looking to bid on the pine tree plots you plan to cut this year. You need to perform some analysis of the risks and 5 rewards based on the number of pine tree plots of land you purchase, the cost you pay per plot of land, and the average production per plot (board feet) 6 You also need to purchase a new plece of machinery this season to harvest this wood, at a cost of $2,000,000 2 3 0 Input Data 10 Number of plots 200 1 Cost per plot s 100,000 12 Avg board feet (production) 10,000 13 Sales Price (per board toot) S 14 Total Revenue $ 13,096,000 15 Total Cost $ 20.000.000 16 Profit 3 (6,904,000) 12 logical teatre Value raise PARTA Paste the list of all range nam here: 19 Number of plots 20 Cost per plot 21 Ave board feet (production) 23 Sales Price per board foot 23 Total Revenue 24 Total cost Profit 16 27 PART What is the average board feet per plot required to cover the machinery cost and earn this profit? For your answ! 28 PARTE What is the Profitif each plot averages 12,000 board feet? een your new 29 PARTO What is the Profitifs plots are purchased at a cost of $105,000 per plot? reference your 30 31 32 PART A R Names 191) For the input data in celo 30:16, new names for this dating the Create from Selection option in 14) dit the names in cell C12 10 beard feet", in cell to be 251) Edit the formula in cell C16 to use this instead of references 104) Anwwer the PART A question above PART Goal See 39 ) U Goals to determine the average Board Feet needed to cover the cost of the new machinery plus eam a profit of 1,000,000 (um of bot) 40 Answer the PART Gestion above Questions Outthon Duito Cuva Question Question 1