Develop a daily production schedule for the buffalo plants

Assignment Help Computer Engineering

Reference no: EM132100931

Please use Excel..

AutoIgnite produces electronic ignition systems for automobiles at a plant in Cleveland, Ohio. Each ignition system is assembled from two components produced at AutoIgnite's plants in Buffalo, New York, and Dayton, Ohio.

The Buffalo plant can produce 2000 units of component 1, 1000 units of component 2, or any combination of the two components each day.

For instance, 60% of Buffalo's production time could be used to produce component 1 and 40% of Buffalo's production time could be used to produce component 2; in this case, the Buffalo plant would be able to produce 0.6(2000) = 1200 units of component 1 each day and 0.4(1000) = 400 units of component 2 each day.

The Dayton plant can produce 600 units of component 1, 1400 units of component 2, or any combination of the two components each day. At the end of each day, the component production at Buffalo and Dayton is sent to Cleveland for assembly of the ignition systems on the following workday.

Formulate a linear programming model that can be used to develop a daily production schedule for the Buffalo and Dayton plants that will maximize daily production of ignition systems at Cleveland. 2. find the optimal solution.

Reference no: EM132100931

Questions Cloud

Write a program that calls a function calculatesum : Write a program that calls a function calculateSum to calculate the sum of Nintegers.

Draw a line on the graph representing total energy of ball : A 1.00 kg ball is thrown directly upward with an initial speed of 16.0 m/s. A graph of the ball's gravitational potential energy vs. height, Ug(h).

Five basic skills your customer service representative : "Five Basic Skills Your Customer Service Representative Cannot Live Without."

Appeal involves claim for workmen compensation benefits : This appeal involves a claim for workmen’s compensation benefits for the period during which the claimant was incapacitated by severe depression caused

Develop a daily production schedule for the buffalo plants : Formulate a linear programming model that can be used to develop a daily production schedule for the Buffalo and Dayton plants.

What is the magnitude of the force of the car on the truck : A 1000 kg car pushes a 2000 kg truck that has a dead battery. When the driver steps on the accelerator, the drive wheels of the car push against the ground.

Good critical thinkers to understand marketing tactics : Why is it important for us as consumers and good critical thinkers to understand marketing tactics?

Preparation of a firm net cash flow : Could someone explain how investments in net working capital are used in the preparation of a firm's net cash flow? Whats an example?

What is the speed of the block : A 11-g bullet with an initial speed of 306 m/s is shot directly at a 1-kg wooden block, which rests on a frictionless surface.

User Account

All Pages