can you please help me proceed by giving the FORMULA OF THE "ADDTIONAL FIXED COST" look at my EXCEL SHEET

when I run it in solver it keeps giving me negative total cost which means I need to define my fixed amount too

I will give thumbs up if it was helpful!

Table (2): Fabric Demands for March (Bolts) Distribution Center Mexico City Manila Fabric Los Angeles Chicago London Rome Tokyo New York 500 Cotton Polyester Silk 1.000 100 800 2.000 100 900 3,000 200 900 1,500 SO 800 400 400 100 700 1200 200 900 700 700 2.500 i 200 Table (3): March Production Capacities (Bolts) Production Capacity Cotton Polyester Mill Silk Bahamas Hong Kong Korea Nigeria Venezuela 1.000 2.000 1.000 2.000 1.000 3,000 2,500 3,500 0 2,000 0 1,000 500 0 0 Table (1): Shipping Cost Data (dollars/bolt) Distribution Center Mexico City Manila Mill Los Angeles Chicago London Rome Tokyo New York 2 3 3 10 Bahamas Hong Kong Korta Nigeria Venezuela 1 8 2 7 6 12 3 7 4 1 10 4 11 2. The company will be opening a silk-making department in the Nigeria mill. Although it will not be completed for several months, a current capacity of 1,000 bolts for that fabric might be during March for an added one-time cost of $2,000. Find the new optimal shipment schedule and the total cost for that fabric. Should the Nigeria mill process silk in March? F H 1 Oo oo B C D E G 1 mill bahamas hong kong korea nigeria venezula demand 2 los angeles 2 6 5 14 4 100 3 chigaco 2 7 6 12 3 100 4 london 3 8 8 6 5 200 5 mexio 3 10 11 9 1 50 6 manila 7 2 4 11 9 400 7 rome 4. 9 9 7 6 200 8 tokyo 7 4 1 5 11 700 9 new york 1 8 7 10 4 200 10 capacity 0 1000 500 1000 0 11 12 mill bahamas hong kong korea nigeria venezula total 13 los angeles 0 0 14 chigaco 0 0 15 london 0 16 mexio 0 17 manila 0 0 -18 rome 0 0 19 tokyo 0 0 20 new york 0 0 21 total 0 0 0 22 23 total cost 0 24 add. Fixed cost O O O O O O O O O O O