Question

In: Operations Management

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool.

*Shipment Costs ($), Supply, and Demand:*
	Destinations
Sources	1	2	3	Supply
A	6	9	100	130
B	12	3	5	70
C	4	8	11	100
Demand	80	110	60

(4 points) Volume Shipped from Source A __________

(4 points) Volume Shipped from Source B __________

(4 points) Volume Shipped from Source C __________

(3 points) Minimum cost __________

Expert Solution

Answer:

Volume Shipped from Source A = 80

Volume Shipped from Source B = 70

Volume Shipped from Source C = 100

Minimum cost = 1530

Solution:

Excel LP Formation:

Formula:

Excel Solver Parameters:

Solution:

keosha answered 1 year ago

A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem....

A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem. Demand in period 1 is 100 units, and in period 2, demand is 150 units. The manager has 125 hours of regular employment available for $10/hour each period. In addition, 50 hours of overtime are available for $15/hour each period. Holding costs are $2 per unit each period. a. How many hours of regular employment should be used in period 1? (Assume demand must...

Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has...

Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has a division that produces two models of fireplace grates, x units of model A and y units of model B. To produce each model A requires 2 lb of cast iron and 8 min of labor. To produce each model B grate requires 5 lb of cast iron and 5 min of labor. The profit for each model A grate is $2.50, and the...

Formulate and solve a linear programming model to deter mine the number of Family Thrillseekers and...

Formulate and solve a linear programming model to deter mine the number of Family Thrillseekers and the number of Classy Cruisers that should be assembled Before she makes her final production decisions, Rachel plans to explore the following questions independently, except where otherwise indicated. The marketing department knows that it can pursue a targeted $500,000 advertising campaign that will raise the demand for the Classy Cruiser next month by 20 percent. Should the campaign be undertaken? Rachel knows that she...

For the given transportation problem, formulate a linear program with objective function and constraints. Solve using...

For the given transportation problem, formulate a linear program with objective function and constraints. Solve using the excel sleeve, provide the optimal transport cost. Imagine that we have three bakeries and three stores. the three stores require 23 dozen, 17 dozen, and 20 dozen loaves of bread, respectively, while the three bakeries can supply 18 dozen, 15 dozen, and 22 dozen loaves, respectively. The unit transportation costs are provided in the table below: Store 1 Store 2 Store 3 Bakery...

Solve this linear programming (LP) problem using the transportation method. Find the optimal transportation plan and...

Solve this linear programming (LP) problem using the transportation method. Find the optimal transportation plan and the minimum cost. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) Minimize 8x11 + 2x12 + 5x13 + 2x21 + x22 + 3x23 + 7x31 + 2x32 + 6x33 Subject to x11 + x12 + x13 = 90 x21 + x22 + x23 = 105 x31 + x32 + x33 = 105 x11...

Formulate the problem as a linear programming model use excel and show your excel work. Thank...

Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50

Formulate the situation as a linear programming problem by identifying the variables, the objective function, and...

Formulate the situation as a linear programming problem by identifying the variables, the objective function, and the constraints. Be sure to state clearly the meaning of each variable. Determine whether a solution exists, and if it does, find it. State your final answer in terms of the original question. A rancher raises goats and llamas on his 400-acre ranch. Each goat needs 2 acres of land and requires $100 of veterinary care per year, and each llama needs 5 acres...

Developing a workforce schedule (using Linear Programming to model and solve this problem) A local bank...

Developing a workforce schedule (using Linear Programming to model and solve this problem) A local bank needs the minimum number of employees needed for each day of the week listed in the following table. If a staff is hired, his/her schedule will be working 5 consecutive days and take two days off. The bank operates seven days a week. Day of the Week M T W TH F Sa Su Number of staff needed 4 5 5 3 5 2...

Formulate the linear programming model for the issue algebraically by stating the: 1) Definition of Decision...

Formulate the linear programming model for the issue algebraically by stating the: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. Set up and solve the problem using Excel. Provide your answers and recommendations to the Manager of the company General organization and formatting. 1. Richelieu Specialty Paints Richelieu Specialty Paints is a company run by Amanda Richelieu. She is an artist and earned a BA degree with a major in Art and Design. The company was...

Please give one example of REAL LIFE problem that can be formulate as linear programming problem....

Please give one example of REAL LIFE problem that can be formulate as linear programming problem. Make sure you have clear statement about background, the decision variables, objective function and constraints.