I will thumbs up please do this in excel and paste pictures of the equations and everything

https://www.chegg.com/homework-help/questions-and-answers/question-4-spm-auto-inc-manufacturer-machine-parts-seen-demand-grow-significantly-company--q60135938?trackid=50ca2ada6ada&strackid=43127586e0c7

I FOUND A SIMILAR CHEGG LINK BUT PLEASE CHECK THE NOTE AT THE BOTTOM OF THIS PICTURE AND EXPLAIN UR WORK FOR ME PLZ!

AutoDoors Inc., a manufacturer of automotive doors has seen its demand grow significantly. The company anticipates demand for the next year to be 450.000 units in Ontario, 650,000 units in Michigan and 300,000 units in Ohio. Managers are designing the network and have selected three potential sites - Windsor. Detroit and Toledo. Plants could have a capacity of 500,000 or 900,000 units. The annual fixed costs at the three locations are shown below along with the cost of producing and shipping each unit. Considering the cost only, where should AutoDoors build its plants and how large they should be? If only one plant is allowed at each supply city, where should AutoDoors build its plants and how large they should be? Supply Region Detroit Windsor Toledo S 5,100,000 6.100.000 $ 7,100,000 S 8,100,000 S 11.100.000 $ 14,100,000 Annual Fixed Cost of 500.000 capacity plant Annual Fixed Cost of 900.000 capacity plant Ontario MI OH s S S Markets 310 410 510 $ $ 410 510 610 S S S 510 610 710 $ NOTE: For each of the questions, formulate and solve the problem. Show algebraic formulation the optimal location optimal size of the plants associated total annual cost. AutoDoors Inc., a manufacturer of automotive doors has seen its demand grow significantly. The company anticipates demand for the next year to be 450.000 units in Ontario, 650,000 units in Michigan and 300,000 units in Ohio. Managers are designing the network and have selected three potential sites - Windsor. Detroit and Toledo. Plants could have a capacity of 500,000 or 900,000 units. The annual fixed costs at the three locations are shown below along with the cost of producing and shipping each unit. Considering the cost only, where should AutoDoors build its plants and how large they should be? If only one plant is allowed at each supply city, where should AutoDoors build its plants and how large they should be? Supply Region Detroit Windsor Toledo S 5,100,000 6.100.000 $ 7,100,000 S 8,100,000 S 11.100.000 $ 14,100,000 Annual Fixed Cost of 500.000 capacity plant Annual Fixed Cost of 900.000 capacity plant Ontario MI OH s S S Markets 310 410 510 $ $ 410 510 610 S S S 510 610 710 $ NOTE: For each of the questions, formulate and solve the problem. Show algebraic formulation the optimal location optimal size of the plants associated total annual cost