EXCEL

a, You need to perform an analysis of Total Revenue and Gross Profit based on different Averages of Board Feet per Plot. Using an appropriate Table, show how Total Revenue and Gross Profit will change with changes in Average Board Feet per Plot, ranging from 1,000 to 1,280 in increments of 40. Apply appropriate formatting to the Table. Highlight in yellow colour, Gross Profit closest to $1.2 million. Also highlight the corresponding Average Board Feet per Plot and the Total Revenue.

b, Using an appropriate Table show how Gross Profit will change with changes in Number of Plots and Cost Per Plot. Change Cost Per Plot from $5,500 to $14,500 in increments of $1,500. Change Number of Plots, from 125 to 175 in increments of 25. Apply appropriate formatting to the Table. Highlight in yellow colour, the Number of Plots and the Cost Per Plot required to produce a minimum Gross Profit.

Number of Plots	200
Cost Per Plot	$ 10,000
Average Board Feet per Plot	1,000
Pine %	9%
Pine Price Per Board Foot	$ 12.00
Poplar %	38%
Poplar Price Per Board Foot	$ 14.00
Spruce %	53%
Spruce Price Per Board Foot	$ 13.00
Total Cost	$ 2,000,000.00
Total Revenue	$ 2,658,000.00
Gross Profit	$ 658,000.00