ASAP! POST USING VBA CODE!

A site with three ellipsoidal subdivisions needs to be cleared for construction. The XYZ

tree cutting company charges $$3\mathrm{.}00$ per square feet to clear trees and to stabilize the area and

would charge $$2\mathrm{.}50$ per linear $ft$ to install fence around each subdivision. Develop a VBA code

that uses a for loop that calls FUNCTIONS $($do not use Subroutines$)$ to compute the area

and perimeter of each subdivision, considering that the ratio between the length of semi$-$major

axis $(L_1)$ and the length of semi$-$minor axis $(L_2)$ of each ellipse is $2(\frac{L_1}{L_2}=2),$ and the values

of $L_1$ is estimated to be $1000,2500,$ and $3500ft$ for the subdivision $A,B$ and $C$ respectively.

Estimate the total cost of the project for each subdivision individually. The code should print

all the results in a table like the following:

Hint $1$: If your code keeps crashing "Run$-$time error $\text{'}6\text{'}$: overflow", try changing the variable

type of the variable that is overflowing to "LongLong" or "Double". It should make your code

work with a wider range of values.

Hint $2$: the area of an ellipse can be estimated as: Area $=**L_1**L_2$

Hint $3$: the perimeter of an ellipse can be approximated as:

$P$~~$[3(L_1+L_2)-\sqrt[\phantom{2}]{(3L_1+L_2)(L_1+3L_2)}]$