Formulate the following problems by writing objective functions and constraints, type or write by hand. For each problem, create an initial Excel worksheet, print it, print Solver parameters, and print the final Excel worksheet after solving the problem. From the final worksheet, write or type the final solution. All worksheets must have your name typed on the first row. PLEASE SHARE LINK TO EXCEL SHEET AND SOLVER PARAMETERS!!!!!!

1.RentR Cars is a multisite car rental company in Huntsville/Madison area. It is trying out a new return the car to the location most convenient for you policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability at the renting facility. The supply and demand for economy cars, cost of moving vehicles between sites per vehicle are shown below.

From / To	D	E	F	G	Supply
A	$9	$8	$6	$5	50
B	9	8	8	0	40
C	5	3	3	10	75
Demand	50	60	25	30

1. Draw a diagram by showing supply points, demand points, and connecting arcs.
2. Define variables, write the objective function and constraints.
3. Prepare an initial Excel worksheet, check your formulas, and save it.
4. Complete solver parameters, copy it, and save as a file.
5. Solve the problem and determine the optimal shipping schedule.
6. Write the shipping schedule and the value of the objective function by hand or type it.