In the attached spreadsheet, you are given the demand and capacity information for two origins (1 and 2) and four destinations (A, B, C, D). The unit transportation costs between origins and destinations are also provided. You are asked to find the least costly way of moving the demands to the destinations from the two origins without violating their capacity constraints.

1- Define your decision variables, objective function, and constraints using words.

2- Write the algebraic formulation using mathematical notation.

3- Create the corresponding spreadsheet model using Solver and solve it. Explain what the optimum solution is and its cost.

In addition to your report, submit your Excel file with your spreadsheet model and solution.