Provide a printout of the formulation of each problem in a word document and provide a printout

of the Excel solution where asked to solve using Excel Solver.

- Eaton Corp. has to satisfy demand of clutch systems to 3 General Motors plants. They have

two warehouses where they stock the product. The demand at plant 1 is 600 units. The

demand at plant 2 is 800 units, and the demand at plant 3 is 400 units. Warehouse 1 has an

inventory of 800 units and Warehouse 2 has an inventory of 1000 units. Given the shipping

costs/unit below, they need to determine how product should be shipped between the

warehouses and the plants.

From To Plant

Warehouse $1 $2 $3

1 $4 $4 $2

2 $3 $5 $5

Transportation Costs ($)

a. Solve this problem with a heuristic. Explain your heuristic and provide the heuristic

solution.

b. Write a formulation for this problem. Write it out with equations as well as in tableau

format.

c. Solve this problem with the Excel Solver. What is the difference in cost between the

heuristic solution and the optimal solution? - A company faces the following demands during the next 4 months, with the following

production costs. They incur inventory costs of $3/month/unit. At the beginning of January

they have 500 units on-hand.

Jan Feb Mar Apr

Demand 1000 3000 2500 3500

Prod. $ 40 25 35 30

They wish to determine the optimal production schedule that will minimize production and

inventory costs.

a. Write a formulation for this problem. Write it out in equations.

b. Try using logic to determine what the optimal answer will be. - Highland’s TV-Radio Store must determine how many TVs and radios to keep in stock (the

store stocks only TVs and radios). A TV requires 10 sq. ft. of floor space, whereas a radio

requires 4 sq. ft; 200 sq. ft. of floor space is available. A TV will earn Highland $60 in

profits, and a radio will earn $20. Marketing requirements dictate that at least 60% of all

appliances in stock be radios. Finally, a TV ties up $200 in capital, and a radio $50.

Highland wants to have at most $3000 worth of capital tied up at any time.

a. Formulate an IP that can be used to maximize Highland’s profit. Solve it using Excel.

b. How much more profit could be attained if Highland rented another 50 sq. ft. of floor

space? How much should Highland be willing to pay for this extra footage?

c. How much more profit could be attained if marketing changed their requirement so that

only 40% of all appliances in stock be radios (keeping the floor space at 200 sq. ft.)?

d. How much more profit could be attained if Highland was willing to have $3500 worth of

capital tied-up (keeping the floor space at 200 sq. ft. and the marketing requirement at

40%)? How should Highland decide if it is worthwhile to increase this value? - You are in charge of loading cargo ships at a major East Coast port. You have been asked to

prepare a loading plan for a freighter bound for Africa. An agricultural commodities dealer

would like to transport the following products aboard this ship:

Commodity Tons Avail. Volume/ton

(cubic ft)

Profit/ton

($)

1 4000 40 70

2 3000 25 50

3 2000 60 60

4 1000 50 80

You can elect to load any and/or all of the available product. However, the ship has 3 cargo

holds with the following capacity restrictions:

Cargo Hold Weight Capacity

(tons)

Vol. Capacity

(cubic ft)

Forward 3000 100,000

Center 5000 150,000

Rear 2000 120,000

More than one type of commodity can be placed in the same cargo hold. However, the ship

must be balanced, so the weight in the forward hold must be within 10% of the weight in the

rear hold, and the center hold must be assigned between 40 and 60% of the total weight.

Write a linear program that will maximize profits. You don’t need to solve it.

Hint: Define your variables as: Xij = tons of commodity i loaded into cargo hold j

Sample Solution

eryone. it absolutely was a difficulty of respect and support to win and to style laborious on a regular base. •Nobody took a free ride and if there was an indication toward on these lines the event had created approaches to manage settle it. Amidst my lord business I worked in numerous social events beginning at as recently. To the degree I will tell I did not expertise social idling impacts once there was an excited, not too straightforward to satisfy objective for the get-together and a setting of accomplices with high game-plan and skill to accomplish that objective. There’s faithfully a partner that does not pull their weight. In cash connected problems this is often referred to as a free rider issue—individuals who advantage from assets they do not obtain. author professional and creator of Originals Adam Grant (building up an recent Meta examination by Karau and Williams) saw a development of segments that urge people to contribute what is returning to them. •Make the trip additional imperative. people sporadically die away once they do not feel that the endeavor matters. once they see the cruciality of their endeavors, they have a tendency to figure tougher and additional unbelievable. •Show them what their mates do. From time to time people basically do not fathom that they are doing not the maximum amount because the customary. •Shrink the get-together. once operating in an exceedingly broad grouping, it’s under no circumstances laborious to deal with whether or not specific endeavors improbably matter. •Assign extraordinary commitments. totally different get-togethers develop in restraint since people are endeavoring to be conscious—they ought to solidify everyone and insult no one. •Make individual wellsprings of knowledge plainly obvious. Right once it’s tough to check who’s doing what, people will hide out within the get-together. •Build a additional grounded relationship. within the event that it’s maki>

GET ANSWER