Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with Excel problems. Use lookup tables (or equivalent) and values where appropriate so that if something changes ( e.g. the Arrival Airport changes),

Please help with Excel problems.

Use lookup tables (or equivalent) and values where appropriate so that if something changes (e.g. the Arrival Airport changes), the change is automatically reflected in the output.

image text in transcribed

image text in transcribed

\begin{tabular}{l|l|} \hline \multicolumn{2}{|l|}{ Weekday Lookup } \\ Day Number & Day Name \\ \cline { 1 } 1 & Sunday \\ \hline 2 & Monday \\ \cline { 1 - 2 } 3 & Tuesday \\ \hline 4 & Wednesday \\ \cline { 1 - 2 } 5 & Thursday \\ \hline 6 & Friday \\ \hline 7 & Saturday \\ \hline \end{tabular} \begin{tabular}{lc|c|c|c|} & & & & \multicolumn{2}{|c|}{ Ticket Booked X Days Before Travel } \\ Dach & & & Days & Surcharge \\ \hline Oklahoma City & $350.00 & $200.00 & $100.00 \\ \hline Kansas City & $375.00 & $215.00 & 7 & $75.00 \\ \hline DallasfFort Worth & $450.00 & $235.00 & 14 & $25.00 \\ \hline 21 & $ & \\ \hline \end{tabular} \begin{tabular}{l|l|} \hline \multicolumn{2}{|l|}{ Weekday Lookup } \\ Day Number & Day Name \\ \cline { 1 } 1 & Sunday \\ \hline 2 & Monday \\ \cline { 1 - 2 } 3 & Tuesday \\ \hline 4 & Wednesday \\ \cline { 1 - 2 } 5 & Thursday \\ \hline 6 & Friday \\ \hline 7 & Saturday \\ \hline \end{tabular} \begin{tabular}{lc|c|c|c|} & & & & \multicolumn{2}{|c|}{ Ticket Booked X Days Before Travel } \\ Dach & & & Days & Surcharge \\ \hline Oklahoma City & $350.00 & $200.00 & $100.00 \\ \hline Kansas City & $375.00 & $215.00 & 7 & $75.00 \\ \hline DallasfFort Worth & $450.00 & $235.00 & 14 & $25.00 \\ \hline 21 & $ & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Hale

14th Edition

0137943601, 9780137943609

More Books

Students also viewed these Finance questions