# Question: Ed Butler is the production manager for the Bilco Corporation

Ed Butler is the production manager for the Bilco Corporation, which produces three types of spare parts for automobiles. The manufacture of each part requires processing on each of two machines, with the following processing times (in hours):

Each machine is available 40 hours per month. Each part manufactured will yield a unit profit as follows:

Ed wants to determine the mix of spare parts to produce in order to maximize total profit.

(a) Formulate a linear programming model for this problem.

(b) Display the model on an Excel spreadsheet.

Each machine is available 40 hours per month. Each part manufactured will yield a unit profit as follows:

Ed wants to determine the mix of spare parts to produce in order to maximize total profit.

(a) Formulate a linear programming model for this problem.

(b) Display the model on an Excel spreadsheet.

**View Solution:**## Answer to relevant Questions

You are given the following data for a linear programming problem where the objective is to minimize the cost of conducting two nonnegative activities so as to achieve three benefits that do not fall below their minimum ...Reconsider Prob. 3.4-11. (a) Use MPL/Solvers to formulate and solve the model for this problem. (b) Use LINGO to formulate and solve this model. In problem This case focuses on a subject that is dear to the heart of many students. How should the manager of a college cafeteria choose the ingredients of a casserole dish to make it sufficiently tasty for the students while also ...Reconsider the model in Prob. 4.1-4. (a) Introduce slack variables in order to write the functional constraints in augmented form. Label each of the following statements as true or false, and then justify your answer by referring to specific statements in the chapter.Post your question