preview

Obsolete Inventory Analysis

Satisfactory Essays

Upon analysis of the December 31, 2012 which was performed, it was noticed that there were fluctuations in inventory among all three cities, Ottawa, Toronto and Quebec. As a way to measure the profitability of all seven hundred and sixty seven products that are included in inventory report were created which analyzed items that carried a negative cost, inventory with turnover band and inventory that have become obsolete.
Negative Cost Items
An analysis of inventory and usage disclosed that all three locations had ongoing issues with the quantity in which inventory were ordered. Review of November and December revealed that items with a negative cost were present only at the Quebec and Toronto locations. Average selling price as of those dates …show more content…

Profits also fluctuated within the rage of no profit reported in Toronto in September to high profits of up to one hundred dollars. Additionally, there were products in Toronto, Quebec and Ottawa that were reported obsolete based on findings in the record of turnover. Those products within inventory totaled less than ten as of December 2012.
Obsolete Inventory
Upon review of items that were obsolete from inventory at Quebec Ottawa and Toronto depots it was found that all three locations shared this similarities. There were various items that are no longer existing which totaled to about thirty five products. Usage of these items listed as obsolete were used within the range of no usage at all to over thirty thousand.
Based on the information provided in the above indicated inventory analysis the financial controller and all interested parties within management will be better able to become informed regarding all indicated irregularities, material misstatements or inventory shrinkage . Furthermore, this will assist the management team in understanding and more effectively managing

Get Access