Purchase Solution

A Linear Program for determining Bus Drivers for a Bus Company

Not what you're looking for?

Ask Custom Question

A bus company believes that it will need the following numbers of bus drivers during each of the next 5 years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; 75 drivers in year 5. At the beginning of each year, the bus company must decide how many drivers to hire or fire. It costs $4000 to hire a driver and $2000 to fire a driver. A driver's salary is $10,000 per year.
At the beginning of year 1 the company has 50 drivers. A driver hired at the beginning of a year can be used to meet the current year's requirements and is paid full salary for the current year.

a. Determine how to minimize the bus company's salary, hiring, and firing costs over the next 5 years.

Purchase this Solution
Solution Summary

This solution clearly sets-up and solves the linear program in the attached Excel file.

Solution Preview

Please see the attached file.

Gray Cells > given data

Red Cell > ...

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

View More Free Quizzes
Related BrainMass Solutions

  • School bus driver company's strategic plan

    A school bus driver company provides drivers to the schools. The main function of the company is to recruit appropriate drivers and to provide sufficient training to them.

  • Optimization Modeling: Applications

    At the beginning of each year, the bus company must decide how many drivers to hire or fire. It costs $4000 to hire a driver and $2000 to fire a driver. A drivers salary is $10,000 per year. At the beginning of year 1, the company has 50 drivers.

  • Omar Khaleel: Bus Driver Applicant Discrimination

    Therefore, he asked Omar to submit a more stringent background check than was used for other bus drivers. Eight months later, the background check was completed and Omar was hired as a driver.

  • Relevant cost

    Bus drivers are paid fixed annual salaries, tour guides are paid for each tour conducted b.

  • Choose the best interpretation of the hypothesis test.

    324084 Interpretation of the Hypothesis Test (TCO 8) The mean age of school bus drivers in Denver is claimed to be 56.9 years. A hypothesis test is performed at a level of significance of 0.05 with a P-value of 0.03.

  • Case Study: Chengdu Bus Group

    The company, Chengdu Bus Group, has been facing serious issues in its operations. There is a need to rectify the problems, for which Dr. Chen has been appointed as a new CEO.

  • Statistics - Two-null Hypothesis Tests

    Develop two-null hypothesis tests to ascertain if there are any statistical variances in the averages of bus route times and any statistical variance among the average performance of the bus drivers.

  • Graphing Linear Equations Word Problems

    121470 Graphing Linear Equations Word Problems A bus company in a small town has an average number of riders of 800 per day. The bus company charges $2.25 for a ride.

  • Bus Case Study: Randomized block ANOVA test using Excel

    Use the following information to conduct the test: The three bus routes are the treatments. The three bus drivers are the blocks. The common element is driving time.

View More Related Solutions