Business Homework Solutions
Problem
#278127

DECISION MODELS-- excel spreadsheet, using SOLVER

HI there:

I 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?

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$39.90)
Included in Download
  • Plain text response
  • Attached file(s):
    • olympic_airlines.xlsx
    • olympic_airlines_2.xlsx
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse