(Answered) develop a spreadsheet for calculating sales using this formula for T equals 0 to 160 in increments…

develop a spreadsheet for calculating sales using this formula for T equals 0 to 160 in increments of 10 one a equals 15,000 B equals -8 and C = -.05 gonpertz curve
Gompertz-form formula (using the given parameters): Sales(T) = a * EXP(B * EXP(C * T)) with a = 15,000, B = -8, C = -0.05.
Excel formula (assuming T is in column A, starting at A2):
=15000*EXP(-8*EXP(-0.05*A2))
T
Sales (approx.)
0
5.03
10
116.91
20
790.03
30
2,512.16
40
5,079.92
50
7,780.40
60
10,071.63
70
11,781.97
80
12,954.33
90
13,724.77
100
14,212.38
110
14,517.39
120
14,705.50
130
14,820.58
140
14,891.92
150
14,933.76
160
14,959.78