Question

At end of which year did Honda motors earn the highest profit?

• A. 2010
• B. 2006
• C. 2003
• D. 2001

Answer 1

The correct option is A 2010

According to the information given let us first see few formulas and then we can draw a table for revenues, profits, cash surplus and cumulative stock at end of each year.
Total production cost =Fixed Cost +(cost of each unit of body $\times 2$ $\times$ production ) +(Cost of each unit of engine $\times 3$ $\times$ production )
Total revenues =Selling Price $\times$ Sales
Cumulative Stock =(Cumulative Stock of previous year + Production -Sales)
Cash Surplus =(Cash Surplus of previous year + Revenue -Cost)
Also, they have a cash surplus of 10 million and there is no cumulative stock at the starting of the year 2001.
Note:
$CS\to$ Cumulative Stock (year end)
$TPC\to$ Total Production Cost (in millions)
$TSR\to$ Total Selling Revenues (in millions)
$TP\to$ Total Profit at end of year (in millions)
$CSP\to$ Cash Surplus (in millions)
$\begin{array}{cccccc}Years& CS& TPC& TSR& TP& CSP\\ 2001& 3000& 195& 240& 45& 55\\ 2002& 6000& 234& 200& -34& 21\\ 2003& 4000& 425& 484& 59& 80\\ 2004& 7000& 423.4& 345& -78.4& 1.6\\ 2005& 8000& 571.25& 576& 4.75& 6.35\\ 2006& 1000& 466& 570& 104& 110.35\\ 2007& 3000& 464& 420& -44& 66.35\\ 2008& 6000& 480& 420& -60& 6.35\\ 2009& 7000& 422.2& 420& -2.2& 4.15\\ 2010& 3000& 353.75& 532& 178.25& 182.4\end{array}$