Customer and supplier at same time

Hi, Everyone

I would like you help for my project. I have a dilemma.

My data model is related to Business Industry. We have several factories and several deposits related to it. The deposits vedem products to customers, but perform transfer of products between them. In this case, the seller is also a client.

I thought of desing 2 tables fact .: 1 - Sales 2 - transfer.

like this,

1)

customer_id
product_id
qt_product


2)
deposit_id (not customer_id)
product_id
qt_product

the problem is: the manager wants to see the total cost of manufacturing output. And so, we have 2 cost facts.

Is there a way to have a single fact cost?


best regards,
Fabricia Barbosa