User Account

All Pages

What is the optimal value for the route orlando

Assignment Help Operation Management
Reference no: EM131282602

Linear Programming

1. A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the machines' time allotted per day is 90 hours and the supply of metal is limited to 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans.

 

Cans

 

Large

Medium

Small

Maximum

Metal   (kg)/batch

9

6

5

120

Machines' Time (hr)/batch

4.4

4.2

4

90

Profit/batch

$50

$45

$42

Let L = number of Large cans produced
M = number of Medium cans produced
S = number of Small cans produced

Formulate and solve for the recommended production quantities for all the three different types cans by maximizing the profit. Use Excel solver to find your answers. Report the optimal value of L

2. Based on question 1, use Excel Solver to find the optimal solution and report the value of M.

3. Based on question 1, use Excel Solver to find the optimal solution and report the value of S.

4. Based on question 1, use Excel Solver to find the optimal solution and report the optimal value of the objective function.

5. Based on question 1, write down the objective fuction.

1. A soft drink manufacturing company has 3 factories set up one in each of the three cities - Orland, Tampa, and Port St. Lucie and it supplies the produced soft drink bottles to 3 warehouses located in the city of Miami. The associated per-unit transportation cost table is provided below:

Transportation Costs   ($)

Factories/Warehouse (W)

W1

W2

W3

Orlando

4

3

7

Tampa

7

6

4

Port St. Lucie

3

6

6

The factory at Orlando has a capacity of 15,000 units.
The factory at Tampa has a capacity of 18,000 units.
The factory at Port St. Lucie has a capacity of 8,000 units.

The requirements of the warehouses are:

Transportation Costs   ($)

Factories/Warehouse   (W)

W1

W2

W3

Orlando

4

3

7

Tampa

7

6

4

Port St. Lucie

3

6

6

How many decision variables do you have in this problem?

7. A soft drink manufacturing company has 3 factories set up one in each of the three cities - Orland, Tampa, and Port St. Lucie and it supplies the produced soft drink bottles to 3 warehouses located in the city of Miami. Using the information from question 6 answer the following:

How many constraints do you have in this problem? (ignore the sign constraints)

8. Based on the problem of the soft drink manufacturing company:

What is the optimal minimum cost for this problem? Use Excel Solver to find your solution.

9. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Orlando - W1, that is how many units should be sent from Orlando to location W1 in order to minimize the total transportation cost?

10. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Orlando - W2, that is how many units should be sent from Orlando to location W2 in order to minimize the total transportation cost?

11. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Tampa - W1, that is how many units should be sent from Tampa to location W1 in order to minimize the total transportation cost?

12. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Tampa - W2, that is how many units should be sent from Tampa to location W2 in order to minimize the total transportation cost?

13. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Port St. Lucie- W3, that is how many units should be sent from Port St. Lucie to location W3 in order to minimize the total transportation cost?

14. Three plants P1, P2, and P3 of a gas corporation supply gasoline to three of their distributors in the city located at A, B, and C locations. The plants' daily capacities are 4500, 3000, and 5000, gallons respectively, while the distributors' daily requirements are 5500, 2500, and 4200 gallons. The per-gallon transportation costs (in $) are provided in the table below:

Distributor

Plant

A

B

C

P1

0.8

0.5

1

P2

0.7

0.65

0.8

P3

0.5

0.45

0.7

What is the optimal minimized cost?

15. Using the sensitivity report in question 14, answer the following:

What is the new minimum cost of transportation if we increase the demand of distributor B to be 2600. Use the shadow price for Demand B in the constraints table to estimate the new cost.

Reference no: EM131282602

Questions Cloud

How the company serves external customers : How the company serves external customers? How will you apply what you learned from this book into your future professional life? What is your own definition of "Service Management"?
What is the input voltage that triggers the scr : If the SCR of Fig. 13-41 has a gate trigger voltage of 1.5 V, a gate trigger current of 15 mA, and a holding current of 10 mA, what is the input voltage that triggers the SCR? The supply voltage that resets the SCR?
Develop a response that includes examples : Develop a response that includes examples and evidence to support your ideas, and which clearly communicates the required message to your audience.
Explain how you would respond to the given situation and why : Explain how you would respond to the given situation and why. Recommend an appropriate process and explain why this process is preferred. Describe the contract styles that will support this process.
What is the optimal value for the route orlando : What is the optimal value for the route Orlando - W2, that is how many units should be sent from Orlando to location W2 in order to minimize the total transportation cost?
Write a paper regarding an aggressive growth plan : Write a paper regarding an aggressive growth plan requiring investment in facilities and equipment, growth in productivity, and labor over the next five years. It is your responsibility to determine how the U.S economy during this five year perio..
Demonstrate equivalence of the two complex representation : Demonstrate the equivalence of the two complex representations given in (7.276) and (7.277), which pertain to the likelihood function.
Charging the optimal price for the product : a. Is the firm charging the optimal price for the product? Why? b. Assuming the elasticity remains at --4.0 what is the optimal price?
Charging the optimal price for the product : Suppose a firm has a constant marginal cost of $12. The current price is $25 and at that price it is estimated that the price elasticity of demand is -4.0. a. Is the firm charging the optimal price for the product? Why?

Reviews

Write a Review

Operation Management Questions & Answers

  Requires routine or positive business message

Post your responses to the following statements on the discussion board. If appropriate, include personal experience as part of your answers. Identify and describe a hypothetical scenario for which a routine or positive business message is appropriat..

  Definition of production operations management

Elaborate your own definition of production operations management, including manufacturing and service operations. Then, assess the implication of technology in your definition. Lastly, appraise the impact of your previous responses to your Operation..

  What is the estimated overall labor cost for a task

What is the estimated overall labor cost for a task that has a learning curve of 90% and is expected to reach steady state value after 16 units in a time of 5 minutes to assemble and the total production run is 20 units. Labor is $22 per hour. What w..

  Discuss the interrelationships among cost of capital

Executive salaries have been shown to be more closely correlated to the size of the firm than to its profitability. Discuss those statements, being sure (1) to discuss the interrelationships among cost of capital, investment opportunities, and new in..

  Interest of the furtherance of company-employee relations

The following passage contains unnecessary jargon, padded phrases, and affectation. Revise the passage. With reference to the matter that management has declared to be in the best interest of the furtherance of the company-employee relations, the pre..

  Considered a basis for competitive pricing

Of the following, which is NOT considered a basis for competitive pricing?

  Producer of pottery is considering addition of new plant

A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $8,152 per month and variable costs of $1.86 per unit produced. Each item..

  What was the empact first marketing effort

What was the Empact's first marketing effort? What product mix have Empact's enterprises developed? How are its services delivered (through what channels)? (Empact Case Study)

  Difference between arbitration and litigation

Which of the following is a difference between arbitration and litigation?

  How are increasingly standardized data

How are increasingly standardized data, access to third-party datasets, cheap, fast computing, and easier-to-use software collectively enabling a new age of decision making?

  What has been the impact of the law

One of the consequences of the terrorist attack of 9/11 was the passage by Congress of the Patriot Act. From an HR perspective, what has been the impact of the law? Should Americans be asked to give up privacy for national security?

  On the three major leadership theories the lpc theory

On the three major leadership theories the LPC theory, the path-goal theory, and Veoom's decision three approach which is the most comprehesvi? Which is the narrowest? Which has the most practical value?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd