NOTE: All Linear Programming models must be \"complete\" and written in stardard
ID: 359349 • Letter: N
Question
NOTE: All Linear Programming models must be "complete" and written in stardard form and describe every term and coefficient in all Excel solver spreadsheets.3. ABC Glass Company produces high-quality glass products, including windows and glass doors. Aluminum frames and hardware are made in Plant 1, wood frames are made in Plant 2, and Plant 3 produces the glass and assembles the product. Because of declining earnings, top management has decided to revamp the company's product line. Unpeofitable products are being discontinued releasing production capacity to launch two new products having large sales potential Product 1: An 8-foot glass door with aluminum framing Product 2: A 4 X 6 foot double-hung wood-framed windovw Product 1 requires some of the production capacity in Plants 1 and 3, but none in Plant 2. Product 2 needs only Plants 2 and 3. The marketing division has concluded that the company could sell as much of cithcr product as could be produced by these plants. However, because both products would be competing for the same production capacity in Plant 3, it is not clear which mix of the two products would be most profitable. Therefore, your leam has been askod to study the question After discussions with upper management, you developed the following definition of the problem: Determine what the production rates should be for the two products in order to maximize their total profit, subject to the restrictions imposed by the limmited production capacities available in the three plants. Each product will be produced in batches of 20, so the production rate is defimed as the momber of hatches produced per week) Amy comhination of the production rates that satisfy these restrictions is permited, including producing none of one product and as much as possihle of the other Your team also identified the data that needed to be gathered a) Number of hours of production time available per week in each plant for these new products. The b) Number of hours of production time used in cach plant for each batch produced of each new c) Profit per batch produced of each new product. Your team chose this measure of profit as an available capacity for new products is limited in all three plants. product, appropriate measure after the team concluded that the incremental profit from each additional batch produced would be roughly constant regardless of the total number of batches produced Because no substantial costs will be incurred to initiate the production and marketing of these new products, the total profit from each one is approximately this 'profit per batch produced times 'the number of batches produced The table below summarizes the data gathered. After examining the information, your team recognizes this as a classic product-mix type of linear programming problem, and takes steps to solve the problem. d) c) Production Time Per Batch, hours Preduction Time Available per wk hours Plant Product I Product 2 0 Profit per Batch S 3,000
Explanation / Answer
NOTE: All Linear Programming models must be "complete" and written in stardard form and describe every term and coefficient in all Excel solver spreadsheets.
3. ABC Glass Company produces high-quality glass products, including windows and glass doors. Aluminum frames and hardware are made in Plant 1, wood frames are made in Plant 2, and Plant 3 produces the glass and assembles the product. Because of declining earnings, top management has decided to revamp the companys product line. Unpeofitable products are being discontinued releasing production capacity to launch two new products having large sales potential Product 1: An 8-foot glass door with aluminum framing Product 2: A 4 X 6 foot double-hung wood-framed windovw Product 1 requires some of the production capacity in Plants 1 and 3, but none in Plant 2. Product 2 needs only Plants 2 and 3. The marketing division has concluded that the company could sell as much of cithcr product as could be produced by these plants. However, because both products would be competing for the same production capacity in Plant 3, it is not clear which mix of the two products would be most profitable. Therefore, your leam has been askod to study the question After discussions with upper management, you developed the following definition of the problem: Determine what the production rates should be for the two products in order to maximize their total profit, subject to the restrictions imposed by the limmited production capacities available in the three plants. Each product will be produced in batches of 20, so the production rate is defimed as the momber of hatches produced per week) Amy comhination of the production rates that satisfy these restrictions is permited, including producing none of one product and as much as possihle of the other Your team also identified the data that needed to be gathered a) Number of hours of production time available per week in each plant for these new products. The b) Number of hours of production time used in cach plant for each batch produced of each new c) Profit per batch produced of each new product. Your team chose this measure of profit as an available capacity for new products is limited in all three plants. product, appropriate measure after the team concluded that the incremental profit from each additional batch produced would be roughly constant regardless of the total number of batches produced Because no substantial costs will be incurred to initiate the production and marketing of these new products, the total profit from each one is approximately this profit per batch produced times the number of batches produced The table below summarizes the data gathered. After examining the information, your team recognizes this as a classic product-mix type of linear programming problem, and takes steps to solve the problem. d) c) Production Time Per Batch, hours Preduction Time Available per wk hours Plant Product I Product 2 0 Profit per Batch S 3,000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.