Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rods is $2,200, and the cost required to setup the production line for the 6-cylinder connecting rods is $3,600. Manufacturing costs are $14 for each 4-cylinder connecting rod and $16 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufacturedthe following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line. Once the line has been set up, the weekly production capacities are 5,000 6-cylinder connecting rods and 9,000 4-cylinderconnecting rods. Let*4 = the number of 4-cylinder connecting rods produced next weekX = the number of 6-cylinder connecting rods produced next week$4 = 1 if the production line is set up to produce the 4-cylinder connecting rods; 0 if otherwiseS6 = 1 if the production line is set up to produce the 6-cylinder connecting rods; 0 if otherwise(a) Using the decision variables x4 and s, write a constraint that limits next week's production of the 4-cylinder connecting rods to either 0 or 9,000 units.(b) Using the decision variables x and write a constraint that limits next week's production of the 6-cylinder connecting rods to either 0 or 5,000 units.(c) Write a third constraint that, taken with the constraints from parts (a) and (b), limits the production of connecting rods for next week.(d) Write an objective function for minimizing the cost of production for next week.Min

CylinderSetup costcost/unitcapacities4-cylinder$2,200$145,0006-cylinder$3,600$169,000

Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rods is $2,200, and the cost required to set up the production line for the 6-cylinder connecting rods is $3,600. Manufacturing costs are $14 for each 4-cylinder connecting rod and $16 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line. Once the line has been set up, the weekly production capacities are 5,000 6-cylinder connecting rods and 9,000 4-cylinder connecting rods. Let x₁ = the number of 4-cylinder connecting rods produced next week x = the number of 6-cylinder connecting rods produced next week $₁=1 if the production line is set up to produce the 4-cylinder connecting rods; 0 if otherwise S = 1 if the production line is set up to produce the 6-cylinder connecting rods; 0 if otherwise (a) Using the decision variables x, and s, write a constraint that limits next week's production of the 4-cylinder connecting rods to either 0 or 9,000 units. (b) Using the decision variables x, and s, write a constraint that limits next week's production of the 6-cylinder connecting rods to either 0 or 5,000 units. (c) Write a third constraint that, taken with the constraints from parts (a) and (b), limits the production of connecting rods for next week. (d) Write an objective function for minimizing the cost production for next week. Min

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P