[Expert Solution]: Create an inventory of 10 office supplies…

Create an inventory of 10 office supplies including how much of the item should be available in the office (the maximum amount on the shelf) and the reorder point (the least amount that can be available). Then, add a current amount and show how many need to be ordered. Remember that office supplies are consumables which means that they get “used up” as compared to capital equipment that is durable and used over a long period of time. Only include supplies on this list. Take for example an ink pen, which is categorized as a supply. The pen will be used up in a few weeks as compared to a telephone which is used repeatedly and lasts for years and would be considered durable equipment. Supplies must be kept “in stock” and reordered routinely. See the PowerPoint on Inventory management for this week as a guide to create the table. You may use Excel or Word to complete this assignment. Some examples are shown for you.