Solve it in an excel and show the formula

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: 6A.M.-9 A.M.-NOON 3 P.M-6P.M.- 9 A.M. NOON 3 P.M.6P.M. 9 P.M. 16 Agents 12 20 24 12 needed Agents begin work either at 6 a.m., 9 a.m., noon, or 3 p.m. The shifts are designated as shifts A B, C, and D, respectively. It is the policy of the airline that at least half of the agents needed in anv time period will speak Enalish as the first lanquage. Further, at least one-auarter of the Sensitivity Report 3 Question 3 Sheet4 (b)question 2