Question: please do not answer this if you already did. new people only. please list the answer for a) and b) and how you got it.
please do not answer this if you already did. new people only.
please list the answer for a) and b) and how you got it. thank you. 
Carlos 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 50 hours per month. Each part manufactured will yield a unit profit as follows: Click here for the Excel Data File Formulate a linear programming model for this problem on a spreadsheet. Use solver to find an optimal solution. a. Carlos wants to determine the mix of spare parts. Note: Enter "0" if a particular part is not produced. Round your answers to 3 decimal places. b. Determine the maximum total profit. Note: Round your answer to 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
