Trying To Create Inventory Tracking Table

I need to get some help on creating a inventory tracking table. Here are the components I have:

1. Original list of inventory in:

2. List of service requests:

Using the data from these 2 tables I need to produce an inventory table that shows the current inventory, similar to the following:

One problem is that for certain equipment there will be a line item for each piece of equipment, a laptop per say, but for others like keyboards and mice it might have 1 entry with a quantity of 50.

Any help is appreciated.