Maintain good relations with the union and labor contract

Assignment Help Operation Management

Reference no: EM132135157

NOTE: This problem does NOT need more information. All the information is here directly as written from the book. I have most done just needed some help with setting up in excel and solver. Again, it has all the information.

Help Solve this problem please, then use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel.

A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 8 worker-days, and yields $20 profit. The farmer has taken out a loan of $80,000 for crop preparations and ahs contracted with a union for 6,000 worker-days o labor. A midwesters granary has agreed to purchase 200 acres of corn, 500 acres of wheat, and 300 acres of soybeans. The farmer has established the following goals, in order of their importance:

(1) Maintain good relations with the union, the labor contract must be honored; that is, the full 6,000 worker-days of labor contracted for must be used.

(2) Preparation costs should not exceed teh loan amount so that additional loans will not have to be secured.

(3) The farmer desires a profit of a least $105,000 to remain in good financial condition.

(4) Contracting for excess labor should be avoided.

(5) The farmer would like to use as much of the available acreage as possible.

(6) The farmer would like to meet the sales agreement with the granary. However, the goal should be weighted according to the profit returned by each crop.

Solve:

a) Formulate a goal programming model to determine the number of acres of each crop the famer shoud plat to satisfy the goals in the best possible way.

b) Solve this model using the computer (Excel and Solver)

Reference no: EM132135157

Questions Cloud

Identify key risks in terms of the economic and social risks : INB 6200 The Turkish and Japanese economies face different challenges over the next decade. The assignment requires you to choose one of the countries.

Create business plan for new cosmetology school : Please create a business plan for a new cosmetology school. What are the methods in measuring Educational Quality in TVET?

Develop an outline of the project plan for the testing : As part of the disaster recovery planning at a medium-sized business,you have been asked to develop a project plan to test the backups of production systems.

Discuss about the contract law : Examples of these include the purchase of expensive property, and dealings with software vendors, building contractors, and facility maintenance firms.

Maintain good relations with the union and labor contract : Maintain good relations with the union, the labor contract must be honored; that is, the full 6,000 worker-days of labor contracted for must be used.

Describe differing theories on organizational development : The CEO has hired you as an external organizational development consultant to help him identify problem areas .

Explain promotions strategy and contingency plans : Explain Promotions strategy and contingency plans for Cell phones and cell phone repair retail store?

Do you have an alternative idea to propose : Briefly summarize your brand and competition. Create a 1-page first draft of a SWOT analysis. Provide only two or three items in each of the four areas.

Identify a problem in society that could be addressed : Identify a problem in society that could be addressed through a partnership between a nonprofit and a government. Why is it appropriate to address this problem.

User Account

All Pages