Question

As an inventory manger, you are checking the daily inventory of at the end of a workday. The inventory changer for one day are given in the table shown.

Answer 1

Given the table in the attached image;

The final stock can be calculated as;

`\text{ Final stock = Initial stock + stock in }-\text{ stock out}`

Let us work out the final stock for each product to confirm if it is correct;

For CBZ;

`\begin{gathered} \text{ Final stock = 350 + 150 -32} \\ \text{ Final stock = 468} \end{gathered}`

For ALT;

`\begin{gathered} \text{ Final stock = 550+100-45} \\ \text{ Final stock = 605} \end{gathered}`

For SAD;

`\begin{gathered} \text{ Final stock = 1,200+50-42} \\ \text{ Final stock = 1,208} \end{gathered}`

For PAB;

`\begin{gathered} \text{ Final stock =}760+125-57 \\ \text{ Final stock = 828} \end{gathered}`

For MTI;

`\begin{gathered} \text{ Final stock =}940+200-18 \\ \text{ Final stock = 1,122} \end{gathered}`

From the calculations above, we can observe that the only wrong final stock is for Product ID ALT.

It is supposed to be 605 instead of 695.

Therefore, the product ID with a mistake in the final stock is ALT