Create an application to solve a dynamic assignment problem for three different travel choices.

You are given unit cost and time/stop for each travel method. Let the user either minimize total travel cost or total travel time.

#1 Create dynamic application in VBA to run Excel Solver model.

Use the given model notes to setup the formulas and Solver model in Excel.

Use VBA to ask the user if they want to minimize total travel Cost or Time and modify the objective function range dynamically.

If they want to minimize Cost, ask them for maximum Time Limit. If they want to minimize Time, ask them for maximum Cost Limist.

If a solution was found, report the total number of stops for each travel option.

If no solution could be found, ask them if they want to try different input and prompt them for the max limit value again and re-solve.

Based on the instructions, solve #1 step by step and show all the necessary steps.

some info, the light orange cells(B15:D20) are named Travel DV. Other cells are named the same as their title row or column, like cell B23:D23 is named Unit_Cost.

12 13 Assignment \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 14 & City & Truck & Train & Plane & Delivered & Demand & \multirow[b]{2}{*}{ Solve Assignment } \\ \hline 15 & Alexandria & & & & & 383 & \\ \hline 16 & Bburg & & & & & 349 & \\ \hline 17 & Cburg & & & & & 233 & \\ \hline 18 & Roanoke & & & & & 165 & \\ \hline 19 & Salem & & & & & 153 & \\ \hline 20 & Vienna & & & & & 262 & \\ \hline \multicolumn{8}{|l|}{21} \\ \hline 22 & Total Load & & & & & & \\ \hline 23 & Unit Cost & $11.00 & $5.00 & $25.00 & & & \\ \hline 24 & Number Stops & & & & & & \\ \hline 25 & Time/Stop & 7.00 & 12.00 & 2.00 & & & \\ \hline \multicolumn{8}{|l|}{26} \\ \hline 27 & Total Travel Cost & & Max Cost & $25,000.00 & & & \\ \hline 28 & Total Travel Time & & Max Time & 60.00 & & & \\ \hline 29 & & & & & & & \\ \hline 30 & & & & & & & \\ \hline \end{tabular} 31 Truck Load = sumproduct(assigned city, city delivery units) 32 City Delivered = sum truck assignments per city 33 City Delivered =1 34 Total Travel Cost = sumproduct(total load, unit cost) Total Travel Time = sumproduct(number stops, time/stop) total cost