You are in charge of determining toy production for Electronic Toy Company ETC Limited. The company

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.

Using Excel, determine the optimal production schedule to maximize profit.

Which constraints are actually holding back your production, and which ones are currently not being fully used?

The marketing department would like to insist that 15 of each toy are produced, for marketing purposes. What effect does this have on your optimal profit?

Speaking with management, you can shift a few employees from one department to another. This will increase the limit on one department by 10%, and decrease the limit on the one losing the employees by 10%.

Maximum profit is 39000

With Marketing insisting on a solution with at least 15 of each model produced, the maximum profit is 37650

      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

QUESTION

what is the new maximum profit (with both the 15 of each produced, AND shifting 10% from one constraint to another) Keep the integer only constraint!

"Is this question part of your assignment? We can help"

ORDER NOW