Question: done on paper however i need help creating a linear program and putting it into excel that is what i need using solver to help

done on paper however i need help creating a linear program and putting it into excel that is what i need using solver to help solve the problem. done on paper however i need help creating a linear program and

The Dynaco Company manufactures a product in five stages. Fach stage of the manufacturing process is conducted at a different plant. The following network shows the five different stages and the routes over which the partially completed products are shipped to the various plants at the different stages: Stage 5 (at node 10) is the distribution center in which final products are stored. Although each node represents a different plant, plants at the same stage perform the same operation. (For example, at stage 2 of the manufucturing process, plants 2, 3, and 4 all perform the same manufacturing operation.) The values accompanying the branches emanating from each node indicate the maximum number of units (in thousands) that a particular plant can produce and ship to another plant. at the next atage. (For example, plant 3 has the capacity to process and ship 7,000 units of the product to plant 5.) Determine the maximum number of units that can be procesed through the five-stage manufacturing process and the number of units processed at each plant. Suppose that the procsssing cost per unit at each plant is different bocause of different machinery, workers' abilities, overhead, and so on, acoording to the following table: There are no differentiated costs at stage 5, the distribution center. Given a budget of 8700,000 , determine the maximum number of units that can be processed through the five-stage manufacturing process using the linesar programming model. The Dynaco Company manufactures a product in five stages. Fach stage of the manufacturing process is conducted at a different plant. The following network shows the five different stages and the routes over which the partially completed products are shipped to the various plants at the different stages: Stage 5 (at node 10) is the distribution center in which final products are stored. Although each node represents a different plant, plants at the same stage perform the same operation. (For example, at stage 2 of the manufucturing process, plants 2, 3, and 4 all perform the same manufacturing operation.) The values accompanying the branches emanating from each node indicate the maximum number of units (in thousands) that a particular plant can produce and ship to another plant. at the next atage. (For example, plant 3 has the capacity to process and ship 7,000 units of the product to plant 5.) Determine the maximum number of units that can be procesed through the five-stage manufacturing process and the number of units processed at each plant. Suppose that the procsssing cost per unit at each plant is different bocause of different machinery, workers' abilities, overhead, and so on, acoording to the following table: There are no differentiated costs at stage 5, the distribution center. Given a budget of 8700,000 , determine the maximum number of units that can be processed through the five-stage manufacturing process using the linesar programming model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!