37) a,b,c,d,e

P d. Use Solver to find an optimal solution. 3 e. Express the model in algebraic form. e Ty of 2 mack decisions w . we are Is of + ar Ma At = Sa :pal te ts ex xil on I at al fu wee + 5A2 $50. , for 1 , + A2+ 3.1 ject ch of d- Id p + 3A2 eg a cat cat em th and ed A rm the s b. n- ced ecisic ove re ent um the inted B il d ti its was st p nan Je nonfir data lla Hel for 1- e di equa- nt -put cell express.- JMPROD- model. vit 3.7 Ed Butler is the production manager for the Bilco Cor- poration, which produces three types of spare parts for automo- biles. The manufacture of each part requires processing on each of two machines, with the following processing times (in hours). Part Machine A B C 0.02 0.03 0.05 mi 0.05 0.02 0.04 eck lov u- Each machine is available 40 hours per month. Each part (8 9). manufactured will yield a unit profit as follows: io asil hich ha ist the Part nd ma n. A B C br Profit $50 $40 $30 al 1 lis E*3 :nel le- len the Ed wants to determine the mix of spare parts to produce to follc maximize total profit. a. Identify both the activities and the resources for this or tic FE ti resource-allocation problem. F* b. Formulate a linear programming model for this problem on a spreadsheet. table B el F* C. Make three guesses of your own choosing for the optimal solution. Use the spreadsheet to check each 30 -NW one for feasibility and, if feasible, for the value of 60 the objective function. Which feasible guess has the 110 best objective function value? U. 500 $300