Please explain both in a word and Excel File. (Supply Chain Management: Strategy, Planning, and Operation (7th edition), by Sunil Chopra and Peter Meindl, Pearson, 2019. )

Bahouth Ltd. is planning for the next two years of production and debating whether to construct a large cross-dock facility with 40 truck bays or a smaller one with 20 truck bays. The cost to build the large facility is $1.8 million and the cost to build the small one is $1.2 million. If they construct a large facility and demand is as high as they hope, then operating costs are $450,000 annually. If they construct a large facility and demand is low, then operating costs are $300,000. If they construct a small facility and demand is low, the operating costs are $275,000 but if they experience high demand, the operating cost of a small facility increases to $600,000. After having conducted some market research, they feel that the likelihood of high demand is 0.6 and the likelihood of small demand is 0.4. Given the information above, determine the total (operating and building) cost of the best alternative for a two year period. Show your omplete analysis in a Word or Excel file.