Cost calculation in excel

It is necessary to configure the relaying of information on the release of finished products and containers unloaded from 1C with a full separation of costs. There is a final form of reporting that must be filled in.
The release of containers is not tied to manufactured products, but there are standards for packaging certain products in certain size boxes. Based on the remainder in the warehouses of containers, you need to set up some automatic selection of containers, taking into account the fact that the same products go to different customers.
The materials are a little more complicated. One product consists of several parts, the cost of which is the cost of the product. Product and part identification number - drawing number. Details are debited by demand number. On one demand can write off several different details or several identical. In both cases, the details can go on different outfits. This should be taken into account when calculating.
Also, there is a file on unfinished materials, which also need to be written off for release taking into account outfits (at the enterprise, the outfit indicates belonging to the product group), the detail can be the same, but made of different steel.