The objective is to find a production plan that maximizes

Assignment Help Operation Management

Reference no: EM1386469

Truckco manufactures two types of trucks, types 1 and 2. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted to painting type 1 trucks, 800 per day could be painted; whereas if the painting shop were completely devoted to painting type 2 trucks, 700 per day could be painted. If the assembly shop were completely devoted to assembling truck 1 engines, 1500 per day could be assembled, and if the assembly shop were completely devoted to assembling truck 2 engines, 1200 per day could be assembled. It is possible, however, to paint both types of trucks in the painting shop. Similarly, it is possible to assemble both types in the assembly shop. Each type 1 truck contributes $300 to profit; each type 2 truck contributes $500. According to the recent sales forecast, Truckco has to produce at least 200 type 1 trucks each day. The objective is to find a production plan that maximizes the daily profit. Formulate your model mathematically and solve it by using the Excel solve

Reference no: EM1386469

Questions Cloud

Formulate a spreadsheet model that will give the profit : Formulate a spreadsheet model that will give the profit in part b for any of the two numbers. Use the Excel goal seek command to calculate the break-even point found in part a.

Question about molecular biology : Assume you infected an E. coli culture with a virulent bacteriophage. Most of the cells lysed, but a few survived - 1x10^-4. You wonder where the resistant bacteria came from.

Determine the amount by which the spring is stretched : A 9.10 kg board is wedged into a corner and held by a spring at a 50° angle, as the Illustrating shows. The spring has a spring constant of 196 N/m and is parallel to the floor.

Determine the mode shapes and frequencies of vibration : Determine the mode shapes and frequencies of vibration of the system of cars by Sweeping the rigid body mode

The objective is to find a production plan that maximizes : The objective is to find a production plan that maximizes the daily profit. Formulate your model mathematically and solve it by using the Excel solve

Define the average force exerted on the ball : While a certain rubber band is stretched a distance x, it exerts a restoring force of magnitude F=ax+bx^2, where a and b are constants. The work completed in stretching this rubber band from x=0 to x=L is what.

Sequences to the ends of chromosomes : Early in development, most human cells turn off expression of an essential component of telomerase, the enzyme responsible for addition of telomere repeat sequences to the ends of chromosomes.

An airport is planning on building a new runway : An airport is planning on building a new runway, identify three significant sustainability impacts that this would cause

Discuss the possibility of a fraud hotline : Discuss the possibility of a fraud hotline as part of your program. How can a hotline be implemented as a tool for preventing and detecting fraud? Provide an overview of steps that you would take for a successful implementation if the corporation ..

User Account

All Pages