We are supposed to use Excel Solver and the Analysis ToolPAK. I have a MAC and I have no idea how to do linear programming. I'm just very confused. Please show all formulas and work that you did in Excel and on paper.

Thank you!

1. Use Excel Solver to find the optimal solution to the Linear Programming problem given below. Report the values of Z, A, B and C in the optimal solution. State and interpret any non-zero Reduced Costs and Shadow Prices. Which constraints are binding?

Max Z = 4A + 9B + 5C Subject to: A + B 45 3B + 2C 33

All decision variables are non-negative.

2. BURT, a transit agency, offers three modes of subsidized travel: Trolley, Bus, and Ferry. Determine the number of trips in each mode that maximize the number of riders handled by BURT if the agency is constrained to a budget of $500,000 and 150,000 kg of CO2. Each mode has a capacity that limits its maximum number of trips (Max Trips). Do not constrain trips to integers.

Mode	Trolley (T)	Bus (B)	Ferry (F)
Riders per trip (R)	100	40	400
Cost per trip (C)	70	30	200
CO2 (kg) per trip (G)	20	15	230
Max Trips (M)	2500	4500	400

Let the decision variables be T, B, and F, i.e., the number of trips by each mode.

(a) I need screenshot of your excel spreadsheet and (b) sensitivity report. (c) If you could allow 1 more kg of CO2 release, how many more riders would there be in the optimal solution of the model? If you could increase the trolley capacity to 2501 trips, how many more riders would there be in the optimal solution of the model?