Georgia Pacific currently is timbering two sites (T1 and T2) to obtain its lumber stock The timber is shipped to either of two lumber storage yards (Y1 and Y2) When needed, it then is shipped on to the company's mill (M) The diagram below depicts this distribution network The diagram also shows the monthly amounts produced at the timber sites and needed at the mill, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane 60 tons produced $800 ton 30 tons max Y1 1 $400 ton $1,200 ton 30 tons max 60 tons max M 100 tons needed $900 ton 40 tons max 40 tons produced $800 ton 80 tons max $700 ton 40 tons max T2 Y2 Management wants to determine the most economical plan for shipping the timber from the timber sites through the distribution networks to the plant a Identify all the requirements that will need to be expressed in fixed requirement constraints b Express the model in algebraic form C Formulate and solve a linear programing model for this problem on a spreadsheet (5 pts) (15 pts) (15 pts) Georgia Pacific currently is timbering two sites (T1 and T2) to obtain its lumber stock The timber is shipped to either of two lumber storage yards (Y1 and Y2) When needed, it then is shipped on to the company's mill (M) The diagram below depicts this distribution network The diagram also shows the monthly amounts produced at the timber sites and needed at the mill, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane 60 tons produced $800 ton 30 tons max Y1 1 $400 ton $1,200 ton 30 tons max 60 tons max M 100 tons needed $900 ton 40 tons max 40 tons produced $800 ton 80 tons max $700 ton 40 tons max T2 Y2 Management wants to determine the most economical plan for shipping the timber from the timber sites through the distribution networks to the plant a Identify all the requirements that will need to be expressed in fixed requirement constraints b Express the model in algebraic form C Formulate and solve a linear programing model for this problem on a spreadsheet (5 pts) (15 pts) (15 pts)

Question

Georgia Pacific currently is timbering two sites (T1 and T2) to obtain its lumber stock  The timber is shipped to either of two lumber storage yards (Y1 and Y2)  When needed, it then is shipped on to the company's mill (M)  The diagram below depicts this distribution network  The diagram also shows the monthly amounts produced at the timber sites and needed at the mill, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane  60 tons produced $800 ton 30 tons max  Y1 1 $400 ton $1,200 ton 30 tons max  60 tons max  M 100 tons needed $900 ton 40 tons max  40 tons produced $800 ton 80 tons max  $700 ton 40 tons max  T2 Y2 Management wants to determine the most economical plan for shipping the timber from the timber sites through the distribution networks to the plant  a  Identify all the requirements that will need to be expressed in fixed requirement constraints  b  Express the model in algebraic form  C  Formulate and solve a linear programing model for this problem on a spreadsheet  (5 pts) (15 pts) (15 pts) Georgia Pacific currently is timbering two sites (T1 and T2) to obtain its lumber stock  The timber is shipped to either of two lumber storage yards (Y1 and Y2)  When needed, it then is shipped on to the company's mill (M)  The diagram below depicts this distribution network  The diagram also shows the monthly amounts produced at the timber sites and needed at the mill, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane  60 tons produced $800 ton 30 tons max  Y1 1 $400 ton $1,200 ton 30 tons max  60 tons max  M 100 tons needed $900 ton 40 tons max  40 tons produced $800 ton 80 tons max  $700 ton 40 tons max  T2 Y2 Management wants to determine the most economical plan for shipping the timber from the timber sites through the distribution networks to the plant  a  Identify all the requirements that will need to be expressed in fixed requirement constraints  b  Express the model in algebraic form  C  Formulate and solve a linear programing model for this problem on a spreadsheet  (5 pts) (15 pts) (15 pts)

Accepted Answer

The Answer is in the image, click to view ...

Question

Georgia-Pacific currently is timbering two sites (T1 and T2) to obtain its lumber stock. The timber is shipped to either of two lumber storage yards

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Scientific And Statistical Database Management 2 International Conference Ssdbm 2012 Chania Crete Greece June 2012 Proceedings Lncs 7338

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question