Suppose you own a limousine company and consider to purchase three different types of limousines: party...

Suppose you own a limousine company and consider to purchase three different types of limousines: party bus, sedan, and classic limousine.The purchase price will be $50K, $35K and $30K for each types, respectively. You have a maximum budget of $ $1245K. It is estimated that net annual profit from each type of limousine would be $115K, $90K, and $70K. Currently you have 20 drivers that are available to serve in new limousines. If only classic limousines were purchased, your car maintenance facility would be able to handle 30 new classic limousines. However, each sedan limousine is equivalent to 1.5 classic limousines, and each party bus is equivalent to 3 classic limousines in terms of maintenance facility usage.

Formulate an integer program to find out how many of each types of limousine you need to buy to maximize your annual profit.

Solutions

Expert Solution

The given data and the constraints are formulated in an LP in excel as given below. Also the formulas used in each cell must be noted.

Using excel solver to get the optimum solution.

the optimum solution is that the company must buy 20 sedan limousine to earn the max profit.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Let's suppose that you are looking to start your own business. This is a limousine company...

Let's suppose that you are looking to start your own business. This is a limousine company that provides transportation between customer's homes and airports, train stations, etc. The first question is, what type of business organization would you select for your business? Be sure to thoroughly explain your rationale for your decision. Anyone?

Suppose a state is considering three different types of fiscal limits for local governments in the...

Suppose a state is considering three different types of fiscal limits for local governments in the state--a maximum property tax rate, a limit that property tax revenue may not increase more than population and inflation rate together, or a limit that spending may not increase more than five percent. In each case, the limit may be exceeded by majority vote. Which limit is most restrictive and why? Contrast the three in terms of the sources of allowed increases in taxes...

Suppose a farmer wanted to test the effectiveness of three different types of fertilizer on strawberry...

Suppose a farmer wanted to test the effectiveness of three different types of fertilizer on strawberry production: no fertilizer, organic fertilizer, and non-organic fertilizer. Three sections of strawberry fields are selected, a random sample of 5 strawberry plants from each section are selected at the end of the growing season. The number of strawberries produced on each plant is counted. The purpose of the study is to determine if type of fertilizer affects strawberry production. Is there a significant effect...

Suppose a state is considering three different types of fiscal limits for local governments in the...

Describe in your own words the different types of withholdings that you will withhold from an...

Describe in your own words the different types of withholdings that you will withhold from an employees gross pay when doing payroll. Additionally, describe the types of payments that an employer may make regarding payroll for employees.

If you consider Amazon and Whole Foods to be firms in different types of business, you...

If you consider Amazon and Whole Foods to be firms in different types of business, you would classify the merger as a ________ merger. If you know that Amazon already delivers food, but does not have the necessary warehousing function in its chain of functions, you would classify the merger as a __________ merger. A. Conglomerate, horizontal B. Conglomerate, vertical C. Horizontal, vertical D. Vertical, conglomerate

Do you think that different party systems will lead to a different responses, if you analyze...

Do you think that different party systems will lead to a different responses, if you analyze them within the context of George Floyd’s killing and the character of the following demonstrations? Why? Why not?

There are three different types of tests we learned. What one of the three types is...

There are three different types of tests we learned. What one of the three types is the following? “ A researcher estimates that high school girls miss more days of school than high school boys. A sample of 16 girls showed that they missed an average of 3.9 days of school and a sample of 22 boys showed that they missed an average of 3.6 days. The standard deviation of the 16 girls was .6 and the standard deviation of...

Suppose that you own a car dealership and purchase (randomly select) 10 cars of a certain...

Suppose that you own a car dealership and purchase (randomly select) 10 cars of a certain make from a production run of 200 cars. Of the 200 cars, 160 are destined to last at least five years without needing a major repair. Using the hypergeometric distribution what is the probability that at least 6 of your 10 cars will last at least five years without needing a major repair.

Let’s say you have a light shop where you sale and purchase having different types of...

Let’s say you have a light shop where you sale and purchase having different types of light and different electric appliances. Now using principles of OOP I want you want make an OOP program which can cater the aforementioned problem.(show different types of purchase and sales ) C#

Subjects