Linear programming problem using commuter bus

Reference no: EM1316556

Developing a linear programming problem using Commuter Bus scheduling to minimize the total cost.

Commuter Bus Scheduling:

You've been tasked with scheduling the routes on a commuter bus system to ensure adequate service is been provided to each of the transit locations, while minimizing the operating cost. Your company currently owns three buses that it uses to provide this service. Route information, including the operating cost and the transit locations served, is shown in the following table.

		Commuter Route
		A	B	C	D	E	F	G	H	I	J
Transit Location	1		1				1				1
	2	1	2		1			1		1
	3		3			1		2	1
	4			1	2						2
	5				3			3	2
	6						2			2
	7	2		2		2					3
	8	3					3		3
	9					3		4		3
Operating Cost ($1,000s)		7	3	3	7	5	4	8	5	4	6

Question: Develop an Excel model to select the three routes to be served by your company's buses in order to minimize the total operating cost while including a stop at each of the transit locations.

Reference no: EM1316556

Questions Cloud

Developing project network using aoa : Developing project network using AOA that determines completion times.

Computation of return of a given portfolio : Computation of return of a given portfolio of amount invested and this year nothing has changed except for the fact that the market risk premium has increased by 2 percent

Eptember energy consumption levels for single family homes : Findout the consumption level separating the bottom 45% to the top 55%. The September energy consumption levels for single family homes are found to the normally distributed with a mean

What percentage of time does the amount of rainfall : A month is classified as "extremely wet" if the amount of rainfall is in the upper 10% for that month. How much precipitation must fall before a month of April is classified as "extremely wet".

Linear programming problem using commuter bus : Developing a linear programming problem using Commuter Bus scheduling to minimize the total cost.

Computation of expected rate of return and beta : Computation of expected rate of return and Beta and Demonstrate to your colleagues how you would calculate the expected rate of return also called r-hat

Find the value of the second number : The sum of three numbers is 98. The ratio of the first to the second is 2:3, and the ratio of the second to the third is 5:8. Find the value of the second number?

Explain the weaknesses in lawrence sports : Short question based on cash budgeting - Compare Lawrence Sports' use of cash budgeting to the purpose of cash budgeting. Explain the weaknesses in Lawrence Sports' existing working capital policies that lead to their cash flow problem.

What is the probability the son attended college : The following data from a sample of 100 families show the record of college attendance by fathers and their oldest sons: in 22 families, both father and son attended college; in 31 families, neither father nor son attended college; in 12 families,..

User Account

All Pages