Question

In: Operations Management

NOTE: This problem does NOT need more information. All the information is here directly as written...

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)

Solutions

Expert Solution

a) Goal programming model is as follows:

Let, C, W, S be the acres of Corn, Wheat and Soybean to grow.

Deviation variables: Let dj+ and dj- be the positive and negative deviation variables for j-th goal

Objective: Min 6d1-+5d2++4d3-+3d4++2d5-+(3/9)d6-+(4/9)d7-+(2/9)d8-

s.t.

7C+10W+8S-d1++d1- = 6000

100C+120W+70S-d2++d2- = 80000

30C+40W+20S-d3++d3- = 105000

7C+10W+8S-d4++d4- = 6000

C+W+S-d5++d5- = 1000

C-d6++d6- = 200

W-d7++d7- = 500

S-d8++d8- = 300

C,W,S,dj+,dj- >= 0

b) Solution using Excel Solver follows

Formula:

U3 =SUMPRODUCT(B3:T3,$B$12:$T$12) copy to U3:U10

B14 =SUMPRODUCT(E14:T14,E12:T12)


Related Solutions

Written In JavaScript Deep comparison : Does Not Need To Be Recursive The == operator compares...
Written In JavaScript Deep comparison : Does Not Need To Be Recursive The == operator compares objects by identity. But sometimes you’d prefer to compare the values of their actual properties. Write a function deepEqual that takes two values and returns true only if they are the same value or are objects with the same properties, where the values of the properties are equal when compared with a recursive call to deepEqual. To find out whether values should be compared...
Here is a Problem I need to solve: 5) Write a function to determine is a...
Here is a Problem I need to solve: 5) Write a function to determine is a given word is legal. A word is illegal if it contains no vowels. For this problem, the letter Y is considered to be a legal vowel. Pass in a word to this function and it will determine if the word is legal or not. You can make the following assumptions about the word you a passing to this function. 1) The string being passed...
Can you please tell me what more information I need to provide to solve below problem?...
Can you please tell me what more information I need to provide to solve below problem? 1. Find out below using R Hints: Use iris dataset from R (built in data set in R) a) Create a new data frame called virginica.versicolor (that only contains these two species) the command I used: virginica.versicolor <- iris[iris$Species %in% c("versicolor", "virginica"), ] b) What is your null hypothesis regarding sepal lengths for the two species (virginica.versicolor) ? And what is your alternate hypothesis?...
The tax pair is more likely to need to increase his or her withholding F here...
The tax pair is more likely to need to increase his or her withholding F here she is married filing jointly and his or her spouse also works if the tax pair chooses to increase his or her withholding here she should complete the option in step 2(b) on the new 2020 form W-4 the taxpayer completes the multiple jobs worksheet on only one form W-4 to determine withholding the withholding amount will be most accurate if after completing the...
1. We are all may be here for a different reason - some of us need...
1. We are all may be here for a different reason - some of us need the general education requirement, some are fulfilling a program requirement, and some may find the material interesting! Either way, I'm sure that we all come into this class with a preconceived view about the field of psychology. So...what do you think?  Are psychologists just those bearded, white-haired old timers who nod at your every word while judging everything you say!? Do you have a preconceived...
Here is the information for a class on campus. We need to randomly select two students...
Here is the information for a class on campus. We need to randomly select two students to interview. (We don't want to interview the same student twice.) Class Frequency Freshman 21 Sophomore 14 Junior 9 Senior 6 (a) Are the two student selections going to be independent? (b) What is the probability that we choose a Freshman and then a Senior? (c) What is the probability that we choose a Sophomore and then another Sophomore? (d) What is the probability...
This is all of the information that was given in my book. Therefore no more information...
This is all of the information that was given in my book. Therefore no more information should be needed. Zack is a mutual fund manager for BlackRock. He manages BlackRock S&P500 Supreme fund which is a passive fund tracking S&P500 index. With an uncertainty ahead, he wants to fully hedge his portfolio using options on S&P500 index futures. Assume that - S&P500 index now is 2300 and his portfolio value is $120 million - He plans to buy put option...
Here is the entire problem; however the trial balance did not copy in correctly. I need...
Here is the entire problem; however the trial balance did not copy in correctly. I need to know how to calculate the basic consolidation entry (mostly income from Soda Company, Investment in Soda Company, NCI in NI and NCI in NA. Pop Corporation acquired 70 percent of Soda Company's voting common shares on January 1, 20X2, for $119,000. At that date, the noncontrolling interest had a fair value of $51,000 and Soda reported $70,000 of common stock outstanding and retained...
Note : I need word typed solution for this problem with comprehensive details. Question : Explain...
Note : I need word typed solution for this problem with comprehensive details. Question : Explain the thermal, acoustic and optical properties of lattice vibrations? Please make it to explain all in need.
Note: I need a step by step answer to the following problem to better understand how...
Note: I need a step by step answer to the following problem to better understand how this works. Hot Coffee Manufacturing produces and sells oak tables. The budgeted   manufacturing costs per table are as follows: Direct costs                 Oak top                48 square feet at $10 per sq. ft.                 Table legs                 4 legs at $5 per leg Direct labor is 3 hours and 24 minutes per table at $15 per hour. The variable overhead rate is $6 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT