Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

Cattle are sent to a feedlot to be grain-fed before being processed into beef. The owners of a feedlot seek to determine the amounts of cattle feed to buy so that the minimum nutritional standards are satisfied to ensure proper weigh gain, while total feed costs are minimized. The feed mix used is made up of three grains that contain the following nutrients per pound of feed. Nutrient (ounces per pound of feed)

FEED A B C D Cost of Mix (per lb.)

Feed Mix X 4 2 3 6 $5.00

Feed Mix Y 2 3 0 8 $4.50

Feed Mix Z 5 2 2 5 $3.50

The minimum requirement per cattle per day is 6 lbs. of Nutrient A, 5 lbs. of Nutrient B, 2 lbs. of Nutrient C, and 10 lbs. of Nutrient D. Another restriction is that only 500 lbs. of Feed Mix Z is available per day. Because there are usually 100 cattle to feed at any given time, this means that no more than 5 lbs. of Feed Mix Z can be counted on for use in the feed mix each day. Formulate and solve this problem in Excel to determine the number of lbs. of each type of Feed Mix to include in the total mix that meet the requirements and minimize the cost (Hint: Make sure your LHS and RHS of your constraints are the same units: 1 lb. = 16 ounces)

a) How many decision variables does this problem have?

b) Not counting the non-negativity constraint - how many constraints does this problem have?

c) What is the minimum cost based on your optimal solution (the value of the objective function)?

d) How many lbs. of Feed Mix X should be included in the mix based on your optimal solution?

e) How many lbs. of Feed Mix Y should be included in the mix based on your optimal solution?

f) How many lbs. of Feed Mix Z should be included in the mix based on your optimal solution?

g) What is the total ounces of Nutrient A included in the mix based on your optimal solution (the value of the LHS of the constraint)?

h) What is the total ounces of Nutrient B included in the mix based on your optimal solution (the value of the LHS of the constraint)?

i) What is the total ounces of Nutrient C included in the mix based on your optimal solution (the value of the LHS of the constraint)?

j) What is the total ounces of Nutrient D included in the mix based on your optimal solution (the value of the LHS of the constraint)?

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91905987

Have any Question?


Related Questions in Operation Management

Explain the barriers associated with organizational

Explain the barriers associated with organizational change. Summarize the complexities of the organizational change process. Identify the characteristics of effective organizational change programs

1 what are some alternatives to completely opting-out and

1. What are some alternatives to completely opting-out and not working? 2. Peter wants to hire Betty to baby-sit his new baby five days a week for one year. He offers Betty the job on March 3, 2000, and tells her that he ...

1 discuss 3 employee motivation compensation performance or

1. Discuss 3 employee motivation, compensation, performance, or other issues related to human resources. What are three challenges and what 2 strategies would you propose using to address those issues (6 total strategies ...

In the 1980s the federal government required drug testing

In the 1980s, the federal government required drug testing from government contractors. Since then, a number of companies have adopted policies regarding drug testing in the workplace. Companies believe they need to do d ...

Also point-of-purchase promotional materials are a popular

Also point-of-purchase promotional materials are a popular form of sales promotion. Because space is at a premium in most grocery stores, this promotional material is strategically located on the floor. There is a compan ...

A project manager leading a large time-sensitive global it

A project manager leading a large, time-sensitive, global IT server replacement project was informed by a server expert on the team that they had a technical problem that they did not know how to resolve. The team member ...

Make no mistake downsizing is extremely difficult it taxes

Make no mistake: downsizing is extremely difficult. It taxes all of a management team's resources, including both business acumen and humanity. No one looks forward to downsizing. Perhaps this is why so many otherwise fi ...

A what is nutrimentrsquos competitive business strategy

A. What is Nutriment’s competitive business strategy (refer to a previous chapter on strategic planning)? Justify your answer. Explain how this strategy impacts the price of Nutriments products and how that impacts compe ...

Office2000 produces expensive quality 2-drawer and 4-drawer

Office2000 produces expensive, quality 2-drawer and 4-drawer filing cabinets from solid oak for major corporations. A 2-drawer model utilizes 2 labor hours to produce and package for a net profit of $75. The 4-drawer mod ...

A small company has 4000000 in annual revenue spends 47 of

A small company has $4,000,000 in (annual) revenue, spends 47% of its revenues on purchases, and has a net profit margin of 9.75%. They would like to increase their profits and they are looking at focusing in one of two ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As