A mwiti-site large production company is looking to optimize its Jotal Cost of transportationishipping The production facilities are A, B, and C, Whth a supply capacity of 200,400 , and 600 -units per week. The distrbution centers are to D. E. F. and G, with a demand of 400,300 , and 500 units per week. A.D,A,A,F, and A,G unit costs are $80,$94, and $160 B-D, B-E, B.F. and B G unit costs are $140,$72, and $116. C.D,C.E,C. and C. 6 unit costs are $48,$122, and $142. Using Microsoft Excel temnlate model xisx, calculate the optimal Total Costs for shipping all the units from the production facilities to the various distribution centers. Total Cost Due to infation some costs have gone up; if CD is $50,BG is $120, and C.G is $150. what is the Iotal Cost now (5 points)