At end of which year did the cumulative stock was the lowest?
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 ×2 × production ) +(Cost of each unit of engine ×3 × production )
Total revenues =Selling Price × 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→ Cumulative Stock (year end)
TPC→ Total Production Cost (in millions)
TSR→ Total Selling Revenues (in millions)
TP→ Total Profit at end of year (in millions)
CSP→ Cash Surplus (in millions)
YearsCSTPCTSRTPCSP20013000195240455520026000234200−342120034000425484598020047000423.4345−78.41.620058000571.255764.756.3520061000466570104110.3520073000464420−4466.3520086000480420−606.3520097000422.2420−2.24.1520103000353.75532178.25182.4