How to create inventory, cost and profit tracking system using excel

I am trying to make an excel tracking system for inventory, cost and profit.
For the 'kit' product, such as apple pie, there is no recipe. So I have no idea how many each components will be used.
For the development cost, prototype cost and test cost, how to distribute these cost to individual product?
The price of components might be fluctuate. How to use First-In-First-Out method to calculate the cost.

I really appreciate if anyone can give some advice to make this tracking system work.
Inventory Tracking System.xlsm

Hi Stella - you have a lot of moving parts here. What actually are you trying to do?