I need the following problems in Excel Solver format that I can upload.

SOLVER 6

Problems: Network Models

100 Points

1) Formulate and solve a spreadsheet model for the maximum flow problem, shown below, where node A is the source, node F is the sink, and arc capacities are numbers in parentheses shown next to arcs.

2) Formulate and solve a spreadsheet model for the shortest path problem, shown below, starting from ORIGIN and ending in DESTINATION. Distances between points in miles in parentheses are shown next to arcs.