Excel Inventory Template

We sell cabinet sets, each set include 2-5 component pieces. We need excel to track our inventory by the SET, also by the components. -The first tab need to show Amount of each model by SET. -The second tab need to show amount by component. -We will manually adjust the quantity shipped by set each day (see attachment 1), when full set quantity is adjusted, each component quantity in tab 2 will adjust accordingly. When adjusting the component count in tab 2, the set count in tab 1 will adjust as well. Example Item Set - B30-DS Component1 B30-DS-CB Component2 B30-DS-CT Each set need "1" of each of the component above If Current component show 5 B30-DS-CB , 8 Component2 B30-DS-CT, then Tab 1 set count will be "5" if 1 set is deducted from tab 1, component count in tab 2 will change to 4 B30-DS-CB, 7 Component2 B30-DS-CT The first tab will need to display as attachment, each "1" with in the week means minus (shipped) 1. We can start a new sheet every month to keep the sheet clean. The sheet will need a template for a full month, with adding and subtracting for total. The second tab or new tab will need to have a column for adding inventory, when we receive new shipment, we will add the number of new arrival components, this will change the total component count in tab 2 and total set count in tab 1 Please make each other row alternative color for each read. Total 119 items and 333 component counts. The spreadsheet needs to be able to upload as a google spreadsheet or MS spreadsheet for editing Please do one item as an example