Question

In: Statistics and Probability

Suppose that you have been given the job of providing advance transport to a new exhibition...

Suppose that you have been given the job of providing advance transport to a new exhibition hall and it is possible to use existing railway connections and bus routes. Each bus will cost $30000 and carry 40 passengers. Each railway train will cost $45000 and carry 50 passengers. A bus can make 15 trips a day and a railway train 12 trips a day. The system has a number of financial and design constraints. It must carry at least 48000 passengers a day and cost no more than $2700000. There is also an agreement to use at least 10 trains, while no more than 66 buses are available. What is the minimal cost solution to this problem? Linear programming explains all the steps please

Solutions

Expert Solution

Let T be the number of trains and B be the number of buses that are needed.

These are the decision variables

Each bus costs $30,000. Hence B buses would cost $30000B

Each train costs $45,000. Hence T trains would cost $45000T

The total cost of transport is

We want to minimize this cost. Hence this is the objective function

Finally the constraints

T trains can carry 50T passengers in each trip and 50T*12 =600T in a day and B bus can carry 40B passengers in each trip and 40B*15 = 600B in a day. The total passengers to be carried per day is at least 48000

there is a agreement ot use atleast 10 trains

There are not more than 66 buses available

The total cost should be no more than $2,700,000

Finally the linear model is

Minimize

s.t.

Prepare the following spreadsheet

with the following values

set the solver using data-->solver

and get the following solution

For a minimum cost solution, we need to use 66 buses and 14 trains


Related Solutions

Suppose you have been assigned to a new job in another nation, and that nation does...
Suppose you have been assigned to a new job in another nation, and that nation does not embrace a Biblical Worldview. What would you need to do to prepare yourself for that assignment in terms of maintaining your Biblical and ethical beliefs?
in java please: You have been given the job of creating a new order processing system...
in java please: You have been given the job of creating a new order processing system for the Yummy Fruit CompanyTM. The system reads pricing information for the various delicious varieties of fruit stocked by YFC, and then processes invoices from customers, determining the total amount for each invoice based on the type and quantity of fruit for each line item in the invoice. The program input starts with the pricing information. Each fruit price (single quantity) is specified on...
You have been given a job analysis for a position of Welder at a factory and...
You have been given a job analysis for a position of Welder at a factory and have been asked to design a new selection instrument, a knowledge-based test. The welder job is an established position with a large number of current incumbents and a large number of unfilled positions. You need to establish the validity of the new knowledge-based test. Describe how you would examine the criterion-related validity of this test. Be as specific as possible.
You have been given the job of evaluating the following merger candidate. You have collected the...
You have been given the job of evaluating the following merger candidate. You have collected the following cash flow for the acquisition candidate for the proposed merger (in millions): Year                                                                1                              2                               3                               4                               5__ Cash flows now for canidate 90                            85                               205                            165                            180 Additional cash flows with merger 60                            90                               100                            225                            250 Total cash flows with synergy 150                            175                            305                            390                            430 Risk free rate of return                                                                                                                 3.0% Beta for this project (the company after merging)                                                        ...
As part of your new job responsibilities as an analyst for Lachute Lumber, you have been...
As part of your new job responsibilities as an analyst for Lachute Lumber, you have been asked to help evaluate a new project. Lachute has a market value debt-to-equity ratio of .6667. The firm's cost of equity is 15% and its pre-tax cost of debt is 4.917%. Flotation costs of debt and equity are 1.71% and 5%, respectively. The firm has a tax rate of 40%. The new project requires purchasing equipment that will cost $2,000,000 plus an additional $200,000...
You have just been appointed as the NEW Portfolio Manager at NAPSA, and you are given...
You have just been appointed as the NEW Portfolio Manager at NAPSA, and you are given the responsibility to set up an investment fund amounting to K100 Million, using the given amount, construct a diversified portfolio of FIVE (5) asst classes, and explain the rationale for picking them and where possible indicate annual return on each class of asset. Notably compare the return with the prevailing inflation rate in Zambia and ignore the tax implication (WHT) on your returns.
Suppose you have been given the task of distilling a mixture of hexane + toluene. Pure...
Suppose you have been given the task of distilling a mixture of hexane + toluene. Pure hexane has a refractive index of 1.375 and pure toluene has a refactive index of 1.497. You collect a distillate sample which has a refractive index of 1.441. Assuming that the refractive index of the hexane + toluene mixture varies linearly with mole fraction, what is the mole fraction of hexane in your sample?
Imagine you are a pediatric nurse. You have been providing care for an infant with failure...
Imagine you are a pediatric nurse. You have been providing care for an infant with failure to thrive and a congenital heart defect. The infant will require multiple types of home medical monitoring equipment and a very expensive surgery to save his life. As the child grows, he will need continued follow-up care and smaller palliative surgeries to ensure his health. The family comes from a strict Amish community in which the elders of the community make all final medical...
You have been recently hired at UMGC Health. One of your new job functions entails educating...
You have been recently hired at UMGC Health. One of your new job functions entails educating new hires on the revenue cycle process. For this assignment, you will prepare a 3-5 page white paper outlining the basic steps of the revenue cycle. Identify the various steps within the revenue cycle process, including admissions, case management, documentation, coding, billing, et cetera. For each step identified, provide details pertaining to the following: Purpose of the step identified. The individuals involved in the...
Imagine that you have been given ample funds to invest in a new retail venture. What...
Imagine that you have been given ample funds to invest in a new retail venture. What kind of business would you start? You can be as creative as you like, but make sure to explain your reasoning and refer to concepts discussed in the reading to support your choices. Determine the type of retail store you want to open. Be specific about the characteristics of the store type. Include product assortment, target market(s), service level, and price level. Where will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT