need help with this question– need ASAP:

1. Olympic Airlines is a rapidly growing airline with a reputation for fast and efficient service. You have been asked to help Olympic schedule its telephone reservation clerks for the eight hour day shift with the objective of minimizing staffing costs while providing a high level of customer service. In order to keep up with calls to its reservation system, Olympic requires at least the following number of clerks

Mon, Fri 21
Tu-Th 18
Sa, Su 15.

Full time reservation clerks work in blocks of 5 consecutive days, starting on any day of the week, and are paid $85/day on weekdays and $120/day on Saturdays and Sundays. Part-time reservation clerks work in blocks of 3 consecutive days, starting on either Friday or Saturday, and are paid $220 dollars per 3-day block.

Use Excel Solver to obtain the minimum LP cost solution.

a. What is the minimum cost of staffing the reservation lines for one week? How many full-time and how many part-time clerks are required? How many full time and part time clerks begin their work week on each day?

b. On which days, if any, is the minimum number of clerks exceeded and by how much?

need help with this question– need ASAP:

1. Olympic Airlines is a rapidly growing airline with a reputation for fast and efficient service. You have been asked to help Olympic schedule its telephone reservation clerks for the eight hour day shift with the objective of minimizing staffing costs while providing a high level of customer service. In order to keep up with calls to its reservation system, Olympic requires at least the following number of clerks

Mon, Fri 21
Tu-Th 18
Sa, Su 15.

Full time reservation clerks work in blocks of 5 consecutive days, starting on any day of the week, and are paid $85/day on weekdays and $120/day on Saturdays and Sundays. Part-time reservation clerks work in blocks of 3 consecutive days, starting on either Friday or Saturday, and are paid $220 dollars per 3-day block.

Use Excel Solver to obtain the minimum LP cost solution.

a. What is the minimum cost of staffing the reservation lines for one week? How many full-time and how many part-time clerks are required? How many full time and part time clerks begin their work week on each day?

b. On which days, if any, is the minimum number of clerks exceeded and by how much?