Mathematics AI SL's Sample Internal Assessment

Mathematics AI SL's Sample Internal Assessment

To investigate the growth of Eastman Auto & Power Limited Company in terms of profit with respect to time and cost of goods sold over a period of 5 years and determination of the corresponding time and expenditure to maximize the profit.

5/7
5/7
10 mins read
10 mins read
Candidate Name: N/A
Candidate Number: N/A
Session: N/A
Word count: 1,916

Table of content

Rationale

Mathematics is a very versatile field. It has always inspired me go beyond the scope of the curriculum and analyze different real life scenarios using mathematics. It is extensively used in the study of businesses. Being and inquirer and aspiring to be an entrepreneur in the future, I wanted to effectively study businesses with the help of mathematics. The concepts of maxima, minima, integration and differentiation have helped me analyze the data to arrive at useful conclusions.

 

Before the pandemic hit the businesses, I wanted to study the growth of a company to determine the time and expenditure to maximize the profit. As I aspire to be an entrepreneur, it’s essential to understand the growth of a company and on which factors and how it depends. I have taken the data from the yearly balance sheets of the company Eastman Auto and Power limited over a period of approximately 5 years from June, 2016 to March, 2020. To determine how the profit varies with respect to time and cost of goods and to determine the maximum profit, the concepts of maxima, minima, integration and differentiation appeared to be very useful.

 

The study would be useful to the businesses to take calculated risks and right decisions to grow it. It would be also helpful to maximize the profit and determine the conditions under which it attains so.

Aim

To investigate the growth of Eastman Auto and Power limited company in terms of profit with respect to time and cost of goods sold over a period of 5 years and thus determining the corresponding time and expenditure to maximize the profit.

Background

Profit and cost of goods sold

The immediate capital earned from selling goods produced by a company is the total revenue. The company uses a portion of the capital earned or the revenue to produce further goods or cuts the costs for making the goods (which is the Cost of goods sold) from the revenue earned. The capital which remains is called the profit.

Differentiation

Let y = f(x) be a single valued function of x defined in some interval. Let x be any value of x in the domain of definition of the function and the corresponding value of y is y = f(x). Suppose for an increment ∆x of x the corresponding increment in y is ∆y.

 

Then,\(\frac{∆y}{∆x}=\frac{dy}{dx}=\frac{f(x+h)-f(x)}{h}\) is called the derivative of the function y with respect to x, provided the limit exists.

Integration

Let f(x) be a bounded single valued continuous function defined in the interval [a,b]. The interval [a,b] is divided into n equal sub-intervals, each of length h.

 

Then,\(\displaystyle\int\limits^b_af(x)dx=h\sum^{n-1}_{r=0}f(a+rh)\) is the integration or the integral of the function f(x) with respect to x between the limits a and b.

Concepts of minima and maxima

The maximum value of any function y = f (x) is called the maxima of the function, and the minimum value of the function is called the minima of the function. This is an application of differential calculus. Any function y = f (x) could be graphically represented in Cartesian coordinate system. The slope at any point of the function could be determined by finding the derivative of the function at the particular point. Slope of any curve equal to zero signifies that the tangent at that point of the curve is parallel to X – axis. As a result, if the equation of slope of the curve is equated to zero, and the root of the equation is determined, then it would be the value of x at which the function is either maximum or minimum. In order to determine the maxima or minima, the equation of slope is further differentiated and if the value of equation is obtained to be negative, then the point is maxima, and vice versa.

Methodology

The study has been done mainly in three steps. Firstly, the values of Profit (taken quarterly) with respect to time has been plotted to obtain the Profit as a function of time and the local maximum has been determined to know at what time the Profit reaches its maximum value. Secondly, the values Cost of goods sold (COGS) (taken quarterly) with respect to time has been plotted to obtain the Cost of goods sold (COGS) as a function of time and the local minimum has been determined to know at what time the Cost of goods sold (COGS) reaches its minimum value. Lastly, the Profit has been expressed as a function of Cost of goods sold (COGS) to determine how the Profit varies with respect to the Cost of goods sold (COGS) and to determine the local maximum or the maximum value of the Profit and at what value it reaches so.

Data collection and calculation

YearMonthIndexProfit
2016June158780477
2016September261552683
2016December364854311
2017March468654782
2017June572439854
2017September668610768
2017December765005376
2018March854414169
2018June950446665
2018September1056509717
2018December1160286127
2019March1250611648
2019June1345501624
2019September1442855761
2019December1543477561
2020March1632288409

Figure 1 - Table On Variation Of Profit (Taken Quarterly) From June, 2016 To March, 2020

Figure 2 - Variation Of Yearly Profit (Taken Quarterly) From The June, 2016 To March, 2020

After plotting the values of profit (taken quarterly for each year) with respect to time (as per indexing), we get the profit expressed as a function of time. The equation is given by, y = - 22820x+ 2000000x + 60000000…(i) where y = p (say) denotes the profit and x = t (say) denotes the time.

 

∴p = - 22820t+ 2000000t + 60000000…(i)

Calculation of local maximum

Now, to calculate at what time the profit reaches its maximum value, we will calculate the local maximum of the function and at what point it reaches so. To calculate the maximum of the function p = f (t), we have to first equate the derivative of the function to zero. 

 

p = - 22820t+ 2000000t + 60000000…(i)

 

\(\frac{dp}{dt}=\frac{d}{dt}\) (-22820t+ 2000000t + 60000000)

 

\(\frac{dp}{dt}=\frac{d}{dt}\big(-22820t^2\big)+\frac{d}{dt}(2000000t)\frac{d}{dt}(60000000)\)

 

\(\frac{dp}{dt}\)= - 45640t + 2000000 + 0

 

\(\frac{dp}{dt}\) = - 45640t + 2000000…(ii)

 

Now, we equate the equation obtained to zero.

 

\(\frac{dp}{dt}\) = - 45640t + 2000000 = 0

 

\(t=\frac{-2000000}{-45640}\)

 

t = 43.82

 

Now, we will further differentiate the equation and calculate its numerical value at t = 43.82

 

\(\frac{dp}{dt}\) = - 45640t + 2000000

 

\(\frac{d^2p}{dt^2}\) = - 45640

 

Therefore, at the point t = 43.82,

 

\(\frac{d^2p}{dt^2}\) = - 45640, which is negative

 

Hence, p = - 22820t2 + 2000000t + 60000000 will have its maximum value at t = 43.82. At t = 43.82, the value of the local maximum is,

 

p = - 22820t2 + 2000000t + 60000000

 

p = - 22820×43.82+ 2000000×43.82 + 60000000

 

p = 103821209.43 (in INR)

Figure 3 - Variation Of Cost Of Goods Sold (COGS) (Taken Quarterly) From June, 2016 To March, 2020

YearMonthIndexCOGS
2016June11349071587
2016September2767738939
2016December31356275870
2017March41590624659
2017June51620682736
2017September61535555852
2017December71615635389
2018March81946676706
2018June91667878045
2018September102137319305
2018December112114832764
2019March122461816607
2019June132707886937
2019September142660489057
2019December153137073824
2020March163704206763

Figure 4 - Table On Variation Of Cost Of Goods Sold (COGS) (Taken Quarterly) From June, 2016 To March, 2020

After plotting the values of the Cost of goods sold (COGS) (taken quarterly for each year) with respect to time (as per indexing), we get the profit expressed as a function of time. The equation is given by, y = 80000000x+ 600000000x + 1000000000…(iii) where y = c (say) denotes the profit and x = t (say) denotes the time.

 

∴c = 80000000t2 + 600000000t + 1000000000…(iii)

Calculation of local minimum

Now, to calculate at what time the Cost of goods sold (COGS) reaches its minimum value, we will calculate the local minimum of the function and at what point it reaches so. To calculate the minimum of the function c = f (t), we have to first equate the derivative of the function to zero.

 

c = 80000000t2 + 600000000t + 1000000000…(iii)

 

\(\frac{dc}{dt}=\frac{d}{dt}\) (80000000t2 + 600000000t + 1000000000)

 

\(\frac{dc}{dt}=\frac{d}{dt}\big(80000000t^2\big)+\frac{d}{dt}(600000000t)+\frac{d}{dt}(1000000000)\) 

 

\(\frac{dc}{dt}\) =160000000t + 600000000…(iv)

 

Now, we equate the equation obtained to zero.

 

\(\frac{dc}{dt}\)=160000000t + 600000000 = 0

 

\(t=\frac{-600000000}{160000000}\)

 

t = 3.75

 

Now, we will further differentiate the equation and calculate its numerical value at t = 3.75

 

\(\frac{dc}{dt}\) = 160000000t + 10000000

 

\(\frac{d^2p}{dt^2}\) = 160000000

 

Therefore, at the point t = 3.75,

 

\(\frac{d^2p}{dt^2}\) = 160000000, which is positive.

 

Hence, c = 80000000t2 + 600000000t + 1000000000 will have its minimum value at t = 3.75.

 

At t = 3.75, the value of the local minimum is,

 

c = 80000000t2 + 600000000t + 1000000000

 

c = 80000000×3.752 + 600000000×3.75 + 1000000000

 

c = 1337500000(in INR)

 

Now, dividing equation (ii) by equation (iv) we get,

 

\(\frac{dp}{dt}\) = - 45640t + 2000000…(ii)

 

\(\frac{dc}{dt}\) = 160000000t + 600000000…(iv)

 

\(\frac{\frac{dp}{dt}}{\frac{dc}{dt}}=\frac{-45640t+2000000}{160000000t+600000000}\)

 

\(\frac{dp}{dc}=\frac{-0.4564t+20}{1600t+6000}\)

 

\(\frac{dp}{dc}\) = - 0.00028 - \(\frac{21.71}{1600t+6000}\) …(v)

 

We get equation (v) which is the general equation for the rate of change of Profit with respect to Cost of goods sold.

 

Now, we put the value of t in terms of c, which we can calculate from equation (v).

 

c = 8000000t2 + 600000000t + 1000000000…(iii)

 

\(\frac{c}{10^8}\) = 0.08t2 + 6t + 10

 

\(t =\frac{-c}{71.59\times10^8}\) -73.29

 

Now, by putting the value of t in equation (v) we get,

 

\(\frac{dp}{dc}=-0.00028-\frac{{21.71}{-c}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\)…(vi)

 

Now, integrating equation (vi) we get,

 

\(\frac{dp}{dc}=-0.00028-\frac{{21.71}{-c}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\)

 

\(\displaystyle\int dp=\displaystyle\int(-0.00028-\frac{{21.71}{-c}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000})dc\)

 

\(p=\displaystyle\int-0.00025dc-\displaystyle\int\frac{{21.71}{-c}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}dc\)

 

\(p=\displaystyle\int-0.000028dc-\displaystyle\int\frac{{21.71}{-c}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}dc\)

 

p = - \(\frac{7c}{25000}+\frac{388554725ln(c+497836860000)}{4}\) + C1

 

Where C1 is the constant of integration.

 

Now, to calculate the numerical value of the constant of integration, we put the values of Profit and Cost of goods sold when the time (as per indexing) is 1.

 

p = - \(\frac{7c}{25000}+\frac{388554725ln(c+497836860000)}{4}\) + C1

 

Putting p = 58780477 and c = 1349071587 we get,

 

58780477 = - \(\frac{7×1349071587}{25000}+\frac{388554725ln(1349071587+497836860000)}{4}\) + C1

 

C1 = 58780477 + 377740.04 + 97138681.25×26.936

 

C1 = 2675685735.19

 

Therefore, we get the Profit expressed as a function of Cost of goods sold as,

 

p = - \(\frac{7c}{25000}+\frac{388554725ln(c+497836860000)}{4}\) + 2675685735.19…(vii)

Figure 5 - Variation Of Profit With Respect To Cost Of Goods Sold

Calculation of local maximum

Now, to find out the local maximum or local minimum of the above function p = f(c), we first equate the derivative of the function to zero.

 

\(\frac{dp}{dc}=-0.00028-\frac{{21.71}{}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\) = 0

 

\(\frac{{-21.71}{}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\) = 0.00028

 

\(\frac{-21.71}{0.000280}-6000=1600\bigg(\frac{-c}{71.59×10^8}-73.29\bigg)\)

 

c = 844760721607

 

Now, we will further differentiate the equation and calculate its numerical value at c = 844760721607

 

\(\frac{dp}{dc}=-0.00028-\frac{{21.71}{}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\)

 

\(\frac{d^2p}{dc^2}=\frac{d}{dc}(-0.00028-\frac{{21.71}{}}{1600(\frac{-c}{71.59\times10^8}-73.29)+6000}\big)\)

 

\(\frac{d^2p}{dc^2}=\frac{d}{dc}(-0.00028)-\frac{d}{dc}(\frac{{21.71}{}}{1600\bigg(\frac{-c}{71.59\times10^8}-73.29\bigg)+6000})\)

 

\(\frac{d^2p}{dc^2}=\frac{-388554725}{4 (c+497836850000)^2}\)

 

Therefore, at the point c = 844760721607,

 

\(\frac{d^2p}{dc^2}\) = - 5.39×10-17, which is negative

 

Hence, p = - \(\frac{7c}{25000}+\frac{388554725ln(c+497836860000)}{4}\) + 2675685735.19 will have its local maximum at c = 844760721607.

 

At c=844760721607, the value of the local maximum is,

 

p = - \(\frac{7c}{25000}+\frac{388554725ln(c+497836860000)}{4}\) + 2675685735.19

 

p = - \(\frac{7×844760721607}{25000}+\frac{388554725ln(844760721607+497836860000)}{4}\) + 2675685735.19

 

p = 5152000000 (in INR)

 

Therefore, the Profit is maximum which is 5152000000 (in INR) when the Cost of goods sold is 84460721607 (in INR).

Conclusion

According to the data taken regarding the Profit and Cost of goods sold (taken quarterly for each year) from the year 2016 to the beginning of the year 2020, the following assumptions can be made:

  • From the Profit vs. Time (as per indexing) graph, the values of Profit keeps going with increasing time and reaches its maximum at time t = 43.82 but the values of Cost of goods sold have gone up with each passing quarter. This indicates inefficiency of the production work or the deterioration of the quality of goods or the sales has gone significantly down.
  • From the Cost of goods sold (COGS) vs. Time (as per indexing) graph, the values of Cost of goods sold have gone up with each passing quarter. The value of the Cost of goods sold (COGS) reaches its minimum value at time t = 3.75. The values of Profit have not increased as such. This indicates that the production cost has increased significantly over time due inflation or significant increase in the quantity of goods produced.
  • From the Profit vs. Cost of goods (COGS) graph, the profit almost remains constant and reaches its maximum 5152000000 (in INR) when Cost of goods sold (COGS) c is 84460721607 (in INR). This indicates that the sales have significantly gone down or the quality of the products has deteriorated.
  • The company should invest more on checking the quality of the goods than producing more goods.
  • The company should invest more on the marketing department in order to reach the people and make them aware of its various goods.

Reflection

Strength

  • The data taken, contains the values of Profit, Cost of goods sold (COGS), which are taken quarterly for each year, varies over a period of approximately 4 years, starting from June, 2016 to March, 2020. The variations of Profit and Cost of goods sold with respect to time have been studied. The variation of Profit with respect to the Cost of goods sold has also been studied, which makes the study coherent.
  • The values of Profit and Cost of goods sold has been taken quarterly for each year instead of just considering the net yearly profit, which makes the study more coherent and relevant to arrive at certain important conclusions.
  • The data has been taken from the balance sheets of the company which makes it authentic, error free and could be considered to do a critical analysis.

Weakness

  • The data has been taken from the balance sheets of a registered company but there is little to no scope of verifying the data, which may lead to discrepancy in the collected data which would make the study less coherent.
  • It was assumed that the variation of Profit and Cost of goods sold would follow the same trend in the future to arrive at certain conclusions. However, this might not be the case in real life.
  • Other real life factors related to the working of the company which actually effects the profit and loss statement and the cost of goods have not been considered which makes the study less coherent and cannot be relied upon entirely to take important decisions for the growth the company.

Further scope

Mathematics is essential to analyze various aspects and the balance sheets of a company to make important and crucial decisions for the growth of the company. Also to maximize profits and to minimize the costs, a mathematical exploration is needed. The above study is done excluding certain real life factors related to the working of the company such as equity and liabilities, different investments, marketing etc. As an extension to this study, one could also analyze the certain other real life factors mentioned earlier. Another study could be framed to study the increment or reduction in the equity and liabilities of the company over a given period of time. A study could be done on the increase or decrease of income generated from various investment. One could also analyze the marketing strategies of the company and its outcomes in order to obtain useful results which would be required to decide innovative and more efficient marketing strategies.

Bibliography

  • “Understanding Cost of Goods Sold – COGS.” Investopedia,https://www.investopedia.com/terms/c/cogs.asp. Accessed 18 Sept. 2021.
  • Finding Maxima and Minima Using Derivatives. https://www.mathsisfun.com/calculus/maxima minima.html.%20Accessed%2018%20Sept.%202021.
  • “Cartesian Coordinate System.” Wikipedia, 30 Aug. 2021. Wikipedia, https://en.wikipedia.org/w/index.php title=Cartesian_coordinate_system&oldid=1041463197.
  • Taken from profit and loss statement of Eastman Auto and Power limited
  • Taken from profit and loss statement of Eastman Auto and Power limited