A cement company has 3 (three) factories in different locations, namely in A, B, and C. Production costs in A are Rp. 600,024 per ton, in B Rp. 400,024 per ton and in C Rp. 500.024,- per ton. Each factory currently only produces 100,024 tons per day according to market demand, even though the actual installed capacity of the three factories is capable of producing 120,024 tons per day. The company sends production from the three factories to 3 (three) distributor locations, namely X, Y, and Z. The demand for Distributor X is 100,024 tons per day, Distributor Y is 120,024 tons per day, and Distributor Z is 80,024 tons per day. The company wants to use warehouses located at J and K with a storage capacity of 125,024 tons and 175,024 tons per day respectively and shipping costs (in thousands of rupiah) as shown in the table below. The value "M" means it is not possible to make a delivery.

The goal of the company is to minimize total costs. Therefore, help the company with:

1. Formulate this problem by drawing a conceptual model with a network model
2. Defining the decision variables, modeling the objective function mathematically and modeling the constraints
3. Find a solution (allocation from the factory to the buffer warehouse and allocation from the buffer warehouse to the distributor) of the problems above using the solver including the total cost (excell or lingo)

Biaya distribusi Pabrik A B C J 75 M 60 Warehouse K M 85 90 Warehouse J K X M 80 Disributor Y 80 90 Z 125 M