$166$ Chapter $3$: Linear Programming Modeling Applications with Computer Analyses in Excel

$3-20.$ An airline with operations in San Diego, California, must staff its ticket counters inside the airport. Ticket attendants work $6-$hour shifts at the counter. There are two types of agents: those who speak English as a first language and those who are fully bilingual $($English and Spanish$).$ The requirements for the number of agents depend on the numbers of people expected to pass through the airline's ticket counters during various hours. The airline believes that the need for agents between the hours of $6$ A$.$M$.$ and $9$ P$.$M$.$ are as follows:

$\backslash$table$[[,6A.M.-$

$9A.M.,9$ A$.$M$.$NOON,NOON$3$ P$.$M$.,3P.M.-$

$6P.M.,6P.M.-$

$9P.M.$

Label and define the decision variables, specify the objective function and all constraints in terms of decision variables. Demonstrate template used for excel solver and ok workbook, thank you.