You are in charge of determining toy production for Electronic Toy Company ETC L

Question

You are in charge of determining toy production for Electronic Toy Company ETC Limited. The company produces electronic remote control trucks helicopters, airplanes, motorcycles and a racecar. The following chart gives you data for how many units of assembly, inspection, plastic molding, batteries, and packing each item requires, the profit for each one, and what your current limits are for each.

      profit

    Inspect

       plast

        batt

        pack

assembly

truck

80

2.5

3

1

1

2

heli

205

3

4

2

2

5

air

150

1.5

2

2

1

4

motor

65

2

3

1

1

3

racecar

55

1

2

1

1

1

total

limit

450

1000

500

400

1000

1. What is the maximum profit? [do not use variables = integer for this one] NOTE which constraints are BINDING at this stage, as once you set integer, that can be more difficult to check

2. Marketing insists on a solution with at least 15 of each model produced. What is the profit now? [set your constraint to integer variables, on some excel versions, you will have to go under options too, and uncheck "ignore integer constraint"

3. What is the maximum profit? [do not use variables = integer for this one] NOTE which constraints are BINDING at this stage, as once you set integer, that can be more difficult to check

      profit

    Inspect

       plast

        batt

        pack

assembly

truck

80

2.5

3

1

1

2

heli

205

3

4

2

2

5

air

150

1.5

2

2

1

4

motor

65

2

3

1

1

3

racecar

55

1

2

1

1

1

total

limit

450

1000

500

400

1000

Explanation / Answer

Maximum Profit is = 450+1000+500+400+1000 = 3350

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.