can you please solve these using excel only

2. Solve the cargo loading problem (solved in class) for the following set of data: w1=4,r1=70,w2=1,r2=20,w3=2,r3=40,W=6 3. For the network in Figure 12.9, it is desired to determine the shortest route between cities 1 to 7. Define the stages and the states using backward recursion, and then solve the problem. Hint: use dummy nodes to create clear stages