Chapter $4$B Excel Assignment Inventory Levels$||$

This Excel assignment involves the monitoring of inventory levels of a business. You will determine which items fall below their reorder points so such items can be reordered. You will calculate the amount from the reorder point on a quantitative and percentage basis. You will then copy this first worksheet for the next request.

On the second worksheet, using a table, determine the items that must be reordered.

You will then go back to the first worksheet and present the results in a chart. In your chart, focus on the Item Number and Inventory Reorder Status. You will be able to see what items need to be reordered and what items do not.