please someone help me with this question i will be grateful

question is complete you judy don't know how to do it.

5. The Forest District Manager has given you the following yield information (Table A) for four different management strategies to re- establish White Spruce in the Prince George Region after harvest or other disturbance such as fire. The yields are for above average site productivity. She wants you to a) Identify what strategies will meet the Government's new policy that all silvicultural investments be financially viable, and b) identify an "optimal" forest management strategy. The cost information for each management strategy is given in Table B. Market research indicates the value of the merchantable timber has a 0.5 probability of being $30 per cubic meter and 0.5 probability of being $50 per cubic meter. The government recommends a real rate of interest between 2 and 4 percent be used to evaluate all public investments. c) Using the yield information in Table A and the Cost information in Table B above, calculate the site value (land expectation value) and optimal rotation ages for all scenarios and all management strategies. d) What would you recommend to your manager and why? You need to use a spreadsheet to calculate approximate answers to the problems. Submit details of calculations and formulas used to receive full marks. Table A- Merchantable yields (m3/hecatare) for four management scenarios of White spruce. Natural strategy involves allowing stand to reforest naturally. Plant strategy involves planting seedlings on unprepared land. Plant plus chemical site preparation strategy involves planting the stand with seedlings after applying an herbicide to kill unwanted vegetation. Plant plus mechanical site preparation strategy involves planting seedlings after site is prepared using machines that destroy unwanted vegetation and create linear mounds of exposed soil for seedlings. Age Silviculture Management Strategy Natural Plant Plant plus Plant plus chemical site mechanical preparation. site preparation 0 0 10 0 0 o 20 1 2 30 12. 51 91 40 13 98 172 234 50 87 210 291 362 60 190 309 408 483 70 288 410 499 552 80 383 490 554 601 90 458 540 596 839 100 517 577 828 880 110 585 B08 853 884 120 805 833 881 889 130 637 652 885 673 140 884 800 888 673 150 678 883 872 873 eleonent costs of management strategies Plant Plant plus chemical site preparation $1050.00 $1250.00 $180000