Create an LP model to help Acme determine how many of each component to make and how many of each component to buy

ACME produces an industrial product, called EZ-Lift, for its major customer, MegaMax. Acme does not make this the EZ-Lift for any other customers. Their contract is to produce 1000 units per month. EZ-Lift is made from three components: a frame, a support and a mounting bracket. ACME can either manufacture the components themselves or they can buy them from an outside supplier. Whether they manufacture the components or purchase them from an outside supplier, ACME will still assemble them into the final product. The costs of each option are given below:

 Component Manufacturing cost(\$/unit) Purchase cost (\$/unit) Frame 38.5 51 Support 11.5 15 Bracket 6.5 7.5

If they manufacture the components, each unit goes through three processing departments. The table below show how much labor time (in hours) is required for each unit in each department as well as showing how much labor time(hours) is available per month in each department.

 Frame Support Bracket Labor Cutting 1.2 1.3 0.8 3500 Milling 2.2 1.7 0 4200 Shaping 1.3 0.3 0.6 6800

Part A (20 points)

Create an LP model to help Acme determine how many of each component to make and how many of each component to buy.

A1.How many of each component should ACME make?

A2. How many of each component should ACME purchase?

A3. What is the cost of this plan?

A4. If they could increase labor capacity in one of the departments, where should they do that?

Part B (20 points)

Now, assume that MegaMax wants to change the contracted amount to 2000 units per month Create an LP model to help Acme determine how many of each component to make and how many of each component to buy.

B1. How many of each component should ACME make?

B2. How many of each component should ACME purchase?

B3. What is the cost of this plan?

B4. If they could increase labor capacity in one of the departments, where should they do that?

B5. If they can add 100 hours of labor capacity to that department, what is the cost of this new plan?

Part C (10 points)

Now assume that the workers are cross-trained so that each of them can work in any of the departments. So they have a total of 14500 hours available each month and those worker hours can be assigned in any combination to the departments. Create a new LP to address the same issues as in Part A, but to also determine how many hours of work to assign to each department. (Hint: create a new set of decision variables corresponding to those assignments.)

Create an LP model to help Acme determine how many of each component to make and how many of each component to buy

C1. How many of each component should ACME make?

C2. How many of each component should ACME purchase?

C3. What is the cost of this plan?

C4. If they could increase labor capacity in one of the departments, where should they do that?

C5. If they can add 100 hours of labor capacity to that department, what is the cost of this new plan?

An Excel file named “Your Last Name – Q47 F20 Excel 1”

For each part, there should be 3 worksheets. I’ll use Part A as an example of how I want the sheets named:

“Part A – Main” – this will be your main submission for Part A – On this sheet, you should:

· Display your LP model. Create the model as a Word document, then copy and paste it into a text box on this sheet

· Create your input table from the model – this is the table that you will reference in the Excel solver

· Answer the questions listed for Part A

“Part A – Answer Report” – the answer report as generated by the Excel solver

“Part A – Sensitivity Report” – the sensitivity report as generated by the Excel solver

(So, your submission will have 9 worksheets in total. )

set up and solve a case-study example of the light-intensity distribution in a photochemical reactor.

Photochemical reactor modeling: a case-study problem. Although radiation is important in heat transfer, an analogous model can be used in the design of photochemical reactors. The modeling of these reactors….

Write a critique on this technique of secondary-emission measurement.

Secondary-emission measurement: a case-study problem. An indirect way of measuring of secondary emission from ponds or large bodies of water used in waste treatment is to measure the concentration and….

set up a mass transfer model and evaluate the variation of the local mass transfer coefficient at various locations in the plate.

Chemical vapor deposition (CVD) on an inclined susceptor: a case-study problem. An important application of convective mass transfer theory is in CVD processes employed to coat surfaces with thin films….